Database Error while rebuilding Search Index

Discussion in 'vBulletin' started by Abhik, May 8, 2010.

  1. #1
    I already posted this in vbulletin forum, but haven't got any help there. :(

    Hello,
    I was trying to rebuild Search Index for Group Messages and got the database error below

    Database error in vBulletin 4.0.3:
    
    Invalid SQL:
    
                    SELECT m.*, 
                        d.firstpostid,
                        fp.title as discussiontitle, 
                        fp.postuserid as discussionuserid,
                        fp.postusername as discussionusername, 
                        fp.dateline as discussiondateline
                    FROM mst_groupmessage AS m JOIN mst_discussion d ON  m.discussionid = d.discussionid JOIN mst_groupmessage fp ON  d.firstpostid = fp.gmid
                    WHERE m.gmid >= 0 AND m.gmid <= 3;
    
    MySQL Error   : Unknown column 'm.discussionid' in 'on clause'
    Error Number  : 1054
    Request Date  : Saturday, May 8th 2010 @ 08:53:40 AM
    Error Date    : Saturday, May 8th 2010 @ 08:53:40 AM
    Script        : http://www.domain.com/admincp/misc.php?do=doindextypes
    Referrer      : http://www.domain.com/admincp/misc.php
    IP Address    : xxx.xxx.xxx.xxx
    Username      : xxxxxxxxxxx
    Classname     : vB_Database
    MySQL Version : 5.0.90-community
    Code (markup):
    How can I fix this?

    Thanks
     
    Abhik, May 8, 2010 IP
  2. ChopSuey

    ChopSuey Peon

    Messages:
    843
    Likes Received:
    8
    Best Answers:
    0
    Trophy Points:
    0
  3. Abhik

    Abhik ..:: The ONE ::..

    Messages:
    11,337
    Likes Received:
    606
    Best Answers:
    0
    Trophy Points:
    410
    Digital Goods:
    2
    #3
    Thanks Buddy..
    But, that's not working for me as my problem is related to some MySQL tables.
     
    Abhik, May 10, 2010 IP
  4. ChopSuey

    ChopSuey Peon

    Messages:
    843
    Likes Received:
    8
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Ask on the official site then.
     
    ChopSuey, May 10, 2010 IP
  5. Rafaweborama

    Rafaweborama Member

    Messages:
    52
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    45
    #5
    Mmm, seems to be that the DB table is corrupted from the search rebuild. Try Repairing that table only via SSH (phpMyAdmin will take weeks doing that).
     
    Rafaweborama, May 14, 2010 IP
  6. Abhik

    Abhik ..:: The ONE ::..

    Messages:
    11,337
    Likes Received:
    606
    Best Answers:
    0
    Trophy Points:
    410
    Digital Goods:
    2
    #6
    repairing that table didn't worked.. :(
     
    Abhik, May 16, 2010 IP