Bug Database error in vBulletin 4.1.7

[KristerSwe]

Try to clean up and Recount in maintance and get this

Database error in vBulletin 4.1.7:

Invalid SQL:

		SELECT entry.*
		FROM hddbtech_thanks_entry AS entry
		LEFT JOIN hdpost AS post ON(post.postid = entry.contentid)
		WHERE entry.entryid >= '0'
			AND contenttype = post
			AND post.postid IS NULL
		ORDER BY entry.entryid
		LIMIT 1000;

MySQL Error   : Unknown column 'post' in 'where clause'
Error Number  : 1054
Request Date  : Saturday, October 22nd 2011 @ 05:08:26 PM
Error Date    : Saturday, October 22nd 2011 @ 05:08:26 PM
Script        : http://www.xxxxxxxx.se/admincp/thanks.php?do=maintenance
Referrer      : http://www.xxxxxxx.se/admincp/thanks.php?do=maintenance
IP Address    : 90.230.20.234
Username      : krister
Classname     : vB_Database_MySQLi
MySQL Version : 5.5.16

 

[Fillip H.]

Hotfix released

 

[Ozzy47]

Excellent it works correctly now.

 

[Ozzy47]

Fillip H., while it does not give DB error anymore when you run cleanup you see this warning now:

 

[Fillip H.]

Can't confirm that, there's checks in place to prevent that specific error. It doesn't matter anyway, doesn't stop anything from functioning.

 

[KristerSwe]

Reuploaded the latest files and now all work perfectly .. no sql errors or text showing up .. Thanks

 

[Fillip H.]

Good stuff