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.
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.
Quote from: Oldiesmann on September 26, 2005, 09:11:28 AM
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.
Ok... It appears the problem is here:
---~ 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:
---~ from_prefix: "$tableprefix"
Ok, many thanks for the help, i will try this. I will post here the résult :)
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 :/
No idea ? :'(
Try changing that line (again) to this:
---~ from_prefix: "`$dbname`";
That should fix your problem.
I don't understand what happen, i upload the .sql original file and now convert works !?
I will post here the results.
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 ?
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 ?
Quote from: gritche on September 28, 2005, 12:39:28 PM
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"
It was the first thing that i do and that change nothing.
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.
Quote from: Oldiesmann on September 28, 2005, 02:02:03 PM
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)
Quote from: Oldiesmann on September 28, 2005, 02:02:03 PMThe "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
vbfieldsThere is a solution to fix that ?
ps: Many many thanks for all your help, i am very grateful :)
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.
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.