[travelsuperlink]

I tried to understand the new database structure by checking the upgrade-schema.php. I found one thing could cause problem:

$bb_queries = “CREATE TABLE IF NOT EXISTS $bbdb->users (

ID bigint(20) unsigned NOT NULL auto_increment,

user_login varchar(60) NOT NULL default ”,

user_pass varchar(64) NOT NULL default ”,

user_nicename varchar(50) NOT NULL default ”,

user_email varchar(100) NOT NULL default ”,

user_url varchar(100) NOT NULL default ”,

user_registered datetime NOT NULL default ‘0000-00-00 00:00:00’,

user_status int(11) NOT NULL default 0,

display_name varchar(250) NOT NULL default ”,

PRIMARY KEY (ID),

UNIQUE KEY user_login (user_login),

UNIQUE KEY user_nicename (user_nicename)

);”;

my old database table bb_users the user_nicename does not have unique key on it, but now upgrade try to setup as unique key. will it be the reason for the upgrade timeout?

Unfortunately for my cpanel host I could not access the mysql log, but please help me solve this. any inputs are welcome.

thanks.