My forum is installed in the root of the server (www.uoforums.com)
I've installed SMF in the folder /smf (www.uoforums.com/smf)
When running the converter, both paths are correct
The database password is correct
Both forums are installed on the same database
Vbulletin doesn't have any prefixes in the database mind you.
These are the errors I get...
At the top of the page, it says
Notice: Undefined variable: dbname in /home/deimos/public_html/smf/vbulletin3_to_smf.php on line 125
Notice: Undefined variable: tableprefix in /home/deimos/public_html/smf/vbulletin3_to_smf.php on line 125
In the installer window, it says
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.
Any advice is appreciated
Sounds like it can't find vBulletin's config file.
Any recommendations? The config file is there (/includes/config.php)
Maybe it's because 'im running RC2?
If anyone can help, let me know
I want to get SMF up and running and sell my VB License if it works ok :)
Ok. It looks like the variables used for the database name and table prefix are different in that version of vB. Edit the config file and make sure it contains this information:
$dbname = '{database name}';
$tableprefix = '{database table prefix}';
I stuck those two lines at the top of the file and changed the '{database name}' to my databases name, but it still comes up with the two errors at the top of the forum
I assume that's what I was supposed to do? heh
It also says in the error below..
QuoteThe error MySQL gave was: No Database Selected
Got abit further tonight
It fails when converting the categories
Duplicate entry '255' for key 1
Fixed the int problem, going through the rest of the steps now...
Bah, now i'm getting
Duplicate entry '60572' for key 1
When converting the messages
60572 is ID_MSG in the smf_messages table, which was allready set to "INT"
Changing to BigInt had no effect
Any recommendations? hehe
Run this query on your vBulletin database:
ALTER TABLE {preifx}posts ADD UNIQUE INDEX(postid);
That will drop all the duplicate values in that table (replace {prefix} with whatever table prefix you used).
Thanks, im getting the same thing with the topics now
Duplicate entry '13001' for key 1
(ID_TOPIC, ID_BOARD, isSticky, ID_POLL, numViews, ID_MEMBER_STARTED, ID_MEMBER_UPDATED, numReplies, locked, ID_FIRST_MSG, ID_LAST_MSG)
VALUES ('13001', '846', '0', '0', '39', '1710', '1744', '13', '0', '98009', '98150'),
Thought i'd be creative and try doing the same for this one
So I ran
ALTER TABLE thread ADD UNIQUE INDEX(threadid);
But it's still doing it
I guess you'll have to manually delete the duplicate entry then.
Thing is, I did a manual scour through the database and there isn't any duplicate entries of that number
Infact, the number is only listed once on the actuall conversion process.
I deleted the one it complained about and it then said the next one was also a duplicate, but it isn't
QuoteINSERT INTO `deimos_uof`.smf_topics
(ID_TOPIC, ID_BOARD, isSticky, ID_POLL, numViews, ID_MEMBER_STARTED, ID_MEMBER_UPDATED, numReplies, locked, ID_FIRST_MSG, ID_LAST_MSG)
VALUES ('12950', '317', '0', '0', '40', '1362', '2391', '4', '0', '97327', '97371'),
('12951', '548', '0', '0', '16', '1710', '1710', '0', '0', '97335', '97335'),
('12952', '786', '0', '0', '32', '1908', '1931', '8', '0', '97341', '97692'),
('12953', '860', '0', '0', '63', '2391', '2558', '6', '1', '97343', '97381'),
('12956', '860', '0', '0', '19', '2391', '2391', '0', '1', '97382', '97382'),
('12957', '814', '0', '0', '61', '1947', '1871', '2', '0', '97401', '97518'),
Caused the error:
Duplicate entry '12950' for key 1
What do you get when you run this query on your SMF database?
SELECT * FROM smf_topics WHERE ID_TOPIC = '12950';
Hiya
It comes up with an entry
ID_TOPIC isSticky ID_BOARD ID_FIRST_MSG ID_LAST_MSG ID_MEMBER_STARTED ID_MEMBER_UPDATED ID_POLL numReplies numViews locked
12950 0 317 97327 97371 1362 2391 0 4 40 0
I deleted the entry and ran it again and it still stopped at the same point
So I double checked the vbulletin database and that topic number/entry only exists once
Me, i have this error : The error MySQL gave was: Table '.user' doesn't exist but i convert from vb3.5rc3 to SMF 1.1RC1
Any idea ?
Quote from: gritche on September 25, 2005, 04:40:18 PM
Me, i have this error : The error MySQL gave was: Table '.user' doesn't exist but i convert from vb3.5rc3 to SMF 1.1RC1
Any idea ?
It'd be polite to start your own support thread.
Sorry
Deimos - It apparently exists in two different places somewhere, or you wouldn't be getting that error... What do you get when you try this query?
SELECT COUNT(postid) FROM {prefix}posts WHERE postid = '12950';
gritche - there could be a number of reasons for that error... Start a new topic with more information (what you're converting from, what the database name and prefix variables are in the config file of the board you're converting from and the value of each) and we'll try to help you.
Saysssss
COUNT(postid)
0
That might've been because I deleted that paticular message/post
So, I ran the converter again and it's coming up withhhhh
INSERT INTO `deimos_uof`.smf_messages
(ID_MSG, ID_TOPIC, posterTime, ID_MEMBER, subject, posterName, posterIP, ID_BOARD, smileysEnabled, body)
VALUES ('64586', '9357', '1112879491', '0', 'Re: New Chessy forums on Stratics!', 'Ransom', '67.106.142.35', '806', '1', 'There is a lot of censorship there. You have to be careful of the forum nazis.'),
so I ran that query you gave me for the number 64586 and it says
COUNT(postid)
1
I really don't understand how you can be getting a duplicate key error when there's only one of each key... Unfortunately, the only way to get the converter to ignore those (that I know of anyway) is to run this query on your SMF database before you run the query again:
ALTER TABLE smf_messages DROP PRIMARY KEY, DROP INDEX 'topic', DROP INDEX 'ID_BOARD';
Then, if the converter runs successfully, run this query:
ALTER TABLE smf_messages ADD PRIMARY KEY('ID_MSG'), ADD UNIQUE topic (ID_TOPIC, ID_MSG), ADD UNIQUE ID_BOARD (ID_BOARD, ID_MSG);
Yea it is odd
Running that query threw up
SQL query:
ALTER TABLE smf_messages DROP PRIMARY KEY ,
DROP INDEX 'topic',
DROP INDEX 'ID_BOARD'
MySQL said:
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''topic', DROP INDEX 'ID_BOARD'' at line 1
Try this one:
ALTER TABLE smf_messages DROP PRIMARY KEY, DROP INDEX topic, DROP INDEX ID_BOARD (without the single quotes around the names).
Thanks, but it didn't work, it comes up with a similiar error
Duplicate entry '91056-580' for key 1
Nevermind, I give up with it.
I'll stick with VB :(
Deimos - I'm doing everything I can to help you. I have no idea why it's giving you duplicate entry errors all over the place. If you can email me a dump of your vB database (including all the data), I'll take a look and see if I can figure out what's causing all these errors.
I know you are, really I appreciate it, thanks
The VB Database isn't something I can send you however, it's .well, abit big, heh
It's something like 341mb.
Wow. That is big. Can you at least give me access to phpMyAdmin then? I won't mess anything up :)