No announcement yet.

MySQL error 1064

  • Filter
  • Time
  • Show
Clear All
new posts

  • WielerArchieven
    @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

    Leave a comment:

  • Wayne Luke
    What exactly was being done? It looks like the user's buddy list was corrupted somehow.

    Leave a comment:

  • DelphiVillage

    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

    Leave a comment:

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

    Leave a comment:

  • WielerArchieven
    started a topic MySQL error 1064

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