PDA

View Full Version : Vb mysql subscriptions error

DannyMilner
10-30-2005, 12:08 PM
When I do this...

Subscription Manager > VIP Membership > Add user

once I submit the date, user ect... I get this error

Database error in vBulletin 3.5.0:

Invalid SQL:

INSERT INTO subscriptionlog
(subscriptionid, userid, pusergroupid, status, regdate, expirydate)
VALUES
(2, 214, 14, 1, 1130681160, );

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 4
Error Number : 1064
Date : Sunday, October 30th 2005 @ 09:06:45 AM
Script : http://www.domain.net/admincp/subscriptions.php
Referrer : http://www.domain.net/admincp/subscriptions.php?do=adjust&subscriptionid=2&s=
IP Address : xx.xxx.x.xxx
Username : User
Classname : vb_database
tnguy3n
10-30-2005, 12:16 PM
expirydate is missing in the VALUES.
DannyMilner
10-30-2005, 01:14 PM
expirydate is missing in the VALUES.

Okay, how do I fix that mate?
Marco van Herwaarden
11-01-2005, 09:50 AM
You might want to ask in the thread of the hack you are using for subscriptions.
007
11-30-2005, 04:23 PM
I have this same problem and I haven't hacked the subscriptions at all...
Marco van Herwaarden
11-30-2005, 06:03 PM
Ahh that was a bug in vB, think i even submitted a bug report for it and it is marked as being fixed. There was no check on the expire date and this would cause an error if left blank.
Marco van Herwaarden
11-30-2005, 06:04 PM
See: http://www.vbulletin.com/forum/bugs35.php?do=view&bugid=1736