[thenags]

Usually with enough Google searches I can get most of my vBulletin issues fixed, but this one has me stumped. Forum was running fine for a long time. I tried to delete a user but during the deletion process in Admin CP I got a database error. Later on I noticed that the user DID get deleted but now 9 times out of 10 clicking on ANY thread in the forum will return the following database error and in the error itself I see the username mentioned that I deleted. Any help would be appreciated.

Database error in vBulletin 4.0.7:

Invalid SQL:

SELECT MIN(postid) AS postid
FROM vb3_post
WHERE threadid = 53409
AND visible = 1
AND dateline > 1421855192
AND userid NOT IN (usernameofdeleteduser)
LIMIT 1;

MySQL Error : Unknown column 'usernameofdeleteduser' in 'where clause'
Error Number : 1054
Request Date : Saturday, January 31st 2015 @ 10:46:32 AM
Error Date : Saturday, January 31st 2015 @ 10:46:32 AM
Script : http://stuntride.com/vbstunt/showthr...s?goto=newpost
Referrer : http://stuntride.com/vbstunt/forum.php
IP Address : 69.65.xxx.xxx
Username : myusername
Classname : vB_Database
MySQL Version : 5.1.70-cll

Thanks a lot.