Error convert from vBulletin 3.5 RC3 to SMF 1.1RC1

[MaT76]

Hi,

I try to convert a forum under vBulletin 3.5 RC3 to SMF 1.1RC1 and i got this error when i try to convert :

The error MySQL gave was: Table '.user' doesn't exist

I check the vBulletin database, and the table user exist. I use mysql server root acount to be sur to have all rights for converting.

In charter members forum they say that it's because vBulletin database structur as changed, and converters v1.1 don't works for it. I insist because i must convert this database before next monday for a customer.

Many thanks in advance for help.

[Oldiesmann]

If you can give me a copy of the table structure for that version of vB (no data, just the table structure), I'll double-check everything and make any changes that are needed.

[MaT76]

If you can give me a copy of the table structure for that version of vB (no data, just the table structure), I'll double-check everything and make any changes that are needed.

I send it to you by mail.

[Oldiesmann]

Ok... It appears the problem is here:

Code Select Expand

---~ from_prefix: "`$dbname`.$tableprefix"

It's not picking up the db name in vBulletin's config file (or it's not being used because it's the same as your SMF database), and since you don't have a table prefix, it's setting the prefix to "."...

Change the line to this:

Code Select Expand

---~ from_prefix: "$tableprefix"

[MaT76]

Ok, many thanks for the help, i will try this. I will post here the résult

[MaT76]

No i have this error :

Sorry, the database connection information used in the specified installation of SMF cannot access the installation of vBulletin 3. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.

The error MySQL gave was: No Database Selected

All paths are good :/

[MaT76]

No idea ?

[Oldiesmann]

Try changing that line (again) to this:

Code Select Expand

---~ from_prefix: "`$dbname`";

That should fix your problem.

[MaT76]

I don't understand what happen, i upload the .sql original file and now convert works !?

I will post here the results.

[MaT76]

I have a little error again but it's sucessfull Here is the result :


Converting...
Converting posts (this may take some time)... Successful.
Converting polls...Successful.
Converting poll options...Successful.
Converting poll votes...Successful.
Converting personal messages (step 1)...Successful.
Converting personal messages (step 2)...Successful.
Converting topic notifications...Successful.
Converting board notifications...Successful.
Converting smileys...Successful.
Converting attachments...Successful.
Converting avatars... Unsuccessful!
This query:

    SELECT ca.userid AS ID_MEMBER, ca.avatardata, ca.filename, u.avatarrevision
    FROM `easihostfvei`.customavatar AS ca, `easihostfvei`.user AS u
    WHERE u.userid = ca.userid
    LIMIT 0, 500;

Caused the error:

    Unknown column 'ca.avatardata' in 'field list'

Do you know how to fix this ?

[MaT76]

I have another problème, all topic are under Salvaged Topics
Topics created for messages with non-existent topics

Do you know how can fix that ?

[Deimos]

I have another problème, all topic are under Salvaged Topics
Topics created for messages with non-existent topics

Do you know how can fix that ?

My advice.....go into the admin panel, then maintenance and try the "Find and repair any errors"

[MaT76]

It was the first thing that i do and that change nothing.

[Oldiesmann]

Those are all messages that didn't have a valid ID_TOPIC (ie there was no topic with that particular ID_TOPIC). You can do what you want with those.

The "avatardata" thing means that it can't find a column called avatardata in the specified table.

[MaT76]

Those are all messages that didn't have a valid ID_TOPIC (ie there was no topic with that particular ID_TOPIC). You can do what you want with those.

In fact, in Salvaged Topics i have all of my subforums, and under subforums, i have all topics (They are in the good Subforum) So i don't know why it push all my subforum under Salvaged Topics instead the good Topics (that are well imported, but empty)

The "avatardata" thing means that it can't find a column called avatardata in the specified table.

I do a search in phpmyadmin, and avatardata exist in the table vbfields
There is a solution to fix that ?

ps: Many many thanks for all your help, i am very grateful

[d3v]

same issue.

The installation of SMF in the path you specified is not a version this converter can deal with. If it is older than SMF 1.0, you need to upgrade first. If it is newer, you need to use a different converter.

Used the one off the Downloads page.

[Oldiesmann]

The one off the downloads page only works with SMF 1.0.5... You need the one in the "1.1 Converters" topic if you want to convert to 1.1.