Print Page - Converting phpbb2 to smf 2.0.7

Title: Converting phpbb2 to smf 2.0.7
Post by: jwoicik on March 11, 2014, 10:30:20 PM

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!

Title: Re: Converting phpbb2 to smf 2.0.7
Post by: margarett on March 12, 2014, 03:45:42 PM

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


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

Add after:

Code Select

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

Title: Re: Converting phpbb2 to smf 2.0.7
Post by: jwoicik on March 12, 2014, 10:59:09 PM

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

Title: Re: Converting phpbb2 to smf 2.0.7
Post by: margarett on March 13, 2014, 04:03:27 AM

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

Simple Machines Community Forum

SMF Support => Converting to SMF => phpBB => Topic started by: jwoicik on March 11, 2014, 10:30:20 PM