Update Subscription Error - Error Number : 1064

  • Time
  • Show
Clear All
new posts
  • Zilvia
    • May 2002
    • 34
    • 3.7.x

    Update Subscription Error - Error Number : 1064

    I just upgraded from 3.0.1 to 3.5.1 and the upgrade went smoothly. I created a new Style to start off with clean templates and replaced all files when uploading the new version.

    Everything that I can tell works perfectly as its been live for a few days. Today I ran accross a problem as I went to update a users expire date for his paid subscription. Below is the error I get. Thanks for the help!

    Database error in vBulletin 3.5.1:

    Invalid SQL:

    UPDATE subscriptionlog

    SET status = 1,

    regdate = 1110248280,

    expirydate =

    WHERE userid = 32405 AND

    subscriptionid = 3;

    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 'WHERE userid = 32405 AND

    subscriptionid = 3' at line 6

    Error Number : 1064

    Date : Thursday, December 8th 2005 @ 04:52:46 PM

    Script : http://www.zilvia.net/f/admincp/subscriptions.php

    Referrer : http://www.zilvia.net/f/admincp/subs...ptionlogid=135

    IP Address :

    Username : RJF

    Classname : vb_database
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    SQL Syntax errors are almost always related to modified code. To troubleshoot this, the first thing you need to do is remove any hacks or plugins, then see if you still have this problem.

    If so, reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography

    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


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