Bug Archive listing db error

[JaiKai]

When trying to archive an unsold listing we get the following DB Error :

Database error in vBulletin 4.2.2:

Invalid SQL:

UPDATE dbtech_classifieds_listing_item
SET
archived = 1
WHERE listingitemid IN ();

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
Request Date : Sunday, March 30th 2014 @ 08:46:23 PM
Error Date : Sunday, March 30th 2014 @ 08:46:24 PM
Script : 300zx.co.uk Club Bulletin Board
Referrer : 300zx.co.uk Club Bulletin Board

 

[Mokonzi]

Will have a look matey. Thanks for the report.

 

[Mokonzi]

I've figured what was causing the issue thanks to this report.

The system was looking for transaction data that wouldn't exist in an unsold item. I've implemented a fix that will go in the next update.