Thanks margarett. I've had a go at fixing one of the problems:
Converting posts...
The database value you're trying to insert does not exist: modified_nameI opened up phpMyAdmin and got the SQL out of the converter, to run manually.
SELECT
p.post_id AS id_msg, p.topic_id AS id_topic, p.forum_id AS id_board,
p.post_time AS poster_time, p.poster_id AS id_member, p.post_subject AS subject,
IFNULL(m.username, 'Guest') AS poster_name,
IFNULL(m.user_email, 'Unknown') AS poster_email,
IFNULL(p.poster_ip, '0.0.0.0') AS poster_ip,
p.enable_smilies AS smileys_enabled, p.post_edit_time AS modified_time,
CASE p.post_edit_user WHEN 0 THEN 'Guest' ELSE m2.username END AS modified_name,
p.post_text AS body
FROM phpbb_posts AS p
LEFT JOIN phpbb_users AS m ON (m.user_id = p.poster_id)
LEFT JOIN phpbb_users AS m2 ON (m2.user_id = p.post_edit_user)
ORDER BY modified_name -- added...
The query came up with 16 posts where "modified_name" was set to null and poster_name was set to guest with poster_email set to unknown.
So I think that could be the problem with that error. I've attached a photo of the result in phpMyAdmin (nothing massively sensitive in there... a few IPs...)
Does this take me 75% of the way? I wonder if you could give me a quick edit for the query above from the converter to handle the NULL entries please? I think I'm on the right track... maybe...
Thanks
Edit...Actually maybe after the three IFNULL lines, I have to put IFNULL(m2.username, 'Unknown') AS modified_name,
Just trying now... onto the next error, maybe!
Edit 2...No luck, still stuck... Feel like I'm near the solution though. Can you guys/girls give me a hand please?