New Registration Issue...
 

When new users register on my site, they receive a confirmation email to complete registration.

The problem is that when they click the link(s) in registration email they get a database error.

Here is the error I receive:

Quote:
Database error in vBulletin 3.8.3:

Invalid SQL:

SELECT userid
FROM useractivation
WHERE activationid = 'users activation id';

MySQL Error : Table 'table name.useractivation' doesn't exist
Error Number : 1146
Request Date : Friday, June 26th 2009 @ 03:04:48 AM
Error Date : Friday, June 26th 2009 @ 03:04:48 AM
Script : http://glitchpc.com/forums/register....t&u=96&i=users activation id
Referrer :
IP Address : users IP address
Username : Unregistered
Classname : vB_Database
MySQL Version :
I have checked the database and the table is there, but the table name is: vb_useractivation and not useractivation

It is very important I get this fixed as soon as possible.

Thank you, in advance for your assistance with this matter.