[the wiz]

Also, when I edit the forumdisplay.php file, the following lines:

SELECT " . iif($sortfield == 'voteavg', $votequery) . " threadid, user.usergroupid AS usergroupid

$deljoin LEFT JOIN " . TABLE_PREFIX . "user ON user.userid = postuserid

AND usergroupid<>17

give me the following SQL Error when someone tries to view one of the forums:

Database error in vBulletin 3.0.3:

Invalid SQL:
SELECT threadid, user.usergroupid AS usergroupid
FROM vb_thread AS thread
LEFT JOIN vb_deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread') LEFT JOIN vb_user ON user.userid = postuserid
WHERE forumid = 16
AND sticky = 0
AND visible = 1
AND usergroupid<>8



AND deletionlog.primaryid IS NULL
ORDER BY sticky DESC, thread.lastpost DESC
LIMIT 0, 20

mysql error: Unknown table 'user' in field list

mysql error number: 1109

Date: Friday 03rd of September 2004 05:50:45 PM