[EzYRiDaH]

Hi Stephen / @netweb

I was finally able to run a complete conversion without any restarts. The MyBB SQL of the database was 435,9 Mb big. We cleaned a lot of the old forum. It contained 1 million+ messages, close to 40k topics and a 400+ members.

The conversion ran for roughly 48 hours on a MacBook Air with i7, 8Gb memory and a 500Gb Solid State drive under MAMP.

For people who want to do such a big conversion, I also had to tweak a lot of the PHP ini files to import such a big query and get maximum throughput. Below a summary. It took me a while to find all the necessary settings.

Copy /applications/mamp/library/support-files/my-huge.cnf and rename to /Applications/MAMP/conf/my.cnf
Change in my.cnf setting [mysqld]max_allowed_packet = 1000M
Change in /Applications/MAMP/bin/php/php5.5.10/conf/php.ini settings
max_execution_time = 259200,
max_input_time = 259200,
memory_limit = 6144M,
upload_max_filesize = 1000M,
post_max_size = 1000M,
mysql.connect_timeout = 1000.
Add or change in Applications/MAMP/bin/phpMyAdmin/config.inc.php setting $cfg['ExecTimeLimit'] = 0;
Don’t forget to restart MAMP.

I ran the conversion with the following settings: Rows Limit 10,000 and Delay Time 0. During the conversion my memory was around 50% and CPU was very low. Most likely it is possible to squeeze out more performance.

I did a lot of random checks and the outcome seems ok-ish. Not quite sure about some things and have some questions. Please bear with me 😉

Some topics are not combined correctly. All replies are separate topics. The ‘Recalculate the parent topic for each post’ does not fix this. I ran all repair queries btw. An option in the Topics interface to combine these, would be ace 😉 Is it possible to correct this with a query? My SQL skills are too limited unfortunately.

The Repair Forums option ‘Recalculate the position of each reply’ does not work. It creates a white screen. Load problem?

myBB accepts spaces in the login name. Unfortunately WordPress does not. The conversion leaves the spaces in the login name. Is it possible to correct this with an SQL? Is there another workaround? Correcting them one by one is not my preference 😉

Two forums are created double. The copies do not contain any topics or replies, so it is easy to remove them. Just thought you should know 😉

The original myBB forum contained 1mlj+ messages and 36k+ discussions. The converted forum contains 109k subjects. That can be explained because of the first issue. But it only contains 830k replies. It could be that myBB adds subjects and replies to messages, but the difference is a bit too big. Is it possible to do an SQL checksum to check the expected output?

Thanks in advance for your time!

[GamingOrdinance]

Hi

im trying to import my XenForo to my BBPress and im having trouble as this is coming up:

