Please help me.....VBulletin Database error!!

[mariocaz]

Hi guys,

Could you please help me a little ??, I am tired to receive tons of emails with this message

Database error in vBulletin 3.7.6:

Invalid SQL:

    SELECT *, thread.title AS threadtitle
    FROM vbrsslog AS rsslog
    INNER JOIN vbrssfeed AS rssfeed ON(rssfeed.rssfeedid = rsslog.rssfeedid)
    INNER JOIN vbthread AS thread ON(thread.threadid = rsslog.itemid)
    WHERE rsslog.threadactioncomplete = 0
        AND rsslog.itemtype = 'thread'
        AND rsslog.threadactiontime <> 0
        AND rsslog.threadactiontime < 1358445618;

MySQL Error   : MySQL server has gone away
Error Number  : 2006
Request Date  : Thursday, January 17th 2013 @ 01:00:18 PM
Error Date    : Thursday, January 17th 2013 @ 01:01:15 PM
Script        : [URL]http://www.all-reefs.com/inicio/cron.php?&rand=741654[/URL]
Referrer      : [URL]http://www.all-reefs.com/[/URL]
IP Address    : 187.210.47.114
Username      : No Registrado
Classname     : vB_Database
MySQL Version :

What can I do to solve this ? or what is wrong with my forum ?

Thank you so much in advance for all your help and comments.

Mario

[In Omnibus]

To disable the plugin/hook system completely without accessing the Admin CP options, you need to edit includes/config.php and add the following code: define('DISABLE_HOOKS', true);

Then disable your RSS as it appears a Cron job related to the RSS is causing the issue.

[Mark.B]

http://www.mysql.com/doc/G/o/Gone_away.html

The most common reason for the MySQL server has gone away error is that the server timed out and closed the connection.
You should contact your host about this.

[mariocaz]

So is more a problem of my host than my forum ??

[Mark.B]

If you have no plugins or modifications, then yes.

[mariocaz]

To disable the plugin/hook system completely without accessing the Admin CP options, you need to edit includes/config.php and add the following code: define('DISABLE_HOOKS', true);

Then disable your RSS as it appears a Cron job related to the RSS is causing the issue.

How can I disable my RSS ??, sorry if this is a stupid question.

- - - Updated - - -

Mark I have a tons of mods installed in my forum. =(

[Mark.B]

How can I disable my RSS ??, sorry if this is a stupid question.

- - - Updated - - -

Mark I have a tons of mods installed in my forum. =(

Just disable them temporarily using these instructions, to see if the problem still occurs:

To disable the plugin/hook system completely, edit includes/config.php and add the following code:
Just below

<?php

enter

define('DISABLE_HOOKS', true);

[Loco.M]

How can I disable my RSS ??, sorry if this is a stupid question.

- - - Updated - - -

Mark I have a tons of mods installed in my forum. =(

admincp > vbsettings > syndicated > rss

[mariocaz]

Perfect thank you so much again Mark and also I need to do what Loco told me ?? (thanx Loco!)

[Mark.B]

For diagnostic purposes you need to do the following so we can see what happens:

To disable the plugin/hook system completely, edit includes/config.php and add the following code:
Just below

<?php

enter

define('DISABLE_HOOKS', true);

[mariocaz]

Mark I have fear my friend!!!! my forum is kinfa old and I hace more than 10,000 registered users, sponsors, etc.

A long time ago I didn´t do anything of these things, I have fear to do something wrong and do a mess with my forum. =(

- - - Updated - - -

Now I am receiving this emails, hope this helps in something......

Database error in vBulletin 3.7.6:

Invalid SQL:

SELECT user.*, COUNT(video.videoid) AS videocount
FROM vbvideo AS video
LEFT JOIN vbuser AS user ON(user.userid = video.userid)
WHERE NOT ISNULL(user.userid)
GROUP BY video.userid
ORDER BY videocount DESC
LIMIT a;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'a' at line 7
Error Number : 1064
Request Date : Thursday, January 17th 2013 @ 03:48:47 PM
Error Date : Thursday, January 17th 2013 @ 03:48:47 PM
Script : http://all-reefs.com/inicio/video.ph...ewtag&tag=solo
Referrer :
IP Address : 67.195.115.242
Username : No Registrado
Classname : vB_Database
MySQL Version :

[Mark.B]

That error's from a modification so that's probably been generated while plugins were disabled.

Do you still get the original error with plugins disabled?

[mariocaz]

Yes I received like 4 emails of VBulletin errors after I disabled the plugins.

Maybe were old emails that arrived just after I disabled it ?

- - - Updated - - -

Yes I just received 3 emails with the same in this moment, now what can I do ?

- - - Updated - - -

Oh now I understan Mark,

No the original message no, only this one:

Database error in vBulletin 3.7.6:

Invalid SQL:

SELECT user.*, COUNT(video.videoid) AS videocount
FROM vbvideo AS video
LEFT JOIN vbuser AS user ON(user.userid = video.userid)
WHERE NOT ISNULL(user.userid)
GROUP BY video.userid
ORDER BY videocount DESC
LIMIT a;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'a' at line 7
Error Number : 1064
Request Date : Thursday, January 17th 2013 @ 06:20:12 PM
Error Date : Thursday, January 17th 2013 @ 06:20:12 PM
Script : http://www.all-reefs.com/inicio/vide...ils&videoid=23
Referrer :
IP Address : 157.55.33.78
Username : No Registrado
Classname : vB_Database
MySQL Version :

- - - Updated - - -

OMG I just received tons of emails with the same!!!! =(

[Trevor Hannant]

Firstly, vB3.7.x has been marked end of life and is therefore no longer supported - you need to upgrade to at least 3.8.7.

Second, that error is still coming from a video modification you added to the software - you will need to seek the author's assistance with this.