YaBB 2.2 Conversion: Duplicate entry

[Conservationist]

For those who have not shared in the sad saga, here's a recap:

I'm converting a series of YaBB 2.2 databases to SMF because our webhost stopped supporting YaBB.

Thanks to SleePy's help, I figured out the first was getting killed by the webhost because it was a large process (in their view).

Now, on to the second:

Code Select Expand


Undefined variable: command_line in [path]/convert.php on line 1148
Cleaning up (part 2)... Successful.
Converting polls and poll choices... Successful.
Converting polls and poll choices (part 2)... Successful.
Converting poll votes... Unsuccessful!
This query:

    ALTER TABLE `tablename`.prefix_poll_choices
    ADD PRIMARY KEY (ID_POLL, ID_CHOICE);

Caused the error:

    Duplicate entry '16777215-0' for key 1


This is one of those darn polls. Questions:

(a) How do I fix this?
(b) Can I skip it? Polls... we have a few, but they're not important. I have no idea where they are in the original forum, which is no longer on its original machine.

Cheers

[SleePy]

You are so close to the end

Who is your host btw? I asked Jay and he says that a host he has seen does this (for what ever reason).

You could go in and manually remove it though and we can hope its the only duplicate one in there and then the conversion would complete its last 3 changes (Yea your that close).

[Conservationist]

It's done! Both forums.

I had to find another machine and run the converter there, which is I think more a reflection of how stringent our webhost is about processor time than anything else.

We lost some PMs on one forum, and I had to remove all poll-linked topics on another (go to Convert/Members and select *.polls, then delete thatname.*).

Who is your host btw? I asked Jay and he says that a host he has seen does this (for what ever reason).

I spilled all the details here [nofollow].

...Thank you, SleePy, and all others who helped. We survived somehow. It's a good feeling. New forums so far are a big improvement, but still slow, because our webhost is a bit overloaded and as a result has restricted users to very little processor time.

[SleePy]

You are welcome

You may want to take a peak at our hosts and hosting board, It has information about other hosts that may help you in your search if you want a new host.