Converter fields question

[sashap13]

Ok, fixed the above, now getting:

Wrong value type sent to the database. Integer expected. (modified_time)
Please help. I've had 4 other errors prior to this and I am now pulling out my hair.

[margarett]

Did you get the converter from the downloads page? What version from your previous software are you converting from?

I'm sorry, the conversion is rarely a straightforward process

[mrjamin]

I'm also getting the error trying to convert Snitz to SMF:

Converting members... Unsuccessful!
This query:
CREATE TABLE IF NOT EXISTS `SMFDB`.smf_convert (
old_id_topic int(10) unsigned NULL default '0',
old_id_msg int(10) unsigned NULL default '0',
msg_date bigint(20) unsigned NULL default '0',
type varchar(80) NOT NULL default ''
) TYPE=MyISAM;
Caused the error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 6

This is using the converter 2.0 downloaded from this site.  Snitz is version 3.4.06 and SMF is 2.0.7.

Any suggestions would be greatly appreciated 

[margarett]

Uh, that's wrong...

So, you need to replace TYPE= with ENGINE=

I'll try to check if I can find it for you

[mrjamin]

Thanks Margarett.

I've made that change in the .sql file and got a little further.  The next blocker seems to be around the date format for the member date of birth:

"Converting members...Wrong value type sent to the database. Date expected. (birthdate)"

Looking at MySQL the data type for M_DOB in Snitz seems to be set to varchar rather than date or datetime, so not sure if that might be the cause.  I'm not really a SQL guru so not sure about how to correct it.

[margarett]

Can you post an example of a birthday from your  database?

[mrjamin]

The field is empty as this option is tuned off in the Snitz configuration.

[margarett]

Empty, like, NULL? Or is it an empty text field?

edit: just remove this:

Code Select Expand


M_DOB AS birthdate,

From the .sql file

[mrjamin]

I think it's NULL. 

I've removed that bit of the SQL, but it appears that there are further issues with the data types:

"Converting members...Wrong value type sent to the database. Integer expected. (hide_email)"

Removing the hide_email bit of the SQL and we get a bit further, but the next failure is on the table names.  I think this is just a capitalisation issue though.  Snitz creates tables names all in caps, but the SQL has them in lower-case. So this one breaks it too:

TOPIC_ID AS old_id_topic
FROM {$from_prefix}forum_reply

Updating that to FORUM_REPLY gets us back to more data type issues :-(

"Preparing Conversion (part 1)...Wrong value type sent to the database. Integer expected. (msg_date)"