nicusor Posted June 24, 2014 Share Posted June 24, 2014 (edited) hello, so after some problems with the csv import of 1.6.0.6, which was ending with internal server error after 120 seconds, where I tryed by changing php.ini: max_execution_time = 300 max_memory_limit = 512M and various attemps with random values, every time the http 500 error, with "Script timed out before returning headers: index.php, referer: ...." inside the logs Then Igave the login info, the file and instructions to my hosting support, and everything went fine from their side. Yesterday I saw the new 1.6.0.8 release, so went with a fresh install. tryed to import the csv and page blank after few seconds with external links of images to import, or 60 seconds without them. all this for less than 150 products I don't know what else to try, I tryed from another pc and same problem, also the debugging mode from define.inc.php doesn't work I even thought might be a modem/provider problem... thanks PS: this is a modified thead for a problem with installing addons which misteriously fixed itself Edited June 24, 2014 by nicusor (see edit history) Link to comment Share on other sites More sharing options...
DoubleGJ Posted June 27, 2014 Share Posted June 27, 2014 same problem here after update from 1.6.0.6 to 1.6.0.8imports only 45 products and then shows a white page before the update i was able to import csv without problems Link to comment Share on other sites More sharing options...
nicusor Posted June 27, 2014 Author Share Posted June 27, 2014 last night, since I didn't knew where to throw my head, I tried to clone the shop on xampp and the problem was occuring after 5 minutes of waiting and only 45-60 products imported. so I set the max_execution_time higher than 300 but the problem persisted. also since it was on the localhost and avira antivir was deactivated manually, this would remove the theory of provider/router/antivirus. I wouldn't blame the windows xp and 8 integrated firewall... anyway, this morning I separated the csv with 10 products per upload....It workied, only 7-15 seconds to finish. so statistically with 150 products it would take about 3 minutes... now when I'm trying to save some changes I have blank pages, sometimes it discards changes and random link_rewrite errors, something like it's required at least for my language Link to comment Share on other sites More sharing options...
El Patron Posted June 27, 2014 Share Posted June 27, 2014 when blank pages, config/defines.inc.php define('_PS_MODE_DEV_', true); recreate blank page, then search on error 1 Link to comment Share on other sites More sharing options...
nicusor Posted June 27, 2014 Author Share Posted June 27, 2014 (edited) already done, but where to look for? neither firebug error console or apache (error) log are useful. the only thing I see are some POST /admin/index.php?controller=AdminProducts&token=1234&id_product=31 POST /admin/ajax.php?rand=1234 in the apache log and <!DOCTYPE html> <html class="js" lang="it"> <head> <body class="ps_back-office page-sidebar adminproducts"> </html> on the firebug html console I discovered that by going back after the first blank page (on save or save&stay), it shows those errors 3 errori Il campo link_rewrite è richiesto almeno in Italiano (Italian) Il prodotto deve essere in almeno una categoria. Questo prodotto deve essere in almeno una categoria di default. something like:1. This link_rewrite field is required at least in italian 2. Products must be in at least one category. 3. This product must be in the default category. which seems to be or a problem of multilanguage installs, but I have downloaded the italian and installed only the italian package or a copy-paste problem, but the only thing I did was importing the csv Edited June 27, 2014 by nicusor (see edit history) 1 Link to comment Share on other sites More sharing options...
nicusor Posted June 30, 2014 Author Share Posted June 30, 2014 NEWS I (re)installed for something like fourth time the 1608, this time using internet explorer 11 just to exclude any firefox 30 and addons issue. my php.ini was [PHP] engine = On date.timezone = Europe/Rome magic_quotes_gpc = Off memory_limit = 512M max_execution_time = 300 (now raised to 600 just for fun) max_input_vars = 10000 upload_max_filesize = 32M max_input_time is already by default -1, so no need to modify) made my import, same blank page after about 120 seconds, no more blank page when saving modifications of a product, but at least now there is an [Mon Jun 30 15:01:38 2014] [error] [client MyIp] Script timed out before returning headers: index.php, referer: https://www.domain.it/adminfolder/index.php?controller=AdminImport&token=1234567890sdfga281 in the apache error log Link to comment Share on other sites More sharing options...
rajansinha02 Posted July 10, 2014 Share Posted July 10, 2014 Hi Friends Using 1.6.0.8 Facing problem with product csv import after 8 - 10 seconds of upload with 10 products each time shows http 500 error . Getting the following errors when setting _PS_dev_mode = true in define.inc.php. 1) Strict Standards: Declaration of Dispatcher::loadRoutes() should be compatible with that of DispatcherCore::loadRoutes() in /home2/myserver/public_html/override/classes/Dispatcher.php on line 16 1) Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 71 bytes) in /home2/myserver/public_html/tools/htmlpurifier/HTMLPurifier.standalone.php on line 15136 Even though after increasing the limits in php.ini to following values max_execution_time = 1000 max_memory_limit = 512M max_input_vars = 8000 upload_max_filesize = 15M max_input_time= -1, suhosin.post.max_vars = 8000;suhosin.request.max_vars = 8000;post_max_size = 15M Checked through phpinfo log and all the values are updated accordingly on the server. regenerated a new .htaccess file but still the problem persist. help. Link to comment Share on other sites More sharing options...
Pr0tEct0 Posted July 16, 2014 Share Posted July 16, 2014 Same here. On 1606 import work fine, but on 1608 seems it has memory leak. I have huge import csv's with 1000 products each with attributes. Server have 4gb ram, and all ram is used by import script after some time, and of course apache's died (if php memory limit is disabled). If i split csv's to a ~100 products - import ends good (but i also see memory leak) Link to comment Share on other sites More sharing options...
LockeAG Posted July 26, 2014 Share Posted July 26, 2014 (edited) #same here , I get : with MEMCACHE Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 72 bytes) in /public/tools/htmlpurifier/HTMLPurifier.standalone.php on line 15136 with OPC Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 20756 bytes) in /public/classes/cache/CacheApc.php on line 50 can anyone help here thanks Edited July 27, 2014 by LockeAG (see edit history) Link to comment Share on other sites More sharing options...
Koko888 Posted September 26, 2014 Share Posted September 26, 2014 any solution? I have the same problem using Prestashop 1.6.0.9. After some seconds I get the blank page, no problem while importing a few products. Also, I noticed that when I delete the images column everything works perfect. Any solution or idea? 2 Link to comment Share on other sites More sharing options...
El Patron Posted September 26, 2014 Share Posted September 26, 2014 here is free module, that will show actual local/master values as used/ini_set by PrestaShop. http://www.prestashop.com/forums/topic/278164-free-module-display-php-environment-phpinfo-back-office/ this may help in some small way determine runtine php.ini happy day, el 1 Link to comment Share on other sites More sharing options...
tigyi Posted October 9, 2014 Share Posted October 9, 2014 I have the problem, I can import only 9916 products, but I have 18 000 products... Link to comment Share on other sites More sharing options...
parsifal Posted October 9, 2014 Share Posted October 9, 2014 Are you automatically importing them in a regular basis (for update reasons)? If not, I don't see think it would be a problem to split your CSV in 3 parts with 6000 products each and import them one after the other. Link to comment Share on other sites More sharing options...
El Patron Posted November 10, 2014 Share Posted November 10, 2014 Hi patron When we download csv file for products and category. Its very difficult to understand for a normal average to understand default example csv excel which comes with semi Colan and comma. Than need to cut and copy one one attribute in and excel file which needs to be saved as CSV file. When importing change ; to , and than import.As simple one column CSV upload don't works with ; Why this is a lengthy process and not easy as people run away when products needs to uploaded.Also after doing all this hard work uploading 200 products take 30 min time even using vps server. Is this the right way or we are missing things. I have seen videos of nemo for 1.5 but in that video the download excel File has every elements in one one column. Is this a bug in 1.6 as simple example file comes in semi colan.Wht is the purpose of using semi Colan default file for 1.6.0.8 Pls put a light as it creates a hell for adding different products and categories for individual different stores with multi store active. You make a good point, I would personally look for 3rd party solution where you can mange your products on your desktop that then interfaces with the prestashop, store commander for example (there may be other solutions). or a good prestashop mass updater module... these may be good solutions given how complex a csv managed shop could be. Link to comment Share on other sites More sharing options...
andrewcavey Posted December 6, 2014 Share Posted December 6, 2014 can anyone tell me how to work this program Ajax csv product import I been trying for over 5 days now and what ever i do i cant get it to do anthing if anyone has a video to show step by step i would be grateful I don't no if I am saving the csv file right I am currently so confused if anyone can help I would be grateful. cheers andy Link to comment Share on other sites More sharing options...
Recommended Posts