I am struggling with a conversion from SnitzForums to SMF. Walking my way thru, one error at a time but have been stopped by a date conversion issue.
I am using SMF 2.0.2, the latest conversion files that can be downloaded and I have corrected the caps issue in the conversion sql file.
The data starts as an MS Access database, which I convert to SQL using Bullzip. I then pull data from that for the conversion.
Snitz saves all dates as a text field, formatted as "yyyymmddhhmmss" As I understand it, SMF uses a Unix timestamp which is seconds since 1970, an integer.
As I work thru the errors, the first one I hit is M_DOB, the birthdate of forum members. We don't collect this data so it is strictly a field settings issue. In my SQL database, I set that to "DATE" and it appears the converter likes that, it runs to the next error.
The next error to pop is that an integer is expected for "msg_date" I went back to my original data and did a bunch of conversions to change the dates to the Unix timestamp and then tried again. It appears the conversion then runs a little further till it hits another error
With the dates converted (in Access, then SQL) the converter runs further, till it hits this error: Wrong value type sent to the database. Integer expected. (modified_time)
I find that data name in the snitz_to_smf.sql file but am a loss as to why this hiccup. I find two instances of that field name
- UNIX_TIMESTAMP(REPLACE(ft.T_LAST_EDIT, '\0', '')) AS modified_time FROM
- UNIX_TIMESTAMP(REPLACE(fr.R_LAST_EDIT, '\0', '')) AS modified_time FROM
In both cases, the data coming in is an integer although some of the fields are empty
I think the issue is "null" for the field. If I change this setting to "nothing" it then goes on to part 2 of the conversion process. At that point, I get this error:Converting posts ( part 2 - this may take some time)...
Notice: Undefined variable: result in -domain & path-/convert.php on line 2494
Notice: Undefined variable: result in -domain & path-/convert.php on line 2495
Warning: Supplied argument is not a valid resource handle in -domain & path-/convert.php on line 2736
Notice: Undefined index: db_fetch_assoc in -domain & path-/convert.php on line 2740
Fatal error: Function name must be a string in -domain & path-/convert.php on line 2740
Can anyone help me past this next stumbling block. Is what I've done already correct?