Jump to content

problems with mysql


Dimoooon

Recommended Posts

Hi! presta version 1.6.5

 

i have virtual server and a few e-shop on it…

now i'm developing a theme for new one and one day ago i have found a problem… the cart is showing that there is some products in it but when i put mouse over it - there is no products and total price 0… on some of those sites on my server are dissapeared also products from main page (new and popular)… so i turned on debug mode and got next error…

 

[PrestaShopDatabaseException] 

 

Got a packet bigger than 'max_allowed_packet' bytes 

 

I have googled and found that i can fix this problem changing value in mysql config file… i've done and changed from 1m to 32, 64 and 128 M… restarted mysql… was all ok… but after some period of time - some hours, this error repeats again…

 

what it could be and what should i do? please help…

post-1252098-0-20682500-1465538219_thumb.png

Link to comment
Share on other sites

PHP Version => 5.6.14-0+deb8u1

mysql  Ver 14.14 Distrib 5.5.46, for debian-linux-gnu (x86_64) using readline 6.3
 

How many memory? For PS 1.6 we recommend not lower than 256M. - what memory are you talking about? if RAM 1GB for virtual server

Mod_security disabled? yes
Php-fpm deactivated? how can i check?
i have tried next
ps aux | grep php-fpmxxx       687  0.0  0.3  47132  3368 ?        Ss   Jun09   0:03 php-fpm: master processxxx     689  0.0  0.7  47252  7724 ?        S    Jun09   0:00 php-fpm: pool www                  xxx      690  0.0  0.7  47800  8044 ?        S    Jun09   0:00 php-fpm: pool www                  xxx     2256  0.0  0.7  47284  7996 ?        S    Jun09   0:00 php-fpm: pool www                  xxx     22966  0.0  0.2  12724  2160 pts/1    S+   10:24   0:00 grep php-fpm
Block cart module in use is latest version? - i'm using block cart which was going with prestashop 1.6.1.5 from official web site. version 1.6.0
Cookie and Browser cache deleted? -yes
 
i tried different browsers… this problem repeates after near 1 hour when i restart mysql… because only mysql restart can help…
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...