Bug Databade Error ~ Packet Size

[Freekoid]

I cant put the all the database error here because its too big

The text that you have entered is too long (1065494 characters). Please shorten it to 20000 characters long.

Database error in vBulletin 4.0.6:

Invalid SQL:
MySQL Error : Got a packet bigger than 'max_allowed_packet' bytes
Error Number : 1153
Request Date : Monday, December 26th 2011 @ 10:55:44 AM
Error Date : Monday, December 26th 2011 @ 10:56:10 AM
Script :
Referrer :
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.0.67-community



View attachment dberror.txt

 

[Fillip H.]

Please increase your max_allowed_packet in my.cnf (*nix) or my.ini (Windows)

 

[Freekoid]

I dont know how to do any of that ^

 

[Fillip H.]

3rd result on Google for "how to increase max_allowed_packet": How to Increase max_allowed_packets in MySQL - Forums - Liferay.com

If you cannot perform the steps described in that thread, contact your web host and tell them to do it

We use 128M as the value here on DBTech, no issues

Please note that shared hosts may be reluctant to change this, so if your host is unwilling to change it you will need to switch web hosts.


PS: This is not a problem unique to DBTech mods or indeed any other vBulletin modification. You will find you are going to run into this issue if you attempt to install one or more other products from other vendors (so long as they add more phrases).

 

[Freekoid]

I logged into mysql and executed show variables like 'max_allowed_packet';

max_allowed_packet 1048576

Now the thread you mention reads quite well yet this line:

To get around this, you need to increase MySQL's max_allowed_packet variable. Edit the .ini or .cnf (depends on the setup you have) file that is read by mySQL.

does not tell you where to find this .ini or .cnf.

Any help on that? Ive looked through my file listing and see neither! DirectAdmin sucks..

 

[Fillip H.]

That depends heavily on your system, though usually it's in /etc/ for *nix systems.