PNphpbb conversion

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
Kena
Registered User
Posts: 89
Joined: Thu Apr 04, 2002 10:46 pm

PNphpbb conversion

Post by Kena » Sun Sep 09, 2007 11:00 am

Hi,

I want to make a conversion script for PNphpbb (the postnuke fork). I've tried the knowledge base solution on this forum. But I don't like it because the scrambles the tables. Now here my issue.

When I import the informatie into the fields of the table throught my script everything seems to work fine. There is one issue I can't seem to work out. I get a "There are no posts in this subject" when I go to the next pages.

I tried tot synchronize the forum, but that didn't work. Can anybody help?

Thankx.

Alex

Kena
Registered User
Posts: 89
Joined: Thu Apr 04, 2002 10:46 pm

Re: PNphpbb conversion

Post by Kena » Sun Sep 09, 2007 12:26 pm

I've found the solution. I had to use addslashes to a number of fields.

Contour
Registered User
Posts: 47
Joined: Sun Nov 25, 2007 1:17 pm

Re: PNphpbb conversion

Post by Contour » Sun Nov 25, 2007 2:13 pm

Can you post the script or the way you done it?

I want to switch from PNphpBB2 to phpBB3, but there is still no info to do that, so i'm thinking to convert to phpBB2 and then use the convertor included in the phpBB3 install.

Regards.

RooMeat
Registered User
Posts: 204
Joined: Sat Jun 24, 2006 10:39 pm
Contact:

Re: PNphpbb conversion

Post by RooMeat » Thu Jan 10, 2008 12:09 pm

There is no need for a script.. it is so easy to upgrade.
1. Backup all existing files and remove all except for the module folder containing pnphpbb. (I coppied this folder to the root then removed everything else)
2. Delete all tables from your database EXCEPT for the pnphpbb tables.
3. De-nuke your database. Basically all you need to do is remove the nuke_ prefix from each table (or what ever prefix your DB has). So you are left with tables with names like phpbb_posts etc etc etc.
4. Create a new database for a fresh phpbb3 installation
5. Upload a fresh copy of phpbb3 to your root folder
6. Run the install
7. At the end of the install click on the convert tab and run through that.

Once that has finished you should have a fully functional board with all posts and users in tact.

I have done 3 conversions so far.. and about to do my largest site (over 4000 members, 218705 posts ;) )

The only issue I have had is the time format gets screwed.. but thats a easy fix :)
Live site: http://www.ozsportsbikes.com (Converted from Nuked phpbb2 to stand alone phpBB3)
Test site: http://www.ozsuperbikes.com
Local Test site with XAMPP

targh
Registered User
Posts: 1
Joined: Thu Jan 17, 2008 6:04 am

Re: PNphpbb conversion

Post by targh » Thu Jan 17, 2008 6:13 am

Hi Roomeat,

Followed your migration steps, works great... i think i'm getting the same time format issue as you were where all of my dates are appearing like this

Code: Select all

Posted: %b %13, %2008 - %0
How did you fix this up??

Cheers

aitala
Registered User
Posts: 3
Joined: Wed Feb 13, 2008 9:49 pm

Re: PNphpbb conversion

Post by aitala » Wed Feb 13, 2008 9:55 pm

Hey,

Did this also migrate over the attachments put in posts?

Thanks much,

Eric

User avatar
golab
Registered User
Posts: 169
Joined: Sun Oct 21, 2001 11:33 pm
Location: Australia
Contact:

Re: PNphpbb conversion

Post by golab » Thu May 15, 2008 4:04 am

The only issue I have had is the time format gets screwed.. but thats a easy fix :)
Can you post what the command is to run this?

Slav

User avatar
devilsharvest
Registered User
Posts: 7
Joined: Mon Oct 21, 2002 5:55 pm
Contact:

Re: PNphpbb conversion

Post by devilsharvest » Sun Jun 15, 2008 10:16 pm

I'd love to see how you got the date format fixed, could you enlighten us?

Viper_iii
Registered User
Posts: 2
Joined: Mon May 26, 2008 3:19 am

Re: PNphpbb conversion

Post by Viper_iii » Wed Jul 23, 2008 3:29 am

Found this but haven't tested it yet myself... From this thread
http://community.zikula.org/module-Foru ... -37829.htm

Code: Select all

UPDATE `phpBB_users` set `user_dateformat`="d M, Y - H:i" WHERE 1

http://www.neothermic.com/kb/article93.html

aitala
Registered User
Posts: 3
Joined: Wed Feb 13, 2008 9:49 pm

Re: PNphpbb conversion

Post by aitala » Tue Aug 19, 2008 6:59 pm

Thanks to everyone who posted here, especially RooMeat. I was able to pull out all the data and attachment from my PNphpBB based Forum into a standard phpBB3 install. Even better, I was able to bridge it to my new Drupal based site so I have a single signon system now.

Only had two issues - one user who had two accounts Hiroboy and hiroboy. Fixed that via phpMyAdmin by changing one of the names. And had the time format bug, which folks posted the fix to...

Thanks again... made my life much easier.

Eric

Locked

Return to “[2.0.x] Convertors”