Got a packet bigger than 'max_allowed_packet'

[KPDub01]

Hi

I have a shop mod on my forum that I have upload items into for the members to buy.

However, when I hit the recache option within the mod, I get a database error.

I have downloaded the sql error file and it has highlighted the problem as

"Got a packet bigger than 'max_allowed_packet"

The error log file is just over 5MB, so I presume the limit needs increasing to something over 5MB

Could somenoe be kind enough to advise where /how I change the settings please

[Rsync]

Hello Karl,

I have increased max_allowed_packet to 16MB in /etc/my.cnf of your VPS server.

Please give a try and let us know if you face any problem.

[Cristiano]

Hi

I have a shop mod on my forum that I have upload items into for the members to buy.

However, when I hit the recache option within the mod, I get a database error.

I have downloaded the sql error file and it has highlighted the problem as

"Got a packet bigger than 'max_allowed_packet"

The error log file is just over 5MB, so I presume the limit needs increasing to something over 5MB

Could somenoe be kind enough to advise where /how I change the settings please

Hi Karl,

max_allowed_packet defines how large your MySQL Query/Data Packet can be. You can set max_allowed_packet in /etc/my.cnf on the server.

Open /etc/my.cnf with the editor you like. Add "max_allowed_packet=8M" in the file and restart mysql on the server. You can set the max_allowed_packet as per your requirement.

Hope this helps

[KPDub01]

Hmmm, well that hasn't appeared to do anything.

Although a subsequent SQL error isnt being generated - which is strange.

Also, can I assume that the /etc directory resides in the route of my installation? I can't see it when viewing on my FTP program though.

Not sure whether to wait 24 hours and try again to see if a new SQL error file is generated

Although it is strange as the table size is only 122,040 bytes

[KPDub01]

Actually, I've been reading through (the rather large error log - lol) and its referencing another table.

There is a blank array in the corresponding entry in that table. I don't know if its applicable in this case as there are others with a blank array and the associate features seem to be working.

Going to see if I have any archived backups (from my shared hosting days), create a new database and upload the backup in there to see if at least I can copy the array code over

[Rsync]

Hello Karl,

Could you please try again to upload the database OR executing the query ?

Also, can I assume that the /etc directory resides in the route of my installation? I can't see it when viewing on my FTP program though.

You can not access / directory of your VPS through FTP. You will need to access your server via ssh to make any modifications.

[KPDub01]

Hello Karl,

Could you please try again to upload the database OR executing the query ?

It has worked now, whatever you did, thankyou very much

[KPDub01]

Doh - spoke to soon. Whilst it recached the large table, it won't recache another one now.

At least I just get a blank screen now and not a driver error - lol

[Rsync]

Hello Karl,

You are
Glad to know that your issue is resolved

[KPDub01]

Okay, wanted to try to recache it in mysql, but can't use the flush table command as I dont have the reload privalege.

Again sorry for the noob question, so where can I set it so I can have the reload privalege

Not sure if this will work, but worth a shot

[KPDub01]

You can not access / directory of your VPS through FTP. You will need to access your server via ssh to make any modifications.

Okay, another noob question, how do I do that - lol

[eukSam]

Okay, wanted to try to recache it in mysql, but can't use the flush table command as I dont have the reload privalege.

Again sorry for the noob question, so where can I set it so I can have the reload privalege

Not sure if this will work, but worth a shot

Privileges can be assigned from phpmyadmin. You can connect to phpmyadmin from your contol panel & assign privileges to your database.

[eukSam]

Okay, another noob question, how do I do that - lol

SSH can be done through SSH client like 'putty'. Simply download the putty exe & use your vps ipaddress as the Host & port 22 to connect to SSH.

[KPDub01]

Privileges can be assigned from phpmyadmin. You can connect to phpmyadmin from your contol panel & assign privileges to your database.

Okay gone into the database and accessed the information_schema

In the table user privaleges, for admin@locahost the is grantable field is set to YES for RELOAD

However, there is no option to add another user to that table.

Sorry for being completely thick

[eukSam]

Hello Karl,


We have opened a ticket on our helpdesk for you. Please reply to that ticket so we can assist you in a better way.