Havouza

Is this the profiling info I attached? All Cache on, using Redis and full page cache. But same settings on both shops

@datakick I have fixed the problem. Unfortunately it does not change the cat that the new server is slow as the old one. I am running bleeding edge but perhaps ther is some new updates that is not installed here

@datakick Ok I will create a new key. Thanks Unfortunately it is still horribly slow. I hoped it would be better on a new server with double ram 16 gb, newer mysql server 8.3 and new ubuntu 20. but it is still the same old ones jv74.se jv80.se These to are clones sitting on the same server. Same amount of products about, same modules, same settings. But huge difference in loadspeed. On both BO is no problem 74.jv74.se is the migrated one. I have no clue where to look for the slow loadtime problem

@datakick settings.inc Looks correct The only thing is this lines about memcache that is not installed on this server define('_DB_SERVER_', 'localhost'); define('_DB_NAME_', 'db_jv74'); define('_DB_USER_', 'jv74'); define('_DB_PASSWD_', 'xxxxxxxx'); define('_DB_PREFIX_', 'ps_'); define('_MYSQL_ENGINE_', 'MyISAM'); define('_PS_CACHING_SYSTEM_', 'CacheMemcache'); define('_PS_CACHE_ENABLED_', '0'); define('_COOKIE_KEY_', 'EW14dGdgFNqqE3AgLSjXvmbue5p6uBGt4AvTWeSYVaFO6BJACZ8HdAea'); define('_COOKIE_IV_', 'M0Wb22fJ'); define('_PS_CREATION_DATE_', '2016-09-01'); define('_PS_VERSION_', '1.6.1.999'); define('_TB_VERSION_', '1.4.0'); define('_RIJNDAEL_KEY_', 'ish7GerF6In1RXpSaVYcseigqCPIv4Oy'); define('_RIJNDAEL_IV_', 'nqT3Sj8kz6AWqjlObU4OCA=='); define('_PS_DIRECTORY_', '/../../'); define('_PHP_ENCRYPTION_KEY_', 'def000008191607ea7718df3adf8fd33b20a58f11acae1bec4e13cf54b3c000a13dcb2e5d4a7cb76c473d33c5c3d6d4acb43d627e33ce546a018a498cd7c121fbd379f2a'); define('_TB_REVISION_', '7c468f3ccd75167e05b5a87a99cb666fd4d78bd8');

@datakick https://74.jv74.se/phpinfo.php

It seems to me that it is time to sity back and wait for the old server to die and the shops with it. Something is very fishy

Expanding memory did not help [Tue Aug 09 12:36:42.703583 2022] [proxy_fcgi:error] [pid 24119:tid 139926830479104] [client 185.60.237.38:47084] AH01071: Got error 'PHP message: PHP Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 20480 bytes) in /home/seven4/public_html/classes/db/DbPDO.php on line 73PHP message: PHP Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 20480 bytes) in /home/seven4/public_html/classes/ErrorHandler.php on line 193'

This one is the one after the reboot [Tue Aug 09 12:18:59.971275 2022] [proxy_fcgi:error] [pid 17553:tid 139926720988928] [client 185.60.237.38:46234] AH01071: Got error 'PHP message: PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 69632 bytes) in /home/seven4/public_html/classes/db/DbPDO.php on line 73PHP message: PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 20480 bytes) in /home/seven4/public_html/classes/PrestaShopAutoload.php on line 263'

The strange this is that in the old one its also set to 128 and thats enough. have to investigate. Changed in the new to 512 rebooted but no change

[Tue Aug 09 11:39:43.970412 2022] [proxy_fcgi:error] [pid 8199:tid 140591677544192] [client 192.241.235.244:50742] AH01071: Got error 'PHP message: PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 20480 bytes) in /home/seven4/public_html/classes/db/DbPDO.php on line 73PHP message: PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 20480 bytes) in /home/seven4/public_html/classes/ErrorHandler.php on line 193'

