fitgura Posted March 24, 2015 Share Posted March 24, 2015 Hello for everyone! I read many forum topcs about one of the most recent problem Cannot importing large amount of products without an 500 error code of server. Peoples, including me, cannot import too much products via csv file, because of server problems (input_vars, execution_time, memory_limit etc.) I would like to know, is there any solution to run a php file somehow in a terminal of the server to not stop the script??? It is a controller (tokened file) without any chance I think (http://mysite.com/admin/index.php?controller=AdminImport&token=cd345ejrg3485o2n58otnv2ermn845#) Is there any good solution? Of course I increased the above mentioned timeout and memory limits I would do it on the most fresh PS 1.6.0.14 ----- If it is not a right way! Please someone explain me wich database table contains the images links because we want to write a code for it, and share when ready thank you Link to comment Share on other sites More sharing options...
tuk66 Posted March 24, 2015 Share Posted March 24, 2015 Install your shop locally, import all products and then move the database on the server. Link to comment Share on other sites More sharing options...
fitgura Posted March 24, 2015 Author Share Posted March 24, 2015 Well the problem is the same on local server too.. The maximum number of products around 300 what we can install before 500 error Link to comment Share on other sites More sharing options...
tuk66 Posted March 24, 2015 Share Posted March 24, 2015 What do you have under the Server Information block at Advanced Paramateres > Configuration Information? Link to comment Share on other sites More sharing options...
fitgura Posted March 24, 2015 Author Share Posted March 24, 2015 Here we are: Serverinformations Linux #57~precise1-Ubuntu SMP Tue Jul 15 03:51:20 UTC 2014 x86_64 Server softvare version Apache/2.2.22 (Ubuntu) PHP version 5.3.10-1ubuntu3.17 Memory limit 1024M Max execution time 44000 Database informationsMySQL version 5.5.31-0ubuntu0.12.04.1 MySQL server: localhost MySQL name: xxxxxxxx MySQL user: yyyyyyyy Table prefix ps_ MySQL engine InnoDB Link to comment Share on other sites More sharing options...
tuk66 Posted March 24, 2015 Share Posted March 24, 2015 The values look good. I have no other idea than to split the CSV file to parts with 250 lines. Link to comment Share on other sites More sharing options...
fitgura Posted March 24, 2015 Author Share Posted March 24, 2015 Thanks my friend, but the problem is we have 37.000 products in the shop and wanted to bypass the endless importing method Link to comment Share on other sites More sharing options...
tuk66 Posted March 24, 2015 Share Posted March 24, 2015 Oh. I understand your pain. I imported similar number of products earlier and had to disable indexing in code, increase memory up to 2G and do other small polishings. But it was v1.4. Things are different in v1.6. How long it takes to import 100 products? Link to comment Share on other sites More sharing options...
fitgura Posted March 24, 2015 Author Share Posted March 24, 2015 Well we have an own phisical 1U xeon i5 server with 8 gigs of ram... The process always stop between 230 and 300 products - it is about 4-5 minutes. does not matter how to pull up the execution time Link to comment Share on other sites More sharing options...
tuk66 Posted March 24, 2015 Share Posted March 24, 2015 Maybe your real Max execution time is 300s only. I've seen that timeout and memory values provided by PHP in rare cases don't correspond to reality. Link to comment Share on other sites More sharing options...
fitgura Posted March 24, 2015 Author Share Posted March 24, 2015 I think some similar, but where could I find the adjusted value in the core? because php.ini, and .htaccess I know well and they are okay... but I found an old topic about ps 1.5 someone did set something https://www.prestashop.com/forums/topic/312347-setting-max-execution-time/ What do you think? Link to comment Share on other sites More sharing options...
tuk66 Posted March 24, 2015 Share Posted March 24, 2015 Hard to say. Think about suhosin or other Linux protection. Link to comment Share on other sites More sharing options...
fitgura Posted March 24, 2015 Author Share Posted March 24, 2015 Is there anyone else have an idea, please? Link to comment Share on other sites More sharing options...
fitgura Posted March 25, 2015 Author Share Posted March 25, 2015 There is an idea if some of the PS programmers read this post: It would be helpful, when an administrator prepare everything on CSV import page, then could be two way: - instantly start the import like now - or make a button what could generate a specified php file about the instantaneous setting, next to the imported csv file And of course admin can run it in terminal console This should be a solution.... any comment please? Link to comment Share on other sites More sharing options...
parsifal Posted April 2, 2015 Share Posted April 2, 2015 Thanks my friend, but the problem is we have 37.000 products in the shop and wanted to bypass the endless importing method For such extreme cases of import volume, I have seen other forum members advising to transfer your website to localhost environment (on a PC with as powerful hardware as possible, obviously), complete the import process there and then transfer the website back to the web host. Link to comment Share on other sites More sharing options...
fitgura Posted April 2, 2015 Author Share Posted April 2, 2015 Thanks Parsifal, finally we solved the problem under 2 days with splitted csv and lots of worrying Now we working on a solution suggested above and share with others soon here 1 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now