Hello,

Here's how i end up with thi sproblem. I have ver 2.0.7 and i did an increment update until i got to ver 2.2.3.

i enocuntered a problem with 2.2.3 regarding email activation and opted for downgrade to 2.0.13. well i was able to downgrade but somethings are not the way they used to be.

I back up my SQL tables from 2.2.3 before i downgrade. now i want to restore my xoops_users data to my my current versio which is 2.0.13. There I got error because the fields are not the same anymore.

Here is the table structure for 2.0.13
CREATE TABLE xoops_users (
uid mediumint(8) unsigned NOT NULL auto_increment,
name varchar(60) NOT NULL default '',
uname varchar(25) NOT NULL default '',
email varchar(60) NOT NULL default '',
url varchar(100) NOT NULL default '',
user_avatar varchar(30) NOT NULL default 'blank.gif',
user_regdate int(10) unsigned NOT NULL default '0',
user_icq varchar(15) NOT NULL default '',
user_from varchar(100) NOT NULL default '',
user_sig tinytext NOT NULL,
user_viewemail tinyint(1) unsigned NOT NULL default '0',
actkey varchar(8) NOT NULL default '',
user_aim varchar(18) NOT NULL default '',
user_yim varchar(25) NOT NULL default '',
user_msnm varchar(100) NOT NULL default '',
pass varchar(32) NOT NULL default '',
posts mediumint(8) unsigned NOT NULL default '0',
attachsig tinyint(1) unsigned NOT NULL default '0',
rank smallint(5) unsigned NOT NULL default '0',
level tinyint(3) unsigned NOT NULL default '1',
theme varchar(100) NOT NULL default '',
timezone_offset float(3,1) NOT NULL default '0.0',
last_login int(10) unsigned NOT NULL default '0',
umode varchar(10) NOT NULL default '',
uorder tinyint(1) unsigned NOT NULL default '0',
notify_method tinyint(1) NOT NULL default '1',
notify_mode tinyint(1) NOT NULL default '0',
user_occ varchar(100) NOT NULL default '',
bio tinytext NOT NULL,
user_intrest varchar(150) NOT NULL default '',
user_mailok tinyint(1) unsigned NOT NULL default '1',
PRIMARY KEY (uid),
KEY uname (uname),
KEY email (email),
KEY uiduname (uid,uname),
KEY unamepass (uname,pass)
) TYPE=MyISAM;

and here is the structure that i have in my backup

CREATE TABLE xoops_users (
uid mediumint(8) unsigned NOT NULL auto_increment,
name varchar(60) NOT NULL default '',
uname varchar(55) NOT NULL default '',
loginname varchar(25) NOT NULL default '',
email varchar(60) NOT NULL default '',
user_avatar varchar(30) NOT NULL default 'blank.gif',
pass varchar(32) NOT NULL default '',
rank smallint(5) unsigned NOT NULL default '0',
level tinyint(3) NOT NULL default '0',
PRIMARY KEY (uid),
KEY uname (uname),
KEY email (email),
KEY uiduname (uid,uname),
KEY unamepass (uname,pass)
) TYPE=MyISAM;

Can anyone please help me! Thanks in advance