Database errors for admins only

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ex0thermic
    New Member
    • Jun 2005
    • 25
    • 3.6.x

    [Forum] Database errors for admins only

    I recently upgraded to 4.0.2 (not sure if it's related), and since then, when I try to view just one particular forum on my site, I get a database error (along with a notification sent to my email)

    Invalid SQL:

    DELETE searchcore, searchcore_text
    FROM vbsearchcore AS searchcore JOIN
    vbsearchcore_text AS searchcore_text ON
    searchcore.searchcoreid = searchcore_text.searchcoreid
    WHERE searchcore.groupcontenttypeid = 2 AND
    searchcore.groupid = 26845

    None of the other usergroups are getting this. Any clue what could be causing it? I also get a similar error when I try to moderate posts in the admin panel.
  • Lynne
    Former vBulletin Support
    • Oct 2004
    • 26255

    #2
    We need to see the bottom part of the error for it to mean something. The part that looks like this:
    Code:
    The actual mysql query/code/problem....
    
    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

    Please don't PM or VM me for support - I only help out in the threads.
    vBulletin Manual & vBulletin 4.0 Code Documentation (API)
    Want help modifying your vbulletin forum? Head on over to vbulletin.org
    If I post CSS and you don't know where it goes, throw it into the additional.css template.

    W3Schools <- awesome site for html/css help

    Comment

    • ex0thermic
      New Member
      • Jun 2005
      • 25
      • 3.6.x

      #3
      Code:
      MySQL Error   : Table './detonate_vbulletin/vbsearchcore_text' is marked as  crashed and last (automatic?) repair failed
      Error Number  : 144
      Request  Date  : Saturday, March 6th 2010 @ 10:37:09 PM
      Error Date    : Saturday,  March 6th 2010 @ 10:37:09 PM
      Script        : [URL]http://www.pyrouniverse.com/forum/forumdisplay.php?4-Consumer-Fireworks[/URL]
      Referrer       : [URL]http://www.pyrouniverse.com/forum/forum.php[/URL]
      IP  Address    : 76.28.243.112
      Username      : Colin
      Classname     :  vB_Database
      MySQL Version : 5.0.89-community
      Then I get this one when I try to moderate posts in the adminCP

      Code:
      Database error in vBulletin 4.0.2:
      
      Invalid SQL:
      INSERT INTO vbsearchcore_text (searchcoreid, keywordtext)
                  VALUES ( 366696, 'Hello My name is A.Z. Homer...nice to know ya' )
                  ON DUPLICATE KEY UPDATE  searchcoreid = VALUES(searchcoreid), keywordtext = VALUES(keywordtext);
      
      MySQL Error   : Table './detonate_vbulletin/vbsearchcore_text' is marked as crashed and last (automatic?) repair failed
      Error Number  : 144
      Request Date  : Saturday, March 6th 2010 @ 10:42:49 PM
      Error Date    : Saturday, March 6th 2010 @ 10:42:49 PM
      Script        : [URL]http://www.pyrouniverse.com/forum/modcp/moderate.php?do=doposts[/URL]
      Referrer      : [URL]http://www.pyrouniverse.com/forum/modcp/moderate.php?do=posts[/URL]
      IP Address    : 76.28.243.112
      Username      : Colin
      Classname     : vB_Database
      MySQL Version : 5.0.89-community
      This happens when I try to rebuild forum information...

      Code:
      Database error in vBulletin 4.0.2:
      
      Invalid SQL:
      INSERT INTO vbsearchcore_text (searchcoreid, title, keywordtext)
                  VALUES ( 960, 'Forum Information', '' )
                  ON DUPLICATE KEY UPDATE  searchcoreid = VALUES(searchcoreid), title = VALUES(title), keywordtext = VALUES(keywordtext);
      
      MySQL Error   : Table './detonate_vbulletin/vbsearchcore_text' is marked as crashed and last (automatic?) repair failed
      Error Number  : 144
      Request Date  : Saturday, March 6th 2010 @ 10:46:40 PM
      Error Date    : Saturday, March 6th 2010 @ 10:46:40 PM
      Script        : [URL]http://www.pyrouniverse.com/forum/admincp/misc.php?do=updateforum[/URL]
      Referrer      : [URL]http://www.pyrouniverse.com/forum/admincp/misc.php?do=chooser[/URL]
      IP Address    : 76.28.243.112
      Username      : Colin
      Classname     : vB_Database
      MySQL Version : 5.0.89-community
      When I attempt to delete a message from a social group thread, I get this

      Code:
      Database error in vBulletin 4.0.2:
      
      Invalid SQL:
      INSERT INTO vbsearchcore_text (searchcoreid, keywordtext)
                  VALUES ( 366863, ' Alas, Saturday events are very tough for me.' )
                  ON DUPLICATE KEY UPDATE  searchcoreid = VALUES(searchcoreid), keywordtext = VALUES(keywordtext);
      
      MySQL Error   : Table './detonate_vbulletin/vbsearchcore_text' is marked as crashed and last (automatic?) repair failed
      Error Number  : 144
      Request Date  : Saturday, March 6th 2010 @ 11:09:51 PM
      Error Date    : Saturday, March 6th 2010 @ 11:09:51 PM
      Script        : http://www.pyrouniverse.com/forum/group_inlinemod.php
      Referrer      : http://www.pyrouniverse.com/forum/group_inlinemod.php?groupid=7&discussionid=278
      IP Address    : 76.28.243.112
      Username      : Colin
      Classname     : vB_Database
      MySQL Version : 5.0.89-community
      Last edited by ex0thermic; Sat 6 Mar '10, 10:11pm.

      Comment

      • Lynne
        Former vBulletin Support
        • Oct 2004
        • 26255

        #4
        You have a crashed table - vbsearchcore_text. Go to admincp > maintenance > repair/optimize tables > select the table "vbsearchcore_text" from the list >hit continue. You may have to run that a couple of times until is says everything is OK.

        Please don't PM or VM me for support - I only help out in the threads.
        vBulletin Manual & vBulletin 4.0 Code Documentation (API)
        Want help modifying your vbulletin forum? Head on over to vbulletin.org
        If I post CSS and you don't know where it goes, throw it into the additional.css template.

        W3Schools <- awesome site for html/css help

        Comment

        • ex0thermic
          New Member
          • Jun 2005
          • 25
          • 3.6.x

          #5
          That worked perfectly. Thank you!

          Comment

          • gezuvor
            New Member
            • May 2007
            • 13
            • 3.8.x

            #6
            I am getting a similar error. Looks like I lost a table, but I'm not sure where it would have gone. Been doing only low-level modifications... :?

            Code:
             Database error in vBulletin 4.0.2:
            
            Invalid SQL:
             
                                SELECT tagthread.tagid, tag.tagtext, COUNT(*) AS searchcount 
                                FROM tagthread AS tagthread 
                                INNER JOIN tag AS tag ON (tagthread.tagid = tag.tagid) 
                                INNER JOIN thread AS thread ON (tagthread.threadid = thread.threadid) 
                                WHERE thread.open <> 10 
            
                                    AND thread.visible = 1 
                                AND thread.forumid IN (28) 
                         
            GROUP BY tagthread.tagid, tag.tagtext 
                                ORDER BY searchcount DESC 
                                LIMIT 50;
            
            MySQL Error   : Table 'xxxxxx.tagthread' doesn't exist
            Error Number  : 1146
            Request Date  : Sunday, March 7th 2010 @ 05:53:13 PM
            Error Date    : Sunday, March 7th 2010 @ 05:53:13 PM
            Script        : [URL]http://xxxxxxxx/forumdisplay.php/28-MFD-Navi-System[/URL]
            Referrer      : [URL]http://xxxxxxx/forum.php[/URL]
            IP Address    : 68.101.106.28
            Username      : admin
            Classname     : vB_Database
            MySQL Version : 5.0.89-community
            If it is indeed gone, how can I resurrect?

            Comment

            • gezuvor
              New Member
              • May 2007
              • 13
              • 3.8.x

              #7
              Okay, answered my own question by searching the forum for "tagthread". You (Lynne) addressed my problem in another thread.

              For others that might stumble on this thread, I had the following two (legacy) mods installed and I have disabled them until I can replace or update:
              - Automatic Thread Tagger
              - Forum Tags

              Comment

              Related Topics

              Collapse

              Working...