Bug DB Error When Trying To Leave Feedback

[CharlieDelta]

Trying to leave feedback and received this DB error.

Database error in vBulletin 4.2.0:

Invalid SQL:

SELECT
l.*,
li.listingitemid,
li.winningofferid,
o.offerid,
o.userid AS ouserid,
o.value,
o.opostageid,
o.oaddressid
FROM dbtech_classifieds_listing AS l
LEFT JOIN dbtech_classifieds_listing_item AS li ON l.listingid = li.listingid
LEFT JOIN dbtech_classifieds_offer AS o ON o.listingitemid = li.listingitemid
WHERE l.listingid = 14
ORDER BY l.listingtypeid = 3, o.value ASC , o.value DESC;

MySQL Error : Unknown column 'o.opostageid' in 'field list'
Error Number : 1054
Request Date : Monday, December 2nd 2013 @ 08:49:13 PM
Error Date : Monday, December 2nd 2013 @ 08:49:14 PM
Script : 401 Unauthorized
Referrer : 401 Unauthorized
IP Address : 24.156.247.126
Username : Outdoorsman
Classname : vB_Database_MySQLi
MySQL Version : 5.1.70-cll

 

[Mokonzi]

Thanks, will take a look at this.

 

[Mokonzi]

I've patched the Beta 12 files with a fix. Let me know if that sorts this issue.

Thanks for finding this error.

 

[CharlieDelta]

Works Great!!