WMR
09-14-2005, 02:57 AM
for some reason i cant edit administrator permissions on my forum, here is the error that i get
Database error in vBulletin 3.0.8:
Invalid SQL:
SELECT user.userid, user.username, administrator.adminpermissions, administrator.cssprefs,
IF(administrator.userid IS NULL, 0, 1, 2) AS isadministrator
FROM user AS user
LEFT JOIN administrator AS administrator ON(administrator.userid = user.userid)
WHERE user.userid = 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 ' 2) AS isadministrator
FROM user AS user
LEFT JOIN admin
mysql error number: 1064
by an error the member #1 was deleted and now the main admin is member#2, just to let u know
any clue what shud be done ?
please help :disappointed:
Database error in vBulletin 3.0.8:
Invalid SQL:
SELECT user.userid, user.username, administrator.adminpermissions, administrator.cssprefs,
IF(administrator.userid IS NULL, 0, 1, 2) AS isadministrator
FROM user AS user
LEFT JOIN administrator AS administrator ON(administrator.userid = user.userid)
WHERE user.userid = 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 ' 2) AS isadministrator
FROM user AS user
LEFT JOIN admin
mysql error number: 1064
by an error the member #1 was deleted and now the main admin is member#2, just to let u know
any clue what shud be done ?
please help :disappointed: