Announcement

Collapse
No announcement yet.

Invalid SQL:

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Invalid SQL:

    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

  • #2
    What are you doing when you get this error? And please post the complete error message, including script info.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


    • #3
      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.

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...
      X