News:

SMF 2.1.4 has been released! Take it for a spin! Read more.

Main Menu

Getting stuck with conversion please

Started by polepositiondriver.net, November 13, 2008, 06:12:23 PM

Previous topic - Next topic

polepositiondriver.net

Hey there,
I'm trying to convert yabb 2.2.3 (but so far the only conversion that worked is yabb 2.1 convertor) to SMF

I'm getting this error at the moment

The members are being added, but for some reason you can't click on the topics themselves to view what is inside them

This is my current error


Recalculating forum statistics... Unsuccessful!
This query:
ALTER TABLE `makemysi_smf`.smf_topics
ADD PRIMARY KEY (ID_TOPIC),
ADD UNIQUE lastMessage (ID_LAST_MSG, ID_BOARD),
ADD UNIQUE firstMessage (ID_FIRST_MSG, ID_BOARD),
ADD UNIQUE poll (ID_POLL, ID_TOPIC);
Caused the error:

Duplicate entry '0' for key 1


This is the web site as yet, hxxp:www.makemysitepopular.com/smf/ [nonactive]

SleePy

Have you tried the Yabb 2.2 converter?
I don't remember if it got on the downloads page as it was still in beta. But it should work smoothly.

One of the issues with the old converters before I remade the Yabb 2.2 converter is that it would add and drop indexes, resulting in all sorts of issues if things didn't go exactly right. I remade this converter to not do this and it has had a more positive result during the conversion process.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

polepositiondriver.net

I did try that,
but it would get stuck then importing the topics

The 2.1 version got much further through on the conversion

polepositiondriver.net

This came up

Converting topics (part 1)... Unsuccessful!
This query:

    INSERT INTO `makemysi_smf`.smf_topics
    (ID_BOARD, isSticky, locked, num_views, ID_LAST_MSG, ID_FIRST_MSG)
    VALUES ('1', '0', '0', '5', '1226230373', '1226230373');

Caused the error:

    Unknown column 'num_views' in 'field list'

ThorstenE


polepositiondriver.net

Still no luck unfortunately.
I'd give someone admin access to my forum if they were willing to help
I really wanted to get it going

SleePy

That is from the Yabb 2.2 script?
I see a bug is why :D

Open the yabb22_to_smf.php
Find:
'num_views' => (int) $views < 0 ? 0 : $views,

Replace:
'numViews' => (int) $views < 0 ? 0 : $views,

Most likely my mistake when I was working with the 2.0 converter and edited the wrong file :P
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

polepositiondriver.net

How long should the conversion take?
I have 2000 posts and 100 members,
So far its taken just on 1 hour

Its been displaying this for quite some time now

Converting...
Converting polls and poll choices (part 2)... Incomplete.
Not quite done yet!
This conversion has paused to avoid overloading your server, and hence not working properly.
Don't worry though, nothing's wrong - simply click the continue button below to start the converter from where it left off.

SleePy

Its possible it caught a loop.

Open the yabb22_to_smf.php

Find:
$_GET['substep'] += $block_size;
if (mysql_num_rows($request) < $block_size)
break;


Before that add this code:
echo $_GET['substep'] . ' rows: ' . mysql_num_rows($request);

It is ugly code, but this is debug code.
It should hopefully tell me something.

Let the page refresh and tell me what it says.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

polepositiondriver.net

I can see in the url bar that the substep keeps going higher
starts off at 600 then i think i let it go till it got to about 360000

polepositiondriver.net

Its still doing the same thing as before.
Doh

SleePy

Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

polepositiondriver.net

No luck

Recalculating forum statistics... Unsuccessful!
This query:

    ALTER TABLE `makemysi_smf`.smf_topics
    ADD PRIMARY KEY (ID_TOPIC),
    ADD UNIQUE lastMessage (ID_LAST_MSG, ID_BOARD),
    ADD UNIQUE firstMessage (ID_FIRST_MSG, ID_BOARD),
    ADD UNIQUE poll (ID_POLL, ID_TOPIC);

Caused the error:

    Duplicate entry '0' for key 1


Can I possibly give you admin rights?
I really need to convert it soon

SleePy

Reinstall SMF. I think the indexes got screwed up from when you tried the Yabb21 converter.

The Yabb 2.1 converter played with the indexes and auto-increment in SMF a lot to do the conversion. I rewrote it for Yabb 2.2 to not do this. So this issue is only going to happen if we tried the other Yabb converter and the indexs/auto-increment is now missing.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

polepositiondriver.net


Advertisement: