Announcement

Collapse
No announcement yet.

Invalid SQL:

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

  • Mike Sullivan
    replied
    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.

    Leave a comment:


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

    Leave a comment:


  • Vanhalen4041
    started a topic Invalid SQL:

    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
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X