My prestashop 1.6 website takes about 2minutes save a categore

[ronelgon]

Hello,

My prestashop 1.6.0.9 website takes about 2-3minutes to save a created/edited category or product.  It is very slow in loading. I talked to my web host and increased the time out up to 3-5minutes. But at times its loads until the time expires and then bring 500 error internal server error. The message i get is time out 

 

What can i do to improve the situation?

 

Is there a plugin or module to help on this or how can i manually solve the issue.

 

I tried to  manually clear cache  by going to the folders below to delete the content in them  but found there very many sub folders and not files. So, should i just delete ll the sub-folders i find in those folders below?

 

cache/smarty/compile

cache/smarty/cache

img/tmp

 

Your help will be highly appreciated

 

Thank you

Ronnie

[maconl]

Hi 

only delete the folders and files in the folder cache (made it bold)  except index.php  : cache/smarty/cache -> files and folders

[El Patron]

edit file config/defines.inc.php

 

change the following to true

 

define('_PS_DEBUG_PROFILING_', false);

 

visit slow page(s), collect information at bottom of page

 

this will help you find where shop back is slow

 

note: this will activate profiling for all visitors so use with caution front and back.

[ronelgon]

Hello,

Thanks for your replies. I deleted files and folders in the 3 folders  mentioned above but the backend is still very when saving a category. I also changed this define('_PS_DEBUG_PROFILING_', true); And many things displayed at the front and backend but did not know what exactly to look  for  but below are some of things that displayed at backend;

 

Query    Time (ms)    Rows    Filesort    Group By    Location
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`
FROM `ps1_module` m
INNER JOIN ps1_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `ps1_module_shop` ms ON ms.`id_module` = m.`id_module`
INNER JOIN `ps1_hook_module` hm ON hm.`id_module` = m.`id_module`
INNER JOIN `ps1_hook` h ON hm.`id_hook` = h.`id_hook`
WHERE (h.name != "displayPayment") AND (hm.id_shop = 1)
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`


Execution    Load time (ms)
config    8042
constructor    0
init    7611
checkAccess    0
setMedia    635
postProcess    0
initHeader    858
initContent    3150
initFooter    263
display    620
 

 

AND in the frontend , still many things displayed and below are some of them

Notice: Undefined variable: output in /home/dondo/public_html/modules/blockinvitereferrals/blockinvitereferrals.php on line 134


Stopwatch (with SQL_NO_CACHE) (total = 374)


rom /tools/profiling/ObjectModel.php:37
from /classes/Category.php:137
from /classes/Link.php:165
from /override/classes/Link.php:404
from /modules/blockcategories/blockcategories.php:150
from /modules/blockcategories/blockcategories.php:143
from /modules/blockcategories/blockcategories.php:143
from /modules/blockcategories/blockcategories.php:143
from /modules/blockcategories/blockcategories.php:233
from /classes/Hook.php:509
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:449
from /controllers/front/IndexController.php:37
from /override/controllers/front/IndexController.php:67
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28

 

 

Your help on this issue will be highly appreciated

 

Thank you

Ronnie

Edited December 28, 2014 by ronelgon (see edit history)

[El Patron]

deleting is not going to help, in all honesty that is just a good way to destroy your shop.

[maconl]

deleted in 3 folders ?

noo  only delete the files in the cache and not the compile folder ! this is why i marked the folder in bold,,

as El Patron already said , ( was my step two  )

 

enable the debug to see if you get any errors

if you delete to many files it will destroy everything ! then i hope you got a good backup from your hosting

Edited December 28, 2014 by maconl (see edit history)

[ronelgon]

Hello,

Thanks for your replies.

I did Debug again and In the frontend i did not see any error except this warning below;

Warning: Invalid argument supplied for foreach() in /home/

 

And in the backend, did not see any error or warning

 

Lastly, i have also told my host to restore a backup of few days back. But now what else should i do to change the situation to better?

 

My website does not have many products except the many categories am still creating. I have so far added 10 products and plus those come with the installation

 

 

Your help is always appreciated and am so happy for your response time.

 

Thank you

Ronnie

[Dallerdkj]

Same here, category is too slow - Something is bugging