Announcement

Collapse
No announcement yet.

Database errors for admins only

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

  • gezuvor
    replied
    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

    Leave a comment:


  • gezuvor
    replied
    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        : http://xxxxxxxx/forumdisplay.php/28-MFD-Navi-System
    Referrer      : http://xxxxxxx/forum.php
    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?

    Leave a comment:


  • ex0thermic
    replied
    That worked perfectly. Thank you!

    Leave a comment:


  • Lynne
    replied
    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.

    Leave a comment:


  • ex0thermic
    replied
    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        : http://www.pyrouniverse.com/forum/fo...umer-Fireworks
    Referrer       : http://www.pyrouniverse.com/forum/forum.php
    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        : http://www.pyrouniverse.com/forum/mo...php?do=doposts
    Referrer      : http://www.pyrouniverse.com/forum/mo...e.php?do=posts
    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        : http://www.pyrouniverse.com/forum/ad...do=updateforum
    Referrer      : http://www.pyrouniverse.com/forum/ad...php?do=chooser
    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.

    Leave a comment:


  • Lynne
    replied
    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

    Leave a comment:


  • ex0thermic
    started a topic [Forum] Database errors for admins only

    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.

Related Topics

Collapse

Working...
X