Burning Board 2.2.1 (was 1.1 Converters)

[[Unknown]]

I think you want something like this:

http://www.simplemachines.org/community/index.php?topic=42260.0

Give me similar descriptions of links and I can adapt it for you.

-[Unknown]

[Kamil]

Since there are no database changes from WBB 2.2.1 to 2.2.2 this converter will also work with the newst release of the WBB 2.2 branch. Tested with a board that has about 100k Posts. Awesome work. :-)

Will this converter also work for converting to SMF 1.0.5 ? If no, is there such a converter ?

Unfortunately, I have had a minor Problem with importing the polls into 1.1b3:

Converting polls...Successful.
Converting polls options... Unsuccessful!
This query:
INSERT INTO `smfhf`.smfhf_poll_choices
(ID_POLL, ID_CHOICE, label, votes)

[...]

Caused the error:

Duplicate entry '24-255' for key 1

Deleting all Polls completely will work, deleting suspect polls (i.e. Polls with many options for example) and clicking "Try again" will generate this error:

Caused the error:

Duplicate entry '1-1' for key 1

Has anyone made the same experience or an idea to fix this ?

Kind regards

Kamil

[Kamil]

My apologies if I bump this thread too early, but is there really no one else with this problem ? Does anybody have an idea to resolve this ?

Kâmil

[[Unknown]]

There is no converter for 1.0.5.

Please try the attached version.

-[Unknown]

[Kamil]

Thanks for your reply.

The problem stayed the same:

Converting posts (this may take some time)... Successful.
Converting polls...Successful.
Converting polls options... Unsuccessful!
This query:
INSERT INTO `smfhf`.smfhf_poll_choices
(ID_POLL, ID_CHOICE, label, votes)

[...]

Caused the error:

Duplicate entry '45-1' for key 1

Any ideas ?

Kamil

[Kamil]

Hi there,

is there any news on this ?

I understand it may not be a top-priority issue (it isn't for me, either ), but if I can be of any help in tracking this down just let me know.

Kamil

[[Unknown]]

Strange... that shouldn't happen.  Any different with these?

-[Unknown]

[Kamil]

Thanks for dealing with this again.

Didn't change anything:

Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting polls options... Unsuccessful!
This query:
INSERT INTO `smfhf`.smf_poll_choices
(ID_POLL, ID_CHOICE, label, votes)

[...]

Caused the error:

Duplicate entry '45-1' for key 1

Kamil

[[Unknown]]

If you change these lines:

Code Select Expand

SELECT pollid AS ID_POLL, 1 AS ID_CHOICE, polloption AS label, votes
FROM {$from_prefix}polloptions;

To:

Code Select Expand

SELECT pollid AS ID_POLL, 1234 AS ID_CHOICE, polloption AS label, votes
FROM {$from_prefix}polloptions;

Or even:

Code Select Expand

SELECT pollid AS ID_POLL, polloption AS label, votes
FROM {$from_prefix}polloptions;

Do you get the same error message?  See, that shouldn't matter at all, and it's sounding to me like something else is going wrong.

You can also try changing this:

$row['ID_CHOICE'] = ++$_SESSION['convert_last_choice'];

To:

$row['ID_CHOICE'] = 1234;

Then you should definitely get an error saying "Duplicate entry '###-1234' for key 1".  If it still says 1, something is definitely still wrong.

-[Unknown]

[Kamil]

If you change these lines:

Code Select Expand

SELECT pollid AS ID_POLL, 1 AS ID_CHOICE, polloption AS label, votes
FROM {$from_prefix}polloptions;

To:

Code Select Expand

SELECT pollid AS ID_POLL, 1234 AS ID_CHOICE, polloption AS label, votes
FROM {$from_prefix}polloptions;

Or even:

[code]SELECT pollid AS ID_POLL, polloption AS label, votes
FROM {$from_prefix}polloptions;

Do you get the same error message?  See, that shouldn't matter at all, and it's sounding to me like something else is going wrong.[/code]

Both generate exactly the same output:

Code Select Expand

Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting polls options... Unsuccessful!
This query:
INSERT INTO `smfhf`.smf_poll_choices

[...]

Caused the error:

Duplicate entry '45-1' for key 1

You can also try changing this:

$row['ID_CHOICE'] = ++$_SESSION['convert_last_choice'];

To:

$row['ID_CHOICE'] = 1234;

Then you should definitely get an error saying "Duplicate entry '###-1234' for key 1".  If it still says 1, something is definitely still wrong.

Hope I did it the right way: I first changed back line 251-252 of burningboard2_to_smf.sql to

Code Select Expand

SELECT pollid AS ID_POLL, 1 AS ID_CHOICE, polloption AS label, votes
FROM {$from_prefix}polloptions;

and changed line 249 as suggested above. Output is:

Code Select Expand

Converting polls options... Unsuccessful!
This query:
INSERT INTO `smfhf`.smf_poll_choices

[...]

Caused the error:

Duplicate entry '1-255' for key 1

Hope this does help you to sort it out.

Thanks for your help again,

Kamil

[[Unknown]]

That was helpful, thank you.  Can you try this one?

-[Unknown]

[Kamil]

Hi there,

and thanks for your quick reaction - I have good news.

We seem to be advancing :-)

There seems to be a similar error in processing the next table:

Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll votes... Unsuccessful!
This query:
INSERT INTO `smfhf`.smf_log_polls
(ID_POLL, ID_MEMBER)

[...]

Caused the error:

Duplicate entry '27-64-0' for key 1

I'm convinced we'll track this one down also.

Kamil

[[Unknown]]

How's this, then?

-[Unknown]

[Kamil]

More advancement, thank you again.

1.) It converts the whole database now, but seems to loop endlessly when recalculating forum-stats. Waited for over 60 Minutes for a forum with approx. 30.000 Posts completing on a P-IV Mobile 1400 with 512 MB RAM. I don't have any further information for you on this one since I don't know where to look for error-logs for the converting-process. If there are none to be generated, maybe I can help you with output of some debug-code you likely want to add :-)

2.) Had a look at the posts generally, found the image-links still messed up (was already reported; pls also see this older post). Weird: if there are two or more images in one post, ALL are shown correctly after I edit just the first pair of image tags from upper to lower case. Does this help you ? Will check for the other tags stated in the older post when I have more time.

Happy coding,

Kamil

[SmackDaddy]

So....let me ask this (sorry, could not find what I was looking for earlier)

I have a  wBB 2.3 forum.......and can either go to and older SMF and then upgrade to the latest, but......

I want to have the least amount of steps as possible.......what should I use (which conversion files)?