Converting phpbb2 to smf 2.0.7

[jwoicik]

I've been trying to convert my old phpbb2 board to my new SMF install and I can't get past the following error:

Converting topics...Wrong value type sent to the database. Integer expected. (id_member_updated)

I've gone into the topics table in my phpbb database via phpmyadmin to try to figure out what the converter is looking for but I can't seem to find anything, though that is probably due to my very limited knowledge of sql databases or php. I'd appreciate any help!

[margarett]

That happens because the converter gets something from phpBB's database that is not interpreted as an integer.

You can fix that by editing phpbb2_to_smf.sql like this:
Find:

Code Select Expand


---* {$to_prefix}topics
---{
$ignore = true;

Add after:

Code Select Expand

$row['id_member_updated'] = (int)$row['id_member_updated'];

[jwoicik]

Thank you! That is fixed but now this:

Converting posts (this may take some time)...The database value you're trying to insert does not exist: poster_name

[margarett]

Oh, that's different... I'll have a look