Problem trying to convert VB RC 2

[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