gavz

I'm using PS 1.6.0.6 The previous version of Mail Alerts was causing the fault also. Upgrading to the latest version did not solve the problem.

Mail alerts v3.4.4 - by PrestaShop is causing the performance of my website to deteriorate, slow load time etc. This is the error: [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]

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?

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]

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.

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

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

I'm trying to add an image to the Hook "Top" of the THEME CONFIGURATOR (V.1.1.6). I'm receiving the error "An error occurred during the image upload." Can someone please assist with rectifying this? Thank you

The Order Status is changing automatically. For example, when an order is received & marked as "Payment Received" it automatically changes to "Shipped". Or if I try & change the status to "Shipped" it automatically changes to "Preparation in Progress". Please advise, thank you

When using PS 1.6.0.6 I receive the following error when uploading product images: "Error while uploading image; please change your server's settings. (Error code: Missing a temporary folder)" Please advise, thank you

Turning off WishList module worked for me as well. A much easier option compared to the the previous advise I was given on the Forge site, which involved upgrading my entire store again! Thank you

I've adjust the number of characters allowed for "supplier_reference" 'size' => 200, but when I import my csv file, it cuts the entries as 32 characters. I can annually enter more than 32 characters though. Can someone please advise, thank you

Thank you, I got it to work. Changes had to be made to ProductSupplier.php

I've increased the number of characters allowed but I'm still getting the error: "Property ProductSupplier->product_supplier_reference length (34) must be between 0 and 32"

I've increased the number of characters allowed but I'm still getting the error: "Property ProductSupplier->product_supplier_reference length (34) must be between 0 and 32"