Weird Error for Moods

[robdog]

Database error in vBulletin 4.0.7:

Invalid SQL:

SELECT * FROM dbtech_status_moods
WHERE moodid =
LIMIT 1;

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
'LIMIT 1' at line 3
Error Number : 1064
Request Date : Monday, November 1st 2010 @ 03:32:27 PM
Error Date : Monday, November 1st 2010 @ 03:32:27 PM
Script : URL
Referrer :
IP Address : 66.249.65.181
Username : Unregistered
Classname : vB_Database
MySQL Version :

Pretty much get this error when viewing a number of threads. Any help would be greatly appreciated.

Thanks.

 

[David]

What version of the mod are you running?

 

[robdog]

I am using the latest version.

This seems to be happening when a member WAS posting and then their account was deleted, switching their posts to GUEST.

I changed line 32 in postbit_display_complete.php from:

WHERE moodid  = " . $post['dbtech_status_mood'] . "

to:

WHERE moodid  = " . (isset($post['dbtech_status_mood']) ? $post['dbtech_status_mood'] : 0) . "

That is my little quick fix. I am sure you guys will come up with something a little more permanent.

 

[David]

I am using the latest version.

This seems to be happening when a member WAS posting and then their account was deleted, switching their posts to GUEST.

I changed line 32 in postbit_display_complete.php from:

WHERE moodid  = " . $post['dbtech_status_mood'] . "

to:

WHERE moodid  = " . (isset($post['dbtech_status_mood']) ? $post['dbtech_status_mood'] : 0) . "

That is my little quick fix. I am sure you guys will come up with something a little more permanent.

Hmm, could have sworn I had that fixed. I'll get the zip updated.