Problem trying to convert VB RC 2

[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.

[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:

Code Select Expand

$dbname = '{database name}';
$tableprefix = '{database table prefix}';

[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..

The error MySQL gave was: No Database Selected

[Deimos]

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:

Code Select Expand

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).

[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.

[Deimos]

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

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

Code Select Expand

SELECT * FROM smf_topics WHERE ID_TOPIC = '12950';

[Deimos]

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 ?

[Deimos]

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]

Sorry

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

Code Select Expand

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.

[Deimos]

Saysssss

COUNT(postid) 
0

[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

[Oldiesmann]

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:

Code Select Expand

ALTER TABLE smf_messages DROP PRIMARY KEY, DROP INDEX 'topic', DROP INDEX 'ID_BOARD';

Then, if the converter runs successfully, run this query:

Code Select Expand

ALTER TABLE smf_messages ADD PRIMARY KEY('ID_MSG'), ADD UNIQUE topic (ID_TOPIC, ID_MSG), ADD UNIQUE ID_BOARD (ID_BOARD, ID_MSG);

[Deimos]

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

[Oldiesmann]

Try this one:

Code Select Expand

ALTER TABLE smf_messages DROP PRIMARY KEY, DROP INDEX topic, DROP INDEX ID_BOARD (without the single quotes around the names).

[Deimos]

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 

[Oldiesmann]

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.

[Deimos]

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.

[Oldiesmann]

Wow. That is big. Can you at least give me access to phpMyAdmin then? I won't mess anything up