News:

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

Main Menu

Problem trying to convert VB RC 2

Started by Deimos, September 23, 2005, 02:21:22 PM

Previous topic - Next topic

Deimos

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

Oldiesmann

Sounds like it can't find vBulletin's config file.
Michael Eshom
Christian Metal Fans

Deimos

Any recommendations? The config file is there (/includes/config.php)

Maybe it's because 'im running RC2?

Deimos

If anyone can help, let me know

I want to get SMF up and running and sell my VB License if it works ok :)

Oldiesmann

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}';
Michael Eshom
Christian Metal Fans

Deimos

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

Deimos

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

Deimos

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

Oldiesmann

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).
Michael Eshom
Christian Metal Fans

Deimos

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

Oldiesmann

I guess you'll have to manually delete the duplicate entry then.
Michael Eshom
Christian Metal Fans

Deimos

#11
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

Oldiesmann

What do you get when you run this query on your SMF database?

SELECT * FROM smf_topics WHERE ID_TOPIC = '12950';
Michael Eshom
Christian Metal Fans

Deimos

#13
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

MaT76

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 ?
--
MaT

Deimos

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.

MaT76

--
MaT

Oldiesmann

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.
Michael Eshom
Christian Metal Fans

Deimos


Deimos

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

Advertisement: