Jump to content

My prestashop 1.6 website takes about 2minutes save a categore


ronelgon

Recommended Posts

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
Link to comment
Share on other sites

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 by ronelgon (see edit history)
Link to comment
Share on other sites

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 by maconl (see edit history)
Link to comment
Share on other sites

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
Link to comment
Share on other sites

  • 5 weeks later...
×
×
  • Create New...