corresponds to your MariaDB server Ошибка при импорте через Export/Import Tool for OpenCart 2.0.x

[igorfelix]

Добрый день, =( 

// Version

define('VERSION', '2.1.0.1.1');

При импорте через Export/Import Tool for OpenCart 2.0.x ,

лезут ошибки, не могу понять в чем проблема..  вот кусок небольшой.. 

экспорт работает, а при импорте такое...

 

Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '',1,313,0,'2016-05-03 02:44:46','2016-05-19 01:38:52','2016-05-03',0,10,1,0,0,0,' at line 1
Error No: 1064
INSERT INTO `oc_product` (`product_id`,`quantity`,`sku`,`upc`,`ean`,`jan`,`isbn`,`mpn`,`location`,`stock_status_id`,`model`,`manufacturer_id`,`image`,`shipping`,`price`,`points`,`date_added`,`date_modified`,`date_available`,`weight`,`weight_class_id`,`status`,`tax_class_id`,`viewed`,`length`,`width`,`height`,`length_class_id`,`sort_order`,`subtract`,`minimum`) VALUES (143,735,'','','','','','','',8,'4901525944700',21,'catalog/butovaya-himia/tovaru-lichnoy-gigienu-dlya-detey/Cow-detskij-shampun'-penka-s-dozatorom-350ml.jpg',1,313,0,'2016-05-03 02:44:46','2016-05-19 01:38:52','2016-05-03',0,10,1,0,0,0,0,0,'4','1','0','1'); in /var/www/vhosts/igorfelix.c2.npdc.ru/httpdocs/mysite.ru/system/library/db/mysqli.php on line 41Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '',1,184,0,'2016-05-03 02:46:54','2016-05-19 01:39:14','2016-05-03',0,10,1,0,0,0,' at line 1
Error No: 1064
INSERT INTO `oc_product` (`product_id`,`quantity`,`sku`,`upc`,`ean`,`jan`,`isbn`,`mpn`,`location`,`stock_status_id`,`model`,`manufacturer_id`,`image`,`shipping`,`price`,`points`,`date_added`,`date_modified`,`date_available`,`weight`,`weight_class_id`,`status`,`tax_class_id`,`viewed`,`length`,`width`,`height`,`length_class_id`,`sort_order`,`subtract`,`minimum`) VALUES (144,814,'','','','','','','',8,'4901525944809',21,'catalog/butovaya-himia/tovaru-lichnoy-gigienu-dlya-detey/Cow-detskij-shampun'-penka-smennyj-blok-300ml.jpg',1,184,0,'2016-05-03 02:46:54','2016-05-19 01:39:14','2016-05-03',0,10,1,0,0,0,0,0,'4','1','0','1'); in /var/www/vhosts/igorfelix.c2.npdc.ru/httpdocs/mysite.ru/system/library/db/mysqli.php on line 41Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'sina-60g-60.jpg',1,161,0,'2016-05-04 00:36:02','2016-05-19 01:41:53','2016-05-04' at line 1
Error No: 1064
INSERT INTO `oc_product` (`product_id`,`quantity`,`sku`,`upc`,`ean`,`jan`,`isbn`,`mpn`,`location`,`stock_status_id`,`model`,`manufacturer_id`,`image`,`shipping`,`price`,`points`,`date_added`,`date_modified`,`date_available`,`weight`,`weight_class_id`,`status`,`tax_class_id`,`viewed`,`length`,`width`,`height`,`length_class_id`,`sort_order`,`subtract`,`minimum`) VALUES (151,348,'','','','','','','',8,'4903301099222',16,'catalog/butovaya-himia/tovaru-lichnoy-gigienu-dlya-detey/Detskaya-zubnaya-pasta-kids-s-natur-podslast-ftorom-i-ferment-so-vkusom-apel'sina-60g-60.jpg',1,161,0,'2016-05-04 00:36:02','2016-05-19 01:41:53','2016-05-04',0,10,1,0,0,0,0,0,'4','1','0','1'); in /var/www/vhosts/igorfelix.c2.npdc.ru/httpdocs/mysite.ru/system/library/db/mysqli.php on line 41Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'mologicheskij-gel'-6-ml.jpg',1,331,0,'2016-05-04 00:43:19','2016-05-14 01:08:22'' at line 1
Error No: 1064
INSERT INTO `oc_product` (`product_id`,`quantity`,`sku`,`upc`,`ean`,`jan`,`isbn`,`mpn`,`location`,`stock_status_id`,`model`,`manufacturer_id`,`image`,`shipping`,`price`,`points`,`date_added`,`date_modified`,`date_available`,`weight`,`weight_class_id`,`status`,`tax_class_id`,`viewed`,`length`,`width`,`height`,`length_class_id`,`sort_order`,`subtract`,`minimum`) VALUES (157,615,'','','','','','','',8,'4987241127733',22,'catalog/butovaya-himia/kapli-dlya-glaz/Rohto-nano-eye-sinie-nerastekayushciesya-kapli-oftal'mologicheskij-gel'-6-ml.jpg',1,331,0,'2016-05-04 00:43:19','2016-05-14 01:08:22','2016-05-04',0,10,1,0,0,0,0,0,'4','1','0','1'); in /var/www/vhosts/igorfelix.c2.npdc.ru/httpdocs/mysite.ru/system/library/db/mysqli.php on line 41Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'zoanii-kontaktnyh-linz-rohto-c3-plus-moist-18ml.jpg',1,361,0,'2016-05-04 00:44:1' at line 1
Error No: 1064
INSERT INTO `oc_product` (`product_id`,`quantity`,`sku`,`upc`,`ean`,`jan`,`isbn`,`mpn`,`location`,`stock_status_id`,`model`,`manufacturer_id`,`image`,`shipping`,`price`,`points`,`date_added`,`date_modified`,`date_available`,`weight`,`weight_class_id`,`status`,`tax_class_id`,`viewed`,`length`,`width`,`height`,`length_class_id`,`sort_order`,`subtract`,`minimum`) VALUES (158,244,'','','','','','','',8,'4987241135615',22,'catalog/butovaya-himia/kapli-dlya-glaz/Kapli-dlya-glaz-ot-ustalosti-pri-ispol'zoanii-kontaktnyh-linz-rohto-c3-plus-moist-18ml.jpg',1,361,0,'2016-05-04 00:44:17','2016-05-14 01:08:33','2016-05-04',0,10,1,0,0,0,0,0,'4','1','0','1'); in /var/www/vhosts/igorfelix.c2.npdc.ru/httpdocs/mysite.ru/system/library/db/mysqli.php on line 41Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'nyj-zubnoj-opolaskivatel'-s-aromatom-citrusovyh-lion-clinica-dental-450ml.jpg',1' at line 1
Error No: 1064
INSERT INTO `oc_product` (`product_id`,`quantity`,`sku`,`upc`,`ean`,`jan`,`isbn`,`mpn`,`location`,`stock_status_id`,`model`,`manufacturer_id`,`image`,`shipping`,`price`,`points`,`date_added`,`date_modified`,`date_available`,`weight`,`weight_class_id`,`status`,`tax_class_id`,`viewed`,`length`,`width`,`height`,`length_class_id`,`sort_order`,`subtract`,`minimum`) VALUES (159,823,'','','','','','','',8,'4903301205890',16,'catalog/butovaya-himia/dly-polosti-rta/Antibakterial'nyj-zubnoj-opolaskivatel'-s-aromatom-citrusovyh-lion-clinica-dental-450ml.jpg',1,383,0,'2016-05-04 00:45:29','2016-05-14 01:09:03','2016-05-04',0,10,1,0,0,0,0,0,'4','1','0','1'); in /var/www/vhosts/igorfelix.c2.npdc.ru/httpdocs/mysite.ru/system/library/db/mysqli.php on line 41Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'nyj-zubnoj-opolaskivatel'-s-aromatom-citrusovyh-lion-clinica-dental-900ml.jpg',1' at line 1
Error No: 1064
INSERT INTO `oc_product` (`product_id`,`quantity`,`sku`,`upc`,`ean`,`jan`,`isbn`,`mpn`,`location`,`stock_status_id`,`model`,`manufacturer_id`,`image`,`shipping`,`price`,`points`,`date_added`,`date_modified`,`date_available`,`weight`,`weight_class_id`,`status`,`tax_class_id`,`viewed`,`length`,`width`,`height`,`length_class_id`,`sort_order`,`subtract`,`minimum`) VALUES (160,367,'','','','','','','',8,'4903301205968',16,'catalog/butovaya-himia/dly-polosti-rta/Antibakterial'nyj-zubnoj-opolaskivatel'-s-aromatom-citrusovyh-lion-clinica-dental-900ml.jpg',1,572,0,'2016-05-04 00:46:08','2016-05-14 01:09:23','2016-05-04',0,10,1,0,0,0,0,0,'4','1','0','1'); in /var/www/vhosts/igorfelix.c2.npdc.ru/httpdocs/mysite.ru/system/library/db/mysqli.php on line 41Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'nyj-osvezhayushcij-zubnoj-opolaskivatel'-s-aromatom-myaty-lion-clinica-dental-45' at line 1

[AlexDW]

да все то же - кривое название файлов

в данном случае - одинарные кавычки

'catalog/butovaya-himia/tovaru-lichnoy-gigienu-dlya-detey/Cow-detskij-shampun'-penka-s-dozatorom-350ml.jpg'

[igorfelix]

Блин. Вот думал на них при создании товара. Спасибо. Попробую исправить. Отпишусь

[igorfelix]

Да.. исправил в картинках. переменовал картинки без ' .

в seo url небыло изначально '.

проблема была из за картинок 

[AlexDW]

у вас помимо кавычек еще и регистр гуляет, тоже может всплыть где-нибудь

 

ищите, как именно у вас происходит формирование/заполнение имен файлов, скорей всего генерируются автоматом

и в самом механизме генерации внесите необходимые поправки, во избежание