No announcement yet.

MySQL error 1064

  • Filter
  • Time
  • Show
Clear All
new posts

  • MySQL error 1064

    I got an error on my vBulletin 3.6.5 board this morning with has no hacks or
    mods installed. (imported from IPB 1.2)
    The error is as follows;

    Database error in vBulletin 3.6.5:

    Invalid SQL:

    SELECT username, usergroupid, user.userid, moderator.userid as moduserid
    FROM vb_user AS user
    LEFT JOIN vb_moderator AS moderator ON(user.userid = moderator.userid)
    WHERE user.userid IN(641,,641,,641);

    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 '641,,641)' at line 4
    Error Number : 1064
    Date : Friday, April 27th 2007 @ 04:19:07 PM
    Script :
    Referrer :
    IP Address : xx.xx.xx.xx
    Username : verhaegen
    Classname : vB_Database_MySQLi

    Where the error happens is pretty obvious, it's in the IN part.

    The userid for username verhaegen = 641.

    Don't know where to start looking what's the cause of this error. So any help
    would be appreciated

  • #2
    re-upload all script files in ASCII mode, then try again.


    • #3

      that ",," in the IN clause is not correct MySQL will complain about it

      "641,,641,,641" that should be one , not two nexto eachother.I'm pretty sure that's the problem but since you are mentioning you don't have hacks installed ..... I would try to reupload the original vBulletin source files (*.php) (no need to upload install.php or upgrade.php) also MySQLI should only be used if you use PHP5 you can change that in includes/config.php


      • #4
        What exactly was being done? It looks like the user's buddy list was corrupted somehow.
        Translations provided by Google.

        Wayne Luke
        The Rabid Badger - a vBulletin Cloud demonstration site.
        vBulletin 5 API


        • #5
          @DelphiVillage already knew that this was causing the error

          @Wayne emailed the user verhaegen asking him what he was doing. Tried to reproduce it myself but so far i've been unlucky at it


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