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 :

https://vborg.vbsupport.ru/external/2015/09/31.png

[ozzy47]

Ohhh good grief.

[Dave]

Ask your host to increase the value of max_allowed_packet in MySQL.

[ForceHSS]

Or close everything down and go on a cruise and bring me with u :)

[the one]

Or close everything down and go on a cruise and bring me with u :)

Can i come

whoops sorry back to topic

[Milobil]

Ask your host to increase the value of max_allowed_packet in MySQL.

They said that it wasn't possible to do that as it's a shared hosting :/

[ozzy47]

Then it's time to find a new host.

[Dave]

They said that it wasn't possible to do that as it's a shared hosting :/

Yeah unfortunately many shared hosting companies have a lot of limitations.
In case you do look for a new host, be sure to ask them before hand if such values can be changed or what the default values are.

If you need a recommendation: I'm very satisfied with stablehost.com.
In case your forum is big, you may want to consider getting a VPS instead of shared hosting.

[Milobil]

All right thanks for your help guys!

[HM666]

Then it's time to find a new host.

Yep, exactly or purchase a different plan that allows for the proper set up. Although if it were me I'd go to another host. There are lots of good ones that do not cost much that do not have a problem in helping with these types of matters.