gavz Posted December 5, 2014 Share Posted December 5, 2014 Hi there, I'm experiencing Slow Load Time & HTTP 500 Internal Server Error issue on my website. This is experienced from the front end with most webpages. I'm not trying to do anything exhaustive, just browse the site's pages. I've followed this advice http://www.prestashop.com/blog/en/the-500-internal-server-error-explained-solved/: - turned on Error Reporting in PrestaShop: with no improvement - adjusted Permissions: with no improvement - regenerate .htaccess file: with no improvement I have cPanel error logs if you would like to view them? Thank you Link to comment Share on other sites More sharing options...
JPresta.com Posted December 5, 2014 Share Posted December 5, 2014 Did you try to enable profiling? Link to comment Share on other sites More sharing options...
gavz Posted December 6, 2014 Author Share Posted December 6, 2014 Did you try to enable profiling? I have now. Here is the result: Load time: 53.431s You'd better run your shop on a toasterconfig: 35.629s constructor: 0ms init: 2.355s checkAccess: 0ms setMedia: 23ms postProcess: 0ms initHeader: 0ms initContent: 8.773s initFooter: 6.008s display: 644ms Hook processing: 15.201s / 13.05 Mb67 methods called in 42 modules displayFooter: 6.008s / 0.98 Mb displayTop: 4.615s / 2.38 Mb displayHomeTab: 1.229s / 0.09 Mb displayHome: 1.063s / 0.22 Mb displayHomeTabContent: 737ms / 0.43 Mb displayHeader: 602ms / 8.84 Mb displayLeftColumn: 525ms / 0.05 Mb displayTopColumn: 421ms / 0.05 Mb moduleRoutes: 0ms / 0 Mb actionObjectAddAfter: 0ms / 0 Mb actionFrontControllerSetMedia: 0ms / 0 Mb displayBanner: 0ms / 0 Mb actionObjectAddBefore: 0ms / 0 Mb DisplayOverrideTemplate: 0ms / 0 Mb actionObjectConnectionAddAfter: 0ms / 0 Mb actionObjectConnectionAddBefore: 0ms / 0 Mb actionDispatcher: 0ms / 0 Mb displayNav: 0ms / 0 Mb Memory peak usage: 23.8 Mbconfig: 6.47 Mb (6.5 Mb) constructor: 0 Mb (6.5 Mb) init: 3.22 Mb (9.7 Mb) checkAccess: 0 Mb (9.7 Mb) setMedia: 0.2 Mb (9.9 Mb) postProcess: 0 Mb (9.9 Mb) initHeader: 0 Mb (9.9 Mb) initContent: 12.03 Mb (22.1 Mb) initFooter: 0.99 Mb (23 Mb) display: 0.38 Mb (23.8 Mb) Total cache size (in Cache class): 0.27 Mb DB type: DbPDO SQL Queries: 77 queries Time spent querying: 52.066s Included files: 216Size of included files: 2.92 Mb Globals (> 1 Ko only): 190 Ko_MODULES ≈ 112.5 Ko _LANG ≈ 60 Ko _SERVER ≈ 8.2 Ko _REQUEST ≈ 1.7 Ko _COOKIE ≈ 1.7 Ko Link to comment Share on other sites More sharing options...
JPresta.com Posted December 6, 2014 Share Posted December 6, 2014 Whaow, are you really running on a toaster? :-) Ask your hosting provider, config should not be that long (35s) I think the problem comes from your MySQL server which taks almost all the time. Link to comment Share on other sites More sharing options...
gavz Posted December 6, 2014 Author Share Posted December 6, 2014 Whaow, are you really running on a toaster? :-) Ask your hosting provider, config should not be that long (35s) I think the problem comes from your MySQL server which taks almost all the time. How do I adjust the config? Godaddy have advised that the MySQL server has no known issues. They are not able to optimise the database for me. Link to comment Share on other sites More sharing options...
El Patron Posted December 7, 2014 Share Posted December 7, 2014 here is something you can try... set these to yes http://screencast.com/t/8gvvL7hn see if improvement....what we want to find out is some module has created this issue. Link to comment Share on other sites More sharing options...
gavz Posted December 8, 2014 Author Share Posted December 8, 2014 here is something you can try... set these to yes http://screencast.com/t/8gvvL7hn see if improvement....what we want to find out is some module has created this issue. Before doing the above, Mail alerts by PrestaShop was throwing the below error. I tried updating the module but the problem still existed. I disabled the module & now the site seems to be working fine. Does this sound familiar? [PrestaShopDatabaseException]Unknown column 'id_shop' in 'where clause' SELECT * FROM `ps_mailalert_customer_oos` WHERE (id_customer=20 OR customer_email='[email protected]') AND `id_product` = 557 AND `id_product_attribute` = 0 AND `id_shop` = 1 at line 635 in file classes/db/Db.php 629. WebserviceRequest::getInstance()->setError(500, ' '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97); 630. } 631. else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) 632. { 633. if ($sql) 634. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>'); 635. throw new PrestaShopDatabaseException($this->getMsgError()); 636. } 637. } 638. 639. /** DbCore->displayError - [line 325 - classes/db/Db.php] - [1 Arguments] DbCore->query - [line 501 - classes/db/Db.php] - [1 Arguments] DbCore->executeS - [line 80 - modules/mailalerts/MailAlert.php] - [1 Arguments] MailAlert::customerHasNotification - [line 426 - modules/mailalerts/mailalerts.php] - [4 Arguments] MailAlerts->hookActionProductOutOfStock - [line 507 - classes/Hook.php] - [1 Arguments] HookCore::exec - [line 262 - controllers/front/ProductController.php] - [2 Arguments] ProductControllerCore->initContent - [line 180 - classes/controller/Controller.php] ControllerCore->run - [line 373 - classes/Dispatcher.php] DispatcherCore->dispatch - [line 28 - index.php] Link to comment Share on other sites More sharing options...
El Patron Posted December 8, 2014 Share Posted December 8, 2014 I suppose the question is what is your PrestaShop version and mail alerts module version. I did not search on the error to see if similar issue reported, did you? Link to comment Share on other sites More sharing options...
gavz Posted December 8, 2014 Author Share Posted December 8, 2014 I suppose the question is what is your PrestaShop version and mail alerts module version. I did not search on the error to see if similar issue reported, did you? Disabling Mail alerts v3.4.4 was only a temporary fix. The speed has deteriorated again & I'm occasionally receiving "HTTP 500 Internal Server Error". I'm using PS 1.6.0.6. Disabling non PrestaShop modules & disabling all overrides has helped improve performance. What would you suggest I do next? Link to comment Share on other sites More sharing options...
El Patron Posted December 8, 2014 Share Posted December 8, 2014 if disabling overrides and modules help performance, this tells us that there is 3rd party module(s) area likely creating issue. Reverse changes over/mod disable. Disable one by one modules you may have installed (note some modules with overrides may not be coded for 'disable', uninstall will ensure override not executed. 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