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
http://www.vbulletin.com/forum/show...-of-vbulletin-4.0.2-PL1&p=1957989#post1957989 Check out the second post
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).