Database Error while rebuilding Search Index

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

 

Thanks Buddy..
But, that's not working for me as my problem is related to some MySQL tables.

 

Ask on the official site then.

 

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).

 

repairing that table didn't worked..