Housy Posted December 19, 2011 Share Posted December 19, 2011 Hello I'm still using the old 1.3.5.0 PS version but I have a little problem with the database backup (BACK OFFICE). When i press create DB backup, then after 35 seconds of creating my backup see what happens (look at the picture in the attachment). I get a blank page but the backup is created, when i refresh the page but it isn't complete. In my shop i have more than 1000 orders and around 200 products so the database is not that small. Are there maybe any time limitations (in my case 35 seconds) set in Prestashop? What could be wrong? When i use phpmyadmin for DB backup, everything works fine. Thanks, Housy Link to comment Share on other sites More sharing options...
doekia Posted December 19, 2011 Share Posted December 19, 2011 The max_execution_time of your server does not allow any operation to exceed 30s Hint: php.ini or php5.ini or .htaccess could on some hosting helps rising this value. Liaise with your hosting company to know exactly how it need to be addressed for your implementation. Link to comment Share on other sites More sharing options...
Mike Kranzler Posted December 19, 2011 Share Posted December 19, 2011 Hi Housy, As doekia said, this is an issue with the max_execution_time value of your php.ini file. Often, the actual time it would've taken on slower servers is barely more than the 30 second value (I've run tests where it would've taken 34 seconds if not for the timeout), but if you call your hosting provider and ask them to increase that value (60 seconds is usually a good value to request), they should be able to handle it for you very easily. I hope this helps. -Mike Link to comment Share on other sites More sharing options...
doekia Posted December 19, 2011 Share Posted December 19, 2011 And when hosting provider allows this to be tuned per directory (thru .htaccess most of the time), you can even go further for the admin portion of the site. This can be usefull for the import function as well. Best, (d)oekia Link to comment Share on other sites More sharing options...
Housy Posted December 21, 2011 Author Share Posted December 21, 2011 "max_execution_time = 60" - That solved my problem It works like a charm Thank you both Link to comment Share on other sites More sharing options...
Mike Kranzler Posted December 21, 2011 Share Posted December 21, 2011 I'm glad we could help! Happy selling! -Mike Link to comment Share on other sites More sharing options...
doekia Posted December 21, 2011 Share Posted December 21, 2011 Just one thing for those searching the forum for solutions 60 seconds may not be suitable for your database and as the DB growth it may not be sufficient. And last if you have the change that the settings can be set per directory reserve this increase of value to the admin area of the site Best, (d)oekia Link to comment Share on other sites More sharing options...
majinkun180 Posted January 6, 2012 Share Posted January 6, 2012 Sorry for posting on something that was solved but I got this php.ini file increased by the host now my backoffice is having tons of problems. I am running prestashop v1.3.3. #1. Random orders don't show up even though the payment went through. I can open the pdf file but I can't see the actual items ordered on the orders tab. #2 When I tried to increase the amount of stock for a certain item Things disappear on the backend, for example: I had 6 types of notebooks in a category then I increased stock for one of them, now it only shows 1 type of notebook with this error showing below it: Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator, [email protected] and inform them of the time the error occurred, and anything you might have done that may have caused the error. More information about this error may be available in the server error log. The hosting company says they only changed was the max_execution_time but I don't believe them. Is it possible that they touched other stuff and not taking responsibility for it? Now they are telling me to get someone to fix it for me. I think this is alot of BS. Link to comment Share on other sites More sharing options...
Mike Kranzler Posted January 6, 2012 Share Posted January 6, 2012 Hi majinkun, If you would like to see everything that may have been changed by your host, please place the attached file at the root of your store via FTP, and then navigate to www.yourshop.com/phpinfo.php Then you can compare the current and default values for many different things across your store. phpinfo.php I hope this helps. -Mike Link to comment Share on other sites More sharing options...
majinkun180 Posted January 6, 2012 Share Posted January 6, 2012 Hi Mike, thank you for your quick response. By root folder did you mean where all my .php files are? Sorry for such a noob question. Link to comment Share on other sites More sharing options...
Mike Kranzler Posted January 6, 2012 Share Posted January 6, 2012 Hi Mike, thank you for your quick response. By root folder did you mean where all my .php files are? Sorry for such a noob question. Yes, along with all of the of the other PrestaShop folders, such as admin, modules, tools, etc. Link to comment Share on other sites More sharing options...
majinkun180 Posted January 6, 2012 Share Posted January 6, 2012 Okay I see where to put it and I'm looking at the numbers but I don't see a difference. The hosting company said they put everything back to default but yet my internal errors are still there. Once the damage is done theres no way of fixing it? Link to comment Share on other sites More sharing options...
Mike Kranzler Posted January 6, 2012 Share Posted January 6, 2012 Okay I see where to put it and I'm looking at the numbers but I don't see a difference. The hosting company said they put everything back to default but yet my internal errors are still there. Once the damage is done theres no way of fixing it? In this situation, I would recommend you speak with our advanced support team. If you would like, you can either call them at 888 947 6543 or PM me with your contact information and I will pass it along to them myself. -Mike Link to comment Share on other sites More sharing options...
majinkun180 Posted January 6, 2012 Share Posted January 6, 2012 pm'ed you. Link to comment Share on other sites More sharing options...
Recommended Posts