SMF Support > vBulletin

[SMF Converter] vBulletin 3.5

<< < (13/13)

Red G. Brown:
Anything new on this?

buckers_wv:
Just managed to successfully convert a vBulletin 3.5.4 forum into SMF 1.1, however I had to modify the "vbulletin35_to_smf.sql" script in order for the conversion process to complete.

Towards the end, I encountered the following error:

>>>>>>>>>>
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 `truforum_vb`.pm AS pm
    WHERE pm.folderid != '-1'
    LIMIT 0, 500;

Caused the error:

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

In order to get the script to complete, I modified the SQL from line 200 (The section saying "Converting personal messages (step 2)...") from this:


TRUNCATE {$to_prefix}pm_recipients;

---* {$to_prefix}pm_recipients
SELECT
   pm.pmid AS ID_PM, pm.touserid AS ID_MEMBER, pm.readtime != 0 AS is_read,
   '-1' AS labels
FROM {$from_prefix}pm AS pm
WHERE pm.folderid != '-1';
---*

to this:

TRUNCATE {$to_prefix}pm_recipients;

---* {$to_prefix}pm_recipients
SELECT
   pm.pmid AS ID_PM, pm.userid AS ID_MEMBER,
   '-1' AS labels
FROM {$from_prefix}pm AS pm
WHERE pm.folderid != '-1';
---*



The script then completed, and my converted forum works perfectly.

N. N.:
Thank you for the information. Yes, it seems there were some changes in vbulletin around that version (3.5.something), though I am not certain when  exactly it happened.

Navigation

[0] Message Index

[*] Previous page