@datakick Errormessages below. As I understand a cache problem. I cleaned the cache and switched all cachesettings off before the migration, but perhaps I could delete some cache files/folders also? Advise please [Tue Aug 09 11:01:09.994052 2022] [proxy_fcgi:error] [pid 17639] [client 69.162.124.235:51082] AH01071: Got error 'PHP message: PHP Warning: Creating default object from empty value in /home/jv74/public_html/cache/smarty/compile/87/a4/f5/87a4f5b16ef3376726317ad2fb0f52169b9043ca_0.file.blockcart.tpl.php on line 256PHP message: PHP Notice: Undefined index: link_rewrite in /home/jv74/public_html/cache/smarty/compile/3c/ec/83/3cec835ea2c1315898dbca134b31ae23de74765d_0.file.at_catproduct.tpl.cache.php on line 85PHP message: PHP Notice: Undefined index: link_rewrite in /home/jv74/public_html/cache/smarty/compile/3c/ec/83/3cec835ea2c1315898dbca134b31ae23de74765d_0.file.at_catproduct.tpl.cache.php on line 85PHP message: PHP Notice: Undefined index: link_rewrite in /home/jv74/public_html/cache/smarty/compile/3c/ec/83/3cec835ea2c1315898dbca134b31ae23de74765d_0.file.at_catproduct.tpl.cache.php on line 85PHP message: PHP Notice: Undefined index: link_rewrite in /home/jv74/public_html/cache/smarty/compile/3c/ec/83/3cec835ea2c1315898dbca134b31ae23de74765d_0.file.at_catproduct.tpl.cache.php on line 85', referer: https://jv74.se [Tue Aug 09 11:06:10.056726 2022] [proxy_fcgi:error] [pid 17632] [client 69.162.124.235:56582] AH01071: Got error 'PHP message: PHP Warning: Creating default object from empty value in /home/jv74/public_html/cache/smarty/compile/87/a4/f5/87a4f5b16ef3376726317ad2fb0f52169b9043ca_0.file.blockcart.tpl.php on line 256PHP message: PHP Notice: Undefined index: link_rewrite in /home/jv74/public_html/cache/smarty/compile/3c/ec/83/3cec835ea2c1315898dbca134b31ae23de74765d_0.file.at_catproduct.tpl.cache.php on line 85PHP message: PHP Notice: Undefined index: link_rewrite in /home/jv74/public_html/cache/smarty/compile/3c/ec/83/3cec835ea2c1315898dbca134b31ae23de74765d_0.file.at_catproduct.tpl.cache.php on line 85PHP message: PHP Notice: Undefined index: link_rewrite in /home/jv74/public_html/cache/smarty/compile/3c/ec/83/3cec835ea2c1315898dbca134b31ae23de74765d_0.file.at_catproduct.tpl.cache.php on line 85PHP message: PHP Notice: Undefined index: link_rewrite in /home/jv74/public_html/cache/smarty/compile/3c/ec/83/3cec835ea2c1315898dbca134b31ae23de74765d_0.file.at_catproduct.tpl.cache.php on line 85', referer: https://jv74.se [Tue Aug 09 11:07:43.619874 2022] [proxy_fcgi:error] [pid 17635] [client 17.121.114.145:37226] AH01071: Got error 'PHP message: PHP Warning: Creating default object from empty value in /home/jv74/public_html/cache/smarty/compile/87/a4/f5/87a4f5b16ef3376726317ad2fb0f52169b9043ca_0.file.blockcart.tpl.php on line 256' [Tue Aug 09 11:11:09.127198 2022] [proxy_fcgi:error] [pid 17595] [client 69.162.124.235:43540] AH01071: Got error 'PHP message: PHP Warning: Creating default object from empty value in /home/jv74/public_html/cache/smarty/compile/87/a4/f5/87a4f5b16ef3376726317ad2fb0f52169b9043ca_0.file.blockcart.tpl.php on line 256PHP message: PHP Notice: Undefined index: link_rewrite in /home/jv74/public_html/cache/smarty/compile/3c/ec/83/3cec835ea2c1315898dbca134b31ae23de74765d_0.file.at_catproduct.tpl.cache.php on line 85PHP message: PHP Notice: Undefined index: link_rewrite in /home/jv74/public_html/cache/smarty/compile/3c/ec/83/3cec835ea2c1315898dbca134b31ae23de74765d_0.file.at_catproduct.tpl.cache.php on line 85PHP message: PHP Notice: Undefined index: link_rewrite in /home/jv74/public_html/cache/smarty/compile/3c/ec/83/3cec835ea2c1315898dbca134b31ae23de74765d_0.file.at_catproduct.tpl.cache.php on line 85PHP message: PHP Notice: Undefined index: link_rewrite in /home/jv74/public_html/cache/smarty/compile/3c/ec/83/3cec835ea2c1315898dbca134b31ae23de74765d_0.file.at_catproduct.tpl.cache.php on line 85', referer: https://jv74.se [Tue Aug 09 11:12:06.314172 2022] [proxy_fcgi:error] [pid 11940] [client 66.249.66.158:39942] AH01071: Got error 'PHP message: PHP Warning: Creating default object from empty value in /home/jv74/public_html/cache/smarty/compile/87/a4/f5/87a4f5b16ef3376726317ad2fb0f52169b9043ca_0.file.blockcart.tpl.php on line 256' [Tue Aug 09 11:12:13.814316 2022] [proxy_fcgi:error] [pid 17635] [client 66.249.66.159:55962] AH01071: Got error 'PHP message: PHP Warning: Creating default object from empty value in /home/jv74/public_html/cache/smarty/compile/87/a4/f5/87a4f5b16ef3376726317ad2fb0f52169b9043ca_0.file.blockcart.tpl.php on line 256' [Tue Aug 09 11:12:20.825219 2022] [proxy_fcgi:error] [pid 17639] [client 66.249.66.158:35442] AH01071: Got error 'PHP message: PHP Warning: Creating default object from empty value in /home/jv74/public_html/cache/smarty/compile/87/a4/f5/87a4f5b16ef3376726317ad2fb0f52169b9043ca_0.file.blockcart.tpl.php on line 256'

