News:

SMF 2.0.19 has been released! Please update. Read more.

Main Menu

[SMF Converter] vBulletin 3.5

Started by JayBachatero, January 11, 2008, 02:07:55 AM

Previous topic - Next topic

Red G. Brown


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.

Norv

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.
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

Doublejay

Getting this error. Any idea on how to fix it.

Converting...
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics...Wrong value type sent to the database. Integer expected. (id_member_updated)

Advertisement: