Update Subscription Error - Error Number : 1064

[Zilvia]

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 : 67.177.217.1

Username : RJF

Classname : vb_database

[Steve Machol]

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.