Did anyone come up with a fix for the new user registration problem in 6.5RC2.
Users cannot register on my site..... after the reg process and the confirmation email they get
_ACTIVATIONERROR
_ACTERROR2
Please help... Gary
sixonetonoffun Major
Joined: Jan 13, 2003
Posts: 892
Posted:
Thu Feb 27, 2003 5:02 am
Do the database updates manually there is one new table
Code:
CREATE TABLE nuke_users_temp (
user_id int(10) NOT NULL auto_increment,
username varchar(25) NOT NULL default '',
user_email varchar(255) NOT NULL default '',
user_password varchar(40) NOT NULL default '',
user_regdate varchar(20) NOT NULL default '',
check_num varchar(50) NOT NULL default '',
time varchar(14) NOT NULL default '',
PRIMARY KEY (user_id)
) TYPE=MyISAM;
and a couple keys added to
CREATE TABLE nuke_stories (
sid int(11) NOT NULL auto_increment,
catid int(11) NOT NULL default '0',
aid varchar(30) NOT NULL default '',
title varchar(80) default NULL,
time datetime default NULL,
hometext text,
bodytext text NOT NULL,
comments int(11) default '0',
counter mediumint(8) unsigned default NULL,
topic int(3) NOT NULL default '1',
informant varchar(20) NOT NULL default '',
notes text NOT NULL,
ihome int(1) NOT NULL default '0',
alanguage varchar(30) NOT NULL default '',
acomm int(1) NOT NULL default '0',
haspoll int(1) NOT NULL default '0',
pollID int(10) NOT NULL default '0',
score int(10) NOT NULL default '0',
ratings int(10) NOT NULL default '0',
PRIMARY KEY (sid),
KEY sid (sid),
KEY catid (catid),
KEY counter (counter), <~New
KEY topic (topic) <~New
) TYPE=MyISAM;
If you haven't made these updates you will get that error. The other is just language file updates that need to be made. chatserve posted a complete english lang file in one of the forums.
CREATE TABLE nuke_users_temp (
user_id int(10) NOT NULL auto_increment,
username varchar(25) NOT NULL default '',
user_email varchar(255) NOT NULL default '',
user_password varchar(40) NOT NULL default '',
user_regdate varchar(20) NOT NULL default '',
check_num varchar(50) NOT NULL default '',
time varchar(14) NOT NULL default '',
PRIMARY KEY (user_id)
) TYPE=MyISAM;
ALTER TABLE nuke_stories ADD KEY counter (counter);
ALTER TABLE nuke_stories ADD KEY topic (topic);
ArtificialIntel
chatserv General
Joined: Jan 12, 2003
Posts: 3128
Location: Puerto Rico
Posted:
Thu Feb 27, 2003 8:56 am
gsicard wrote:
Did anyone come up with a fix for the new user registration problem in 6.5RC2.
Users cannot register on my site..... after the reg process and the confirmation email they get
_ACTIVATIONERROR
_ACTERROR2
Please help... Gary
If you are using the 2.1 port and uploaded the language file that came with the port when it was first released replace it with the one that comes with RC-2
_________________ Feed a man a fish and you feed him for a day. Teach a man to fish and you feed him for a lifetime.
ScriptHeaven | NukeResources
gsicard Sergeant
Joined: Feb 08, 2003
Posts: 105
Location: Virginia, USA
Posted:
Thu Feb 27, 2003 9:42 am
My database does not use the nuke prefix. Should I change the SQL code prior to running it.
Gary
gsicard Sergeant
Joined: Feb 08, 2003
Posts: 105
Location: Virginia, USA
Posted:
Thu Feb 27, 2003 10:42 am
Did that. Same problem.
Gary
chatserv wrote:
gsicard wrote:
Did anyone come up with a fix for the new user registration problem in 6.5RC2.
Users cannot register on my site..... after the reg process and the confirmation email they get
_ACTIVATIONERROR
_ACTERROR2
Please help... Gary
If you are using the 2.1 port and uploaded the language file that came with the port when it was first released replace it with the one that comes with RC-2
ArtificialIntel
Joined: Jan 31, 2004
Posts: -88
Posted:
Thu Feb 27, 2003 11:08 am
yes, change nuke to the prefix u use.
Most ppl use nuke so that's why i put nuke rather than $prefix
ArtificialIntel
Tjendol Sergeant
Joined: Dec 15, 2003
Posts: 77
Posted:
Wed Dec 17, 2003 9:01 am
ArtificialIntel wrote:
copy and paste the following into phpMyAdmin
Code:
CREATE TABLE nuke_users_temp (
user_id int(10) NOT NULL auto_increment,
username varchar(25) NOT NULL default '',
user_email varchar(255) NOT NULL default '',
user_password varchar(40) NOT NULL default '',
user_regdate varchar(20) NOT NULL default '',
check_num varchar(50) NOT NULL default '',
time varchar(14) NOT NULL default '',
PRIMARY KEY (user_id)
) TYPE=MyISAM;
ALTER TABLE nuke_stories ADD KEY counter (counter);
ALTER TABLE nuke_stories ADD KEY topic (topic);
ArtificialIntel
Where and HOW do I copy and paste code like this in myphpadmin?
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
