By beginner on
Migrating from phpBB: http://drupal.org/node/24633
phpBB is a major bulletin board, widely used by many people. Many people are looking for a way to migrate from phpBB to a Drupal based forum.
If you search drupal.org, you will find many informative posts.
I am hereby creating a new chapter in the book to sort this information and to make it more accessible to people coming from phpBB.
Port phpBB or migrate to Drupal?
Drupal/phpBB features comparison chart.
Migration toolsThe way this section is going to be updated is thus: ask your questions in the comments below, and I'll look for the answer and incorporate it within the main text.
Comments
I am sure it would be much
I am sure it would be much appreciated by ALOT of people if there was a "semi-official" script to import PHPBB (whatever the latest version is) to Drupal.
I am aware of these database scripts:
http://drupal.org/node/12311#comment-23314
http://drupal.org/node/12311#comment-28057
Currantly this seems like a huge pain. Is there anyone working on an easier / solid way of importing PHPBB (At least some well laid out instructions for the everyday person would be great)
Possibly someone could update this script by "axel"?
http://cvs.drupal.org/viewcvs/drupal/contributions/tricks/phpbb2drupal/
Thanks,
Marand B.
About the semi-official
About the semi-official script: it's obvious that the core developers won't do it. They prefer working on other stuff, according to the time they have. The existing script will only improve as successive users modify it before using it. Unfortunately, due to the nature of the script (which is useful only once), people just leave it as it is after it has been used succesfully once. I hope that each time a new user comes and wants to use it, they'll share what worked for which versions of phpBB and Drupal, what didn't and also share any improvement they have made to the script. Over time, we should have more info and a better script for future users.
Meanwhile, since the script is what would be the most wanted item, I'll take the time (hopefully next week) to summarize the threads you quote and put the script in the not yet official phpBB2Drupal migration tutorial page.
http://www.reuniting.info/
Healing with Sexual Relationships.
Share info relevant to your situation
And also, tell us about your setup (versions). Have you tried using the script, yet? How did it go? Have you encountered some problems?
Currently, nobody is maintaining the script for the reasons explained above. I have not used it myself yet, but may have to in the future. I am preparing the ground for myself, while helping future users by making a permanent, organized record relevant to people looking to migrate.
I still know little. Share your experience and write down here your questions or the questions of the users in your phpBB board. If you can provide very specific questions, I'll see if I can help you. If you succeed migrating, tell us how it went. Tell us about the experience of the users in your board: do they like the new Drupal setup? Are they confused? by what? What features are you missing as an admin? And the users? etc...
Thank you.
--
http://www.reuniting.info/
Healing with Sexual Relationships.
Problem with first user duplication
I have the same primary user on both my phpbb board and my drupal forums. Importing hits this snag (via phpmyadmin):
- - -
SQL-query:
#
# Import user forms phpbb_users
#
INSERT INTO users( uid, name, pass, mail,
MODE , sort, threshold, theme, signature, created,
CHANGED ,
STATUS , timezone, language, picture, init,
DATA )
SELECT user_id, username, user_password, user_email, 0, 0, 0, '', user_sig, user_regdate, user_lastvisit, 1, 0, '', user_avatar, user_email, 'a:1:{s:5:"roles";a:1:{i:0;s:1:"2";}}'
FROM phpbb_users
WHERE user_id >= @first_phpbb_user_id
MySQL said: Documentation
#1062 - Duplicate entry '3' for key 1
Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /usr/local/dh/web/phpmyadmin/libraries/common.lib.php on line 685
- - -
I've tried changing the first user id name on both accounts, changing the ID number, and even deleting the user. Still can't get the script past this point. Any ideas? Bear in mind, I am an advanced newbie.
thanks in advance.
How many users do you have in your Drupal site?(in drupal_users)
Hello,
Just to make sure. You are using this script?
http://cvs.drupal.org/viewcvs/*checkout*/drupal/contributions/tricks/php...
(which at this stage is the same as this one:
http://www.mova.org/~lowry/phpbb2drupal.mysql but not in the future).
Note that the script currently works for Drupal 4.5 and slight modifications must be made for it to work with Drupal 4.6 (see the rest of this thread).
The script also works to import an existing phpBB installation into a NEW Drupal installation. How many users do you have in your Drupal installation?
Look at the highest uid in your drupal_users table. If you have 3 users in your Drupal installation, the highest uid should be 3 (uid=1 is always admin in Drupal).
Those users will conflict with the import for phpBB.
You may want to delete from your drupal_users table all users above uid=1 and change the last line of your sql command your quoted from:
WHERE user_id >= @first_phpbb_user_idtoWHERE user_id >= 2Or else only import the users from phpBB that do not conflict with the drupal users, i.e. if you have 3 drupal users, the last line of the query should read:
WHERE user_id >= 4.Beware: this second solution may create problems: imported posts may not be attributed to their proper owner. (Always test migration on a test Data Base with a copy of the data, so that you can start again from scratch if you have a problem)
It really depends how many users you have in Drupal. A new installation is prefered precisely to avoid this type of conflicts.
If you have many users in your live Drupal site, then a more complex strategy must be figured out.
--
http://www.reuniting.info/
Healing with Sexual Relationships.
Getting there.
Thanks for the assist. Now, I get past the initial user_id problem, but then I still have conflict problems:
How do I fix this (I'm not sure what --'', '', '0', '2', '0', '1', 'forum'-- means)? Thanks again.
Tell me more...
It may be a similar problem: the script is to be used on a virgin install of Drupal, but there could be ways around problems if not.
Please let me know the following:
What's your situation? How many users do you have on phpBB?
How many on Drupal?
Do you already have an active forum on Drupal?
How many forums? How many posts on Drupal?
B.
--
http://www.reuniting.info/
Healing with Sexual Relationships.
More...
> What's your situation?
Well, I'm 6' 2", brown hair, happily married and employed...(oh, that's not what you meant.)
> How many users do you have on phpBB?
6, but it's a testbed, they're nothing important
> How many on Drupal?
Started with the same 6, but I deleted all but two, then set the number in the script to 3
> Do you already have an active forum on Drupal?
Yes.
> How many forums?
One
> How many posts on Drupal?
One
Sounds like you're suggesting just scrapping the test forums on Drupal, and running the script again. Yes?
I am old, fat, ugly, but
I am old, fat, ugly, but equally happily married and employed!
Nice to meet you :-)
If your phpBB installation is a testbed, why do you need to import them into Drupal?
Try to to run the script with a _copy_ of your real data: you'll have less surprises later.
your "#1062 - Duplicate entry" errors are due to the fact that some data already exists where the script expected none.
Do you have a forum worth anything to you in your LIVE drupal installation?
I think I can see a place where the script might go wrong if it is used more than once on the same data.
Can you get a fresh copy of your live drupal site, and a fresh copy of your live phpBB site, and do the test again. Do not create any forum on the drupal site.
If you run into the same problem, or if you cannot meet the conditions I set you, try this, then:
with phpmyadmin, try in turn the following two queries (remove/replace prefix as necessary):
Both should return the same number (probably 2 or 3).
If not, run the following query:
then try the script again.
Tell me the result.
B.
--
http://www.reuniting.info/
Healing with Sexual Relationships.
Ok, I was willing to help, but what the hell!
I tried to post a page to the Drupal manual some time ago, it got posted but does not appear in the contents under Migrating from other weblog software.
Anyone can help?
I would also share my experience but I am not sure it will not get buried somewhere in the forums/unattached nodes.
Issue opened. Keeping track of different incarnations of script
Thanks mikhailian.
book entries are moderated. I have opened an issue to ask them to include your article:
http://drupal.org/node/26922
I have not had much time to sort out the mess from my own pages, yet.
I have a question about your script: how does it compare to the latest one posted by Axel here:
http://drupal.org/node/12311#comment-28060
Is your script based on that one, is it an improvement thereof, or based on the ealier one posted in that same thread?
There are now many scripts running around and things are getting a bit confusing: which one is the latest? Are there two forks or one original script? Could you shed some light on those issues?
When I get some time (hopefully within 2-3 months), I'd like to start a proper phpbb migration module, kept in cvs, here. A phpBB migration tool will always be in high demand, and a module that makes migration somewhat easier will be welcome by many. That's why I try to keep track on the latest/best script.
Here is the right place to do so. I'm taking notes and eventually I'll take the time to sort everything out.
Even if the moderators don't approve your page, I keep track of what's happening related to phpBB. Your contribution is not lost.
Thanks for sharing.
--
http://www.reuniting.info/
Healing with Sexual Relationships.
I have a question about your
I have a question about your script: how does it compare to the latest one posted by Axel here:
http://drupal.org/node/12311#comment-28060
It is the same except one bugfix probably.
The latest version is and will be in CVS now -- I asked Axel to update it there regularily.
That's great,
That's great, thanks!
--
http://www.reuniting.info/
Healing with Sexual Relationships.
Why port phpBB when drupal is more flexible?
Why port phpBB?
You can make drupal forums look EXACTLY like phpBB forums, and add more features than phpBB ever could. The secret is with the flatforum module (although not necessary), and custom theming. I wrote a basic walk-through with an example how to do it here:
http://www.drupalart.org/phpbb
Let me know what you think. Here is an example of drupal forums that I themed to look exactly like this phpBB style.
You could customize it even moreso of course. So now that you can get it to look the same, the question is how to transfer the database information.
Farsheed
Small problem with this.....
Used this example to make my forums look like phpbb and it works fine with one exception, I'm getting the following error when doing certain functions such as deleting content.
details
Type php
Date Saturday, August 13, 2005 - 19:35
User Sougent
Location /node/add/page
Message Cannot modify header information - headers already sent by (output started at /var/www/html/themes/spreadfirefox/template.php:81) in /var/www/html/includes/common.inc on line 192.
Severity error
------------------------------------------------------------
I'm guessing I've got something defined in duplicate or something like that. Any ideas?
Oh, and I'm using the spreadfirefox theme.
Joe
Nevermind.....
I think I figured it out, finally found the page in the handbook on that error and after looking at the template.php file about 5 times I found a spare space at the end that I was overlooking. Everything seems to work now.
Pretty odd error, though.
Joe
multi page comments links don't work
see my post at:
http://drupal.org/node/26966
... with big threads, if the comments span multiple pages, the links to the comments not on the first page don't work at all.
I consider this to be a *major* problem with popular message boards where threads can have 100, 200, 300 posts very quickly.
confused with all the scripts available
I'd like to convert my phpbb to drupal including forums, threads, users, etc. The thing is I'm getting confused with all the scripts recommended above.
Does this script work? I got this from the russian guy.
http://www.mova.org/~lowry/phpbb2drupal.html
It all seems pretty confusing to me but I do understand a bit of SQL statements. I'm using phpmyadmin and my phpbb database is called pinoy_phpbb and my drupal database is called drupal. How does the abovementioned script transfer data?
pls help
You should use the CVS
You should use the CVS script:
http://cvs.drupal.org/viewcvs/drupal/contributions/tricks/phpbb2drupal/
This should be the latest one available. Hopefully, everyone who is working on improving the script is using the cvs version and is updating it.
It seems that the cvs version is the same as the one you link to. Alexander Mikhailian seems to be the author of the recent upgrades to an original script by Feodor, and is updating both his site and the cvs. The latest version (1.3 in cvs) is only 13 hours old, so make sure you download it.
You will have, to modify the script to take into account your table prefixes.
The script transfers data by selecting the data from the phpBB part, and inserting it at the same time in the drupal part.
For example:
The code INSERT into Drupal the content of what has been SELECTed in the statement that directly follows.
Good luck with your move. If it went well, don't forget to let us know!
--
http://www.reuniting.info/
Healing with Sexual Relationships.
What about the data ?
Hi. I just created a new Drupal forum on my new provider and I would like to import data from my old phpbb forum. I'm not sure what to do with the script. Should I first upload my old forum's data to the new provider, under the same directory ? My new Drupal forum has the same url as the previous phpbb forum : http://www.quebec-japon.com/Multifrancophone
Before leaving my old server I made a backup of my sql database. I also made a backup of my old Multifrancophone directory.
Any help will be appreciated...
Alain
Bonjour Alain,
Bonjour Alain,
You confuse two things in your post:
1- the phpBB installation itself (all the .php files)
2- the phpBB data in the database.
You don't need the first one, i.e. phpBB doesn't need to be installed at all at your new provider.
You do need the data in the database, however. The url doesn't matter. The script assumes that the phpBB data is in the same database as the Drupal installation. So, if you started from scratch a new site at your new provider, with a new database, you need to dump the old phpBB data from the old database (easily done if you have phpMyAdmin installed and running on your home computer) and upload it into the new database that powers Drupal. Only then can your run the script.
I repeat: you don't need to have phpBB itself installed.
Since you start anew, if I were you, I wouldn't encourage users to register just quite yet, to avoid collisions between old phpBB user names and Drupal ones. I am not quite sure that it would have an adverse effect otherwise, but I think it's safer if you first import the phpBB messages+ user data, then enable the drupal Forum module (which you don't seem to have done yet), and then invite the users in: old users won't need to re-register and SHOULD be able to use their old user names and passwords.
Ask again if you are still confused or if you run into other problems.
B.
--
http://www.reuniting.info/
Healing with Sexual Relationships.
Getting closer...
thank you for your help. I already have a few users on the new forum (some of them with their old name). I have no technical knowledge, but I'm doing my best to follow your instructions. I imported my phpbb tables from the phpMyAdmin interface available on the provider (I don't use phpMyAdmin on my own computer). Now I can see my php tables. Drupal tables do not seem to have any prefix. Here is an example (extract) of what I see :
(...)
node_comment_statistics
node_counter
permission
phpbb_auth_access
phpbb_banlist
phpbb_categories
phpbb_config
(...)
So the tables are there. Can I conclude that Drupal tables have no prefix (like in node_comment_statisctics) ? I tried to apply the script without prefix for Drupal tables, but It didn't work. I will keep trying, but this stuff is very difficult for non technical users like me.
------
As for the "Connexion automatique", I told my users. Thanks. :-)
Alain
You're right. Drupal tables
You're right. Drupal tables don't seem to have prefix. How did you install it? Running the script without the drupal_ prefix is the thing to do...
What errors messages do you get?
It's never recommended to do stuff like this on a live site. I guess you are limited to only one database? Try to copy both the drupal and the phpBB tables onto a copy with other prefixes, like drupaltest_ and phpbbtest_ and run the script on that. Make sure you have a proper backup of your real data!!!!!
I'm looking forward to find the time to make this type of migration easier to non-technical users....
B.
--
http://www.reuniting.info/
Healing with Sexual Relationships.
Ok, I removed the drupal_
Ok, I removed the drupal_ prefix from the script. (There were 127. )
Was it OK to remove all the drupal_ entries from the sript ?
I get the following error when I do the sql request :
SQL-query:
#
# Create a vocabulary (called "Forum")
#
DELETE FROM vocabulary WHERE nodes = 'forum'
MySQL said: Documentation
#1054 - Unknown column 'nodes' in 'where clause'
By the way, I can have up to 50 sql databases. Does it help ?
Alain
127, he? I hope you use a
127, he? I hope you use a text editor with a good find&replace function ;-) (I use vim).
many datables are useful when you want to do backups, testing, etc... You can test this script on a copycat installationg of your site but using a test database. In case of any problem, you drop the database, and recreate it afresh, without ever affecting your main one. Also, you can try exactly the same script without having to create dozens of prefixes...
The error means what it says: the column doesn't exist. I just checked, and indeed, there's no such column in that table.
I post this first and I check something I remember having seen that may be relevant...
--
http://www.reuniting.info/
Healing with Sexual Relationships.
try this, tell me if it works.
You use drupal 4.6, right?
The script is for 4.5, so there may be some minor changes like this.
change this:
to this:
i.e. 'nodes' becomes 'module'
B.
--
http://www.reuniting.info/
Healing with Sexual Relationships.
Getting closer ?
Hi, this time I got the following error message :
SQL-query:
CREATE TABLE temp_posts(
post_id mediumint( 8 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
topic_id mediumint( 8 ) UNSIGNED DEFAULT '0' NOT NULL ,
forum_id smallint( 5 ) UNSIGNED DEFAULT '0' NOT NULL ,
poster_id mediumint( 8 ) DEFAULT '0' NOT NULL ,
post_time int( 11 ) DEFAULT '0' NOT NULL ,
post_edit_time int( 11 ) ,
post_subject char( 512 ) ,
post_text text,
PRIMARY KEY ( post_id ) ,
KEY forum_id( forum_id ) ,
KEY topic_id( topic_id ) ,
KEY poster_id( poster_id ) ,
KEY post_time( post_time )
)
MySQL said: Documentation
#1074 - Too big column length for column 'post_subject' (max = 255). Use BLOB instead
in phpBB, the post subject
in phpBB, the post subject is 60chars max, so there is no inconvenient of changing the following:
to this:
--
http://www.reuniting.info/
Healing with Sexual Relationships.
Kind of bizarre.
Downloaded Revision 1.3 from the CVS. When I run this on my db, I get this error:
1054 - Unknown column 'nodes' in 'field list'
I'm running the latest version of Drupal and phpbb 2.0.17
Both the drupal tables and the phpbb tables are in one database. I made sure to delete all the "drupal_" prefixes.
Any help greatly appreciated!
See three posts above
See three posts above yours:
http://drupal.org/node/24639#comment-50307
I haven't heard back from Alain. Tell me if your move is successful.
Goog luck.
--
http://www.reuniting.info/
Healing with Sexual Relationships.
My God.
This is why I have a "no coding after ten rule" -- and I regret it every time I break it.
I changed the first instance of "node" to "module" in that snippet -- and didn't even look for another.
That took care of that, then had to change "new" in the privatemsgs field to "newmsg" (the script should probably be updated).
Once the SQL went off without a hitch, I had to go into my forums and delete an existing container that somehow seemed to be interfering with the imported ones showing up -- I could see and even play with them a little in taxonomy, but they would NOT appear in the forum listings -- then all was well.
Private messages showed up, as did all posts in all forums. No signatures or avatars, of course, but I was looking for a solution, not a miracle.
Overall, I'm thrilled.
So far the only glitch I've found is that the quoting in replies broke down (you can see the raw bb code); since this was a test run, I'm going to restore the backup and install the quote module on my drupal site, then run this again see if that will catch the quotes. If not, no big.
Also, I'll make sure to delete all the containers and forums in the forum so I can see if that will prevent the slight problem I had with that. Will run the second test, report back and upload modified script later tonight or possibly tomorrow.
Thank you so much for all of your help!
Lily
Thanks for your
Thanks for your feedback.
--
http://www.reuniting.info/
Healing with Sexual Relationships.
One more to that list
I ran into all of the problems lily did, plus one more.
If you have your old phpbb tables in the same database as your drupal tables, and you run the script on that database, you will not have this problem.
Having said that, if you do have the two sets of tables in separate databases, and you change the table names in the script from
To fix this, you can either modify the database script to use the correct names, or just run it and go to the sequences table afterwords and copy all of the values from the . rows into the rows. ie. make sure the row with name "node_nid" has the value placed in the row with name "drupal.node_nid".
Other than that, a quick script to convert all of the bbcode with standard HTML in the comments and posts would be nice, but I may just tell people to ignore it. I also had to manually assign each imported user the "authenticated user" role. That could probably be done in the script. It also created forums in place of the forum containers from phpbb.
Still, this script is well written and quite helpful. I really don't think I could have done this without it, and being able to migrate all of our existing discussions to our new drupal community site was one of the big criteria I had to pass to convince the person in charge of setting up the site to let me install Drupal for us. Now, instead of a site with either a message board only, or a disconnected front page, calendar, forums, wiki and gallery, I'm building a Drupal site that has all of these things under one CMS (I used the wiki setup guide posted on this site). Our WCRI members site will be online in only a few days time when I have everything ready.
Connexion automatique?
I saw the comment here about the Connexion automatique.
http://quebec-japon.com/Multifrancophone/?q=node/10
I assume the user is referring to the checkbox when you login in phpBB to ask the computer to "remember you". There is (unfortunately) no equivalent that I know of in Drupal. Drupal should remember your by default, so that you have to remember to log out if you use someone else's computer (e.g. in a library).
This is an issue I'd like to find a solution for.
B.
--
http://www.reuniting.info/
Healing with Sexual Relationships.
By the way...
I just realized that I don't have to input my name and password. I can leave the boxes empty and simply click on a forum or the logo to get connected. Is it normal ? For us, it's very convenient indeed... ;-)
That's because you didn't
That's because you didn't log out. Beware if you use another person's computer! Try logging out to see the difference. I believe there's a security issue here (people won't remember to log out where they should.).
--
http://www.reuniting.info/
Healing with Sexual Relationships.
session timeouts
it is also controlled by how long before the php sessions timeouts. If you are using someone else's computer, then click the logout button. There was hue and cry and wailing and gnashing of teeth the last time Drupal.org had a shorter session timeout.
-sp
---------
Drupal Best Practices Guide - My stuff Black Mountain
-Steven Peck
---------
Test site, always start with a test site.
Drupal Best Practices Guide
successful migration of phpbb_user data only
Hi! I used the script to migrate the users. There were some errors when I started to migrate the forums and threads.
Which version of Drupal?
Hello,
I'm not the author of the script, and I haven't tried running myself, yet...
You don't provide much information, so it'd be difficult to help.
I notice that the script is for Drupal 4.5. Do you use Drupal 4.6?
In anycase, we need more info, the error message, etc...
--
http://www.reuniting.info/
Healing with Sexual Relationships.
Ok, I'll bite...
I recently got a project thrown into my lap to create a brand new community website for a group of people who are used to using PHPBB as their base of operations but have since outgrown it. Because of this background, the forums are really the "crux" of the community, although they welcome the advanced features Drupal can supply such as blogs, etc.
Here is a list of functionality they've cited so far that they miss from PHPBB with the built-in forums, which I'm either going to have to figure out how to get working in Drupal, or else migrate to another CMS (noooo!):
Signatures
- Signatures not attached to new threads as they are in comments. I was actually able to fix this one pretty easily, but it's weird that it's not that way by default.
- No way to initially discern what's a signature from what's a comment. I like what Drupal.org does with the "-- " separating the comment text from the signature text. Again, probably won't be too tricky to figure out but kind of weird that it's not done by default.
- The way in which Drupal attaches the signatures is awkward; since there's text sitting in the box before you even type anything, your cursor actually appears *after* your signature when you click/tab into the box, at which point you have to move your cursor back to the beginning of the box to type your reply. This has bothered users to the extent that most of them don't bother using signatures anymore. I really like irwin's suggestions here: http://drupal.org/node/16726
Posting Stuff
- No box on the side of the comment posting area to show them what smilies are available, which will transfer the smilies into the textbox when clicked.
- The only WYSIWYG editors available for inclusion into Drupal don't have support for Safari or WebTV, which happen to be the browsers used by two of the administrators of this new site. PHPBB's interface for inserting BBCode, though rather primitive compared to something like TinyMCE, works great on these alternate browsers.
- No "quote" button/link, to quote another person's text in a reply.
- When replying to a thread, only the post you're replying to, rather than the last X replies, is viewable below the textbox. This causes problems for users who want to get more of a "context" of the discussion when replying.
Viewing Stuff
- No avatar displayed next to name. chx's flat-forum module seems to address this, so I'll have to install that and then see.
- No "tags" and "levels" or whatever they're called.. when after X posts you have a label of "super poster" or whatever under your name and after Y posts you can make up your own... and you're given a rating via a system of stars or whatever based on how active you are.
- No post count. Further, these folks want to use the post count as a means of enabling certain site functions (after 1000 posts == create blog access, etc.) which I think is a cool idea but I don't see any means of enabling that easily.
I think that's it, at least for now. I'll be working on solving these issues myself in the meantime (and can post back with my progress), but I'd appreciate any help people could give so I don't have to end up downgrading to some other piece of software just to have a nice forum. :(
Oh yes, the biggie...
Oh yes, the biggie... how could I forget this? :P
PRIVATE FORUMS.
I've done some searching and realize that there must be some way to cruft together something like private forums using taxonomy_access, but I think I'm still a few hours' worth of futzing around before I manage to figure that one out.
Yes, that's the way to go.
taxonomy_access is the solution for private forums.
As you say, it's a biggie, so the documentation will have to include a detailed step by step howto.
B.
--
http://www.reuniting.info/
Healing with Sexual Relationships.
great summary. Thank you for biting!
Thanks webchicks!
That's the kind of post I was also looking forward to see in this thread.
About signatures: you've got a point. Thanks for the link to the task report.
For the rest, I'm not yet familiar with all the existing drupal modules, so I cannot answer (yet) everything.
Yes, there is. see module quote.
http://drupal.org/project/quote
You must configure your filters at admin/filters/ and enable "Quote filter".
There must be a soltution for avatars, for I've seen in more than one drupal forum, like for example here:
http://www.gamerswithjobs.com/node/18056
post count do not currently exists, I believe, but it shouldn't be too complicated to make a simple module for it. The module could also deal with the "tags" and "levels" you're talking about. If someone has some free time (Ha! Anyone?), its a minor feature that could be implemented fairly easily.
For the rest, I don't know of any currently working solutions.
Let us know of any workaround you find for each issue.
I am currently working on something else, but I guess I'll be able to start working seriously on this phpBB stuff in September (In september, I'll be moving our own forum here http://www.reuniting.info/forum/ from phpBB to Drupal). I'll take all the comments in this thread into account when working on the documentation, with howtos for former phpBB admins. Post any further information that could help me in that respect.
thanks a lot.
B.
--
http://www.reuniting.info/
Healing with Sexual Relationships.
BBcode
TinyMCE is reported as "partialy" working on Safari.
http://tinymce.moxiecode.com/tinymce/docs/compatiblity_chart.html
Have you tried this:
http://drupal.org/node/24875
Does WebTV support javascript? I'm sure Safari does...
http://drupal.org/project/smileys
I know it's not what you are asking for, but it's a start. Make that module to add a box beside the input area and with some javascript to it, we're there! Again, a small job for someone who has some time...
Again, thanks for pointing out the missing features, and also the features that phpBB users will be looking for in Drupal.
Really, there not much missing, and what's missing could be implemented fairly easily.
Good luck.
--
http://www.reuniting.info/
Healing with Sexual Relationships.
User Badges & Custom Ranks by Post Count
here's what i can add to the mix
this is new
http://drupal.org/project/userbadges
this seems rather old, but perhaps is workable
http://drupal.org/node/12738
We all need to kick in and turn Drupal into a powerful forums tool, I've recently been alerted to a vBulletin fork of Drupal, which is clearly the wrong way to go, this confuses newer users and takes away from the focus of improving Drupal.
Here is the overview of the project about new vbulletin integration - its at http://drupal.org/node/32879
a more comprehensive link:
http://www.vbulletin.org/forum/showthread.php?threadid=97341
my reason for not switching from phpbb
i've been using phpbb and have also watched the drupal and civicspace develop over time, but have hesitated to swtich due to the many MODs that are available on phpbb. Since I am no programmer, I have used the included mod instruction to add things to the forum which is easier than programming.
Here are some of the features I enjoy with phpbb:
-bookmaker (make bets on events using points*)
-activity (flash game to keep member high score and ranking)
-*points (provide an automatic reward system to posters)
-referral (refer friends and get points* rewarded)
-topic calendar (calendar of events that users can add with link to the forum topic)
-auto group (forum permission based on number of post)
-inline banner (banner system)
etc. etc. etc.
i thought civicspace would be the solution, but it kept on giving me errors (already installed) when i tried it the first day it was released, but after uninstalling and still getting the same error, i finally decided to give up.
can I use drupal as the main community while using phpbb as the forum? i prefer their forum layout/theming. if not, i guess i would have to wait until drupal can offer some of the features listed. any suggestion/comment regarding this is appreciated.
Using phpbb with drupal
Well, aside from the bother of there being two separate user databases forcing the users to sign up with both, what's to prevent a Drupal site from linking into a phpbb page and running the forum that way?
And the user problem could probably be gotten around by creating a script or trigger of some kind to create the entry in the phpbb user table based on the info provided when signing up for Drupal.
Any other gotcha's that would make this difficult?
Joe
yes
There are some very long threads which contain mention of a variety of difficulties with this solution. All that said, good luck and have fun. Consider contributing back any success.
-sp
---------
Drupal Best Practices Guide - My stuff Black Mountain
-Steven Peck
---------
Test site, always start with a test site.
Drupal Best Practices Guide
LDAP
Hi,
Doesn't both Drupal and phpBB have LDAP add-in's/modules that can be set up for authentication?
Could this not be a way to solve the multiple user login problem?
Joe
LDAP links
Hello Joe,
I knew nothing of LDAP. Here are some relevant links:
For Drupal:
http://drupal.org/node/15109
For phpBB:
http://sourceforge.net/projects/ldapauthmod/
http://www.phpbb.com/phpBB/viewtopic.php?t=185829
http://www.pcquest.com/content/enterprise/2005/105060201.asp
the following one may be obsolete already (?):
http://cerebus.sandiego.edu/~jerry/blog/article.php?story=20031126163833533
We'd like to hear about anyone who has succeeded going along that road...
B.
--
http://www.reuniting.info/
Healing with Sexual Relationships.
could convert phpbb 2.0.18 to drupal
Here's a little note on how the conversion went... might be of use to other folks looking for the workarounds.
First step, I downloaded the script from CVS:
http://cvs.drupal.org/viewcvs/*checkout*/drupal/contributions/tricks/php...
(Use the scripts/prefix.sh to prefix the drupal tables if needed or use them as it is with "drupal_" removed on the above script at all occurances. Put both drupal tables and phpbb tables on one database - use phpmyadmin to do this)
I had an admin user already, so:
@first_phpbb_user_id:=2I had to use:
as mentioned by beginner above.
The private messages wouldn't export siting some unrecognised column. So, for private messages, replace:
with
After all this doing, the /forum still showed "No Forums Defined", but the nodes were appearing with phpbb's topics.
I had to edit the "forum_nav_vocabulary" in the table - "variable" to "i:3;" (3 being the number of the vocabulary I was using for forums.
I added a new entry on the same table with "forum_order" for name and "s:3:"8";" for value. ( 3 - Vocabulary number of the vocabulary used for forums, 8 - taxonomy number of the first taxonomy in that vocabulary)
I had to install bbcode module, quote module and smileys module (bbcode toolbar is a plus) to make the port complete.
Here's the modified script that works without any errors on 4.6.3:
http://hpnadig.net/drupal-php-script-with-slight-modifications.txt
http://hpnadig.net/blog/
Has anyone been able to do
Has anyone been able to do something with the attachments in phpbb? It would sure be nice if they could be transfered over some how.
Not that I am aware of.If
Not that I am aware of.
If you improve the script, I'll update the cvs version.
--
http://www.reuniting.info/
Healing with Sexual Relationships.
New topics don't appear
I am trying to migrate phpBB2 to a new Drupal 4.6.3 installation. I have used the script from hpn above, and all the topics and forums come in ok.
BUT, when I try to create a new topic after the import, it only appears in the 'Active / New Forum Topics' blocks. The topic doesn't appear in the forum itself.
Has anyone else had this problem?
The effects are the same as the bug reported at http://drupal.org/node/22960, but the workaround shown there seems to be to delete the forum - which means I lose all the posts from phpBB2.
The test installation of drupal I'm working on is up at http://67.15.157.14/~batgung/3drupal/forum/10
Another thing I notice is that before the import, if I choose to 'Post new forum topic' the following page includes a field 'Forums:', which is a drop-down list of forums.
After the import, that field and drop-down list no longer appear on the 'Post new forum topic' page.
Any ideas?
comment.module?
I won't be able to help much.
Just a question, though. Was the comment.module enabled before you migrated the data? And now?
--
http://www.reuniting.info/
Healing with Sexual Relationships.
comments were enabled
Hi, thanks for replying.
Yes, unfortunately that wasn't the problem. Comments were enabled on the default install, and before running the migration script I could post new topics and they would appear ok. So it seems there is something that the script changes, but not sure what :-(
Comments are still enabled now.
I think you can go to
I think you can go to categories > edit the vocabulary > and select forum topics to fix it.
If you look at the code of where the vocabulary gets inserted I think you can fix that, but I haven't had a chance to look at it yet.
fixed it
By looking at the code for where the drop-down list should appear (same as Keizo suggests I think?), and comparing clean and bad forums, I found a couple of entries in the databases were missing after running the script. I added them and it seems all ok now: http://67.15.157.14/~batgung/4drupal/forum/2
I'm away from home (and my notes on this) for a few days, but will post the changes I had to make, and a couple of other problems/fixes I found when I get back.
Making the topics appear
Here are the extra steps I took to make hpn's script work successfully on our migration.
First note you should also import the phpbb_topics database from phpbb to drupal, as well as the seven databases listed in the script.
I started with a clean install of drupal from the fantastico utility included with our hosting package. This creates the admin user. I originally chose the same name for that user (say 'admin') as the first user I'd defined on phpBB2, thinking that would save problems later (because the script starts importing from user #2 in phpBB2). The script failed, and I found that my first user in phpBB2 was actually user #2 in the database. I guess the script died because the name already existed. So changed the name in drupal to another name, and ran the script again.
Next I found that although the users were imported ok, when I logged in I wasn't given any more rights than an anonymous user. Tracked that down to drupal's 'user_roles' database. I added the following lines between the script's "import users" and "create a vocabulary" sections:
#
# Set roles for all new users to be 2, ie 'authenticated user'
#
INSERT INTO users_roles (uid,rid)
SELECT user_id,2
FROM phpbb_users
WHERE user_id>=@first_phpbb_user_id;
After the script completed and the topics were all imported, I had to manually update two databases:
- add a record to 'sequences' with name=vocabulary_vid, id=1
- add a record to `vocabulary_node_types` with vid=1, type=forum
(These values probably only work on a fresh install of drupal)
Then I logged in to drupal as administrator, went to Administer and enabled the forum module, then in blocks enabled display of the two topics blocks ('new' and 'active')
The forums then displayed ok, and I can post new content that appears in the forums.
Hope that helps,
MrB
phpbb2drupal
For those interested:
http://drupalhacks.com/phpbb2drupal.txt
Marcel
B2B trade Leads
Wholesale Letter
Mac Mini
Redirect users from phpBB2 to Drupal
After the migration, many links, Google searches, etc will still point to the old phpBB2 site. Here's a simple way to get anyone using those old links over to your new drupal topics.
Fortunately after the migration, the drupal node number is the same as the phpbb2 topic number, so ...
Go to your phpBB2 directory and rename viewtopic.php -> oldviewtopic.php (so you can still view the original post if needed). Then cut and paste the following php code into viewtopic.php and save to your phpBB2 directory.
Now when anyone access a topic on the phpBB2 forum, they will be redirected to the equivalent post on the drupal forum. (This example is for a drupal site with "Clean URLs" enabled. The format of the url in the above code will be slightly different if you have them disabled)
MrB
after many tries with this
after many tries with this export script I finally got it to work.
just one note that the script tries to export/import private messages near the end however on my fresh default install of drupal there was no such table and the script did not seem to create it. I think the script mentions a privatemsg module but it didn't go into detail about it. You might want to install it if you care about PMs.
Also the script errored many times on tables that had some fields with no "default" field setting (perhap my database settings made the hiccup) - but merely re-saving the field made it take the 'null' default and that fixed my issue.
With my setup, the script was unable to create the comments_tmp data base, error was "Incorrect table definition; there can be only one auto column and it must be defined as a key" - this was fixed with TYPE = MYISAM in the entry.
I am using php4 & mysql 5.
After about 2 hours of fiddling through this, I was able to get it to work and the topics finally show up correctly (previously they were missing and the forums show new messages as a negative number)
Thank you for a great script and thread on how to get phpbb2 forums migrated.
I did a fresh drupal 4.6.5
I did a fresh drupal 4.6.5 install, edited settings.php per the script to include both the drupal database and the phpBB databse.
I get this:
Parse error: parse error, unexpected $ in /dir/phpbb2drupal.php on line 933.
Line 933 is the last line in the script, it only has the ?> tag on it.
Any ideas?
The line above that is
The line above that is likely missing a semicolon.
It was close to that simple,
It was close to that simple, there seemed to be an extra space, that was screwing it up.
That error is gone.
Now I get this:
Parse error: parse error, unexpected '@' in phpbb2drupal2.php on line 33
Line 33: SELECT @forum_title:='Forums';
It's almost like it is not connecting to the database.
Instead of migrating from
Instead of migrating from phpbb to drupal you could go from phpbb to VB and use VB with Drupal ( http://vbdrupal.com )
Marcel
TargetedPixels.com - Pixel Advertising
BusinessLetters.com - small business articles and advice
New phpbb2drupal.module
At last!!!
I have created a new phpbb2drupal.module for Drupal 4.6 to ease the migration. Enable the module, run it, and you're done.
It includes all the information shared in this thread.
I am going to commit it to the contribution repository very shortly, so you can download it from here.
Those who can't wait one day or two can contact me directly.
Thanks to everyone who contributed in this thread.
GREAT MODULE
THANKS A LOT. Although I've ran into minor problems, it's OK. The module works.
I forgot to install the flatforum module and import the sql..
I got these errors:
user error: Table 'tablename.flatforum' doesn't exist
query: SELECT uid FROM flatforum WHERE uid = 56 in /home/.darnel/planetzoo/planet/includes/database.mysql.inc on line 66.
I think that error was generated when I tried to import TOPICS. Anyway, that doesn't matter. I'm happy I got this message when I impoted the posts:
About to import posts
Importing comments of 578 topics
Successfully Imported posts
The were 11598 loops executed
There 0 errors while importing posts
Thanks for the feedback. I
Thanks for the feedback.
I am puzzle about your comment about flatforum: the phpbb2drupal.module doesn't use flatforum.module.
If you encountered any bug or problem, please open an issue here:
http://drupal.org/project/issues/phpbb2drupal
thanks.
--
http://www.reuniting.info/
Healing with Sexual Relationships.
http://www.wechange.org/
We live in a world of solutions.
BB CODE
It's not a bug. Just a minor testing error. I also found a problem with the bbcode module. After successfully importing everything, I couldn't properly view some topics and comments because they appear this way:
[b]PHPBB2DRUPAL MODULE WORKS BUT BBCODE DOESN'T[/b]
and not this way:
PHPBB2DRUPAL MODULE WORKS BUT BBCODE DOESN'T
BBCode
See the documentation link on the bbcode project page:
http://drupal.org/project/bbcode
Basically, you need to set bbcode as an additional input filter for your imported posts.
bbcode must be configured properly so it can work.
I tested it and it worked, too.
B.
--
http://www.reuniting.info/
Healing with Sexual Relationships.
http://www.wechange.org/
We live in a world of solutions.
Thanks for the help
thanks... I'll check that out.
ok so i figured this out,
ok so i figured this out, never mind.
Thanks
Thanks for this great module, its been really good so far. Just the one problem of polls myself and someone else need some help with - http://drupal.org/node/71780 - as can be seen here.
Also it would be cool if the original post was updated to include these URLs for this project:
http://drupal.org/project/phpbb2drupal
http://drupal.org/node/57197
And maybe linking those two urls better - the http://drupal.org/node/57197 seems rather surplus tbh tho. Whats the point of it?
benefits
Hi
Just a general question about converting from phpbb to Drupal - and I hope I'm posting this in the right place; if not, apologies!
I could be wrong but I've noticed with these drupal.org support forums, that the feature set available seems to be less than that available with phpbb. Mainly it seems that you don't get emails when someone replies to a thread you're 'watching', which I think isn't great.
On our phpbb board we've also set it up so users can get emails of any new topic or reply posted to the board; I just want to know if I try and convert this board, are these features available under Drupal? Or is it like Mambo, where you can install different forum modules, and therefore have a choice of functionality/features according to what the different modules offer? If so, what are the choices.
Am I making sense?
Cheers
You can add additional
You can add additional modules to add additional featres for your site. You can add subscription module if you want email notifications on forums. Of course I really don't get the point of that but it's your site.
-Steven Peck
---------
Test site, always start with a test site.
Drupal Best Practices Guide -|- Black Mountain
-Steven Peck
---------
Test site, always start with a test site.
Drupal Best Practices Guide
There are a couple of
There are a couple of modules u are talking about mentioned here:
http://drupal.org/node/58969
documentation updated.
I have just updated the said page with relevant information about subscriptions.
--
http://www.reuniting.info/
Healing with Sexual Relationships.
http://www.wechange.org/
We live in a world of solutions.
you might want to add these
you might want to add these as well:
http://drupal.org/project/smileys
http://drupal.org/project/quicktags
done.
done, thanks.
I aslo added a link to the list of filter/editor modules.
--
http://www.reuniting.info/
Healing with Sexual Relationships.
http://www.wechange.org/
We live in a world of solutions.
One table for Drupal and phpbb users
This is my first post so if I make any mistakes, please say so.
I've got a site with Drupal and phpbb3 installed and I want to synchronise my user accounts, but it's a bit difficult. I've also got an old module from phpbb3 to display user data and it used a seperate table in the database.
I've seen some nice projects to convert phpbb3 to drupal but the forum is working fine so I don't want to make any changes. What I want to do is make one table which contains all the data regarding users where both Drupal, phpbb3 and my module can tap into.
Does anyone know how drupal uses the database and how i can manipulate it?
Thanx in advance
UI missing in phpbb module for drupal
Hello,
I am using drupal 5.7.I was trying to integrate phpbb3.0 in my drupalsite i followed the instruction as specified in http://community.contractwebdevelopment.com/integrating-phpbb-with-drupa... but once i install the phpbb module for drupal i cannot see any user interface for that.it is appearing in the module list but no other links to access it its not even appearing in the access control page???
I have read that many people have used this module but i would be thankfule if anyone could provide me a valuable instruction to install this module.
Pls help.
UI missing in phpbb module for drupal
Hello,
I am using drupal 5.7.I was trying to integrate phpbb3.0 in my drupalsite i followed the instruction as specified in http://community.contractwebdevelopment.com/integrating-phpbb-with-drupa... but once i install the phpbb module for drupal i cannot see any user interface for that.it is appearing in the module list but no other links to access it its not even appearing in the access control page???
I have read that many people have used this module but i would be thankfule if anyone could provide me a valuable instruction to install this module.
Pls help.
Auto login into phpbb from drupal
Hi i am using drupal 5.7 i used the module phpbb and integrated phpbb with drupal.but when i click the link for phpbb it is asking 2 login again.. so how do i get rid of this? is there any way for an auto login into phpbb from drupal?
Auto login into phpbb from drupal
Hi i am using drupal 5.7 i used the module phpbb and integrated phpbb with drupal.but when i click the link for phpbb it is asking 2 login again.. so how do i get rid of this? is there any way for an auto login into phpbb from drupal?
getting error while installing phpbb forum settings in drupal6
Hi,
phpbb forum module installing into my site..but am getting these erros.
Error locating phpBB installation. Please fix your settings!
Error locating . Please fix your settings!
Unable to connect to the phpBB database. Please fix your settings!
how to rectify these problems..please provide me detailed documentation/step by step process.
thanks.