Cheers folks - was a quick hack that I did so credit goes to the original authors.

Do be aware that I specifically excluded users with empty passwords. So if you had a bunch of pending signups they may have been dropped. I had to do this as I had a multitude of spam signons from my previous site that I couldn't delete owing to problems with the ppbb2 bridge software interactions.

Me, I'm just glad to have a converter!!

hi folks,

I just tried to convert my phpBB data, but always get an error message, seems like I use the wrong password and/or Username. Though I have used the correct data bank user name and password, but maybe I had it wrong? what username and password should I try? the one of the phpbb admin? The Password/user for joomla admin?

edit: or it might be the data base name... hummm. I don't know what that is, I assumed it is the same as the user name, at least that is what my hoster says... any idea how I can find out what parameters are used?

edit 2: uh, no, it was the localhost, that was named differently... let's try that... wish me luck...

okay, now I have all the posts importet, but.... argh.. the users are gone!

I think I know how that happened: I had first saved another joomla installation, that I wanted to clone, installed that on the new home page, importet the database from that first installation (else the moduls won't be found), everything worked fine. BUT: by doing so, I must have killed the Users that phpbb had created. I can only find those from the other joomla installation...

I still have a saved database from phpbb, if that is any help... would it be possible to run phpbb from another folder on that homepage?


edit: this is the failuremessage I receive by converting the data base. All goes fine but the user data. It started with the admin, but when attempting to write the user into Community Builder, it gave that output:

ID: 100
Insert user into jos_users admin...OK
Insert groups into core_acl_groups_aro_map ...OK
Insert groups into core_acl_aro ...OK
Update alle posts with correct userid and unsername ...OK
Insert Users into Simpleboard ...OK

Insert Users into Comunity Builder...
...
Invalid query:
INSERT INTO jos_comprofiler (id, user_id, firstname, middlename, lastname, hits, message_last_sent, message_number_sent, avatar, avatarapproved, approved, confirmed, lastupdatedate, registeripaddr, cbactivation, banned, banneddate, bannedby, bannedreason, acceptedterms, sbviewtype, sbordering, sbsignature, cb_pgenable, cb_pgautopublish, cb_pgautoapprove, cb_pgshortgreeting, cb_pgtotalquotasize, cb_pgtotalquotaitems, cb_pguploadsize, cb_pgtotalitems, cb_pgtotalsize, cb_pglastupdate, cb_pgaccessmode, cb_pgdisplayformat, cb_location, cb_msn, cb_skype, cb_yahoo, cb_aim, cb_website, cb_occupation, cb_interests, cb_icq) VALUES ('100', '100', 'admin', '', '', '', '', '', '', '1', '1', '1', '', '', '', '0', '', '', '', '0', '_UE_SB_VIEWTYPE_FLAT', '_UE_SB_ORDERING_OLDEST', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''
Unknown column 'sbviewtype' in 'field list'

can anybody tell me what to do???

edit2: can the reason for the gone wrong conversion be that I have not installed community builder? What is it anyway, and do I need it?

okay, seems like noone is reading me..

I installed CB in hope that the neccessary fields will be created. Did anybody mention it to be essessential? anyway.

Now I have the problem that I cannot proceed the converter again, since it got stuck after adding the posts, it now starts all over, quitting after recognizing that the tabs are not empty as they should.

My next attempt is to change the php file in that way so it skips the first part and will continue from where it first stopped. has anybody an opinion to that?

*stefan

edit: okay you guesed it, I did so. It worked well, but now I get a new error message when importing the users:

...
Invalid query:
INSERT INTO jos_comprofiler (id, user_id, firstname, middlename, lastname, hits, message_last_sent, message_number_sent, avatar, avatarapproved, approved, confirmed, lastupdatedate, registeripaddr, cbactivation, banned, banneddate, bannedby, bannedreason, acceptedterms, sbviewtype, sbordering, sbsignature, cb_pgenable, cb_pgautopublish, cb_pgautoapprove, cb_pgshortgreeting, cb_pgtotalquotasize, cb_pgtotalquotaitems, cb_pguploadsize, cb_pgtotalitems, cb_pgtotalsize, cb_pglastupdate, cb_pgaccessmode, cb_pgdisplayformat, cb_location, cb_msn, cb_skype, cb_yahoo, cb_aim, cb_website, cb_occupation, cb_interests, cb_icq) VALUES ('100', '100', 'admin', '', '', '', '', '', '', '1', '1', '1', '', '', '', '0', '', '', '', '0', '_UE_SB_VIEWTYPE_FLAT', '_UE_SB_ORDERING_OLDEST', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''
Unknown column 'sbviewtype' in 'field list'

so what does that mean?????

as if things can't get worse, ha. now the forum content is gone. hooops... how did that happen?????


okay. this code is in the php converter file:

// Insert user into Comunity Builder
echo "...";
$query = "
INSERT INTO {$mosConfig_dbprefix}comprofiler
(id, user_id, firstname, middlename, lastname, hits, message_last_sent, message_number_sent, avatar, avatarapproved, approved, confirmed, lastupdatedate, registeripaddr, cbactivation, banned, banneddate, bannedby, bannedreason, acceptedterms, sbviewtype, sbordering, sbsignature, cb_pgenable, cb_pgautopublish, cb_pgautoapprove, cb_pgshortgreeting, cb_pgtotalquotasize, cb_pgtotalquotaitems, cb_pguploadsize, cb_pgtotalitems, cb_pgtotalsize, cb_pglastupdate, cb_pgaccessmode, cb_pgdisplayformat, cb_location, cb_msn, cb_skype, cb_yahoo, cb_aim, cb_website, cb_occupation, cb_interests, cb_icq)
VALUES ('$newuserid', '$newuserid', '$row->username', '', '', '', '', '', '$row->user_avatar', '1', '1', '1', '', '', '', '$block', '', '', '', '0', '_UE_SB_VIEWTYPE_FLAT', '_UE_SB_ORDERING_OLDEST', '$row->user_sig', '', '', '', '', '', '', '', '', '', '', '', '', '$row->user_from', '$row->user_msn', '', '', '$row->user_aim', '$row->user_website', '$row->user_occ', '$row->user_interests', '$row->user_icq'
";
mysql_query($query) or die("Invalid query:$query" . mysql_error());
echo "OK";

I wonder what happens if I take out the die command... this is why it always ends right there. too bad, it sure won't bring my posts back...

Hi guys,

I don't know if you have a similar problem, but after conversion, some users with super high post counts would have their Posts Statistics Bar extended so long that it warps everything else. I'm talking about that bar (with a default green color) just below the user's post counts when you are reading posts. Anyone else getting this problem?

After reading 33 pages about this converter I still havent found solution to the following problem. (Even when someone had the same problem and solved it, he didnt post the answer). I have done everything as told here, using the latest file for the converter and I get this error message.

Code:

ALTER TABLE `jos_fb_messages` ADD `phpbb_userid` int(10) NOT NULL default '1' Duplicate column name 'phpbb_userid'

I have been browsing the database on phpmyadmin and havent found any dublicated columns or such. Any help would be most apreciated.

Thanks in advance!

It seems you have run the script before. Try running the script again on a complete new joomla database (with fb installed), using the last script, that should do the trick...

I just manually cleaned all the data from jos_fb* from phpmyadmin and still getting the same error...

www.kleiner-tuning.fi/

That is the site where I have put up fireboard, and I would like to get all posts and users from phpbb...

kleiner-tuning.fi/forums/

Im not very familiar with joomla yet and just starting up so I can be doing some starter mistakes. Forgive me my noobism

I think you'll need clean versions of both jos and phpbb. When doing conversion, the converter alters tables from both sides. I hope you've made backups.