Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » Converters » Converting phpBB2 w/mail2forum posts
Show: Today's Messages :: Unread Messages :: Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Return to the default flat view Create a new topic Submit Reply
Converting phpBB2 w/mail2forum posts [message #168378] Wed, 24 April 2013 20:03 Go to previous message
cpreston is currently offline  cpreston   United States
Messages: 160
Registered: June 2012
Location: Oceanside
Senior Member
add to buddy list
ignore all messages by this user
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.
[Message index]
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: JForum Conversion to FUDForum
Next Topic: phpBB2 to FUDforum converter
Goto Forum:

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

Current Time: Sun Aug 09 18:42:58 EDT 2020

Total time taken to generate the page: 0.00742 seconds