I had an several Impex imports of another forum done to my Vbulletin 4 CMS. Some user id's got messed up from me working on the CMS between imports. Now I am getting database error when clicking activation link in email on new registration.

This job is to fix this error so users can receive email and activate account via email. Repair must be not be affected by frequent VB updates.

Thanks,

The error is below.
Database error in vBulletin 4.0.2:

Invalid SQL:

SELECT ipaddress
FROM vb4_user
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 : Sunday, March 7th 2010 10:59:54 PM
Error Date : Sunday, March 7th 2010 10:59:54 PM
Script : http://xxx.xxx.xxx.xxx/community/register.php?a=act&u=407&i=c61ce4852700af2cec08b81f2efc0fa6670f0ec0
Referrer :
IP Address : xx.xxx.xxx.xx
Username : Another
Classname : vB_Database
MySQL Version :