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, www.makemysitepopular.com/smf/
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.
I did try that,
but it would get stuck then importing the topics
The 2.1 version got much further through on the conversion
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'
sounds like the same issue posted here:
http://www.simplemachines.org/community/index.php?topic=273182.0
solution is also there. Hope that helps?!?
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
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
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.
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.
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
Its still doing the same thing as before.
Doh
Alright, give this one a shot.
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
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.
Seems like it worked
Thank you so much!