1. Upload a fresh copy of PHPBB2 to the new directory
2. Use PHPMyAdmin to drop the following tables in the fresh copy: Auth-access, Topics, Categories, Forums, Posts, Posts_text.
3. Then use PHPMyAdmin to export the above tables from the PHPNuke copy (nuke_bb*) then change the nuke_bb values to phpbb_ or whatever your prefix is and import them into the fresh copy. Be sure to choose data AND structure when exporting the original tables.
4. Then export data AND structure of the nuke_users table. Again change all the nuke_ values to phpbb_ and import it. Now some tricky modding, you'll have to convert the regdate to unixtime, so in phpmyadmin edit all the user_regdate fields. See http://www.onlineconversion.com/unix_time.htm for a online unixtime converter.
5. When that is done, alter the user table by deleting all fields that NOT start with user_ (except username).
6. Then export DATA only of the following nuke fields: nuke_bbgroups and nuke_bbuser_groups. Again change the nuke_bb values to phpbb_ and then import them.
7. enter this code in the mysql command
UPDATE phpbb_users SET user_level = '0' WHERE username!= '';
and replace your username with your username, as you are the administrator, that should fix the error
8. run this query on the database: Code:
ALTER TABLE phpbb_users ADD COLUMN user_login_tries smallint(5) UNSIGNED DEFAULT '0' NOT NULL;
ALTER TABLE phpbb_users ADD COLUMN user_last_login_try int(11) DEFAULT '0' NOT NULL;
9. Set some of your configuration options, and your done. PHPNuke can be deleted safely, but first make sure the forum works fine!