Problem with slow loading homepage and other CMS pages.

[Kolar]

Hello, I have problem with my online shop. A few days ago, something happened and there was 500 internal server error when trying to go to my website. I restarted VPS, cleaned cache. I realized that a cannot upload any file to my FTP account because of quota limit (I use Webmin/Virtualmin), so I changed it and the page started to work normally, but it is loading very slow.

 

Not all pages are loading slow, only homepage, about us page and other cms pages.

 

Here is error code:

 

[PrestaShopDatabaseException]

Db->executeS() must be used only with select, show, explain or describe queries
at line 616 in file classes/db/Db.php

611.
612.         // This method must be used only with queries which display results
613.         if (!preg_match('#^\s*\(?\s*(select|show|explain|describe|desc)\s#i', $sql))
614.         {
615.             if (defined('_PS_MODE_DEV_') && _PS_MODE_DEV_)
616.                 throw new PrestaShopDatabaseException('Db->executeS() must be used only with select, show, explain or describe queries');
617.             return $this->execute($sql, $use_cache);
618.         }
619.
620.         $this->result = $this->query($sql);
621.

• DbCore->executeS - [line 58 - override/classes/Product.php] - [1 Arguments]
• Product::getFrontFeaturesStatic - [line 4148 - classes/Product.php] - [2 Arguments]
• ProductCore::getProductProperties - [line 4199 - classes/Product.php] - [2 Arguments]
• ProductCore::getProductsProperties - [line 202 - classes/ProductSale.php] - [2 Arguments]
• ProductSaleCore::getBestSalesLight - [line 268 - modules/blockbestsellers/blockbestsellers.php] - [3 Arguments]
• BlockBestSellers->getBestSellers - [line 243 - modules/blockbestsellers/blockbestsellers.php] - [1 Arguments]
• BlockBestSellers->hookRightColumn - [line 260 - modules/blockbestsellers/blockbestsellers.php] - [1 Arguments]
• BlockBestSellers->hookLeftColumn - [line 569 - classes/Hook.php] - [1 Arguments]
• HookCore::coreCallHook - [line 526 - classes/Hook.php] - [3 Arguments]
• HookCore::exec - [line 581 - classes/controller/FrontController.php] - [1 Arguments]
• FrontControllerCore->initContent - [line 37 - controllers/front/IndexController.php]
• IndexControllerCore->initContent - [line 180 - classes/controller/Controller.php]
• ControllerCore->run - [line 373 - classes/Dispatcher.php]
• DispatcherCore->dispatch - [line 28 - index.php]

[shokinro]

I think the error is from following file, where it should use Execute() for non-data query SQL statement(such update/delete/indert) , but in stead it uses "executeS" as  it is mentiioned in the error message

 

override/classes/Product.php

 

The override class should be coming from module, if you are not sure how to change that, it is better to contact the module developer.

[Kolar]

Thank you for your reply. Do you know what module it concerns? I will disable it and check if everything is ok.

 

EDIT:

When I ticked "Disable all modules not from Prestashop" and "Disable all overrides" in Performance tab, nothing changed. BO works perfectly and fast.

Edited May 4, 2016 by Kolar (see edit history)

[dep+......]

So it's maybe conflict modules. Try disable recent module you installed to test what really work. Good luck!

 

Atlas batteries for cars with cheap price.

Edited May 4, 2016 by dep+...... (see edit history)

[Kolar]

The problem is, that from a few months I have not installed any module. Maybe the problem is with something else? Maybe something with database?

 

Loading the homepage lasts about 2-3min. You can check: www.autoleds.pl

[Teapot Creative]

Hi

 

Do you have caching enabled in the back office? This will speed things up. 

 

 

 

(See screenshots)

 

NickC

NB. Went to site was not to slow certainly not 2-3 mins

Edited May 4, 2016 by Teapot Creative (see edit history)

[Kolar]

No, I disabled cache to see changes and I wont enable this until everything works fine. I disabled updated Paypal module and the homepage loads fast. I have no idea why it is Paypal module.

[shokinro]

The slowness might be not related to the error. The error itself is just warning, it should be still working.

 

In order to increase performance, you need to enable both Smarty cache and enable CCC as suggested by @Teapot Creative.

 

Beside that, you may also consider to use contents cache of the store, which is at bottom of the same setting page

- back office - Advanced Parameters - Performance tab

[tuk66]

The page loads within 10 s and you should definitely enable CCC. There are too many requests on every page.