Site registry with admin approval problems

juantus · New Member Joined: Mar 17, 2010 Posts: 5

I upgraded from phpnuke to Raven but now I cant register members. It gives an error 'unable to update data base' can anyone help with this... It happens even when I try manually entering the member. Confused

Palbin · Posted: Wed Jun 02, 2010 7:47 am

Just so everyone can get an understanding of the situation, how did you go about upgrading from phpnuke to ravennuke?

snype · Regular Joined: Aug 12, 2008 Posts: 58

Was this the site that scope1234 done for you?

juantus · New Member Joined: Mar 17, 2010 Posts: 5

Yes but I dont think its something he done for we talked and walked through it

Palbin · Posted: Wed Jun 02, 2010 2:46 pm

I would suggest running the Table Compare Utility which is located in the UtilityFiles folder in the download. This will inform you of an discrepancies in the database. We can go from there.

juantus · New Member Joined: Mar 17, 2010 Posts: 5

Sorry it took so long finally ran the comparison and here is the results:

You are comparing this data base against the structure of the database represented in fieldlist240.txt
null status not match nuke_users bio : Base YES Your table NO
null status not match nuke_users ublock : Base YES Your table NO
column not found in your table: nuke_users user_login_tries
column not found in your table: nuke_users user_last_login_try
column not found in your table: nuke_users agreedtos
column not found in your table: nuke_users lastsitevisit

--------------------------------------------------------------------------------
tables processed: 163
fields processed: 1179
fields not found on your system 4
tables not found in your system: 0

Palbin · Posted: Mon Jun 07, 2010 12:00 pm

Looks like an easy fix. I don't have time right now to prepare the necessary sql statements to fix it, but I will try to do it tonight.

If anyone else sees this before I respond feel free to help Smile

juantus · New Member Joined: Mar 17, 2010 Posts: 5

Thanks Guys for your help..it will get the recruit dept off my back...lol..

Palbin · Posted: Mon Jun 07, 2010 8:03 pm

Use phpmyadmin to run this, and then rerun the table compare.

Code:

ALTER TABLE nuke_users CHANGE bio bio tinytext NULL default NULL;
ALTER TABLE nuke_users CHANGE ublock ublock tinytext NULL default NULL;
ALTER TABLE nuke_users ADD lastsitevisit INT(11) NOT NULL DEFAULT 0;
ALTER TABLE nuke_users ADD agreedtos TINYINT(1) NOT NULL DEFAULT 0;
ALTER TABLE nuke_users ADD user_last_login_try int(11) NOT NULL DEFAULT 0;
ALTER TABLE nuke_users ADD user_login_tries smallint(5) unsigned NOT NULL DEFAULT 0;

Also FYI I see your comparing 2.40.00. Our current version is 2.40.01. After we get this fixed I suggest you upgrade.