Hi! I am trying to finally migrate our shops to a new a little more powerful vps with newer OS and Mysql server. I have used the Rsync method to transfer the public_html folder and a sqldump to move the db. But I get a 500 error when I try to open it on the new server. What is it I have missed or been douing wrong. Any help appreciated

What is the files in the download folder? over 400 files over 500 mb. All named like 0005d5d206c2458c0ef5b5e30cafa907e46d54bf oldest from beginning 2017 Can be deleted?

Hi @Mediacom87 I will ask the owner. But unfotunately I think the problem is bigger. He has 2 shops, mostly identical. Same version, same number of products, about 1500 in each, same modules etc. They both resides on the same vps. Jv74.se is horribly slow, jv80.se is much better even if not perfect. I have run out of ideas about what can be wrong. The biggest delay is to load the frontpage. Both shops has memcached installed can you give a hint where to look

I am trying to find why the shop is so slow. this could be one reason to it. The other shop has only 10% of the rows and is also much faster. It seems that the table only holds statistics

I have found a corrupt db table, ps_guest. It contains 2596906 rows. What is this? Result when try to recover Wrong bytesec: 0- 0- 0 at 54229816; Skipped Can the table be emptied

Well our mysql server do that. It only has to do with the bind address. And as said I have already tested the user from remote, the question is if just the username is enoughj because when you test it you use user@ip

Hi! The shop today connect to a local msql server. But we want to change that and connect to a remote one. I have donee all preparations and the user is approved and tested. But how should it look in settings.inc? _DB_SERVER_', 'localhost'); define('_DB_NAME_', 'db_jv74'); define('_DB_USER_', 'jxxxx'); define('_DB_PASSWD_', 'xxxxxxxx');

Hi all! Which is the optimal caching method and best settings? Shop run on Ubuntu 20.04

The only real diff between them is that jv74 is a converted ps from the very early tb days, the other one is created with tb 1.0.2 i think

Its strange because nothing is done to any of the shops more then price uploads. All came when I installed bleeding edge

The other one is jv80.se

Hi We have a vps with 2 shops running. they are really setuop the same way with same modules etc. Both TB 1.4 One of them is for some reason very slow now. jv74.se The other one loads much faster and searches is much faster. is there some way to diagnose what is wrong? They both run on ubuntu First I thought it was my internet here in Cyprus that was slow but the owner in Sweden say the same and he has a 100/100 fiber

What is the best way to migrate a shop from one vps to another?

Hi all! We need to migrate one of our shops to a new vps. The old one runs ubuntu 18.04 so I has snapshots built in but I suspect that it not possible to just take a snapshot and then reload it on another vps. So which way is the best and most secure way to do it. Regards Anders