Bug Database Error when Disabling Feature Integration on Visitor Messages

[impaktZygo]

When we attempt to disable the feature integration with Visitor Messages, we get the following SQL Database error on all of our profile pages...

Database error in vBulletin 4.2.0:

Invalid SQL:

SELECT
entry.*,
user.username,
user.usergroupid,
user.membergroupids,
user.infractiongroupid,
user.displaygroupid,
receiveduser.username AS receivedusername,
receiveduser.usergroupid AS receivedusergroupid,
receiveduser.membergroupids AS receivedmembergroupids,
receiveduser.infractiongroupid AS receivedinfractiongroupid,
receiveduser.displaygroupid AS receiveddisplaygroupid
, user.dbtech_vbshop_purchase, receiveduser.dbtech_vbshop_purchase AS receivedpurchase
FROM (
()
) AS entry
LEFT JOIN vb3user AS user ON(user.userid = entry.userid)
LEFT JOIN vb3user AS receiveduser ON(receiveduser.userid = entry.receiveduserid)
ORDER BY entryid DESC
LIMIT 20;

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 ')
) AS entry
LEFT JOIN vb3user AS user ON(user.userid = entry.userid)
' at line 15
Error Number : 1064
Request Date : Sunday, September 15th 2013 @ 06:37:03 PM
Error Date : Sunday, September 15th 2013 @ 06:37:05 PM
Script : IconiK Gaming
Referrer :
IP Address :
Username : IG Zygo IV
Classname : vB_Database
MySQL Version : 5.0.96-community

 

[Fillip H.]

I have uploaded a potential hotfix for this issue. Please re-download and re-upload /dbtech/thanks/includes/class_profileblock.php

 

[impaktZygo]

Re uploaded and reinstalled. That appears to have done it!!

Thanks!

 

[Fillip H.]

Good stuff, thanks for posting back


If you have a few minutes, we would appreciate it if you would create a review in our new review system.

Not only do we get invaluable feedback on our products, you also get $1 in free DBTech points to go towards your next purchase for every approved review you write.

When entering a review there is also a field to enter a link to your site so it's win-win. Points to get a DBTech product at a lower price and free advertising!

If you wonder what kind of review we are looking for, Cosmic created what he thinks is a good sample here.