Vb mysql subscriptions error

[DannyMilner]

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:

PHP Code:

                    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]

expirydate is missing in the VALUES.

[DannyMilner]

Originally Posted by tnguy3n

expirydate is missing in the VALUES.

Okay, how do I fix that mate?

[Marco van Herwaarden]

You might want to ask in the thread of the hack you are using for subscriptions.

[007]

I have this same problem and I haven't hacked the subscriptions at all...

[Marco van Herwaarden]

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]

See: http://www.vbulletin.com/forum/bugs3...iew&bugid=1736