Error Message entitled VBulletin Database Error!

[Doctor Death]

I routinely get emails from my vbulletin 4.1.0 setup telling me I have an error....

These emails are large and consist mostly of binary data; I believe it has something to do with storing pictures in albums, but I cannot specifically tell.

I have taken screen captures of both error message emails; I get several of these a day but with no useful pattern.

Any advice or tips on figuring out how to resolve this error would be useful.

[Doctor Death]

No ideas anyone?

[Videx]

I'm no expert. But it looks like a cron job is running the script, so the first thing to do is figure out which script is actually screwing up. I found a related thread: http://www.vbulletin.com/forum/showthread.php?252115-HACK-cron.php-rand-XXXXXX-Replacing-my-SQL-data-from-browser

You might also be able to disable all your mods and add them back one at a time, but I don't think that trick would work if this is some old cron job from a partially uninstalled mod.

[fluidswork]

Another solution is that go to cpannel and check for cron jobs and I don't know that this will help you or not but if you delete the mod and then delete the cron job from cpannel and again do the fresh install of the same mod then i think it will solve then problem ....

But remember this will only help if you do this manually from cpannel ............!!!

[Doctor Death]

I am still unable to find this... have checked Cron jobs and databases with no orphaned tasks.... I think it pertains to adding pictures to an album using the assett manager.

Would really appreciate help from any pro who can assist.

[Lynne]

When you get the messages, does it always say the script is cron.php? If so, note the time on these errors and find the cron job that runs at those times.

[Doctor Death]

I changed all my chron times to spread out over the hour (I dont have many).

Last error (with Chron script) occured at 19 minutes after hour... only chron job scheduled for that time is VB Infractions Cleanup.

If a scheduled task is to occur at 19 after and no one is on board, does it run as soon as next person logs on (after 19 minutes after?)

I feel like I am still chasing sparks on this... I am certain it deals with the user albums and the asset manager.

[Videx]

You didn't actually answer Lynne's question. But I'll add a few more anyway. Do you still get the error if you disable Infractions Cleanup? Do you still get the error with mods disabled? Do you have any album mods?

[Lynne]

If you have no one on your site at the time a task should run, then it won't run until someone comes on board and triggers it to run. If this is the case on your site (not many users), then chasing down the cron job is going to be harder to do since the time may not be accurate.

[Whiteknite]

I am getting database errors too. It looks like every time someone posts something.
The message I get in an e mail looks like this:

Database error in vBulletin 4.0.8:

Invalid SQL:

SELECT value, varname, datatype, optioncode
FROM setting
WHERE varname IN ('fc_users_update_time')
ORDER BY varname;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Thursday, December 23rd 2010 @ 01:33:17 PM
Error Date : Thursday, December 23rd 2010 @ 01:34:17 PM
Script : http://www.truchristianchat.net/forum/fchat.php?t=user_list
Referrer : http://www.truchristianchat.net/forum/forum.php
IP Address : ---------------
Username : xxxxxxxxxx
Classname : vB_Database
MySQL Version :

These just started a few days ago. When my chat room was fixed. And I delibrately deleted out the user name and IP address when I posted this.

[Videx]

I am getting database errors too. It looks like every time someone posts something.
MySQL Error : MySQL server has gone awayYou should start your own thread. At vb.com if this isn't an error having to do with a modification. I will tell you very quickly: "MySQL server has gone away" is a common error on oversold shared servers. Check the CPU loads in cpanel and AdminCP.

[Lynne]

"MySQL Server has gone away" is a server issue. See this: http://www.vbulletin.com/docs/html/troubleshoot_mysql_goneaway and this: http://www.vbulletin.com/forum/showthread.php?s=&postid=310265#post310265

[Doctor Death]

I have just recently also gotten the SERVER HAS GONE AWAY message...

[Videx]

As I said, it can be a common error, unlike the first one you posted. I've never seen a syntax error caused by server load.

But you're never going to solve it if you don't give more information in a timely fashion. When someone asks direct questions, if you want them to continue helping you have to drop whatever tangent your on and answer the questions quickly.