Topic: 2.0.0 to SMF: Converting members...Wrong value type sent to the database.

[LeYoyo]

Hi all,

I'm trying to convert from IPB 2.0.0 trial to the latest SMF.

I have downloaded and installed the latest conversion tool.

By running it, I had first the "birthday" error. Fixed by adding a solution found here

                     if(!preg_match('/\d{4}-\d{2}-\d{2}/', $row['birthdate']))
                        $row['birthdate'] = '0001-01-01';


Now I have another issue: Converting members...Wrong value type sent to the database. Integer expected. (instant_messages)

Any advice about this one ?

Thanks in advance

[margarett]

Which converter are you using?

[LeYoyo]

Invision 2 to SMF 2-0

[margarett]

Of course Did you get it from the downloads page or one of the sticky topics in this board?

[LeYoyo]

From the download page : http://download.simplemachines.org/?converters;software=invision

[margarett]

Thanks I needed to know which file to pick.

That issue is caused by your original database (IPB) has something other than in integer in that column (most likely a NULL). So we have to tell the converter to make all those rows in integers.
Open the .sql file and find:

Code: [Select]

$row['signature'] = substr(strtr(strtr($row['signature'], '<>', '[]'), array('[br /]' => '<br />')), 0, 65534);Add after:

Code: [Select]

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

[LeYoyo]

Added here:

Code: [Select]

), ltrim($row['signature'])));
$row['signature'] = substr(strtr(strtr($row['signature'], '<>', '[]'), array('[br /]' => '<br />')), 0, 65534);
$row['instant_messages'] = (int)$row['instant_messages'];

Same error   Converting members...Wrong value type sent to the database. Integer expected. (instant_messages)

[LeYoyo]

Just wondering about one point : do I use the right converter ?

[margarett]

It seems you are, if you downloaded the latest version from the downloads page

I forgot this issue, sorry. But I can't really understand why you're still having that error

[LeYoyo]

Is there any way to drop the IPB instant message values ?
It's a workaround, but at least, after migration I could inform the members that they have to refill these informations.

[margarett]

Maybe the sense is different here. What values do you have in IPB's table in the corresponding field?

[LeYoyo]

Humm, strange... I couldn't find an instant_message field in the member tables...

In the ibf_member_extra table I have:

aim_name = varchar(40)
icq = int(15)
yahoo = varchar(40)
msn = varchar(200)
skype = varchar(250)

[Oldiesmann]

"instant_messages" is the name of the column in SMF. It should be called "msg_total" in the IPB database.

[LeYoyo]

OK, sorry ^^

msg_total     smallint(5)

[margarett]

Give your IPB table a look, check for non-integer values in that column

[LeYoyo]

I did a double check, but can't find something else as integers (from 0 to 403) or NULL value

[margarett]

Hummmm how odd...

Check the latest row that was added to SMF members table, get his id, then go to IPB members table and check what the next id has in msg_total, please

[LeYoyo]

No row were added to the SMF members DB

[margarett]

Hu, right on the first row? Damn... And what value has your first row in IPB's table?

[LeYoyo]

1100