Bug SQL error on buy now

[JaiKai]

When trying to use the buy now I get a database error as follows :

Database error in vBulletin 4.2.1:

Invalid SQL:

		INSERT INTO dbtech_classifieds_offer (listingitemid, userid, currencyid, value, date, listingtypeid, postageid, addressid)
		VALUES (106,16521,'GBP',0,1382908122,1,,1);

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 '1)' at line 2
Error Number  : 1064
Request Date  : Sunday, October 27th 2013 @ 09:08:42 PM
Error Date    : Sunday, October 27th 2013 @ 09:08:42 PM
Script        : http://beta.300zx.co.uk/forums/dbtclassifieds.php?do=listing&action=buynow
Referrer      : http://beta.300zx.co.uk/forums/dbtclassifieds.php?do=listing&action=viewlisting&listingid=7

 

[Mokonzi]

Thanks JaiKai, will take a look in the morning and get the bug fixed with Beta 7. Can you confirm that you have no postage selected? Perhaps not one even connected to your user account on your testboard?

 

[JaiKai]

your right, there's no postage set for that particular buy now.

 

[Mokonzi]

Ok, I thought it might have been. I've included a fix that will sort this in Beta 7.