Database error in showgroups.php

[Milobil]

Hi,

When i open this url : myforum.com/showgroups.php, i get a database error with this message :

Database error in vBulletin 4.2.0:

Invalid SQL:

REPLACE INTO vb_cache
SET cacheid = 'showgroups.groupcache',
expires = 1440799765,
created = 1440788965,
locktime = 0,
data = "too long message so i didin't past it here"


I tried to clear the cache, repair & optimize tables through admincp but i'm still facing this problem.

If you have any idea what's the problem please help me

[squidsk]

That's not the complete error message. Your missing the part where it tells you what the query is and which part of it has the invalid sql.

[Dave]

I have a feeling this is the "max_allowed_packet" error, which is related to your database server.
If that's the case, you should ask your host to increase that parameter its value in MySQL.

[Milobil]

So I don't have to do anything on the vb_cache table myself ?

[ozzy47]

Post the entire error message.

[Lynne]

Well, not the "too long message so i didin't past it here" part, but post the part that looks like this:

MySQL Error : some sort of something here
Error Number : another something here
Date : Sunday, April 13th 2008 @ 11:16:43 AM
Script : http://address.path.path/page.php
Referrer :
IP Address : **.***.**.***
Username : username
Classname : database

[Milobil]

Well I just contacted my host and they told me that I had to optimize the script because the request was taking to much time to be executed through mysql, thanks for your help anyways!

[squidsk]

If they're telling you that they don't know what they're talking about and don't really want to look into the issue.

Either way what's the actual error message, the part in the code block that Lynne posted in post #6.

[Milobil]

Well, it seems that it tries to display all the users datas, and the script can't end itself, i have to stop the page loading myself, here's a part of the error message :

[ozzy47]

Ohhh good grief.