Announcement

Collapse
No announcement yet.

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

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Trevor Hannant
    replied
    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.

    Leave a comment:


  • mariocaz
    replied
    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!!!! =(

    Leave a comment:


  • Mark.B
    replied
    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?

    Leave a comment:


  • mariocaz
    replied
    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 :

    Leave a comment:


  • Mark.B
    replied
    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
    Code:
    <?php
    enter
    Code:
    define('DISABLE_HOOKS', true);
    Last edited by Mark.B; Thu 17 Jan '13, 12:14pm.

    Leave a comment:


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

    Leave a comment:


  • Loco.M
    replied
    Originally posted by mariocaz View Post
    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

    Leave a comment:


  • Mark.B
    replied
    Originally posted by mariocaz View Post
    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
    Code:
    <?php
    enter
    Code:
    define('DISABLE_HOOKS', true);

    Leave a comment:


  • mariocaz
    replied
    Originally posted by ProSportsForums View Post
    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. =(

    Leave a comment:


  • Mark.B
    replied
    If you have no plugins or modifications, then yes.

    Leave a comment:


  • mariocaz
    replied
    So is more a problem of my host than my forum ??

    Leave a comment:


  • Mark.B
    replied
    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.

    Leave a comment:


  • In Omnibus
    replied
    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.

    Leave a comment:


  • mariocaz
    started a topic Please help me.....VBulletin Database error!!

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

    Hi guys,

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

    Code:
    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

Related Topics

Collapse

Working...
X