Advertisement:

Author Topic: Getting stuck with conversion please  (Read 17585 times)

Offline polepositiondriver.net

  • Newbie
  • *
  • Posts: 9
Getting stuck with conversion please
« on: November 13, 2008, 06:12:23 PM »
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]

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,373
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: Getting stuck with conversion please
« Reply #1 on: November 13, 2008, 06:31:46 PM »
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
Support the SMF Support team!
Profiles:
GitHub

Offline polepositiondriver.net

  • Newbie
  • *
  • Posts: 9
Re: Getting stuck with conversion please
« Reply #2 on: November 13, 2008, 09:45:57 PM »
I did try that,
but it would get stuck then importing the topics

The 2.1 version got much further through on the conversion

Offline polepositiondriver.net

  • Newbie
  • *
  • Posts: 9
Re: Getting stuck with conversion please
« Reply #3 on: November 13, 2008, 09:46:43 PM »
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

  • Guest
Re: Getting stuck with conversion please
« Reply #4 on: November 14, 2008, 12:33:59 AM »
sounds like the same issue posted here:
http://www.simplemachines.org/community/index.php?topic=273182.0
solution is also there. Hope that helps?!?

Offline polepositiondriver.net

  • Newbie
  • *
  • Posts: 9
Re: Getting stuck with conversion please
« Reply #5 on: November 14, 2008, 07:41:35 AM »
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

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,373
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: Getting stuck with conversion please
« Reply #6 on: November 14, 2008, 12:51:56 PM »
That is from the Yabb 2.2 script?
I see a bug is why :D

Open the yabb22_to_smf.php
Find:
Code: [Select]
'num_views' => (int) $views < 0 ? 0 : $views,
Replace:
Code: [Select]
'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
Support the SMF Support team!
Profiles:
GitHub

Offline polepositiondriver.net

  • Newbie
  • *
  • Posts: 9
Re: Getting stuck with conversion please
« Reply #7 on: November 16, 2008, 02:13:34 AM »
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.

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,373
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: Getting stuck with conversion please
« Reply #8 on: November 16, 2008, 08:40:36 AM »
Its possible it caught a loop.

Open the yabb22_to_smf.php

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

Before that add this code:
Code: [Select]
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
Support the SMF Support team!
Profiles:
GitHub

Offline polepositiondriver.net

  • Newbie
  • *
  • Posts: 9
Re: Getting stuck with conversion please
« Reply #9 on: November 16, 2008, 05:26:22 PM »
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

Offline polepositiondriver.net

  • Newbie
  • *
  • Posts: 9
Re: Getting stuck with conversion please
« Reply #10 on: November 16, 2008, 05:34:15 PM »
Its still doing the same thing as before.
Doh

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,373
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: Getting stuck with conversion please
« Reply #11 on: November 17, 2008, 12:40:38 PM »
Alright, give this one a shot.

Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline polepositiondriver.net

  • Newbie
  • *
  • Posts: 9
Re: Getting stuck with conversion please
« Reply #12 on: November 19, 2008, 01:15:42 AM »
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

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,373
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: Getting stuck with conversion please
« Reply #13 on: November 19, 2008, 02:03:37 PM »
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
Support the SMF Support team!
Profiles:
GitHub

Offline polepositiondriver.net

  • Newbie
  • *
  • Posts: 9
Re: Getting stuck with conversion please
« Reply #14 on: November 19, 2008, 04:11:25 PM »
Seems like it worked
Thank you so much!