I am trying to convert my Snitz 3.4.05 on MySQL to SMF. The converter script returns the following:
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting posts (this may take some time)...
Parse error: parse error, expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING' in C:\inetpub\mydomainname\forums\convert.php(827) : eval()'d code on line 6
The Parse error is repeated several dozen times, then it says:
INSERT INTO `mydbname`.smf_messages
(ID_TOPIC, ID_BOARD, subject, TposterTime, TID_MEMBER, TposterIP, TposterName, Tbody, TposterEmail, TmodifiedName, TmodifiedTime, RposterTime, RID_MEMBER, RposterIP, RposterName, Rbody, RposterEmail, RmodifiedName, RmodifiedTime)
VALUES ('2', '2', 'The post title', '1111288703', '1', '22.214.171.124', 'MemberName', 'Welcome to the blah blah blah<br />', 'firstname.lastname@example.org
', '', '', '', '', '', '', '', '', '', ''),
Then the VALUES block is repeated several dozen times for the various posts, then:
Caused the error:
Unknown column 'TposterTime' in 'field list'
It appears to me that virtually all of the field names are incorrect, each with a T or R tacked on the front. I assume that is related to the Snitz forum using separate Topic and Reply tables, but I don't understand what the converter is doing stacking them together like this.
I'm stuck. Can anyone tell me what is going on here?