Thanks first for your help.

I had an old version bbpress 0.8. Did not upgrade for a long time, thinking to do it for the beta version release. Now I guess it is a good time to do the upgrade, since holiday season my web traffic is low.

But what should I do to upgrade from bbpress 0.8 to bbPress 1.0-alpha-2 released?

[@chrishajer Participant 16 years, 1 month ago]

Make a backup of the files and the database, then just try the upgrade. I don’t know of any specific problems that come up between 0.8 and 1.0-alpha. I can’t remember any when I upgraded.

[@travelsuperlink Member 16 years ago]

I follow the steps. After extract the new bbpress files and rename the config.php (v0. to bb-config.php, I could see all my previous posts.

However, when I login to the Admin, it displays:

It looks like your database is out-of-date.

You can update it here.

After click the Upgrade Database button, after a few seconds, the http://www.travelsuperlink.com/forum/bb-admin/upgrade.php page just display a blank webpage (timeout?)

I am stuck here, please help.

[@travelsuperlink Member 16 years ago]

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.

[@travelsuperlink Member 16 years ago]

Yes, what I mentioned above is the reason to cause upgrade fail. I update the user_nicename with user_loginname, which is unique key, and the upgrade goes ok.