Advertisement:

Author Topic: [SMF Converter] vBulletin 3.5  (Read 117989 times)

Offline Red G. Brown

  • Jr. Member
  • **
  • Posts: 225
Re: [SMF Converter] vBulletin 3.5
« Reply #60 on: January 02, 2010, 06:41:45 PM »
Anything new on this?

Offline buckers_wv

  • Semi-Newbie
  • *
  • Posts: 33
    • OnePopz Music News
Re: [SMF Converter] vBulletin 3.5
« Reply #61 on: February 18, 2010, 10:40:54 AM »
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.

Offline Norv

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,313
  • Blue Wolf
Re: [SMF Converter] vBulletin 3.5
« Reply #62 on: March 18, 2010, 01:25:55 PM »
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

Offline Doublejay

  • Newbie
  • *
  • Posts: 1
Re: [SMF Converter] vBulletin 3.5
« Reply #63 on: July 27, 2013, 10:58:06 AM »
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)