[SUPPORT] PHP-Nuke to phpBB

This is an archive of the phpBB 2.0.x convertors forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
Locked
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

[SUPPORT] PHP-Nuke to phpBB

Post by D¡cky »

This convertor will transfer the following:
  • Categories
  • Forums
  • Topics
  • Posts
  • Users
  • Groups
  • Private messages
  • Topics watch
  • Polls
  • Authorizations
  • Banned list
  • Ranks
  • Censored words
  • Search words
  • some configuration settings
*************************************************************

This is an adaptation of the script by jonny lamb and jaymer
Fixes include:

* Groups convert properly and all users are assigned to groups
* Adjust user_level to match phpBB user levels
* Set PHP-Nuke anonymous user_id of 1 to phpBB anonymous user_id of -1 for topics and posts. (Sets posts by guests and deleted users correctly.)
* Add code so script will run with php Register Globals = Off

*************************************************************
PHP-Nuke to phpBB is now a complete transfer tool. There is no going into the database after to get things working correctly. At the very most, you may have to make some minor adjustments in the Administration Control Panel.

This was written for PHP-Nuke 7.7, but should work for most older versions, including 6.x versions

Download link. Version 1.2.13
Last edited by D¡cky on Sat Feb 11, 2006 4:13 pm, edited 7 times in total.
Have you hugged someone today?
digiraver
Registered User
Posts: 21
Joined: Mon Jul 11, 2005 7:28 pm
Location: Napa, California
Contact:

Post by digiraver »

