Database error on member account activation

[ice4ys]

Hi new members are not able to activate their accounts as they get the following DB error.

Database error in vBulletin 3.8.4:

Invalid SQL:

SELECT userid
FROM useractivation
WHERE activationid = '63cadbf6d960501335a2db834abc09cab99b1f9c';

MySQL Error : Table 'rampant_forum.useractivation' doesn't exist
Error Number : 1146
Request Date : Tuesday, October 6th 2009 @ 06:24:14 PM
Error Date : Tuesday, October 6th 2009 @ 06:24:14 PM
Script : http://www.*************.com/forum/r...bc09cab99b1f9c
Referrer : http://uk.mg41.mail.yahoo.com/dc/bla...uk&.lang=en-GB
IP Address : 86.149.198.26
Username : rampant
Classname : vB_Database
MySQL Version : 5.0.67-community

Please advise if this can be rectified.

Thanks

[Steve Machol]

You are missing the useractivation table for some reason. Assuming this is the only thing missing you can add that table with this query:

CREATE TABLE useractivation (
useractivationid INT UNSIGNED NOT NULL AUTO_INCREMENT,
userid INT UNSIGNED NOT NULL DEFAULT '0',
dateline INT UNSIGNED NOT NULL DEFAULT '0',
activationid VARCHAR(40) NOT NULL DEFAULT '',
type SMALLINT UNSIGNED NOT NULL DEFAULT '0',
usergroupid SMALLINT UNSIGNED NOT NULL DEFAULT '0',
emailchange SMALLINT UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (useractivationid),
UNIQUE KEY userid (userid, type)
);

[ice4ys]

Thank you problem solved.

[badawidollah]

You are missing the useractivation table for some reason. Assuming this is the only thing missing you can add that table with this query:

CREATE TABLE useractivation (
useractivationid INT UNSIGNED NOT NULL AUTO_INCREMENT,
userid INT UNSIGNED NOT NULL DEFAULT '0',
dateline INT UNSIGNED NOT NULL DEFAULT '0',
activationid VARCHAR(40) NOT NULL DEFAULT '',
type SMALLINT UNSIGNED NOT NULL DEFAULT '0',
usergroupid SMALLINT UNSIGNED NOT NULL DEFAULT '0',
emailchange SMALLINT UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (useractivationid),
UNIQUE KEY userid (userid, type)
);

where is i can found useractivation table

[Steve Machol]

Please start your own thread with all the relevant details. Thank you.