Bug Buy Now URL Error

[Mokonzi]

Cool. I'll continue my pursuit into this one...

 

[Mokonzi]

I think I've got this one fixed for Beta 11.

 

[CharlieDelta]

So I got this DB error when clicking the Buy Now button.

Database error in vBulletin 4.2.0:

Invalid SQL:

		INSERT INTO dbtech_classifieds_offer (listingitemid, userid, currencyid, value, date, listingtypeid, postageid, addressid)
		VALUES (36,1,'CAD',1.5,1385519662,1,,8);

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 '8)' at line 2
Error Number  : 1064
Request Date  : Tuesday, November 26th 2013 @ 08:34:22 PM
Error Date    : Tuesday, November 26th 2013 @ 08:34:23 PM
Script        : http://www.archerandangler.com/testaa/dbtclassifieds.php?do=listing&action=buynow
Referrer      : http://www.archerandangler.com/testaa/dbtclassifieds.php?do=listing&action=viewlisting&listingid=14
IP Address    : 24.156.247.126
Username      : Outdoorsman
Classname     : vB_Database_MySQLi
MySQL Version : 5.1.70-cll

By the way, I updated to the new beta 11

 

[Mokonzi]

I've looked over the code again and there doesn't seem to be any explanation for this error other than possibly the file that's been uploaded hasn't overwritten the old file properly, or perhaps the server is caching the old file some how.

Do you have any sort of caching system running on your server? If so, can you reupload the Beta 11 files and flush the cache?

 

[CharlieDelta]

It is not a dedicated server so I do not have any caching running. I re-uploaded the files and get the same error.

Is it time to uninstall?

 

[GoodApples]

It is not a dedicated server so I do not have any caching running. I re-uploaded the files and get the same error.

Is it time to uninstall?

Hey Buddy it's been a while ...I had some issues too!
If you haven't already I would un-install the beta11 xml Product then re-install the product.

 

[CharlieDelta]

It has been a while.

We got this sorted via skype. Mokonzi was able to figure it out with a few file downloads, uploads and edits.

 

[Mokonzi]

Yup, we've got this fixed, and it's been patched in the Beta 11 files. If you downloaded them before this post, please redownload and upload them to get the fix for this error.

Many thanks to CharlieDelta and Fillip H. for tracing this issue and finding a good fix for it.