News:

Wondering if this will always be free?  See why free is better.

Main Menu

Problem when convert vbulletin to smf

Started by dsb_spain, April 09, 2010, 06:05:15 PM

Previous topic - Next topic

dsb_spain

Hi !

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

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:


Password security has recently been upgraded. Please enter your password again


I hope you can help!

Greetings and thanks to all

Norv

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

dsb_spain

Hi !

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

Bye & Thanks!!

dsb_spain


Norv

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

dsb_spain

Hi !

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

Thanks to all members help me


laogui

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.

taotoon

#7
Quote from: laogui on June 11, 2010, 05:24:32 AM
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:

taotoon

If I use this code


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


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.

Norv

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

taotoon

#10
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.

laogui

I tried many times, cannot convert attachments.

Antes

Quote from: laogui on July 04, 2010, 03:01:48 AM
I tried many times, cannot convert attachments.

there is a bug, you need to wait :/

InternetMafia

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.

Antes

Quote from: InternetMafia 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

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 )

InternetMafia

Its better to be dead and cool than alive and uncool.

Advertisement: