Invalid SQL:

[Vanhalen4041]

Invalid SQL:


SELECT username, cancontrolpanel


FROM user AS user


INNER JOIN usergroup AS usergroup USING(usergroupid)


WHERE user.userid = 0


mysql error: You have an error in your SQL syntax near 'INNER JOIN usergroup AS usergroup USING(usergroupid)


WHERE user.userid = 0

' at line 4

mysql error number: 1064

[Steve Machol]

What are you doing when you get this error? And please post the complete error message, including script info.

[Mike Sullivan]

I believe this is because you don't have a recent enough MySQL -- I'm guessing it's somewhere in 3.22.x. vB3 requires at least 3.23.

If this is a shared server, you'll have to contact your host and ask them to upgrade. MySQL 3.22 has been superceded by 3.23 and more recently, 4.0.