Advertisement:

Author Topic: Problem when convert vbulletin to smf  (Read 11146 times)

Offline dsb_spain

  • Semi-Newbie
  • *
  • Posts: 46
  • Gender: Male
    • Foros Hispanos
Problem when convert vbulletin to smf
« on: April 09, 2010, 06:05:15 PM »
Hi !

when trying to convert, I get almost everything right except that I get this:

Code: [Select]
Converting attachments... Unsuccessful!
This query:

    SELECT
    postid AS id_msg, counter AS downloads, filename, filedata, userid,
    attachmentid
    FROM `foroayuda`.vb_attachment
    LIMIT 0, 500;

Caused the error:

    Unknown column 'postid' in 'field list'

also trying loguearme in smf forum I get this:

Code: [Select]
Password security has recently been upgraded. Please enter your password again
I hope you can help!

Greetings and thanks to all

Offline Norv

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,313
  • Blue Wolf
Re: Problem when convert vbulletin to smf
« Reply #1 on: April 10, 2010, 04:46:37 PM »
Hello there!
Can you please tell, what exact version of vbulletin did you have? What version of SMF did you convert to?
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 dsb_spain

  • Semi-Newbie
  • *
  • Posts: 46
  • Gender: Male
    • Foros Hispanos
Re: Problem when convert vbulletin to smf
« Reply #2 on: April 10, 2010, 06:59:17 PM »
Hi !

The version of vBulletin is 4.0.1 and the SMf is 2.0 RC3

Bye & Thanks!!

Offline dsb_spain

  • Semi-Newbie
  • *
  • Posts: 46
  • Gender: Male
    • Foros Hispanos
Re: Problem when convert vbulletin to smf
« Reply #3 on: April 11, 2010, 08:57:06 AM »
BUMP

Offline Norv

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,313
  • Blue Wolf
Re: Problem when convert vbulletin to smf
« Reply #4 on: April 11, 2010, 03:02:13 PM »
Please try (in the vbulletin 3.7 to smf sql file):
Code: (find) [Select]
SELECT
postid AS id_msg, counter AS downloads, filename, filedata, userid,
attachmentid
FROM {$from_prefix}attachment;
Code: (replace) [Select]
SELECT
IFNULL(c.postid, 0) AS id_msg, a.counter AS downloads, a.filename, f.filedata, a.userid,
a.attachmentid
FROM {$from_prefix}attachment AS a, {$from_prefix}cms_article AS c, {$from_prefix}filedata AS f
WHERE a.contentid = c.contentid AND a.filedataid = f.filedataid;

I'm not sure it will work, there is a real problem with attachments from vbulletin 4, due to some changes in their database structure that I didn't fully get yet.
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 dsb_spain

  • Semi-Newbie
  • *
  • Posts: 46
  • Gender: Male
    • Foros Hispanos
Re: Problem when convert vbulletin to smf
« Reply #5 on: April 12, 2010, 12:41:11 PM »
Hi !

Thanks !! Thanks Thanks Thank you very much!! the conversion is complete !! ALELUYA!! :D

Thanks to all members help me


Offline laogui

  • Newbie
  • *
  • Posts: 9
Re: Problem when convert vbulletin to smf
« Reply #6 on: June 11, 2010, 05:24:32 AM »
I meet the same error, I modified the SQL file get the following error:

Table 'laogui_ch.cms_article' doesn't exist


My forum is vb4.0.3,but i have no installation CMS.

Offline taotoon

  • Newbie
  • *
  • Posts: 6
Re: Problem when convert vbulletin to smf
« Reply #7 on: June 16, 2010, 01:52:48 PM »
I meet the same error, I modified the SQL file get the following error:
Table 'xxxx.cms_article' doesn't exist

My forum is vb4.0.3,but i have no installation CMS.

I faced the same problem.  I don't have CMS.
See my v4.0.2 databases below:
« Last Edit: June 19, 2010, 11:11:29 AM by taotoon »

Offline taotoon

  • Newbie
  • *
  • Posts: 6
Re: Problem when convert vbulletin to smf
« Reply #8 on: June 16, 2010, 02:29:50 PM »
If I use this code

