Announcement

Collapse
No announcement yet.

Can't delete forum

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

  • Lynne
    replied
    Your table "vbtesttable_searchcore_text" is crashed. Go to Maintenance > Repair/Optimize Tables > select that table > Continue. You may have to do this a couple of times until it says OK.

    Leave a comment:


  • ever-fresh
    started a topic [Forum] Can't delete forum

    Can't delete forum

    Hello !
    I am trying to delete a forum.
    but i am getting below error in Admin CP:

    Code:
    Database error in vBulletin 4.0.2:
    
    Invalid SQL:
    
                 DELETE searchcore, searchcore_text 
                FROM vbtesttable_searchcore AS searchcore JOIN 
                    vbtesttable_searchcore_text AS searchcore_text ON 
                        searchcore.searchcoreid = searchcore_text.searchcoreid 
                WHERE searchcore.groupcontenttypeid = 2 AND 
                    searchcore.groupid = 87857;
    
    MySQL Error   : Table './***********/vbtesttable_searchcore_text' is marked as crashed and should be repaired
    Error Number  : 145
    Request Date  : Friday, May 14th 2010 @ 03:19:31 AM
    Error Date    : Friday, May 14th 2010 @ 03:19:32 AM
    Script        : http://******/home/admincp/forum.php?do=kill
    Referrer      : http://******/home/admincp/forum.php?do=remove&f=182&s=
    IP Address    : 109.123.86.176
    Username      : ******
    Classname     : vB_Database_MySQLi
    MySQL Version : 5.0.90-community
    And when i try to delete all posts in that forum one by one, i am getting below error:

    HTML Code:
    Database error in vBulletin 4.0.2:
    
    Invalid SQL:
    
                 DELETE searchcore, searchcore_text 
                FROM vbtesttable_searchcore AS searchcore JOIN 
                    vbtesttable_searchcore_text AS searchcore_text ON 
                        searchcore.searchcoreid = searchcore_text.searchcoreid 
                WHERE searchcore.groupcontenttypeid = 2 AND 
                    searchcore.groupid = 51893;
    
    MySQL Error   : Table './******/vbtesttable_searchcore_text' is marked as crashed and should be repaired
    Error Number  : 145
    Request Date  : Friday, May 14th 2010 @ 03:20:46 AM
    Error Date    : Friday, May 14th 2010 @ 03:20:46 AM
    Script        : http://*******/home/inlinemod.php?do=dodeletethreads&threadids=81407,95070,51893,115891,116023,116027,108208,115880,115881,115818,115481,115087,114995,114078,114925,113549,114019,112320,113185,91688,113267,113262,112322
    Referrer      : http://*******/home/inlinemod.php?forumid=182
    IP Address    : 109.123.86.176
    Username      : ***********
    Classname     : vB_Database_MySQLi
    MySQL Version : 5.0.90-community

Related Topics

Collapse

Working...
X