Need Help on vBulletin mysql error
 

I recently moved a site I host from one server to another. Soon afterwards* I started receiving mysql errors that I can't figure out. Here's the error:

Quote:
:
Sorry* I couldn't find any host named hitcraft.com. (#5.1.2)

--- Below this line is a copy of the message.

Return-Path:
Received: (qmail 6376 invoked from network); 24 Nov 2009 13:03:38 -0000
Received: from maker1010.hostmaker.com (294.120.170.34)
by gateway02.websitewelcome.com with SMTP; 24 Nov 2009 13:03:38 -0000
Received: from hitch by maker1010.hostmaker.com with local (Exim 4.69)
(envelope-from )
id 1NCurb-0006Da-Nt
for [email protected]; Tue* 24 Nov 2009 06:51:23 -0600
To: [email protected]
Subject: vBulletin Database Error!
X-PHP-Script: www.walkinoutnewhampshire.com/forums/member.php for 91.211.117.122
From: [email protected]
Message-ID:
MIME-Version: 1.0
Content-Type: text/plain
Content-Transfer-Encoding: 8bit
X-Priority: 3
X-Mailer: vBulletin Mail via PHP
Date: Tue* 24 Nov 2009 06:51:23 -0600
X-AntiAbuse: This header was added to track abuse* please include it with any abuse report
X-AntiAbuse: Primary Hostname - maker1010.hostmaker.com
X-AntiAbuse: Original Domain - hitcraft.com
X-AntiAbuse: Originator/Caller UID/GID - [943 943] / [47 12]
X-AntiAbuse: Sender Address Domain - WalkinOutNewHampshire.com

Database error in vBulletin 3.8.2:

Invalid SQL:

SELECT reason* liftdate
FROM vb3_userban
WHERE userid =;

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 '' at line 3
Error Number : 1064
Request Date : Tuesday* November 24th 2009 @ 07:51:23 AM
Error Date : Tuesday* November 24th 2009 @ 07:51:23 AM
Script : http://www.walkinoutnewhampshire.com...er.php?u=26073
Referrer : http://www.walkinoutnewhampshire.com...er.php?u=26073
IP Address : 91.211.117.122
Username :
Classname : vB_Database
MySQL Version :

The first problem with this message is the domain name of the sending domain is spelled wrong. It should be hitchcraft.com and not hitcraft.com. I assume this is as a result of a typo I made somewhere; but the question is WHERE? I'm not sure where recipient address for mysql errors address is being drawn from. The webmaster's email address from the vbulletin global options page is the other email address you see in this message* namely "[email protected]"

Can anyone tell me where the heck the misspelled email address is drawn from so that I can find and correct it?

BTW* I don't think this error is a result of the server change. I assume these errors may have been occurring all along but on the old host with my extensive custom junk-mail filtering I'm not sure an error email sent out to a non-existent email address would have made it to my inbox when it bounced back.

As you can see from this message* I'm running vbulletin 3.8.2 and the error is coming from a query against the vb3_userban table. Is there possibly a known error dealing with vb3_userban in version 3.8.2 of vb3?

Here's another clue... I did a full export dump of ALL my mysql databases on this server (100+ mb of data) and then did a "grep" search of the entire dump file looking for any occurrence of "hitcraft.com" but found none. Isn't that a pretty solid indication the misspelled email address is coming from somewhere else? The question is WHERE?

Thanks!