bluecarbon Posted June 12, 2015 Share Posted June 12, 2015 Hi, I'm trying the new 1.6.1.0 RC4, and I have a problem in CSV import when I import the same csv twice, for example to modify a price.Property Product->date_upd is not validIf I try it the next day it work fine, but only once. Link to comment Share on other sites More sharing options...
4exob Posted June 13, 2015 Share Posted June 13, 2015 format must be such yyyy-mm-dd that when you open a file format CSV date slips Link to comment Share on other sites More sharing options...
bluecarbon Posted June 14, 2015 Author Share Posted June 14, 2015 Hi again, The problem is that I don't have any date field in the CSV. Link to comment Share on other sites More sharing options...
objectifboetie Posted July 6, 2015 Share Posted July 6, 2015 (edited) Hi, did you resolve your problem ? I have the same problem with the official 1.6.1 Edited July 6, 2015 by objectifboetie (see edit history) Link to comment Share on other sites More sharing options...
leonbazar Posted July 8, 2015 Share Posted July 8, 2015 maybe in ps_product you have dates with 0000-00-00 00:00:00 you must put the correct date in phpmyadmin, go to SQL and write this: UPDATE `ps_product` SET `date_upd` = '2015-08-07 16:58:53' WHERE `date_upd` = '0000-00-00 00:00:00' and click continue bottom. Link to comment Share on other sites More sharing options...
leonbazar Posted July 8, 2015 Share Posted July 8, 2015 now i have the same problem, the answer i wrote dosn´t work Link to comment Share on other sites More sharing options...
leonbazar Posted July 8, 2015 Share Posted July 8, 2015 i solved. i had to do the same in ps_product_shop too UPDATE `ps_product` SET `date_upd` = '2015-08-07 16:58:53' WHERE `date_upd` = '0000-00-00 00:00:00' UPDATE `ps_product_shop` SET `date_upd` = '2015-08-07 16:58:53' WHERE `date_upd` = '0000-00-00 00:00:00' Link to comment Share on other sites More sharing options...
Tamara F Posted July 12, 2015 Share Posted July 12, 2015 i solved. i had to do the same in ps_product_shop too UPDATE `ps_product` SET `date_upd` = '2015-08-07 16:58:53' WHERE `date_upd` = '0000-00-00 00:00:00' UPDATE `ps_product_shop` SET `date_upd` = '2015-08-07 16:58:53' WHERE `date_upd` = '0000-00-00 00:00:00' Thanks a lot!!! Link to comment Share on other sites More sharing options...
xfdisco Posted July 14, 2015 Share Posted July 14, 2015 Hello, we have the same problem. Article texts in German worked but the English texts had this failure while importing the CSv. We also have noch date in our CSV. @rubben1985: Is your solution final or temporary? We're planning to import the files every day because we have no import plugin for our ERP. Link to comment Share on other sites More sharing options...
Tamara F Posted July 14, 2015 Share Posted July 14, 2015 Hello, we have the same problem. Article texts in German worked but the English texts had this failure while importing the CSv. We also have noch date in our CSV. @rubben1985: Is your solution final or temporary? We're planning to import the files every day because we have no import plugin for our ERP. Hi, it worked for me but i do not know if it will be stable in long terme. Anyway it seems like a bug that prestashop should correct someday. Answering your question: in this moment it is working fine. Link to comment Share on other sites More sharing options...
xfdisco Posted July 14, 2015 Share Posted July 14, 2015 Many thanks for the feedback. We'll test that... Link to comment Share on other sites More sharing options...
leonbazar Posted July 17, 2015 Share Posted July 17, 2015 write the date in correct way ?? YYYY-MM-DD hh-mm-ss Link to comment Share on other sites More sharing options...
xfdisco Posted July 20, 2015 Share Posted July 20, 2015 Hi Leonbazar, we've tested the workaround. This mysql command works also for us: UPDATE `ps_product` SET `date_upd` = '2015-08-07 16:58:53' WHERE `date_upd` = '0000-00-00 00:00:00' UPDATE `ps_product_shop` SET `date_upd` = '2015-08-07 16:58:53' WHERE `date_upd` = '0000-00-00 00:00:00' Thanks a lot! XF Link to comment Share on other sites More sharing options...
atef1987 Posted July 21, 2015 Share Posted July 21, 2015 view this topic, it contain some bug fix http://build.prestashop.com/news/announcing-prestashop-1-6-1-1/ Link to comment Share on other sites More sharing options...
xfdisco Posted July 24, 2015 Share Posted July 24, 2015 (edited) Thanks for the tip!So the last Prestashop update 1.6.1.1 corrected this bug. Edited July 24, 2015 by xfdisco (see edit history) Link to comment Share on other sites More sharing options...
pborroni Posted July 29, 2015 Share Posted July 29, 2015 Solution until new version (August): https://github.com/PrestaShop/PrestaShop/commit/c18b699ec8cd50f70672217879b9e6728bfe10a0 Link to comment Share on other sites More sharing options...
xfdisco Posted July 30, 2015 Share Posted July 30, 2015 (edited) @pborroni We tried your code correction in AdminImportController.php but the result is a error page when we click CSV import... Parse error: syntax error, unexpected 'public' (T_PUBLIC) in /var/www/html/prestashop/controllers/admin/AdminImportController.php on line 1936 Do we have to correct more things? We're eager to test it. Edited July 30, 2015 by xfdisco (see edit history) Link to comment Share on other sites More sharing options...
pborroni Posted July 30, 2015 Share Posted July 30, 2015 Hello Xfdisco! I made the correction and it worked ok... I have the last available version installed. The php file with the modifications I use is: https://drive.google.com/file/d/0By9lczRhjmhfUGFRZGpqandobm8/view?usp=sharing The code correction is not mine, is from Prestashop team. I hope it helps, by. 1 Link to comment Share on other sites More sharing options...
xfdisco Posted July 31, 2015 Share Posted July 31, 2015 Thank you - yesterday we didn't recognize that there were more changes. So we found a solution but we compare with yours. Have nice weekend T Link to comment Share on other sites More sharing options...
xfdisco Posted July 31, 2015 Share Posted July 31, 2015 Hello Xfdisco! I made the correction and it worked ok... I have the last available version installed. The php file with the modifications I use is: https://drive.google.com/file/d/0By9lczRhjmhfUGFRZGpqandobm8/view?usp=sharing The code correction is not mine, is from Prestashop team. I hope it helps, by. @pborroni: We've tried your fix. It seemed to work correctly but now we've found another problem. Prestashop somehow has problems with signs like Ø, ¼, ½ or >. For that reason we've used this fix to correct that… Sadly we figured out now that your fix makes the old problem appear again. Do you have an idea we're the dependency is? We've reseted it for the moment. Link to comment Share on other sites More sharing options...
bernd445 Posted November 19, 2015 Share Posted November 19, 2015 (edited) Please can you tell me, where exactly can i find this???? UPDATE `ps_product` SET `date_upd` = '2015-08-07 16:58:53' WHERE `date_upd` = '0000-00-00 00:00:00'UPDATE `ps_product_shop` SET `date_upd` = '2015-08-07 16:58:53' WHERE `date_upd` = '0000-00-00 00:00:00' I know in PHPmyADMIN, but what have i click exactly If I go SQL stay this inside SELECT * FROM `ps_product` WHERE 1 I have this do delete and write this? UPDATE `ps_product` SET `date_upd` = '2015-08-07 16:58:53' WHERE `date_upd` = '0000-00-00 00:00:00' or I go under SQL to UPDATE UPDATE `ps_product` SET `id_product`=[value-1],`id_supplier`=[value-2],`id_manufacturer`=[value-3],`id_category_default`=[value-4],`id_shop_default`=[value-5],`id_tax_rules_group`=[value-6],`on_sale`=[value-7],`online_only`=[value-8],`ean13`=[value-9],`upc`=[value-10],`ecotax`=[value-11],`quantity`=[value-12],`minimal_quantity`=[value-13],`price`=[value-14],`wholesale_price`=[value-15],`unity`=[value-16],`unit_price_ratio`=[value-17],`additional_shipping_cost`=[value-18],`reference`=[value-19],`supplier_reference`=[value-20],`location`=[value-21],`width`=[value-22],`height`=[value-23],`depth`=[value-24],`weight`=[value-25],`out_of_stock`=[value-26],`quantity_discount`=[value-27],`customizable`=[value-28],`uploadable_files`=[value-29],`text_fields`=[value-30],`active`=[value-31],`redirect_type`=[value-32],`id_product_redirected`=[value-33],`available_for_order`=[value-34],`available_date`=[value-35],`condition`=[value-36],`show_price`=[value-37],`indexed`=[value-38],`visibility`=[value-39],`cache_is_pack`=[value-40],`cache_has_attachments`=[value-41],`is_virtual`=[value-42],`cache_default_attribute`=[value-43],`date_add`=[value-44],`date_upd`=[value-45],`advanced_stock_management`=[value-46],`pack_stock_type`=[value-47] WHERE 1 This is my Text under Update, i have to delete this??? UPDATE `ps_product_shop` SET `date_upd` = '2015-08-07 16:58:53' WHERE `date_upd` = '0000-00-00 00:00:00' I hope someone can explean me step by step Thanks Edited November 19, 2015 by bernd445 (see edit history) Link to comment Share on other sites More sharing options...
bernd445 Posted November 19, 2015 Share Posted November 19, 2015 Now i install this under database SQL UPDATE `ps_product` SET `date_upd`='2015-08-07 16:58:53'WHERE `date_upd`='0000-00-00 00:00:00'UPDATE `ps_product_shop` SET `date_upd`='2015-08-07 16:58:53'WHERE `date_upd`='0000-00-00 00:00:00' i am not sure is correct or not. I get this error #1064 - 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 'UPDATE `ps_product_shop` SET `date_upd`='2015-08-07 16:58:53'WHERE `date_upd`='0' at line 2 can someone help me, please Link to comment Share on other sites More sharing options...
bernd445 Posted November 20, 2015 Share Posted November 20, 2015 Thanks for your help, works fine now Link to comment Share on other sites More sharing options...
Recommended Posts