Yes, i use a functions.php in my child theme
i thought bbpress had a signature option. But after your question what plugin i use for the signature i think it is the signature from Buddypress
Thank you for your reply.
I’ve had already solved the problem. an it works now for me.
bbPress 2.6-alpha is very stable, that’s right.
But still slow on huge forums, and gets slower by using big subforums.
My site has 75K topics and 1.100K posts
-posting takes ~5 to ~10 seconds (sometimes it hangs and takes almost ~50 seconds)
-Forumindex takes ~5 seconds to load
-Put topic/post to trash by modarator takes more than a minute
-Delete topic/post from trash by moderator takes more than a minute
I hope developers can find a good fix to make this, otherwise my forum has no future
I’ve edit the viewtopic in my old pbpbb forum in my sub-domain
And do the personal DB settings, and nog i get this error
Fatal error: Call to a member function free() on a non-object in /home/***/***/public_html/archief/viewtopic.php on line 48
Is there a way to export al old and new urls to a csv file. So i can import this in my redirect plugin on my new forum?
Google send many visitors with the old url that not can find on my new bbpress forum. So i can catch these visitors and redirect them
Looks great, but is this usefull when my old phpbb forum is moved to a sub-domain, and my new forum is now on the main-domain?
For example.
My old phpbb is moved to archive.domain.com
My Bbpres is on domain.com
How can u use your code, and where must i place it?
The wrong old Google phpbb urls goes to domain.com
Is there any solution for this slow post/reply problem.
I’ve the same problem and lose visitors
Look at my index
Forumindex
And the new topics
http://opel-forum.nl/topics/
with big query’s it’s very slow.
Posting in big topics takes almost 20 seconds.
Removing post/topics in admin takes half-a-minute
Nobody like this?
Am i the only one with a huge bbpress forum?
one best way.ive done with my forum. All other ways are not working
-Update phpbb to the latest version
-use the BBpress Alpha 2.6
-import the data from phpbb
-do the fixes down under in separatly ( run sql in 5 steps, begin with the first)
/* Get all posts with wrong author and correspondent right author from translator table */
create table TMP_ORPHANS as
select
wp_posts.ID,
wp_posts.post_author,
wp_bbp_converter_translator.value_id real_author,
IFNULL(wp_posts.post_date, NULL) post_date,
IFNULL(wp_posts.post_date_gmt, NULL) post_date_gmt,
wp_posts.post_content,
CASE
WHEN wp_posts.post_type = 'reply'
THEN (SELECT tmposts.post_title from wp_posts as tmposts where tmposts.id = wp_posts.post_parent)
ELSE wp_posts.post_title
END post_title,
wp_posts.post_excerpt,
wp_posts.post_status,
wp_posts.comment_status,
wp_posts.ping_status,
wp_posts.post_password,
wp_posts.post_name,
wp_posts.to_ping,
wp_posts.pinged,
IFNULL(wp_posts.post_modified, NULL) post_modified,
IFNULL(wp_posts.post_modified_gmt, NULL) post_modified_gmt,
wp_posts.post_content_filtered,
wp_posts.post_parent,
wp_posts.guid,
wp_posts.menu_order,
wp_posts.post_type,
wp_posts.post_mime_type,
wp_posts.comment_count,
( select wp_postmeta.meta_value
from wp_postmeta
where
wp_postmeta.meta_key = '_bbp_author_ip' and
wp_postmeta.post_id = wp_posts.id
) user_ip
from wp_posts
left join wp_users on wp_posts.post_author = wp_users.id
left join wp_bbp_converter_translator on wp_posts.post_author = wp_bbp_converter_translator.meta_value
where
wp_posts.post_type in ('forum', 'reply', 'topic') and
(wp_users.id is null or
wp_users.id = 1) and
wp_bbp_converter_translator.value_type = 'user' and
wp_bbp_converter_translator.meta_key = '_bbp_old_user_id';
/* Do this to be able to create indexes later – some may not work */
ALTER TABLE TMP_ORPHANS modify column post_date datetime default NULL;
ALTER TABLE TMP_ORPHANS modify column post_date_gmt datetime default NULL;
ALTER TABLE TMP_ORPHANS modify column post_modified datetime default NULL;
ALTER TABLE TMP_ORPHANS modify column post_modified_gmt datetime default NULL;
ALTER TABLE TMP_ORPHANS modify column user_ip varchar(40);
ALTER TABLE TMP_ORPHANS modify column post_title varchar(255);
/* we create indexes to speed up the update process */
ALTER TABLE TMP_ORPHANS ADD INDEX(post_date);
ALTER TABLE TMP_ORPHANS ADD INDEX(post_author);
ALTER TABLE TMP_ORPHANS ADD INDEX(real_author);
ALTER TABLE TMP_ORPHANS ADD INDEX(user_ip);
ALTER TABLE TMP_ORPHANS ADD INDEX(post_title);
/* Revert bad authors to good authors */
UPDATE
wp_posts INNER JOIN TMP_ORPHANS
ON wp_posts.id = TMP_ORPHANS.id
set wp_posts.post_author = TMP_ORPHANS.real_author
where wp_posts.post_type in ('reply', 'topic') ;
/* Drop TMP table */
DROP TABLE TMP_ORPHANS;
The result is a compleet database with the good relation between post and author
Hopenly you don’t give up the search for a faster BBpress.
We migrating from phpbb to BBpress. and the new BBpress forum is ready for launch.
But we afraid the visitors are not happy with the speed and boycot out
So we waiting and hoping than anyone the speedproblem find and solve this huge problem.
Until the problem exist we still use phpBB
Great! it works. All authors are correct now, and there is no post with anonymous as author.
Thx for your help and patience.
Hopely the BBpress creators implement this in the convertor.
should the error i get with the last query be the reason that i don’t see any difference?
#1146 – Table ‘****_monza.wp_postsINNER’ doesn’t exist
No, the moderator combine the too topics to this one topic. i think.
I’ve run all query individually and has one errormesage on the last query
#1146 – Table ‘****_monza.wp_postsINNER’ doesn’t exist
I take a look of my forum, and see no changes. Many posts has still anonymous as author.
i removed (<YOUR_SCHEMA>.) and run this as an sql in my MySql database
i get the follow error
#1054 – Unknown column ‘‘reply’’ in ‘field list’
When i fill in the name of the database in <YOUR_SCHEMA>
i get the follow error
#1064 – 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 ‘<****FOR_MONZA>.wp_posts.ID,
<****FOR_MONZA>.wp_posts.post_author,
<****FOR_MO’ at line 4
(**** i make it hidden)
i’ve php 3.1.9.
The convert file is made voor this version, so i do not have to make the missing tables.
The script you post above to maps the old IDs to the new ones is maybe a good solution an i wil give that a tray.
I don’t understand the field <YOUR_SCHEMA>
Do i have to change this field. If so, what must u fill in?
Thx @Giobby. A had already read your topic, and do as you told, but i keep this problem.
-The first topicpost has always the correct author
-The second ans all other posts in that topis has the anonymous as author.
This problem has nog every topic, some topics had for al posts the correct author.
Iám sure, there is a problem in the converting file, and it looks that this problem online exist by big phpbb forums
Please. BBpress team, can you look at this problem?
For us this is a big problem and the only reason we can’t release our new bbpress forum.
Our new site is complete ready, we have worked many months on it. and now we stuck on this hopely little problem.
i know bbpress authors are very busy people,but i hope they can help us.
i’ve found the file.
do the import, this takes almost 30 hours
1120363 posts
72212 Topics
50290 members.
And there is still a problem with converting
He lost the relations with many posts and author.
There are hunderds of posts with an anonymous author.
Also recently as very old posts has this problem.
ok.
can i separete download this file someware.
can you give me an url please.
i understand what you say and do that exactly
removed al mods and use a basic pbpbb 3.1.9 database
I use for all the latest verions
-bbpress 2.6 alpha
-phpBB 3.1.9
-phpBB Converter file 5795
As i said earlier in this topic, there is a problem with the latest version of the phpbb converter https://bbpress.trac.wordpress.org/browser/trunk/src/includes/admin/converters/phpBB.php?rev=5795
After converting all the passwords, at the beginning converting posts or topics i there is an error.
