im not using 3.6.5 and i get this i think its the same not checked properly:
Quote:
Database error in vBulletin 3.6.5:
Invalid SQL:
SELECT
user.*,
userfield.field5,
IF(usergroup.genericoptions & 32, 0, 1) AS isnotbannedgroup
FROM
`userfield`
INNER JOIN
usergroup AS usergroup ON(usergroup.usergroupid = user.usergroupid)
LEFT JOIN
`user` ON userfield.userid = user.userid
WHERE
user.posts >= '0'
AND
userfield.field5 != ''
ORDER BY
RAND();
MySQL Error : Unknown column 'user.usergroupid' in 'on clause'
Error Number : 1054
Date : Sunday, March 4th 2007 @ 05:45:34 PM
Script : http://www.digital-community.co.uk/f...cron&cronid=26
Referrer : http://www.digital-community.co.uk/f...incp/index.php
IP Address : 86.2.61.215
Username : ORACLE
Classname : vB_Database
|