The instructions say that the install of phpBB and PHP-Nuke have to be on the same server but in my case I am relocating. So...this is what I would do (unless someone tells me it's wrong)...install a freash install of phpBB on the same server as PHP-Nuke, install the same version of phpBB on the new server, run the converter on the old server to get the phpBB database set up with my old user list from PHP-Nuke, then copy the newly converted phpBB database to the new server and presto...everything works...right?

l8r,
Jake (aka gecko)
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

Post by D¡cky »

digiraver wrote: ...everything works...right?
l8r,
Jake (aka gecko)

We hope everything works. You do have the procedure correct so you should be all set.
Have you hugged someone today?
digiraver
Registered User
Posts: 21
Joined: Mon Jul 11, 2005 7:28 pm
Location: Napa, California
Contact:

Post by digiraver »

Very cool...now for the part of the question that is REALLY newbie like. I imagine that it is a good idea to back up the database before hand just in case. Should I use phpMyAdmin to do this (in which case I really don't know how) or can I use my hosts cPanel database backup option? Would there really be any difference or is a backup a backup?

Thanks in advance...

l8r,
Jake (aka gecko)
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

Post by D¡cky »

I am not that familiar with cPanel, but I assume that a backup is a backup.

To do a backup with phpMyadmin, open phpMyAdmin, select your database and click the Export tab at the top. The SQL button and the Structure button should be checked. Under the Data section, check Complete Inserts. Check the Save As File and click Go. The file will save to your computer.
Have you hugged someone today?
digiraver
Registered User
Posts: 21
Joined: Mon Jul 11, 2005 7:28 pm
Location: Napa, California
Contact:

Post by digiraver »

Thank you so very much for your help. Now I just have to find the time to sit down and get all this fun stuff done. Thanks again...

l8r,
Jake (aka gecko)
digiraver
Registered User
Posts: 21
Joined: Mon Jul 11, 2005 7:28 pm
Location: Napa, California
Contact:

new question

Post by digiraver »

ok...new question. Does this converter work with phpBB 1.x or 2.x or both? I am assuming that it is for 2.x (what is the newest version? 2.0.16?) but if it is for the older version please let me know...Thanks...

l8r,
Jake (aka gecko)
Graham
Former Team Member
Posts: 8462
Joined: Tue Mar 19, 2002 7:11 pm
Location: UK
Contact:

Post by Graham »

It will be for 2.0.x

Version 1.x has not been supported for a very long time and should not be used on a live site.
"So Long, and Thanks for All the Fish"

phpBB Useful Links: Knowledge Base | Userguide | Forum Search | MOD Database | Styles Database
My Links: Blog!
digiraver
Registered User
Posts: 21
Joined: Mon Jul 11, 2005 7:28 pm
Location: Napa, California
Contact:

Post by digiraver »

Okie Dokie...installed a freash copy of phpBB into it's own directory and set up the basics (pretty much nothing...it was totally freash with the 'Test Forum 1' and all). Then backed up my PHP-Nuke database. Then uploaded the converter script to my phpBB directory. I ran the script and entered the correct information and this is what it said:

Couldn't find nuke_bbsearch_wordmatch
1146: Table 'digirave_backup.nuke_bbsearch_wordmatch' doesn't exist

SELECT * FROM nuke_bbsearch_wordmatch

Warning: Cannot modify header information - headers already sent by (output started at /home/digirave/public_html/backup/conv_nuke.php:45) in /home/digirave/public_html/backup/includes/sessions.php on line 206

Warning: Cannot modify header information - headers already sent by (output started at /home/digirave/public_html/backup/conv_nuke.php:45) in /home/digirave/public_html/backup/includes/sessions.php on line 207

Warning: Cannot modify header information - headers already sent by (output started at /home/digirave/public_html/backup/conv_nuke.php:45) in /home/digirave/public_html/backup/includes/page_header.php on line 475

Warning: Cannot modify header information - headers already sent by (output started at /home/digirave/public_html/backup/conv_nuke.php:45) in /home/digirave/public_html/backup/includes/page_header.php on line 477

Warning: Cannot modify header information - headers already sent by (output started at /home/digirave/public_html/backup/conv_nuke.php:45) in /home/digirave/public_html/backup/includes/page_header.php on line 478
yourdomain.com
A _little_ text to describe your forum
FAQ Search Memberlist Usergroups Register
Profile Log in to check your private messages Log in


yourdomain.com Forum Index
Information

Connecting to PHP-Nuke database server...Success
Connecting to PHP-Nuke database...Success
Connecting to phpBB database server...Success
Connecting to phpBB database...Success
Exporting data from PHP-Nuke table: disallow...Success
Exporting data from PHP-Nuke table: categories...Success
Exporting data from PHP-Nuke table: forums...Success
Exporting data from PHP-Nuke table: posts_text...Success
Exporting data from PHP-Nuke table: privmsgs...Success
Exporting data from PHP-Nuke table: privmsgs_text...Success
Exporting data from PHP-Nuke table: topics_watch...Success
Exporting data from PHP-Nuke table: words...Success
Exporting data from PHP-Nuke table: vote_desc...Success
Exporting data from PHP-Nuke table: vote_results...Success
Exporting data from PHP-Nuke table: vote_voters...Success
Exporting data from PHP-Nuke table: search_wordlist...Success
Exporting data from PHP-Nuke table: search_wordmatch...Success
Exporting data from PHP-Nuke configuration tables...Success
Exporting data from PHP-Nuke table: auth_access...Success
Exporting data from PHP-Nuke tables: topics...Success
Exporting data from PHP-Nuke tables: posts...Success
Exporting data from PHP-Nuke tables: users...Success
Moving groups data from PHP-Nuke -> phpBB...Moving usergroup data from PHP-Nuke -> phpBB...Moving banlist data from PHP-Nuke -> phpBB...Success
Moving ranks data from PHP-Nuke -> phpBB...Success



The conversion has been a success


However...it doesn't appear that anything actually converted successfully. The only tables that contain anything are:

phpbb_config
phpbb_groups
phpbb_sessions
phpbb_smilies
phpbb_themes
phpbb_themes_name
phpbb_user_group

Any ideas?

l8r,
Jake (aka gecko)
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

Post by D¡cky »

digiraver wrote: I ran the script and entered the correct information and this is what it said:

Couldn't find nuke_bbsearch_wordmatch
1146: Table 'digirave_backup.nuke_bbsearch_wordmatch' doesn't exist

SELECT * FROM nuke_bbsearch_wordmatch


You should have 3 word search tables, nuke_bbsearch_results, nuke_bbsearch_worklist and nuke_bbsearch_wordmatch. Do you have these tables?

As for the empty tables, you did import the backup into your digirave_backup table?
I don't know what to say about the "Cannot modify header information" problem. I can't duplicate the problem. There may be something wrong with your phpBB installation.

What version of php and MySQL are you running?
Are you doing the conversion on your local machine or on the webhost?
Have you hugged someone today?
redTop
Registered User
Posts: 3
Joined: Wed Jul 13, 2005 6:09 pm

Post by redTop »

Hello,

I've tried the converter as well... followed all steps as mentioned in the readme. I get exactly the same output as Digiraver.

I do get some more tables into the database, but they are all empty.

PHP 4.3.11
Apache 1.3.33
PHPnuke 2.6
phpBB 2.16 (new install)
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

Post by D¡cky »

Very strange happenings. I will see if I can get some debugging routines working in the script so we can see what is going on.

What database setups are y'all using.

Are Nuke and phpBB in the same database or separate databases?
Are you importing into the phpBB database that phpBB installed?
Have you hugged someone today?
redTop
Registered User
Posts: 3
Joined: Wed Jul 13, 2005 6:09 pm

Post by redTop »

Nuke database:
name: rknuke
prefix: nuke_

phpBB database:
name: forum
prefix phpbb_

same server, hosted by myself. Importing into the database that phpBB installed.
TOGFather
Registered User
Posts: 74
Joined: Sat Feb 01, 2003 1:13 pm
Location: Australia
Contact:

Post by TOGFather »

Not working here either, convering from Nuke to 2.0.16, I get the following but all is empty, no users, no forums, nothing :/

-----------------------

Couldn't find nuke_bbsearch_wordmatch
1146: Table '2016.nuke_bbsearch_wordmatch' doesn't exist

SELECT * FROM nuke_bbsearch_wordmatch


Connecting to PHP-Nuke database server...Success
Connecting to PHP-Nuke database...Success
Connecting to phpBB database server...Success
Connecting to phpBB database...Success
Exporting data from PHP-Nuke table: disallow...Success
Exporting data from PHP-Nuke table: categories...Success
Exporting data from PHP-Nuke table: forums...Success
Exporting data from PHP-Nuke table: posts_text...Success
Exporting data from PHP-Nuke table: privmsgs...Success
Exporting data from PHP-Nuke table: privmsgs_text...Success
Exporting data from PHP-Nuke table: topics_watch...Success
Exporting data from PHP-Nuke table: words...Success
Exporting data from PHP-Nuke table: vote_desc...Success
Exporting data from PHP-Nuke table: vote_results...Success
Exporting data from PHP-Nuke table: vote_voters...Success
Exporting data from PHP-Nuke table: search_wordlist...Success
Exporting data from PHP-Nuke table: search_wordmatch...Success
Exporting data from PHP-Nuke configuration tables...Success
Exporting data from PHP-Nuke table: auth_access...Success
Exporting data from PHP-Nuke tables: topics...Success
Exporting data from PHP-Nuke tables: posts...Success
Exporting data from PHP-Nuke tables: users...Success
Moving groups data from PHP-Nuke -> phpBB...Moving usergroup data from PHP-Nuke -> phpBB...Moving banlist data from PHP-Nuke -> phpBB...Success
Moving ranks data from PHP-Nuke -> phpBB...Success
TOGFather
Registered User
Posts: 74
Joined: Sat Feb 01, 2003 1:13 pm
Location: Australia
Contact:

Post by TOGFather »

Got a bit further by having it all sitting in one DB, but not there yet.

It seems like all forums have been imported but users and gruops are still empty.

Even the forums are all listing and so are the number of posts in them, when you open up the forums they are empty.

And the dates for the lasts post is 1 jan 1970.

The script also finished on a blank page rather then a fail or success.
Locked

Return to “[2.0.x] Convertors”