UberCSV Errors on Import of Orders
Posted: 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
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