Post by vitalvintage » Wed Feb 11, 2015 6:33 am

Let me first say that I have contacted the author but have yet to receive any official response. I have imported users and addresses successfully. My third step was to import orders. I exported 3 test orders to get the csv file to show columns and values. I then thought I had successfully entered in all correct information. But I get the following errors which I have attached to this and tried to show below. I have attached the csv file that I am trying to import my orders from. I have tested this on the demo site and the same problem persists. I even tried the original export, and it gives the same error messages.

Screen Error Messages:

Warning: mysql_num_fields() expects parameter 1 to be resource, boolean given in /var/www/vhosts/vitalvintagecoalition.com/httpdocs/opencart/admin/model/module/uber_csv.php on line 399Warning: mysql_fetch_row() expects parameter 1 to be resource, boolean given in /var/www/vhosts/vitalvintagecoalition.com/httpdocs/opencart/admin/model/module/uber_csv.php on line 402Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order where Key_name = 'PRIMARY'' at line 1
Error No: 1064
show index from order where Key_name = 'PRIMARY'; in /var/www/vhosts/vitalvintagecoalition.com/httpdocs/opencart/system/library/db/mysqli.php on line 40Notice: Trying to get property of non-object in /var/www/vhosts/vitalvintagecoalition.com/httpdocs/opencart/admin/model/module/uber_csv.php on line 175Warning: Invalid argument supplied for foreach() in /var/www/vhosts/vitalvintagecoalition.com/httpdocs/opencart/admin/model/module/uber_csv.php on line 175Notice: Trying to get property of non-object in /var/www/vhosts/vitalvintagecoalition.com/httpdocs/opencart/admin/model/module/uber_csv.php on line 175Warning: Invalid argument supplied for foreach() in /var/www/vhosts/vitalvintagecoalition.com/httpdocs/opencart/admin/model/module/uber_csv.php on line 175Notice: Trying to get property of non-object in /var/www/vhosts/vitalvintagecoalition.com/httpdocs/opencart/admin/model/module/uber_csv.php on line 175Warning: Invalid argument supplied for foreach() in /var/www/vhosts/vitalvintagecoalition.com/httpdocs/opencart/admin/model/module/uber_csv.php on line 175
Trying to get property of non-object in /var/www/vhosts/vitalvintagecoalition.com/httpdocs/opencart/admin/model/module/uber_csv.php on line 193Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order' at line 1
Error No: 1064
TRUNCATE TABLE order in /var/www/vhosts/vitalvintagecoalition.com/httpdocs/opencart/system/library/db/mysqli.php on line 40

** Taken From SERVER ERROR LOG **


[Mon Feb 09 13:32:58 2015] [warn] [client 208.95.68.120] mod_fcgid: stderr: PHP Fatal error: Uncaught exception 'ErrorException' with message 'Error CSV DB MultiQuery: Column count doesn't match value count at row 1<br />Error No: 1136<br />INSERT INTO `order` (order_id,invoice_no,invoice_prefix,store_id,store_name,store_url,customer_id,customer_group_id,firstname,lastname,email,telephone,fax,custom_field,payment_firstname,payment_lastname,payment_company,payment_address_1,payment_address_2,payment_city,payment_postcode,payment_country,payment_country_id,payment_zone,payment_zone_id,payment_address_format,payment_custom_field,payment_method,payment_code,shipping_firstname,shipping_lastname,shipping_company,shipping_address_1,shipping_address_2,shipping_city,shipping_postcode,shipping_country,shipping_country_id,shipping_zone,shipping_zone_id,shipping_address_format,shipping_custom_field,shipping_method,shipping_code,comment,total,order_status_id,affiliate_id,o) VALUES('rder.commission','order.marketing_id','order.tracking','order.language_id','order.currency_id','order.currency_code','order.currency_ in /var/www/vhosts/vitalvintagecoalition.com/httpdocs/opencart/admin/model/module/uber_csv.php on line 370, referer: https://www.vitalvintagecoalition.com/o ... c84313741d

*** CSV FILE Columns & Headers importing **
I can not attach to this post

Thanks for anyone who responds and tries to help

Attachments

screen shown with errors after failed import

pulled from my server error log file


New member

Posts

Joined
Tue Oct 14, 2014 5:47 pm
Who is online

Users browsing this forum: No registered users and 4 guests