Announcement

Collapse
No announcement yet.

MySQl error 1064

Collapse
X
 
  • Time
  • Show
Clear All
new posts

  • MySQl error 1064

    i randomly get this eror when posting, or editing s podt

    Database error in vBulletin 3.7.3:

    Invalid SQL:
    SELECT username,userid FROM user WHERE userid=;

    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 '' at line 1
    Error Number : 1064
    Request Date : Friday, October 3rd 2008 @ 01:14:40 AM
    Error Date : Friday, October 3rd 2008 @ 01:14:40 AM
    Script : http://www.emuasylum.com/forums/edit...epost&p=521048
    Referrer : http://www.emuasylum.com/forums/edit...tpost&p=521048
    IP Address : 71.161.41.156
    Username : Ice
    Classname : vb_database
    MySQL Version : 4.1.22-standard

  • #2
    Turn off the hook system, and try again.
    Also check via admincp > maintenance > diagnostics > file suspect, to see if any older versions are showing.

    Comment


    • #3
      how do you turn off the hook system?

      Comment


      • #4
        Admin Control Panel > vBulletin Options > vBulletin Options > Hook System > Active? No.

        Or edit config.php and below <?php add on a new line:
        define('DISABLE_HOOKS', true);

        Comment


        • #5
          thanks floris, from there i was able to figure out which mod was causing it, and removed it

          for anyone else having the same issue, its the mod moderation autoPM

          Comment

          widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
          Working...
          X
          😀
          🥰
          🤢
          😎
          😡
          👍
          👎