Havouza

Hi! Is it possible to change a setting so you show the prices ex vat?

ok problem solved for now. Thousand thanks to @datakick for your patience

the strange thing is that it is on both shops. But at least somewhere to start Loadtime is still 1136 ms

This looks shit balso

@datakick

@datakick To compare the other server that is on the same vps and all else is the same

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