I was converting another forum tonight and ran into a MySQL error while running the converter.
The error had the name of one of the forums in it, and that forum happened to have a contraction in it. I’m not sure how one could edit the script to accommodate apostrophes, but I simply renamed the forum and removed the apostrophe.
I reran the converter without the apostrophe, and it worked just fine. So if anyone else runs into an error, pay attention to what it is choking on, maybe you can remove some funky characters and sneak around it!
First off, I would like to say hello this community. I have been a long time supporter of WordPress, and just recently started looking into bbPress. I am very impressed with the software so far, but would like to get a couple kinks ironed out.
I run my own gaming community at http://www.irefire.com. The main page is running off of the most recent version of WordPress. Our forums used to be PHPBB and a backup of them is at http://www.irefire.com/phpbb. Our new forums are running off of the most recent version of bbPress and are located at http://www.irefire.com/forums.
I converted our phpBB3 forums to bbPress (thanks to http://bbpress.org/forums/topic/phpbb3-gt-bbpress-converter-beta-release) but I must have done something wrong since no one’s password worked. It wasn’t a big deal since the community doesn’t have too many members, and they could just reset it. Then I integrated the userbase with my WordPress blog, and all of a sudden the only users I have are the ones that were in WordPress.
All of my users are gone except for those that were in WordPress. Even then, one of them (Giraffe) has been assigned as the author of posts he never wrote. Any help as to how to get my users back and on the forums (even if they have to reset their passwords) but keep it integrated with my WordPress (so they only need one account to post on the forums and comment on the blog) would be great. If I need to just do a clean install of bbPress and try pulling over the phpBB passwords correctly this time, help would be appreciated in how to do that.
Thank you so much.
Edit: I would also like to say that I have access to and limited knowledge of phpMyAdmin. I can still see all my old phpbb users in the _pbb database. All my the wordpress users are in my _wp database. If I could just throw the users from one database to the other, would that force them as registered users on both wordpress and bbpress?
Hi everyone,
I’ve successfully installed PHPBB3 forums, WordPress blogs etc etc… and somehow, I’m having a nightmare installing BBpress…
I’m not a coding/IT guru but I’m not a beginner either so this makes the thing even more frustrated. By wanting to make the installation process easy, the description lacks a lot of details I believe. Here’s what I have:
– Yahoo web hosting
– MySQL Server version: 4.1.14
– MySQL client version: 3.23.49
– phpMyAdmin latest version
Steps:
1. download bbpress
2. upload it to gufugumu.com/bbpress
3. go to the url gufugumu.com/bbpress -> installation window appears fine
4. Step1 – fill the information
– Database name : guillos
– Database user : admin
– Database password : *********
Then comes the famous error : “There was a problem connecting to the database you specified. Please check the settings, then try again.”
So I can’t pass step1. I then look in the forum but could not find anything usefull. One would expect that installing a forum should not require advanced PHP or MySQL knowledge. This is quite annoying.
Also, if I try to remove the “-sample” from the “bb-config-sample.php” then I get the error message “ERROR: Could not establish a database connection”. Finally, I have also created the database in phpMyAdmin. Of course there’s 0 tables.
Any help would be extremly nice as I’m about to give up and go for PHPBB3…
Thanks in advance
I have this problem on the second step:
SQL ERROR [ mysqli ]
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 ‘uso, critiche e suggerimenti’, ‘Aiutaci a migliorare la community!’, ‘142’, ’11” at line 1 [1064]
SQL
INSERT INTO bb_forums (forum_id , forum_name, forum_desc, forum_parent, forum_order, topics, posts) VALUES (‘2’, ‘istruzioni per l’uso, critiche e suggerimenti’, ‘Aiutaci a migliorare la community!’, ‘142’, ’11’, ’47’, ‘1129’)
BACKTRACE
FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()
FILE: phpbb3tobbpress.php
LINE: 201
CALL: dbal_mysqli->sql_query()
Just done this myself on a live phpBB3 forum, worked like a dream, no issues. Thanks very much!
hello friends..i need help from you people..
can anybody please help me..
Hi friends.
I have a phpBB 3.0.5 forum.Now i want to convert it to bbpress.I have my database.Can any body please help me ..how can i do it ..
waiting for your reply..
thanks in advance..
Bummer, I took a closer look at the YAF forum thread, and it’s actually to convert from phpBB to YetAnotherForum…
Anyone else have any other wild ideas?
How can I move database from phpbb2 to bbpress with the same links without losing them scanned by google?
Andrew, I just converted a test install of phpBB 3.05 to bbPress 1.0.1 without any problems.
I haven’t heard any benchmarks as it’s up to you on setting it up (nginx/apache/phpcgi/phpfpm/etc….).
It’s even harder to compare pound for pound because of the extensibility bbpress affords you with wordpress and buddypress. Even the plug-ins that each trio of apps afford you.
There is a point when it’s not about how many users you can squeeze out of a single VPS, it’s about building a site… a community and what is the best software & hardware able to do that.
Of course, when your scaled to the limit with hardware, software, and users to that of say Twitter it’s a different story.
On their curve, no matter how much hardware they add, curbing simple things like response time become a huge battle. At this scale it’s in your best interest to develop something proprietary as such they have and are doing.
In your case though, your probably better off worrying about ‘how do i scale my forum installation’ , and ‘what forum software gives my users the most benefit’, than asking ‘how many people can i house on my vps/dedicated/box/PS3’.
Even having said this all of this, out of the box there is less overhead in the bbpress architecture than with PHPBBx.
Take all of what I said with a grain of salt, and a beer in hand.
Cheers,
– Jason
Hi,
How stable bbPress is? Is it ready to hold 15k users (still growing) and 100u online in one moment?
How much faster/slower is it he in comparison to PHPBB3, vbulletin, ipb?
Single Sign-on is a very convenient feature to have in an organization, and for web services (on apache, at least) it’s very conveniently provided by mod_auth_kerb.
However, there is a problem preventing its use with bbPress, namely user name handling.
Kerberos user names are of the form user@DOMAIN.TLD. bbPress username sanitization rules are too strict and strip the ‘@’ character outright. And anyway, domain concept is not supported throughout the code and in underlying database.
Moreover, the whole HTTP auth support (purportedly, a basic thing in any web app) relies on external and somewhat broken plugin (it uses bb_user_exists deprecated function, which is not working properly in 1.0, or at least it seems so to me).
In my most extant dreams (phpbb style
, SPNEGO auth plugin should be also able to query an LDAP database (which is most often present in such set-ups) for extra user info.
Any word on whether this converter works for phpBB3 v3.0.5 and bbpress v1.0? (asking before trying!)
Thanks,
~Andrew~
Creating a theme without a table is easy enough, just remove the tables from the theme. However the question you need to ask is “why?”.
The default phpBB3 theme ProSilver uses a table-less layout and instead use definition lists to achieve a ‘table-like’ look, but most HTML/accessibility experts consider this to be an abuse of definition lists and do not recommend it. Tables are for tabular data and most people consider things like a board index to be in fact tabular, hence tables are typically used.
I got it to work, the converter did a great job, thanks wmnasef!
I was trying to do the conversion on fairly standard VPS with a typical LAMP stack, I’m not really sure why it didn’t work on there.
But after that I tried the conversion on my Media Temple Grid Service account and it worked fine. (The forum is quite small, 7000 posts) So if someone else runs into a similar problem, try a different web host or a local web server, maybe you’ll have better luck too!
Footer tells me: 0.397 seconds – but thats relative. I will change host and server when I publish the board. I just know 4 other boards that are faster on my server right now. So its not exactly beeing about “slow” – Its about making it faster. Perhaps with Caching because my board will have 90% passive readers/guests who can wait a few minutes for updates and should not slow it down.
But thanks. Looks like there arent any tipps or a caching-plugin. To bad, bbPress would be really great.
Firefox/Firebug/Yslow/Pagespeed-Tests:
Punbb: 200ms
Vbulletin: 200ms
Minibb: 300ms
Seoboard: 400ms
BBpress: 500ms
Phpbb: 500ms
Vanilla: 600ms
+-50ms
Can you share those results? I’m curious, since I found it to run faster than phpBB and IPB (though anything runs faster than IPB…)
I got pretty close with wmnasef’s script, but I think I am having a problem similar to gavinj77’s.
SQL ERROR [ mysql4 ]
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 ‘opinions on current political questions.’, ‘0’, ‘2’, ’48’, ‘235’)’ at line 1 [1064]
I’m trying to convert an install of phpBB 3.0.4 to bbPress 0.9.0.5, a small amount of data did transfer over to bbPress before I received the error.
I tried to download matiaspunx’s edited file and I was also unable to.
Does anyone know exactly what I have to edit to “use the addslash function”, or happen to have a copy of this file they would be kind enough to share with me?
Thanks so much for the links Ipstenu!
I figured if there was a way out of YAF, it would most likely be to phpBB. Surprised I didn’t find this in my own searches.
If I can just get this data out of YAF, I think it will all be downhill from there
Mad idea.
Convert it to phpBB2 (NOT 3!) – http://forum.yetanotherforum.net/default.aspx?g=posts&t=782
Convert phpBB to bbPress – http://www.iteisa.com/phpbb2bbpress/
See also: https://bbpress.org/forums/topic/import-smf-to-bbpress
If you read the SMF to bbPress thread you’ll see what machinations were needed. Good luck!
Anonymous UserInactive
hmm… this function/plugin would be great to admin’s for “cleaning” after an import from another software, e.g. phpBB.
When today a admin user goes into an old Post from an Guest Users (of the old software) and change something – the post is saved with his user-id. It’s not possible to change the username afterwards to the original username.