The database value you're trying to insert does not exist: from_name

[zaandammer]

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 Expand

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!

[Norv]

Please find in phpbb3_to_smf.sql file:

Code (find) Select Expand


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


Code (replace) Select Expand


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


[zaandammer]

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.

[Norv]

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.