Quote:
Originally Posted by FullyTested
Version 1.6
Revert to original 'includes/cron/remove_managed_bans.php' as 1.5 unbanned users it shouldn't have.
Has anyone else encountered the problem MrD has?
|
Yes i am again im using the latest VB
Invalid SQL:
SELECT user.*,
userban.usergroupid AS banusergroupid, userban.displaygroupid AS bandisplaygroupid, userban.customtitle AS bancustomtitle, userban.usertitle AS banusertitle
FROM userban AS userban
LEFT JOIN userban_manage AS userban_manage ON(userban_manage.userid = userban.userid)
INNER JOIN user AS user USING(userid)
WHERE userban.bandate < 1195852530;
MySQL Error : Column 'userid' in from clause is ambiguous
Error Number : 1052
Date : Friday, November 30th 2007 @ 09:15:30 PM
have had to temp disable it