Announcement

Collapse
No announcement yet.

Database error on member account activation

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts
    Steve Machol
    Former Customer Support Manager

  • Steve Machol
    replied
    Please start your own thread with all the relevant details. Thank you.

    Leave a comment:

  • badawidollah
    Senior Member

  • badawidollah
    replied
    Originally posted by Steve Machol View Post
    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

    Leave a comment:

  • ice4ys
    New Member

  • ice4ys
    replied
    Thank you problem solved.

    Leave a comment:

  • Steve Machol
    Former Customer Support Manager

  • Steve Machol
    replied
    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)
    );

    Leave a comment:

  • ice4ys
    New Member

  • ice4ys
    started a topic Database error on member account activation

    Database error on member account activation

    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
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X