Status
Not open for further replies.

robdog

New member
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.
 
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:
PHP:
WHERE moodid  = " . $post['dbtech_status_mood'] . "

to:
PHP:
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.
 
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:
PHP:
WHERE moodid  = " . $post['dbtech_status_mood'] . "

to:
PHP:
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.
 
Status
Not open for further replies.

Similar threads

  • Locked
  • Support ticket Support ticket
Bug DB Error
Tags Tags
db error
Replies
5
Views
537
  • Locked
  • Support ticket Support ticket
Bug DB Error
Replies
4
Views
2K
  • Locked
  • Support ticket Support ticket
Replies
23
Views
5K
Top