Text only | Text with Images

Simple Machines Community Forum

SMF Support => Converting to SMF => phpBB => Topic started by: zaandammer on May 03, 2010, 07:32:12 PM

Title: The database value you're trying to insert does not exist: from_name
Post by: zaandammer on May 03, 2010, 07:32:12 PM
Hi all! Trying to do a conversion from phpbb3.?? to RC2

Last week I did a test and conversion went well!
Now we want to converse the live forum but it's giving the following error over and over again.
Tried it several times, fresh install and all, cost me 18 hours today... :)

Code Select
Converting posts...
Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll votes... Successful.
Converting personal messages (step 1)...The database value you're trying to insert does not exist: from_name

Off course I have used the search function on this board but unfortunately without any (good) result. Help will be appreciated!
Title: Re: The database value you're trying to insert does not exist: from_name
Post by: Norv on May 06, 2010, 01:27:04 AM
Please find in phpbb3_to_smf.sql file:
Code (find) Select

SUBSTRING(uf.username, 1, 255) AS from_name,

Code (replace) Select

IFNULL(SUBSTRING(uf.username, 1, 255), "Guest") AS from_name,

Title: Re: The database value you're trying to insert does not exist: from_name
Post by: zaandammer on May 06, 2010, 01:06:35 PM
Thanks for your help but somehow after a trying to convert a couple of more time it all went well! Don't know why, maybe you can explain what was causing it?

Ronald.
Title: Re: The database value you're trying to insert does not exist: from_name
Post by: Norv on May 06, 2010, 01:15:33 PM
It seems that for some reason, some PM in your phpbb database didn't have the username of the sender associated with it. Perhaps meanwhile that unexpected PM was corrected or something. I don't know, because I don't know why a PM in phpbb would ever miss the username of its sender, normally all have a sender.
Text only | Text with Images