WordPress database error: [Table 'db502829828.user' doesn't exist]
SELECT convert(user.user_id USING "utf8") AS user_id,convert(user.username USING "utf8") AS username,convert(user.email USING "utf8") AS email,convert(user_profile.homepage USING "utf8") AS homepage,convert(user.register_date USING "utf8") AS register_date,convert(user.custom_title USING "utf8") AS custom_title,convert(user_profile.status USING "utf8") AS status,convert(user_profile.signature USING "utf8") AS signature,convert(user_profile.location USING "utf8") AS location,convert(user_profile.occupation USING "utf8") AS occupation,convert(user_profile.about USING "utf8") AS about FROM user AS user LEFT JOIN user_profile AS user_profile USING (user_id) LIMIT 0, 100
No users to convert
Starting Conversion

My forum link: community.gamingordinance.com

[Stephen Edgar]

A massive copy and paste of your code is not helpful, no one wants to read a wall of code with no formatting, next time use the “code” button in the toolbar to wrap your code so it’s a little easier to read, also only post the specific parts of the code that is relevant.

Either way, I’m closing this as a duplicate of your other post as that was readable and I’ve answered it. https://bbpress.org/forums/topic/pagination-on-forum-listing-page/

[Stephen Edgar]

This really isn’t a bbPress issue, it is more of a WordPress issue.

Your web host should be able to do some things via firewall rules.

A good starter doc is https://codex.wordpress.org/Combating_Comment_Spam , conceptually it is the same thing, you have some ‘content’ that spammers want to get in on, in this case rather than comments it’s your bbPress forums and/or topics.

bbPress uses WordPress user system for user authentication (login registration etc)

I know it’s probably ideally not what you were looking for but is the state of things.

A couple more thoughts would be to verify your Akismet API key is valid and Akismet is actually catching what spam it can. I’d also look to adding “capcha” plugin that supports the bbPress, there’s a few of these in WordPress plugin directory.

[Stephen Edgar]

Check out some of our docs, scroll down past the main headers on the following link and you’ll see some tutorials: https://codex.bbpress.org/

If you want a capcha for your site search the WordPress plugins for “bbPress Capcha”, there are a couple of these I think from memory.

[Stephen Edgar]

Check out some of the docs, there’s a link at the top of this page.

If you don’t want particular widgets in a sidebar remove those widgets, this is not a bbPress issue so we have nothing to fix here.

If you don’t want a sidebar, use a template from your theme that doesn’t include a sidebar.

Step by step guide to setting up a bbPress forum – Part 1

[Robin W]

suspect you have a whitespace in your functions file

Whitespace before <?php when “functions.php line 1” mentioned

If the message says the error is in line 1, then it is typically leading whitespace, text or HTML before the opening <?php marker.

eg

 <?php

not

<?php

[cybarmitzvah]

Hi I just tried to add your code to the site.

add_filter('show_admin_bar', '__return_false');
Warning: Cannot modify header information - headers already sent by (output started at /home/vaghar123/public_html/wp-content/themes/awesome/functions.php:1) in /home/vaghar123/public_html/wp-includes/pluggable.php on line 1121

and tat was the error I got from a non admin account.

[Robin W]

Step by step guide to setting up a bbPress forum – Part 1

[jilleryfregan]

I have a weird bug going on with my Static Homepage.

We are using the plugin called Store Locator (http://wordpress.org/plugins/store-locator-le/) to show office locations. It’s a fairly simple plugin called by a shortcode in a page to display a map and list of offices.

When I installed bbPress in addition to this Store Locator plugin, my static homepage was no longer working and my homepage reverted to a generic list of recent posts. (The static page was set in all settings correctly).

This happens on every theme, including twentyfourteen, only when both plugins are activated at the same time.

Is there any hook or reason that these two plugins would affect the static homepage?

Thank you!
Wordpress Version: 3.9.2
bbPress Version: 2.5.4
Website: http://209.240.4.6/

[Robin W]

it is in

\bbpress\templates\default\bbpress\form-reply.php

However it would be easiest to change the text using a function which you put in your functions file

//This function changes the text wherever it is quoted
function change_translate_text( $translated_text ) {
	if ( $translated_text == 'old text' ) {
	$translated_text = 'new text';
	}
	return $translated_text;
}
add_filter( 'gettext', 'change_translate_text', 20 );

Functions files and child themes – explained !

[Robin W]

So basically on the forum, when someone clicks edit my profile at the top of the page, it goes to the backend. Even though, it would be preferable to go to the front end.

I would not let users see the toolbar, this is really just for admins.

You need to disable the toolbar – add this to your functions file

add_filter('show_admin_bar', '__return_false');

then put the profile into your menu

Layout and functionality – Examples you can use

[cybarmitzvah]

Thanks Stephen Edgar for the help, in request by him, I am posting this here and starting this new topic:

disable front end editing

So basically on the forum, when someone clicks edit my profile at the top of the page, it goes to the backend. Even though, it would be preferable to go to the front end. Currently, the only way a user can go to the front end is by clicking their name next to a post or in a topic/replies sequence.

I am using the mesocolumn theme and am new to wordpress. site: http://www.astronomertalk.com

I also moved template-full-width.php, to my child theme, and called it bbpress.php. After doing this, nothing has changed except now the forum specific sidebar, that came with the theme, does not show up.

Source code from bbpress.php:

<?php
/*
Template Name: Full Width
*/
?>

<?php get_header(); ?>

<?php do_action( 'bp_before_content' ); ?>
<!-- CONTENT START -->
<div class="content full-width">
<div class="content-inner">

<?php do_action( 'bp_before_blog_home' ); ?>

<!-- POST ENTRY -->
<div id="post-entry">
<section class="post-entry-inner">

<?php if (have_posts()) : ?><?php while (have_posts()) : the_post(); ?>

<article <?php post_class('post-single page-single'); ?> id="post-<?php the_ID(); ?>">

<h1 class="post-title entry-title"><?php the_title(); ?></h1>

<div class="post-content">
<div class="entry-content"><?php the_content( __('...Continue reading', TEMPLATE_DOMAIN) ); ?></div>
<?php wp_link_pages('before=<div id="page-links">&after=</div>'); ?>

</div><!-- POST CONTENT END -->

</article>

<?php endwhile; ?>
<?php comments_template(); ?>
<?php else : ?>
<?php get_template_part( 'lib/templates/result' ); ?>
<?php endif; ?>

</section>
</div>
<!-- POST ENTRY END -->

<?php do_action( 'bp_after_blog_home' ); ?>

</div><!-- CONTENT INNER END -->
</div><!-- CONTENT END -->

<?php do_action( 'bp_after_content' ); ?>

<?php get_footer(); ?>

Thank You,
JB

[Robkk]

no i dont want to do that , its harder for me to design the look of the widget.

here let me explain a little bit more on why i want to hack your shortcodes plugin to show recent replies.

well first i want my recent replies (and also recent topics) to look sort of like any recent comments widget. im going to use jetpacks recent comments on their website as an example.

I have already pretty much made a copy of your shortcode plugin , edited it and threw it in my functions.php and put the shortcode in the visual editor widget by blackstudio

heres what it looks like vs the default recent topics widget.

now to make a replies widget with your shortcode all i have to do is rearrange code and use css to style everything together.

to make it look like its showing recent replies, i just show the latest reply authors avatar , their name and what topic they replied on and im done.

The only problem when doing this is if there is no replies on a topic , it would just show the topic author instead.

Plus if you can figure this out i can also make a hack to make a replies archive. Which would be cool for something else i might do and ILL share it all when im done.

i just need help on only showing topics with replies instead of all topics. if that is possible.

[divyesh25]

hi everyone,

i have one page in which i am listing “no-replies” topics. for that i am using shortcode this [bbp-single-view id="no-replies"]. currently i have total 11 topics and i am listing 5 topics per page, among them 10 topics have “no replies”. paging 1 and paging 2 list 5 topics properly but there is paging 3 is also show and on that i got message like this “Oh bother! No topics were found here!”.

please help me how i can remove paging 3.

thanks

[tiredofit]

I’ve dusted off an old site of mine – using buddypress.

I have the Forums component setup as a seperate site in Multisite, and just went to go through to make sure all the features worked on this site.

When I went to the forums site, I was presented with the Forum list as usual (I have created a Static page and use the shortcode to load the forums list). The forums themselves have topics inside of them, and I can view them seperately by visiting the backend and viewing the topic. When I click the seperate board links, it instead takes me to the Create New Topic section.

What could be going wrong?

[Robkk]

the css or content-statistics.php

if its the css ,

test to see if you need to add more classes to the code so it could with the tab widget,

test it by seeing if another stats widget has the css if you place it alone in the sidebar by itself in the tab widget

[Komal23]

Hi

I have used registration widget and logged in shortcode in a widget. But I wanted to show registration widget only when user is not logged in.
But it shows both. What should i do for that?
Here is the link of forum of my site.

R-CE Forum

Please help me in this ASAP.

Thanks in advance.

[Stephen Edgar]

Don’t use bbPress login widgets or shortcodes then, use whatever is supplying that form instead, essentially we are all just piggy backing the standard WordPress login form.

[Stephen Edgar]

Create new topic and per my previous replies, and include the name of the theme. You are using and include the source code of the contents of the bbpress.php file you created.

disable front end editing

disable front end editing

[Robkk]

ok heres the code

.widget_display_stats  dt, .widget_display_stats  dd {
	text-align: center;
}

.widget_display_stats dd {
	background:#CCC;
	padding: 5px;
	margin-top: 5px;
	color: #222;
}

category tags and forums number

if your talking about whats in the stats widget

just copy content-statistics.php into your child theme if you havent already.

and edit the file and remove what you want.

[divyesh25]

Hi robin,

i want list that all topics since user last visit to site, so for that some how i am update user last activity date and time and when user logged in next time i am get that date and time. so using this date & time i want to list topics since last visit of user.

i hope u got it what i want to say. the code is below. if i do any mistake please suggest me.

if u have better solution then please suggest me.

thanks

<?php$week = date( ‘W’ );
$year = date( ‘Y’ );?>
<?php if ( bbp_has_topics(‘author’ => 0, ‘order’ => ‘DESC’, ‘post_parent’ => ‘any’,’year’ => $year, ‘&w’ => $week) ) : ?>
<?php while ( bbp_topics() ) : bbp_the_topic(); ?>
<?php bbp_get_template_part( ‘loop’, ‘single-topic’ ); ?>
<?php endwhile; ?>
<?php else : ?>
<?php bbp_get_template_part( ‘feedback’, ‘no-topics’ ); ?>
<?php endif; ?>

[Robin W]

You explain me in detail with code?

Can you explain what you are trying to do and where on your site eg put a shortcode on the front page, add a widget that does this etc.

[divyesh25]

hi Robin,

thanks for reply.. i am implemented your suggestion, but not getting result. can You explain me in detail with code?

thanks

[LoraLu]

I am attempting to use the shortcode [bbp-forum-form] to allow users (keymasters) to be able to add new forums as needed. I set up a new page and added this shortcode. The page looks great and the shortcode pulls up the form to add a new forum (as desired). However, when I test it by filling out this form and clicking submit, nothing seems to happen. The page does seem to refresh but a new forum is not added.

Am I missing something? I am new to bbpress so perhaps I just missed a setting somewhere? I am running the latest version of WordPress (3.9.2) and bbPress 2.5.4. My site URL is http://wwcustomercare.azurewebsites.net.

Thank you in advance for your help!
Lora