Forum Database Error while rebuilding Search Index
 

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

<div class="bbcode_container"> Code:
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