Burning Board 2.2.1 (was 1.1 Converters)

[goetzi]

Try it again.  As I said above, if you used the converter while in debugging mode, you'll need to go to:

convert.php?debug=0

Thanks for this hint. Now he did the conversion/made the database entries.

But there are still a few things the converter does not correctly:

He is ignoring Forums/Subforums.

The original WBB2 looked like this:



The SMF (after the conversion) looks like this:




The attachments are copied to the SMF-Folder, but they are not inserted into the posts. I don't know whats the problem there, but they are simply not shown.

[goetzi]

I don't suppose you'd be willing to send me (or just post) a dump of your "bb?_boards" table, could you?  I might very well be able to fix it with data; the problem is that I don't have an actual copy of Burning Board 2 to work with.

Of course, I can (Sorry, it's a german board).

Here is the wbb1_boards:

Code Select Expand

-- phpMyAdmin SQL Dump
-- version 2.6.1-pl2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Erstellungszeit: 08. Juli 2005 um 14:15
-- Server Version: 4.1.8
-- PHP-Version: 5.0.3
--
-- Datenbank: `db1011602-3ai`
--

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `bb1_boards`
--

CREATE TABLE `bb1_boards` (
  `boardid` int(11) unsigned NOT NULL auto_increment,
  `styleid` int(11) unsigned NOT NULL default '0',
  `parentid` int(11) unsigned NOT NULL default '0',
  `parentlist` text collate latin1_german2_ci NOT NULL,
  `childlist` text collate latin1_german2_ci NOT NULL,
  `boardorder` mediumint(7) unsigned NOT NULL default '1',
  `title` varchar(250) collate latin1_german2_ci NOT NULL default '',
  `password` varchar(25) collate latin1_german2_ci NOT NULL default '',
  `description` text collate latin1_german2_ci NOT NULL,
  `prefixuse` tinyint(1) NOT NULL default '0',
  `prefix` text collate latin1_german2_ci NOT NULL,
  `threadtemplateuse` tinyint(1) NOT NULL default '0',
  `threadtemplate` text collate latin1_german2_ci NOT NULL,
  `posttemplateuse` tinyint(1) NOT NULL default '0',
  `posttemplate` text collate latin1_german2_ci NOT NULL,
  `threadcount` int(11) unsigned NOT NULL default '0',
  `postcount` int(11) unsigned NOT NULL default '0',
  `lastthreadid` int(11) unsigned NOT NULL default '0',
  `lastposttime` int(11) unsigned NOT NULL default '0',
  `lastposterid` int(11) unsigned NOT NULL default '0',
  `lastposter` varchar(50) collate latin1_german2_ci NOT NULL default '0',
  `allowratings` tinyint(1) NOT NULL default '1',
  `daysprune` smallint(5) unsigned NOT NULL default '0',
  `sortfield` varchar(20) collate latin1_german2_ci NOT NULL default '',
  `sortorder` varchar(5) collate latin1_german2_ci NOT NULL default '',
  `threadsperpage` smallint(5) unsigned NOT NULL default '0',
  `postsperpage` smallint(5) unsigned NOT NULL default '0',
  `postorder` tinyint(1) NOT NULL default '0',
  `countuserposts` tinyint(1) NOT NULL default '1',
  `hotthread_reply` smallint(5) unsigned NOT NULL default '0',
  `hotthread_view` smallint(5) unsigned NOT NULL default '0',
  `moderatenew` tinyint(2) NOT NULL default '0',
  `enforcestyle` tinyint(1) NOT NULL default '0',
  `closed` tinyint(1) NOT NULL default '0',
  `isboard` tinyint(1) NOT NULL default '0',
  `invisible` tinyint(1) NOT NULL default '0',
  `showinarchive` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`boardid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci AUTO_INCREMENT=22 ;

--
-- Daten für Tabelle `bb1_boards`
--

INSERT INTO `bb1_boards` VALUES (1, 0, 0, '0', '0,2,20', 1, 'News & Ankündigungen', '', '', 0, '', 0, '', 0, '', 5, 24, 403, 1120659164, 9, 'Hannes', 1, 0, '', '', 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `bb1_boards` VALUES (2, 0, 1, '0,1', '0', 1, 'Schwarzes Brett', '', 'News & Ankündigungen', 0, '', 0, '', 0, '', 3, 22, 116, 1115056302, 9, 'Hannes', 1, 0, '', '', 0, 0, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0);
INSERT INTO `bb1_boards` VALUES (3, 0, 0, '0', '0,4,5,6,7', 2, 'Schule', '', '', 0, '', 0, '', 0, '', 153, 1551, 408, 1120768502, 12, 'dominik', 1, 0, '', '', 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `bb1_boards` VALUES (4, 0, 3, '0,3', '0', 1, 'Allgemein', '', 'Berlinwoche, Termine, Ausflüge, Projekttage und allgemeines zur Klasse', 0, '', 0, '', 0, '', 25, 344, 408, 1120768502, 12, 'dominik', 1, 0, '', '', 0, 0, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0);
INSERT INTO `bb1_boards` VALUES (5, 0, 3, '0,3', '0', 2, 'Schulübungen', '', 'Für die, die zu faul sind mitzuschreiben', 1, '', 0, '', 0, '', 57, 266, 371, 1119864216, 9, 'Hannes', 1, 0, '', '', 0, 0, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0);
INSERT INTO `bb1_boards` VALUES (6, 0, 3, '0,3', '0', 3, 'Hausübungen', '', 'Nur zum "kontrollieren", ob man''s zuhause richtig gemacht hat ;-)', 0, '', 0, '', 0, '', 28, 325, 307, 1118341894, 13, 'theboescho', 1, 0, '', '', 0, 0, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0);
INSERT INTO `bb1_boards` VALUES (7, 0, 3, '0,3', '0', 4, 'Schularbeiten und Tests', '', 'Oder auch Partnerbörse für panische Menschen...', 0, '', 0, '', 0, '', 43, 616, 332, 1119284649, 14, 'Schwömse', 1, 0, '', '', 0, 0, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0);
INSERT INTO `bb1_boards` VALUES (8, 0, 0, '0', '0,9,10', 3, 'Off Topic', '', '', 0, '', 0, '', 0, '', 125, 858, 14, 1120726310, 18, 'Bimbo', 1, 0, '', '', 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `bb1_boards` VALUES (9, 0, 8, '0,8', '0', 1, 'Smalltalk', '', 'Hier könnt ihr über Gott und die Welt reden!', 0, '', 0, '', 0, '', 39, 448, 14, 1120726310, 18, 'Bimbo', 1, 0, '', '', 0, 0, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0);
INSERT INTO `bb1_boards` VALUES (10, 0, 8, '0,8', '0', 2, 'Fun Links', '', 'Lustige Links, Bilder, mp3''s, Videos, usw.', 0, '', 0, '', 0, '', 86, 410, 27, 1120716256, 1, 'Lemieux', 1, 0, '', '', 0, 0, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0);
INSERT INTO `bb1_boards` VALUES (11, 0, 0, '0', '0,12,13,14,18,19,21', 4, 'Freizeit', '', '', 0, '', 0, '', 0, '', 78, 975, 377, 1120776905, 1, 'Lemieux', 1, 0, '', '', 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `bb1_boards` VALUES (12, 0, 11, '0,11', '0', 1, 'Informatikraum 250', '', 'Spiele, Hardware, Software, Internet und "möchtegern" Support =)', 0, '', 0, '', 0, '', 26, 199, 404, 1120660500, 19, 'Staempfe', 1, 0, '', '', 0, 0, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0);
INSERT INTO `bb1_boards` VALUES (13, 0, 11, '0,11', '0,19', 2, 'Turnsaal', '', 'Alles über Sport von Fußball, Eishockey bis hin zu psyeudo Sportarten wie Formel 1 ;-)', 0, '', 0, '', 0, '', 20, 268, 391, 1120511968, 1, 'Lemieux', 1, 0, '', '', 0, 0, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0);
INSERT INTO `bb1_boards` VALUES (14, 0, 11, '0,11', '0', 3, 'Musiksaal', '', 'Alles über Musik von X to tha C!', 0, '', 0, '', 0, '', 9, 158, 405, 1120685619, 14, 'Schwömse', 1, 0, '', '', 0, 0, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0);
INSERT INTO `bb1_boards` VALUES (15, 0, 0, '0', '0,16', 5, 'Feedback', '', '', 0, '', 0, '', 0, '', 8, 91, 364, 1120498320, 1, 'Lemieux', 1, 0, '', '', 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `bb1_boards` VALUES (16, 0, 15, '0,15', '0', 1, 'Feedback', '', 'Hier entsteht die virtuelle Müllhalde für Kritik, Beschwerden usw! Wenn ihr Wünsche habt, zieht ''ne Nummer und stellt euch hinten an!', 0, '', 0, '', 0, '', 8, 91, 364, 1120498320, 1, 'Lemieux', 1, 0, '', '', 0, 0, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0);
INSERT INTO `bb1_boards` VALUES (18, 0, 11, '0,11', '0', 4, 'Sonstiges', '', 'Alles was sonst nicht zu den anderen Foren passt...', 0, '', 0, '', 0, '', 14, 259, 406, 1120757834, 9, 'Hannes', 1, 0, '', '', 0, 0, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0);
INSERT INTO `bb1_boards` VALUES (21, 0, 11, '0,11', '0', 5, 'Multimediahaus Projekt', '', 'Projekt zum Multimediahaus im Raum 66b', 0, '', 0, '', 0, '', 9, 91, 377, 1120776905, 1, 'Lemieux', 1, 0, '', '', 0, 0, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0);
INSERT INTO `bb1_boards` VALUES (19, 0, 13, '0,11,13', '0', 1, 'Eishockey WM', '', 'Forum zur Aktuellen Eishockey WM in Wien und Innsbruck', 0, '', 0, '', 0, '', 5, 31, 203, 1116192045, 1, 'Lemieux', 1, 0, '', '', 0, 0, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0);
INSERT INTO `bb1_boards` VALUES (20, 0, 1, '0,1', '0', 2, 'Supplierplan', '', 'Hier sind immer die neuesten Supplierungen, falls es welche gibt', 0, '', 0, '', 0, '', 2, 2, 403, 1120659164, 9, 'Hannes', 1, 0, '', '', 0, 0, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0);
       

If you want, I can send you the hole database and upload all files, than you would have an installation for testing. Tell me if I shall do this.

goetzi

[[Unknown]]

I don't suppose you'd be willing to send me (or just post) a dump of your "bb?_boards" table, could you?  I might very well be able to fix it with data; the problem is that I don't have an actual copy of Burning Board 2 to work with.

Of course, I can (Sorry, it's a german board).

Danke schon .  I took a very small amount of German in school.

Can you try the attached version?  I think I tracked the problem down.

I sended you a backup of the sql-tables via pm. Thanks.

Looking at it now, thanks.

-[Unknown]

[goetzi]

I am afraid you built in a bug at this version.

Converting ranks... Successful.
Converting members... Unsuccessful!
This query:

    SELECT
    u.userid AS ID_MEMBER, u.username AS memberName, u.userposts AS posts,
    u.regdate AS dateRegistered, gc.groupids AS ID_GROUP,
    u.title AS usertitle, u.lastvisit AS lastLogin, u.username AS realName,
    u.email AS emailAddress, IF(u.sha1_password != '', u.sha1_password, u.password) AS passwd, u.ICQ,
    u.AIM, u.YIM, u.MSN, u.homepage AS websiteTitle, u.homepage AS websiteUrl,
    u.birthday AS birthdate, IF(u.invisible = 0, 1, 0) AS showOnline, u.gender,
    u.usertext AS personalText, IF(u.showemail = 0, 1, 0) AS hideEmail,
    u.signature, u.timezoneoffset AS timeOffset
    FROM `db1011602-3ai`.bb1_users AS u
    LEFT JOIN {$from_prefix}groupcombinations AS gc ON (gc.groupcombinationid = u.groupcombinationid)
    LIMIT 0, 500;

Caused the error:

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '}groupcombinations AS gc ON (gc.groupcombinationid = u.groupcombinationid)
    LIMIT' at line 11

[[Unknown]]

Try this one.

-[Unknown]

[goetzi]

 

Converting ranks... Successful.
Converting members... Unsuccessful!
This query:

    SELECT
    u.userid AS ID_MEMBER, u.username AS memberName, u.userposts AS posts,
    u.regdate AS dateRegistered, gc.groupids AS ID_GROUP,
    u.title AS usertitle, u.lastvisit AS lastLogin, u.username AS realName,
    u.email AS emailAddress, IF(u.sha1_password != \'\', u.sha1_password, u.password) AS passwd, u.ICQ,
    u.AIM, u.YIM, u.MSN, u.homepage AS websiteTitle, u.homepage AS websiteUrl,
    u.birthday AS birthdate, IF(u.invisible = 0, 1, 0) AS showOnline, u.gender,
    u.usertext AS personalText, IF(u.showemail = 0, 1, 0) AS hideEmail,
    u.signature, u.timezoneoffset AS timeOffset
    FROM `db1011602-3ai`.bb1_users AS u
    LEFT JOIN `db1011602-3ai`.bb1_groupcombinations AS gc ON (gc.groupcombinationid = u.groupcombinationid)
    LIMIT 0, 500;

Caused the error:

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'\', u.sha1_password, u.password) AS passwd, u.ICQ,
    u.AIM, u.YIM, u.MSN, u.ho' at line 5

[[Unknown]]

Here, this one.  I don't have a copy of Burning Board 2.1 or higher to test this on.

-[Unknown]

[goetzi]

The WBB2 converter is still not doing well.

Now the forums look like this (He is only making the first category, but then he does all forums into one):




The attachments are not added to the posts.

@[unknown]
I will send you a link per PM where you can download a backup of the WBB2 board (files and database dump), because you said you don't have a WBB2 board for testing.

[goetzi]

@[unknown]
Did you receive the backup of the board? If yes, does it help you?

[goetzi]

@[Unknown]
Thanks! Now the converter is working much better. But there are still a few things that it doesn't do right:

First of all, the attachments are not shown in the posts. Maybe I do something wrong. Did you get this working on my backup?

Then there are a few things at the statistic where no value is shown: "Average registrations per day"," Average posts per day", "Average topics per day" and "Most Time Online". I don't know if it's the converters fault or if the WBB doesn't have this data.

Edit: It seems the - Tag isn't working too, because in the WBB2 it's written in upper case and in SMF it has to be lower case.

[Trekkie101]

I dont know about the attachments

But, WBB probably doesnt have that data, it wont be long though before SMF can make some averages for itself.

Also the IMG tag, word censro it.

[goetzi]

I dont know about the attachments

How do you mean this? The attachments work for you?

But, WBB probably doesnt have that data, it wont be long though before SMF can make some averages for itself.

Also the IMG tag, word censro it.

Sorry, I don't know what you mean with this. Maybe my english is too bad 

[Trekkie101]

I mean, I dont know why the attachments arent working, ive never tried it myself.

The stats will fill up with the missing data over time.

And if you add [IMG] in the censored words list in the SMF admin panel, you can make it change all [IMG] -> [img]

[goetzi]

Ok, I will try that trick with the censored words. But I think it would be more elegant if the converter converts the tags (I don't know if it's much work).

The stats will fill up with the missing data over time.

Allright 

I mean, I dont know why the attachments arent working, ive never tried it myself.

Hm, ok. Has anyone tried the WBB2 converter with attachments? In my case, attachments are very important so they should work properly.

[Miraenda]

Edit: It seems the - Tag isn't working too, because in the WBB2 it's written in upper case and in SMF it has to be lower case.

It does?  This works fine for me:

[iMg]http://smf/Themes/default/images/english/help.gif[/ImG]

As it should.  Perhaps the tag is formatted slightly differently in wbb2... I'll look into it.

-[Unknown]

Actually, it isn't working for me...but then maybe I'm hallucinating

[[Unknown]]

Well, I posted it using nobbc.  Example without nobbc:



-[Unknown]

[Miraenda]

heh ok, thanks for the clarification

* Miraenda needs to go to bed as she must be out of it

[goetzi]

I thought so; did you get any error messages during the conversion?

This is my "conversion-log":

Code Select Expand

Converting ranks... Successful.
Converting members... Successful.
Converting avatars... Successful.
Creating "Catch All" category... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Converting poll questions... Successful.
Converting polls options... Successful.
Converting polls votes... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting moderators... Successful.
Converting banned users (by IP)... Successful.
Converting banned users (by email)... Successful.
Converting smileys... Successful.
Converting attachments...
Warning: copy(C:\apachefriends\xampp\htdocs\wbb2/attachments/attachment-312.wmv) [function.copy]: failed to open stream: No such file or directory in C:\apachefriends\xampp\htdocs\smf1\convert.php(682) : eval()'d code on line 21

Warning: copy(C:\apachefriends\xampp\htdocs\wbb2/attachments/attachment-313.wmv) [function.copy]: failed to open stream: No such file or directory in C:\apachefriends\xampp\htdocs\smf1\convert.php(682) : eval()'d code on line 21
Successful.
Recalculating forum statistics... Successful.

I thought so; did you get any error messages during the conversion?  Can you try this query?

SELECT *
FROM smf_attachments
LIMIT 5;

I can do this query without problems.

Another thing I discovered: avatars are not converted too.

[goetzi]

I don't want to go on your nerves ([Unknown]), but how is the WBB2 converter going on?

[[Unknown]]

Can you try the attached?  I tested these again (they have been updated) and it seemed fine?

Also, sorry about the split - but it gets very hard to support multiple people in a single topic, all about completely different things.  I hope it's oaky with you that I split things out - hopefully it will help make things easier on both of us.

-[Unknown]

[goetzi]

Can you try the attached?  I tested these again (they have been updated) and it seemed fine?

I tried it. It didn't work for me. Maybe because I'm testing it locally (running XAMPP)? I will try it at my webserver, we will see, if it works there.

Also, sorry about the split

Oh, no problem. I was just a little confused, because I didn't find all my posts anymore, but then I discovered this thread.

Edit: Did your trying of the conversion go well with the my backup I sent you?

[[Unknown]]

It did.  The attachments even seemed to transfer just fine.

Please note that you will have to log in to see the attachments.

-[Unknown]

[goetzi]

Please note that you will have to log in to see the attachments.

Wohoo, that was it  . Attachments are working fine now.

There are another small bugs, I will collect and post them today.

[goetzi]

Ok,

here is a list of all things that are not correct at the converted forum. This doesn't always have to be the converters fault, maybe I did some incorrect settings at the SMF-board

1.) Avatars are not converted


2.) The converter seems to have problems with BB-code:


Original:


After conversion:




This was in a signature:

Original:


After conversion:



There are a few more examples, but generally said the converter seems to have problems with

Code Select Expand

[B], [SIZE], [IMG], [LIST], [U] tags.



3.) Permissions are not converted

After the conversion everyone (including guests) can see all forums. The permissions are completely ignored.


4.) Membergroups

In the admin panel, every Membergroup appears about 20 times (but only the self-defined)

[[Unknown]]

1. The converter may not yet do avatars completely perfectly (if not uploaded.)  That is to say, it currently only does converted avatars.  I'll try to change this and post an updated converter soon.

2a. Interesting.  Can I assume that [size=...] is for point sizes?  In other words, equivalent to [size=...pt], right?

2b. I just added [IMG]http://www.smilietown.de/smilies/flaggen/flaggen_081.gif[/IMG] to my signature and it went through fine.  Tell me, does it work if the img are lowercase, or is there some other problem?

3. Yes, this is a limitation of some of the converters currently.  With many systems, it's... difficult to map their permission scheme to the one SMF uses.  I'll try to put some work into this, but alas I don't yet know even how wBB stores permissions.

4. It looks like groups aren't being cleared before conversion.  I think I can fix that one pretty easily.

-[Unknown]

[Grudge]

[Unknown],

wbb seems to do all it's bbc in uppercase - and some of it doesn't parse in SMF (Although some does strangely enough). I think we need to update the converters to lowercase the BBC before we put it in the SMF database.

Grudge

[[Unknown]]

[Unknown],

wbb seems to do all it's bbc in uppercase - and some of it doesn't parse in SMF (Although some does strangely enough). I think we need to update the converters to lowercase the BBC before we put it in the SMF database.

Grudge

SMF should parse bbc regardless of case.  I used nobbc there - what are you talking about that doesn't parse?

The only restriction, *in cases*, is that the start tag is the same case as the end tag.

-[Unknown]

[Grudge]

Code Select Expand

Testing

Must be a bug then :/

[[Unknown]]

Then I'll fix that.  It's probably just code and nobbc, in that case.  Still doesn't explain this issue about img above.

-[Unknown]

[goetzi]

I just added to my signature and it went through fine.  Tell me, does it work if the img are lowercase, or is there some other problem?

I tried the following 4 possibilities at a post and my signature:

Code Select Expand

[img]http://www.smilietown.de/smilies/flaggen/flaggen_081.gif[/IMG]
[img]http://www.smilietown.de/smilies/flaggen/flaggen_081.gif[/img]
[IMG]http://www.smilietown.de/smilies/flaggen/flaggen_081.gif[/img]
[IMG]http://www.smilietown.de/smilies/flaggen/flaggen_081.gif[/IMG]

It worked fine both times. I don't know where the error is, but it seems the converter does something (what?) with the tags 


@[Unknown]
I really have to point out what a superb work you (and your team) are doing! I have worked with a few forum systems but nowhere the (free) support was so good like here! Go on 

[goetzi]

@[Unknown]
How is the development at the converter going?

[goetzi]

Will the work at the converter go on or do i have to finally convert my board with this version?

[[Unknown]]

Sorry, I lost this topic.

Can you tell me, are all the uploaded avatars going across properly, or not even those?

I'll make the pt size assumption.

-[Unknown]

[[Unknown]]

Okay, here are the latest versions, attached.  I tested the avatars again, and they seemed fine?  It looks like you must uploade avatars with Burning Board.

-[Unknown]

[Lizardking]

thank u

really needed a converter for WBB2
P.S.: SMF is awesome!!! 

[goetzi]

So, today, I finally converted my board from WBB 2.2.1 to SMF.
Here is my little report:

- Avatars worked. I don't know why, maybe because it was the first time I did the conversion at my online webspace (Before I always tested locally)

- Smilies didn't work. I had to add them all manually

- Some BB-Codes didn't work correctly. I could fix this with the "forbidden words" (for example: --> )


I have to say again: VERY GOOD WORK! 

goetzi

[[Unknown]]

The next release will probably fix your bbc issues (at which time you can probably remove the censoring.)

-[Unknown]

[goetzi]

Do you mean the next SMF release or the next release of the converter?

[[Unknown]]

The next release of SMF 1.1.

-[Unknown]

[goetzi]

The next release of SMF 1.1.

Ok.

I found one thing what the converter didn't do: Internal links.
Before the conversion, the WBB was at 3ai.net. In the board there are many internal links (e.g. 3ai.net/thread.php?threadid=242&threadview=0&hilight=&hilightuser=0&page=1 or 3ai.net/thread.php?threadid=188&page=2)

The new (converted) SMF board is at 4ai.at. Now this "internal" links are all dead, because they point to 3ai.net and are in "WBB-style". Is there any possibility to fix this automatically? (Fixing about 100 of such by hand links isn't funny)

goetzi

[[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)?