3.5.4 vB to SMF 1.1.9 Problems

[cecilbergwin]

Hello Folks, would be of great help if anybody could input on this one.

Trying convert 3.5.4 to SMF 1.1.9 and im getting the below errors, I have over 10,000 members and plenty of posts what are in th DB and I'm dearly hoping that I can get this imported/converted.


Many Thx in advance.

****ERROR HERE****

Converting...
Converting personal messages (step 2)... Unsuccessful!
This query:

    SELECT
    pm.pmid AS ID_PM, pm.touserid AS ID_MEMBER, pm.readtime != 0 AS is_read,
    '-1' AS labels
    FROM `dbnamehere`.vb3pm AS pm
    WHERE pm.folderid != '-1'
    LIMIT 0, 500;

Caused the error:

    Unknown column 'pm.touserid' in 'field list'

**** END OF ERROR ****

Regards
Cecil

[cecilbergwin]

++Update.

Just reading around the forums and I see somebody saying try using the 3.6 vB convertor on my 3.5, so I tried it (I've got backups) and this is now the error im getting.

Converting personal messages (step 2)... Unsuccessful!
This query:

    SELECT
    pm.pmid AS ID_PM, pm.userid AS ID_MEMBER, pm.messageread != 0 AS is_read,
    '-1' AS labels
    FROM `dbnamednbame`.vb3pm
    LIMIT 0, 500;

Caused the error:

    Unknown column 'pm.pmid' in 'field list'

Any helps appreciated.

[ThorstenE]

looks like the table layout is different or you used the wrong converter file:
This one is for vBulletin 3.5:
http://www.simplemachines.org/community/index.php?topic=216076.0
If this file caused errors you can also test it with the 3.6 version:
http://www.simplemachines.org/community/index.php?topic=152837.0