FUDforum: Converters » Converting phpBB2 w/mail2forum posts

Home » FUDforum Development » Converters » Converting phpBB2 w/mail2forum posts

Show: Today's Messages :: Polls :: Message Navigator

Converting phpBB2 w/mail2forum posts [message #168378]

Thu, 25 April 2013 00:03

cpreston

Messages: 160
Registered: July 2012
Location: Oceanside

Karma:

Senior Member

Problem 1:

I'm putting this into a separate thread because I believe I'm experiencing have to do with the fact that my board has been successfully running mail2forum for several years. When importing emails from "strangers" (those on a mailing list, but not subscribed to the board), we chose to have those messages imported as Anonymous, but with the username set to their full name from their email. The result is that the topics and messages are imported with the userID anonymous.

It appears that the convert.php script is not importing these messages. The number of messages in my forum after the conversion is roughly the number of messages that have real user ids associated with them (~24K). The number of messages missing is roughly the number that were created with the anonymous id.

Problem 2:
I get to the "import topic descriptions" section and I get the following:
Fatal error: SQL error has occurred!

If I look at the log, I see this message:

?419       ?1366847591?(/home/username/FUDforum/include/theme/default/db.inc:104<br />
/home/username/public_html/ff/convert.php:532<br />
/home/username/public_html/ff/conversionmaps/phpBB2.map:255<br />
/home/username/public_html/ff/convert.php:875<br />
) 1062: Duplicate entry '18738-94191' for key 'PRIMARY'<br />
Query: INSERT INTO fud30_thread_notify (user_id, thread_id) VALUES(18738, 94191)<br />
Database version: 5.1.68-cll<br />

And then it exits. I'm not sure what I'm missing out on here.

Question 1:

Is there any kind of table that is created that would show me old forumid/postid and new forum/postid? I'd like to build a 301 redirect script from my old board to my new one.

Report message to a moderator

[Message index]

		Converting phpBB2 w/mail2forum posts By: cpreston on Thu, 25 April 2013 00:03
		Re: Converting phpBB2 w/mail2forum posts By: cpreston on Thu, 25 April 2013 01:07
		Re: Converting phpBB2 w/mail2forum posts By: naudefj on Thu, 25 April 2013 07:12
		Re: Converting phpBB2 w/mail2forum posts By: cpreston on Thu, 25 April 2013 07:19
		Re: Converting phpBB2 w/mail2forum posts By: naudefj on Fri, 03 May 2013 17:04
		Re: Converting phpBB2 w/mail2forum posts By: cpreston on Sun, 12 May 2013 07:01
		Re: Converting phpBB2 w/mail2forum posts By: cpreston on Mon, 13 May 2013 03:45
		Re: Converting phpBB2 w/mail2forum posts By: cpreston on Mon, 13 May 2013 12:59

Previous Topic:	JForum Conversion to FUDForum
Next Topic:	phpBB2 to FUDforum converter

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 30 16:05:46 GMT 2024

Total time taken to generate the page: 0.04562 seconds