Anyone familiar with this Database Error?

[Ernie Romers]

I am getting these every once and a while. The error message (1.1 MB) is sent to my admin e-mail address and begins with:

Database error in vBulletin 3.7.2:
Invalid SQL:
SELECT
thread.threadid
FROM thread AS thread

INNER JOIN post AS post ON(thread.threadid = post.threadid )
WHERE post.postid IN

and ends with hundreds of numbers....

My forums are at http://forums.watchuseek.com

[Nick]

Is that the entire Error shown?

[Steve Machol]

Invalid SQL errors are almost always related to modified code. To troubleshoot this, the first thing you need to do is remove any third-pary hacks or plugins, then see if you still have this problem.

If so, reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server.

Next, create a new style and choose no parent style. This will force it to use the default templates. Finally empty your browser cache, close all browser windows then try again. Make sure you change to the new style and view your forums with it. Do you have the same problem?

[Ernie Romers]

no, there are hundreds of numbers and this at the end of the error message:

MySQL Error : Got a packet bigger than 'max_allowed_packet' bytes
Error Number : 1153
Request Date : Friday, August 8th 2008 @ 10:49:23 PM
Error Date : Friday, August 8th 2008 @ 10:49:38 PM
Script : http://forums.watchuseek.com/search.php?do=process
Referrer : http://forums.watchuseek.com/search.php?do=process
IP Address : [removed for privacy reasons]
Username : Unregistered
Classname : vB_Database
MySQL Version :

[Steve Machol]

This is a server issue. You or your host will need to increase the 'max_allowed_packet' in my.cnf, then restart MySQL. I recommend at least 32M for this setting. If that doesn't work, try 64M.

[Ernie Romers]

Steve,

Thanks so much. That was very helpful. I will forward your advice to my tech guys.

Best regards,
Ernie
Watchuseek.com