Knowledgebase

Problem:

Cannot update phpBB2 when using PHP-Nuke.

Solution:

1. Upload a fresh copy of phpBB2 to the new directory, using the most up to date version.
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 PHP-Nuke 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. Now set the user_level of your admin in your phpbb_users table to 1.
8. Set some of your configuration options, and your done. PHPNuke can be deleted safely, but first make sure the forum works fine before you do!