DB error when mod new members.....
 

My admin tried this today.....

So, I just went in to approve/disapprove the members awaiting moderation. After I did all of the detective work (most of them were spammers, BTW) I hit the button where you send them the letter of approval/disapproval. I got a database error, a few times. Don't quite know what to do about it.

.......

I show three similar DB messages that came to my error email box I have set up to come from DB errors. These are what i got.......

Database error in vBulletin 3.6.0:Invalid SQL: SELECT status, regdate, expirydate, subscriptionlogid, subscription.subscriptionid FROM subscriptionlog AS subscriptionlog INNER JOIN subscription AS subscription USING (subscriptionid) WHERE userid = ORDER BY status DESC, regdate;MySQL Error : You have an error in your SQL syntax; check the manual thatcorresponds to your MySQL server version for the right syntax to use near 'ORDER BYstatus DESC, regdate' at line 5Error Number : 1064Date : Wednesday, July 15th 2009 @ 01:00:22 PMScript : http://www.yesfans.com/admincp/user.php?do=edit&u=16084Referrer : http://www.yesfans.com/admincp/user.php?do=moderateIP Address : 205.225.146.106Username : SheerahClassname : vb_database