[fixed] Database error from moderator control panel

[kippesp]

I've gotten two of these errors over about 5 months. So, not a big deal.

Database error in vBulletin Mod Control Panel 2.2.5:

Invalid SQL: SELECT COUNT(*) AS threads,SUM(replycount) AS replies FROM thread WHERE forumid= AND
visible=1 AND open<>10
mysql error: You have an error in your SQL syntax near 'AND visible=1 AND open<>10' at line 1

mysql error number: 1064

Date: Sunday 02nd of June 2002 04:33:02 PM
Script: http://www.fictionalley.org/artisticalley/reviews/artisticalley/reviews/mod/moderate.php
Referer: http://www.fictionalley.org/artisticalley/reviews/mod/moderate.php?s=&action=posts

I would guess there is a race condition here. We have several moderators, so it wouldn't surprise me. Perhaps updateforumcount() should check for a NULL value and just return. (Is this also possible with the other update functions?)

[kippesp]

Make that 3 errors over the last 6 months.

[Mike Sullivan]

Since it's happening, I'll move it to the bugs forum. Will have to do some research first.

[tamarian]

Same here, I got it too. Thought it was due to mod hack for moderated users, but it's a different query.

[kippesp]

We have 4 boards. The only one it is happening on is the board where we moderate all new threads. So I think moderators are in there a lot dealing with approving threads/posts.