FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » Converters » phpBB2 to FUDforum converter
Show: Today's Messages :: Unread Messages :: Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
Message by ShineOn is ignored  [reveal message]  [reveal all messages by ShineOn]  [stop ignoring this user] Go to next message
Re: phpbb3 conversion to 3.03RC1 - stuck [message #166116 is a reply to message #166115] Sun, 18 September 2011 16:18 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3768
Registered: December 2004
Karma: 27
Senior Member
Administrator
Core Developer
remove from buddy list
ignore all messages by this user
My guess is that the config file exits because of a missing define. Anyway, if you need some help, and you can provide me a dump to test with, please open a new topic or e-mail me to discuss.
Re: phpBB2 to FUDforum converter [message #166121 is a reply to message #166116] Tue, 20 September 2011 01:48 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3768
Registered: December 2004
Karma: 27
Senior Member
Administrator
Core Developer
remove from buddy list
ignore all messages by this user
Here is a phpBB2 map you can try:
http://fudforum.svn.sourceforge.net/viewvc/fudforum/trunk/converter/convers ionmaps/phpBB2.map

Please let us know if you improve it so we can sync the changes back to the repository.

Best regards.

Frank
Re: phpBB2 to FUDforum converter [message #166136 is a reply to message #166115] Tue, 27 September 2011 11:49 Go to previous messageGo to next message
Canal Noises is currently offline  Canal Noises   United States
Messages: 2
Registered: September 2011
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
I just ran the converter using this map and it worked great for the most part. As far as I can tell right now, the only problems are with the attachments and smilies. Apparently I can't post a link to the attachment mod I used, but if you search "phpbb2 attachment mod by acyd burn" you should be able to find it. I know this isn't part of a standard phpBB2 install, but is there any way you guys could make it work? I'm sure I'm not the only one who would find it useful. It was a very popular mod back in the day.

The smilies themselves imported just fine, but they don't display in any of the posts imported from phpBB2. It looks like the conversion script replaced each smilie with a hardcoded path to the image, which would be fine except I had uploaded some custom smilies to the forum with different file names from the default smilies and the script has used the default file names.

Any help on these issues would be greatly appreciated. We've been stuck on phpBB2 because our community insists on having a mailing list interface, and the mail2forum add-on for phpBB2 is the only free and open source solution I had been able to find. I was really excited when I discovered that FUDforum is a modern, currently maintained forum software with the mailing list built in! I am really hoping we can get it to work for our needs.

Thanks for your time!
Re: phpBB2 to FUDforum converter [message #166144 is a reply to message #166136] Wed, 28 September 2011 13:06 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3768
Registered: December 2004
Karma: 27
Senior Member
Administrator
Core Developer
remove from buddy list
ignore all messages by this user
This should address both problems:
http://fudforum.svn.sourceforge.net/fudforum/?rev=5393&view=rev
Re: phpBB2 to FUDforum converter [message #166147 is a reply to message #166144] Wed, 28 September 2011 19:38 Go to previous messageGo to next message
Canal Noises is currently offline  Canal Noises   United States
Messages: 2
Registered: September 2011
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Wow, that was fast! That worked great, thank you so much! You're awesome. Very Happy
Message by ShineOn is ignored  [reveal message]  [reveal all messages by ShineOn]  [stop ignoring this user] Go to previous messageGo to next message
Re: phpBB2 to FUDforum converter [message #166185 is a reply to message #166182] Sun, 09 October 2011 08:54 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3768
Registered: December 2004
Karma: 27
Senior Member
Administrator
Core Developer
remove from buddy list
ignore all messages by this user
ShineOn wrote:
1) Some bbcode doesn't translate, for example [list]. Does FUDforum have the [list] bbcode? Do I have to add that?


It was fixed a while ago. Lists should now be converted. If you see any other BBcode problems, let us know so we can fix them.

ShineOn wrote:
2) Internal links do not translate well. Any links within a topic/post that redirect to another topic/post within the forum appear broken. The phpbb "viewtopic.php/viewforum.php" functionality is apparently in the index.php script in FUDforum, and the forum/topic/message number variables are different, even though the numbers referenced match up. I will get more info to you on that, if you want to address this in the converter. It would be nice if the messages were checked for internal forum post links which would be translated from <webroot>/viewtopic.php?etc. or <webroot>/viewforum.php?etc. to the FUDforum <webroot>/index.php?etc. topic/message URL format, so the internal links aren't broken post-conversion.


I'm sure we can implement it. Mail me a couple of examples to work on.

ShineOn wrote:
3) Any external links to the forum will also be broken, because although the forum ID, topic ID and post ID are all consistent, the URL format is different. Is there a possibility of perhaps a plugin that would "unbreak" external links so someone linking to your site with the phpbb format link would have it translated to the FUDforum url for the same forum/topic number, or will all of those external links also be broken?


You can always re-map URLs with .htaccess rewrite rules.

ShineOn wrote:
4) There appears to be a difference in max message length between my phpbb forum and FUD. Is there a way to either detect messages that would be truncated or change the max message length to match the source forum?


Message formats are different and there is no direct way of comparing them.
The easiest would be to find the longest message in phpBB and check if it complete in FUDforum.
Message by ShineOn is ignored  [reveal message]  [reveal all messages by ShineOn]  [stop ignoring this user] Go to previous messageGo to next message
Message by ShineOn is ignored  [reveal message]  [reveal all messages by ShineOn]  [stop ignoring this user] Go to previous messageGo to next message
Re: phpBB2 to FUDforum converter [message #166361 is a reply to message #166358] Fri, 25 November 2011 03:52 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3768
Registered: December 2004
Karma: 27
Senior Member
Administrator
Core Developer
remove from buddy list
ignore all messages by this user
The query on this page may help you to fix your data:
http://www.4webhelp.net/us/phpbb_ip.php

I'll prepare a fix for the converter later.
Re: phpBB2 to FUDforum converter [message #166362 is a reply to message #166361] Fri, 25 November 2011 04:32 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3768
Registered: December 2004
Karma: 27
Senior Member
Administrator
Core Developer
remove from buddy list
ignore all messages by this user
Converter fix @ http://fudforum.svn.sourceforge.net/viewvc/fudforum?view=revision&revis ion=5406
Message by ShineOn is ignored  [reveal message]  [reveal all messages by ShineOn]  [stop ignoring this user] Go to previous messageGo to next message
Message by ShineOn is ignored  [reveal message]  [reveal all messages by ShineOn]  [stop ignoring this user] Go to previous messageGo to next message
Re: phpBB2 to FUDforum converter [message #166367 is a reply to message #166365] Fri, 25 November 2011 23:38 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3768
Registered: December 2004
Karma: 27
Senior Member
Administrator
Core Developer
remove from buddy list
ignore all messages by this user
Thanks, your fixes were committed:
http://fudforum.svn.sourceforge.net/fudforum/?rev=5407&view=rev and http://fudforum.svn.sourceforge.net/fudforum/?rev=5408&view=rev

The decode_ip() function will now:
1. Check if IP is valid. If so, return.
2. If not, and len==8, convert hex to dotted and return.
3. If numeric, do a long2ip() and return.
Message by ShineOn is ignored  [reveal message]  [reveal all messages by ShineOn]  [stop ignoring this user] Go to previous messageGo to next message
Re: phpBB2 to FUDforum converter [message #166370 is a reply to message #166369] Sun, 27 November 2011 07:57 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3768
Registered: December 2004
Karma: 27
Senior Member
Administrator
Core Developer
remove from buddy list
ignore all messages by this user
phpBB2 doesn't track who voted for what option, so votes aren't imported.
Re: phpBB2 to FUDforum converter [message #167919 is a reply to message #166370] Mon, 12 November 2012 04:00 Go to previous messageGo to next message
merryflip is currently offline  merryflip   United States
Messages: 1
Registered: November 2012
Location: ??
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
well, the software is really very great.
Re: phpBB2 to FUDforum converter [message #168343 is a reply to message #167919] Sat, 20 April 2013 20:46 Go to previous messageGo to next message
cpreston is currently offline  cpreston   United States
Messages: 160
Registered: June 2012
Location: Oceanside
Karma: 6
Senior Member
remove from buddy list
ignore all messages by this user
Frank,

We spoke last year about me migrating our phpBB2/mail2forum forum to FUDforum, and you were very helpful. Now I'm finally ready to give it a shot and I'm very glad to see that you're on the job!

I am still running php 5.2.17 because phpBB2 can't run any higher than that. I will be able to upgrade PHP once I migrate this forum to FUDforum.

Here's the doozy: It's a large forum with 10K users and 250K messages.

I downloaded the latest MigrationAssistant.zip, unzipped it into the directory and ran:
php convert.php phpBB2 ../phpBB2

Everything seemed to work fine until it started importing messages, at which point it gave a segmentation fault. When I google about php and seg faults, the suggestion seems to be to upgrade PHP.

Suggestions? TIA for any help.

Other config values in case you're curious:
cPanel Version 11.36.1 (build 5)
Apache version 2.2.23
PHP version 5.2.17
MySQL version 5.0.96-community
Architecture x86_64
Operating system linux
Kernel version 2.6.18-194.32.1.el5
cPanel Pro 1.0 (RC1)

I tried copying the database to another host with a more recent PHP version. (phpBB2 won't work over there, but I can access the database.) Now when I try to do the import I get an error right away during the user import:

?343 ?1366516804?(/home/<user>/FUDforum/include/theme/default/db.inc:104<br />
/home/<user>/public_html/ff/convert.php:328<br />
/home/<user>/public_html/ff/conversionmaps/phpBB2.map:108<br />
/home/<user>/public_html/ff/convert.php:818<br />
) 1062: Duplicate entry '' for key 'fud30_users_i_a'<br />
Query: <br />
Database version: 5.5.30-cll<br />

[Updated on: Sun, 21 April 2013 00:06]

Report message to a moderator

Re: phpBB2 to FUDforum converter [message #168370 is a reply to message #166115] Tue, 23 April 2013 22:23 Go to previous messageGo to next message
cpreston is currently offline  cpreston   United States
Messages: 160
Registered: June 2012
Location: Oceanside
Karma: 6
Senior Member
remove from buddy list
ignore all messages by this user
I am getting nowhere and am spinning my wheels. I have now tried putting the database on a 5.3 site, because some of my apps don't run on 5.4 yet.

Now this is what happens when I run the import script

$ php convert.php phpBB2 ../phpBB2
phpBB2 to FUDforum conversion
Read phpBB2's config...
... reading config file ../phpBB2/config.php
... reading config file ../phpBB2/includes/constants.php
Connecting to phpBB2's database...
... connected to mysql4 database <username>@<database>
Import avatars...
...Skip invalid avatar [index.htm]
Import smilies...
Import users...
Import categories...
Import forums...
Import topics...
Import messages...
PHP Warning:  strpos(): Offset not contained in string in /home/<username>/FUDforum/include/theme/default/post_proc.inc on line 447

Warning: strpos(): Offset not contained in string in /home/<username>/FUDforum/include/theme/default/post_proc.inc on line 447
PHP Notice:  Uninitialized string offset: 1240 in /home/<username>/FUDforum/include/theme/default/post_proc.inc on line 431

Notice: Uninitialized string offset: 1240 in /home/<username>/FUDforum/include/theme/default/post_proc.inc on line 431
PHP Notice:  Uninitialized string offset: 2621 in /home/<username>/FUDforum/include/theme/default/post_proc.inc on line 431

.... a whole bunch more like that....

Import attachments...
Import polls...
SQL statement: SELECT vd.*, p.forum_id, p.post_id, p.poster_id FROM <username>_site.phpbb_vote_desc vd INNER JOIN <username>_site.phpbb_topics t ON t.topic_id=vd.topic_id INNER JOIN <username>_site.phpbb_posts p ON p.post_id=t.topic_first_post_id
MySQL error: MySQL server has gone away


When I'm done, I do see a bunch of users, but I see no forums or posts.
Re: phpBB2 to FUDforum converter [message #168374 is a reply to message #168370] Wed, 24 April 2013 02:35 Go to previous messageGo to next message
naudefj is currently offline  naudefj   
Messages: 3768
Registered: December 2004
Karma: 27
Senior Member
Administrator
Core Developer
remove from buddy list
ignore all messages by this user
The "MySQL server has gone away" error is an indication that your server/ database is probably overloaded and cannot process the request. This is, unfortunately, not a FUDforum problem and we cannot help you with it.

Tip: To see the messages, you need run the consistency checker.
Re: phpBB2 to FUDforum converter [message #168379 is a reply to message #168374] Wed, 24 April 2013 20:04 Go to previous messageGo to next message
cpreston is currently offline  cpreston   United States
Messages: 160
Registered: June 2012
Location: Oceanside
Karma: 6
Senior Member
remove from buddy list
ignore all messages by this user
Alright, moving it to a beefier box got rid of that error. I still have the others, and I think I know what's causing them. I decided to start a different thread because the errors are specific to mail2forum.
Re: phpBB2 to FUDforum converter [message #168644 is a reply to message #168379] Sun, 16 June 2013 13:17 Go to previous messageGo to next message
cpreston is currently offline  cpreston   United States
Messages: 160
Registered: June 2012
Location: Oceanside
Karma: 6
Senior Member
remove from buddy list
ignore all messages by this user
I'm continuing to work on this, and I'm oh so close. It's importing 99% of the messages, but 1% are silently failing. So I have a few questions:

- Any idea why a small portion of the messages would not import?
- What happens if I run the import again? Does it look to see which messages are/aren't imported and import the ones that arent?
- I ask the above question in hopes that I could figure out which messages aren't working, fix them somehow, then rerun the script so they import properly.
Re: phpBB2 to FUDforum converter [message #168674 is a reply to message #168644] Thu, 27 June 2013 12:25 Go to previous messageGo to next message
naudefj is currently offline  naudefj   
Messages: 3768
Registered: December 2004
Karma: 27
Senior Member
Administrator
Core Developer
remove from buddy list
ignore all messages by this user
> Any idea why a small portion of the messages would not import?

Maybe they are all there. I wouldn't necessarily trust phpBB2's counts.

> What happens if I run the import again? Does it look to see which messages are/aren't imported and import the ones that aren't?

It will erase all messages and restart the conversion process. The idea is to go through a couple of iterations until you are happy with the result.
Re: phpBB2 to FUDforum converter [message #168718 is a reply to message #168674] Thu, 04 July 2013 22:09 Go to previous messageGo to next message
cpreston is currently offline  cpreston   United States
Messages: 160
Registered: June 2012
Location: Oceanside
Karma: 6
Senior Member
remove from buddy list
ignore all messages by this user
There are definitely messages that didn't import. Multiple attempts continue to leave the same messages out. What should my next step be? I need to sort this out before I go live, of course.
Re: phpBB2 to FUDforum converter [message #168721 is a reply to message #168718] Fri, 05 July 2013 01:50 Go to previous messageGo to next message
naudefj is currently offline  naudefj   
Messages: 3768
Registered: December 2004
Karma: 27
Senior Member
Administrator
Core Developer
remove from buddy list
ignore all messages by this user
Should be easy to fix, but I need to get hold of one or more of those messages (in raw format from the DB) to setup a test case.
Re: phpBB2 to FUDforum converter [message #168791 is a reply to message #168721] Thu, 25 July 2013 13:05 Go to previous messageGo to next message
cpreston is currently offline  cpreston   United States
Messages: 160
Registered: June 2012
Location: Oceanside
Karma: 6
Senior Member
remove from buddy list
ignore all messages by this user
I had my team look at it. The messages that don't import appear to be messages in phpBB that don't have an associated thread. I'm not sure how those messages got created in the first place, or how you even have a message that isn't attached to a thread, but the mystery appears to be solved!
Re: phpBB2 to FUDforum converter [message #168802 is a reply to message #168791] Fri, 26 July 2013 13:56 Go to previous messageGo to next message
naudefj is currently offline  naudefj   
Messages: 3768
Registered: December 2004
Karma: 27
Senior Member
Administrator
Core Developer
remove from buddy list
ignore all messages by this user
Good to know, thanks.

It should be relatively easy to import them under an "orphaned messages" thread.
Re: phpBB2 to FUDforum converter [message #168829 is a reply to message #168802] Sun, 28 July 2013 00:02 Go to previous messageGo to next message
cpreston is currently offline  cpreston   United States
Messages: 160
Registered: June 2012
Location: Oceanside
Karma: 6
Senior Member
remove from buddy list
ignore all messages by this user
Unless you tell me it's really easy for you to make that happen, I think I'm just going to let it go. I just wanted an explanation. Not sure what the value would be of messages that got put into an orphaned messages thread.
Re: phpBB2 to FUDforum converter [message #183071 is a reply to message #168343] Mon, 07 October 2013 01:33 Go to previous messageGo to next message
cpreston is currently offline  cpreston   United States
Messages: 160
Registered: June 2012
Location: Oceanside
Karma: 6
Senior Member
remove from buddy list
ignore all messages by this user
I was running php 5.4.20 and was getting these errors again. I downreved to the next lowest version (5.3.27) and the import worked. However, that's weird that it wouldn't run with the current non-experimental PHP version. 5.3.27 is deprecated according to cpanel.
Re: phpBB2 to FUDforum converter [message #183077 is a reply to message #183071] Mon, 07 October 2013 05:23 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3768
Registered: December 2004
Karma: 27
Senior Member
Administrator
Core Developer
remove from buddy list
ignore all messages by this user
Are you referring to the "MySQL server has gone away" errors? This normally indicates a database issue that we don't have any control over.

What MySQL Driver are you using? Try to pick "MySQL Improved" when installing the forum. BTW, in 3.0.5 the installer won't allow you to pick the deprecated "MySQL" driver any longer.
Re: phpBB2 to FUDforum converter [message #183079 is a reply to message #183077] Mon, 07 October 2013 10:50 Go to previous messageGo to next message
cpreston is currently offline  cpreston   United States
Messages: 160
Registered: June 2012
Location: Oceanside
Karma: 6
Senior Member
remove from buddy list
ignore all messages by this user
I'm referring to the "duplicate entry for key" errors. I am using mysqli.
Re: phpBB2 to FUDforum converter [message #183101 is a reply to message #183079] Tue, 08 October 2013 15:50 Go to previous messageGo to next message
naudefj is currently offline  naudefj   
Messages: 3768
Registered: December 2004
Karma: 27
Senior Member
Administrator
Core Developer
remove from buddy list
ignore all messages by this user
Maybe start by getting the latest converter scripts from https://sourceforge.net/projects/fudforum/files/
Re: phpBB2 to FUDforum converter [message #183102 is a reply to message #183101] Tue, 08 October 2013 16:25 Go to previous message
cpreston is currently offline  cpreston   United States
Messages: 160
Registered: June 2012
Location: Oceanside
Karma: 6
Senior Member
remove from buddy list
ignore all messages by this user
I did download them and use them.
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: Converting phpBB2 w/mail2forum posts
Next Topic: Xenforo converter
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Oct 18 12:44:08 EDT 2021

Total time taken to generate the page: 0.01136 seconds