Code: [Select]
SELECT
   IFNULL(c.postid, 0) AS id_msg, a.counter AS downloads, a.filename, f.filedata, a.userid,
   a.attachmentid
FROM {$from_prefix}attachment AS a, {$from_prefix}post AS c, {$from_prefix}filedata AS f

I got errors

Code: [Select]
Converting attachments... Error in convert script - line 492!
Error in convert script - line 495!
Successful.
Converting avatars...Error in convert script - line 498!
Error in convert script - line 499!
Successful.
Recalculating forum statistics... Successful.

Offline Norv

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,313
  • Blue Wolf
Re: Problem when convert vbulletin to smf
« Reply #9 on: June 19, 2010, 07:20:08 AM »
Can you please make sure you replace exactly the code above with the one to replace?
You seem to be missing an extra line, and also note that the lines should be replaced, not added.
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 taotoon

  • Newbie
  • *
  • Posts: 6
Re: Problem when convert vbulletin to smf
« Reply #10 on: June 19, 2010, 11:14:59 AM »
Yes, the vb 4.0.x no CMS version doesn't have vb1cms_article table. I tried to modify by myself but didn't success.

Please modify code for 4.0.x  no CMS version.  If you want to know the structure of databases, please tell me how to list.
« Last Edit: June 19, 2010, 11:22:12 AM by taotoon »

Offline laogui

  • Newbie
  • *
  • Posts: 9
Re: Problem when convert vbulletin to smf
« Reply #11 on: July 04, 2010, 03:01:48 AM »
I tried many times, cannot convert attachments.

Offline Antes

  • Evil Black Cat
  • SMF Friend
  • SMF Hero
  • *
  • Posts: 8,943
  • Gender: Male
  • Black cat rulz!
    • Antes on GitHub
    • merta on LinkedIn
    • @XinYenFon on Twitter
    • WoWSnips
Re: Problem when convert vbulletin to smf
« Reply #12 on: July 04, 2010, 05:16:31 AM »
I tried many times, cannot convert attachments.

there is a bug, you need to wait :/
You can support me directly via Patreon

In Catnip We Trust.
The solution is Catnip!
Vote for Catnip!

Current Project(s): [ WoWSnips ]
Past Project(s): [ ezPortal ] # [ Lunarfall ] # [ RDD (HTML5) ]

Offline InternetMafia

  • Jr. Member
  • **
  • Posts: 100
  • Gender: Male
    • Deviant-Mafia
Re: Problem when convert vbulletin to smf
« Reply #13 on: July 25, 2010, 11:20:36 PM »
Have we gotten anywhere with fixing attachments with the conversion.


I would be happy to supply a database or something to help along the process
Its better to be dead and cool than alive and uncool.

Offline Antes

  • Evil Black Cat
  • SMF Friend
  • SMF Hero
  • *
  • Posts: 8,943
  • Gender: Male
  • Black cat rulz!
    • Antes on GitHub
    • merta on LinkedIn
    • @XinYenFon on Twitter
    • WoWSnips
Re: Problem when convert vbulletin to smf
« Reply #14 on: July 26, 2010, 08:30:32 AM »
Have we gotten anywhere with fixing attachments with the conversion.

I would be happy to supply a database or something to help along the process

i already sent a db to Norv but he's now Developer, he cant look converters anymore ( out-of-time ), i think you need to wait more :) I think he open a topic about this ( when attachment problem solved with vB4 to SMF )
You can support me directly via Patreon

In Catnip We Trust.
The solution is Catnip!
Vote for Catnip!

Current Project(s): [ WoWSnips ]
Past Project(s): [ ezPortal ] # [ Lunarfall ] # [ RDD (HTML5) ]

Offline InternetMafia

  • Jr. Member
  • **
  • Posts: 100
  • Gender: Male
    • Deviant-Mafia
Re: Problem when convert vbulletin to smf
« Reply #15 on: July 28, 2010, 10:56:41 PM »
Ehhh, I hate waiting. :P
Its better to be dead and cool than alive and uncool.