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]