Silly me, actually i have no prefix. :P. But it gives me the same error eventhough I did set a usergroup as moderator of a forum o_O.
Code:
Database error in vBulletin 3.5.0 Release Candidate 1:
Invalid SQL:
DELETE FROM moderator AS moderator
USING moderator AS moderator, moderatorusergroup AS moderatorusergroup
WHERE moderator.userid = 11
AND moderator.moderatorusergroupid = moderatorusergroup.moderatorusergroupid
AND NOT (moderatorusergroup.usergroupid IN (2));
MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS moderator
USING moderator AS moderator, moderatorusergroup
Error Number : 1064
Date : Thursday, August 4th 2005 @ 04:13:59 AM
Script : admincp/user.php
Referrer : admincp/user.php?do=edit&u=11
IP Address : x.x.x.x
Username : Union Jack
Classname : vb_database