Results 1 to 4 of 4

MySQL Error 1064

This is a discussion on MySQL Error 1064 within the Troubleshooting forums, part of the vBSEO SEO Plugin category; I've been receiving a few emails from vBulletin that I'm getting some forum database errors. I see that the script ...

  1. #1
    Junior Member Imperial's Avatar
    Real Name
    Imperial
    Join Date
    Sep 2007
    Location
    California
    Posts
    28
    Liked
    0 times

    MySQL Error 1064

    I've been receiving a few emails from vBulletin that I'm getting some forum database errors. I see that the script is vbseo.php. Not too long ago I upgraded gXboxLive which uses field5 for Xbox Live Gamertags, but I wasn't quite sure how vbseo.php is causing the error. Any thoughts?

    Code:
    Database error in vBulletin 3.6.8:
    
    Invalid SQL:
    UPDATE vb3_userfield SET
                                           field5 = '
                                           WHERE userid = '158';
    
    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 '158'' at line 2
    Error Number : 1064
    Date         : Tuesday, February 5th 2008 @ 07:12:13 AM
    Script       : http://www.xboxnation.net/forums/vbseo.php?vbseourl=cron.php&rand=509247
    Referrer     : http://www.xboxnation.net/forums/
    IP Address   : 86.16.187.109
    Username     : Unregistered
    Classname    : vB_Database_MySQLi
    Administrator of Xbox Nation

  2. #2
    Senior Member briansol's Avatar
    Real Name
    Brian
    Join Date
    Apr 2006
    Location
    Central CT, USA
    Posts
    6,981
    Liked
    8 times
    I don't think its a problem with vbseo... most likely the mod.

    There's a cron task that runs something to update field 5, but its not getting passed in correctly.

    its obviously missing the extra quote

    field5 = ''

    or even
    field5 = 'something here'

  3. #3
    vBSEO Staff Oleg Ignatiuk's Avatar
    Real Name
    Oleg Ignatiuk
    Join Date
    Jun 2005
    Location
    Belarus
    Posts
    25,744
    Liked
    169 times
    Hello,

    the actual script is cron.php, which is called by vbseo.php, so you should check your scheduled tasks to find which one causes the issue (vBSEO doesn't use similar sql queries).

  4. #4
    Junior Member Imperial's Avatar
    Real Name
    Imperial
    Join Date
    Sep 2007
    Location
    California
    Posts
    28
    Liked
    0 times
    Okay, I figured that this was probably caused by the cron job for the mod. I'll try disabling it and see what happens. Thanks for the replies.
    Administrator of Xbox Nation

Similar Threads

  1. MySql error in linkback
    By adivor in forum LinkBacks
    Replies: 2
    Last Post: 10-21-2007, 09:00 AM
  2. MySQL error: mailqueue
    By rj2 in forum Troubleshooting
    Replies: 1
    Last Post: 03-04-2006, 05:27 AM
  3. Get Mysql Error in archive
    By shaochun in forum Bug Reporting
    Replies: 1
    Last Post: 01-16-2006, 12:07 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •