Skip to:
Content
Pages
Categories
Search
Top
Bottom

postmeta db size

Published on June 26th, 2018 by matrixino

Hello,
I migrated from phpBB to bbPress recently. My forum has ~1Million posts. My postmeta table is 30GB.
Is there anything I can do to shrink it?
I noticed there are many lines for every post like _bbp_old_xxxx, which i suspect comes from migration.
It’s safe to delete all those records with _old_ in it? Or anything else? 30GB seems quite too much even for that amount of posts, compared to the old phpbb db size…

Started topics and cretated replies info private group forums

Published on June 26th, 2018 by webmasterfreya

ello,

Members of private groups are missing in their overviews the started topics and created replies from private forum(s) .

e.g Group member erwintest (member of 1 group) added some topics and replies in the private forum that should (at least i expect that) pop up via this link
/members/erwintest/forums/ and /members/erwintest/forums/replies/ but they don’t.

However if i logon as administrator and use the same links, the started topics and created replies placed in the private forum of user erwintest do popup.

Is this expected behaviour or not?

With Non private forums there is no problem.

site: freya.nl
Latest WordPress, bbPresss and Buddypress

Twenty eleven full width

Published on June 26th, 2018 by pauldlb

Hi,

I don’t know much about CCS and I’d like to change the forum to full width.
Can you help?
My site is: danslabande.com

Thank you!

Topic titles issue with shortened words

Published on June 26th, 2018 by DianaN

Hi Experts,

BBPress 2.5.14 and also using BB style pack 3.9.2
Wordpress version 4.9.6
Site url: StandUpGirl.com

Issue:
I am getting many errors in the google search console for titles that have words like haven’t, won’t, I’m which are contraction words. These words show up as this sample /forums/topic/i-haven-t-posted-in-a-while-but/ where you can see the word haven’t is haven-t. The search bots don’t understand the ‘t’ and I get errors. Also if a user puts an comma in the title I get errors.

How do I fix this?

Thank you so much for giving me help!
Diana

Controlling replies to topics

Published on June 26th, 2018 by wiseone.search

I’m interested in creating a forum that disallows replies to be made to topics until topics that have already been created have been replied to. How would I go about this?

Oh bother! No topics were found here!

Published on June 25th, 2018 by shagee

I get the error message “Oh bother! No topics were found here!”. I have installed bbpress and working on a divi theme. My shortcode for forum works but not my topics or index short code and I get this error. https://motionspecificrelease.ca/msr-community/

Importing problem Example.php

Published on June 25th, 2018 by evildrome

WordPress 4.9.6
bbPress 2.5.14

http://www.personalgroupware.com/wilsonlogan/

Hi All,

I have a forum in SQLITE format and I want to import it into bbPress.

I decided that if I was going to have to convert to a MYSQL database, I might as well use the schema indicated in Example.php

As I didn’t *actually* have the schema, I had to *guess* based on the fields in Example.php

For example:

CREATE TABLE IF NOT EXISTS forums_table (

_bbp_old_forum_id int(10) NOT NULL default 0,

the_parent_id int(10) NOT NULL default 0,

the_topic_count int(10) NOT NULL default 0,

the_reply_count int(10) NOT NULL default 0,

the_total_topic_count int(10) NOT NULL default 0,

the_total_reply_count int(10) NOT NULL default 0,

the_forum_title varchar(150) NOT NULL default ‘ ‘,

the_forum_slug varchar(255) NOT NULL default ‘ ‘,

the_forum_description text NOT NULL,

the_forum_order int(10) NOT NULL default 0,

the_forum_type int(10) NOT NULL default 0,

the_forum_status int(10) NOT NULL default 0

);

Having created the database as it is in Example.php, all I needed to do was load the MYSQL database from my SQLITE database.

Job done!

Yeah? Not so fast…

The import fails here:

SELECT convert(topics_table.the_topic_id USING “utf8mb4”)
AS the_topic_id,convert(topics_table.the_topic_reply_count USING “utf8mb4”)
AS the_topic_reply_count,convert(topics_table.the_total_topic_reply_count USING “utf8mb4”)
AS the_total_topic_reply_count,convert(topics_table.the_topic_parent_forum_id USING “utf8mb4”)
AS the_topic_parent_forum_id,convert(topics_table.the_topic_author_id USING “utf8mb4”)
AS the_topic_author_id,convert(topics_table.the_topic_author_ip_address USING “utf8mb4”)
AS the_topic_author_ip_address,convert(topics_table.the_topic_content USING “utf8mb4”)
AS the_topic_content,convert(topics_table.the_topic_title USING “utf8mb4”)
AS the_topic_title,convert(topics_table.the_topic_slug USING “utf8mb4”)
AS the_topic_slug,convert(topics_table.the_topic_sticky_status USING “utf8mb4”)
AS the_topic_sticky_status,convert(topics_table.the_topic_creation_date USING “utf8mb4”)
AS the_topic_creation_date,convert(topics_table.the_topic_modified_date USING “utf8mb4”)
AS the_topic_modified_date,convert(replies_table.the_topic_id USING “utf8mb4”)
AS the_topic_id FROM topics_table AS topics_table INNER JOIN replies_table
AS replies_table USING replies_table.the_topic_id = topics_table.the_topic_id WHERE forums_table.the_topic_id = 0 LIMIT 0, 100

Lookee thar… a mystery field!

forums_table.the_topic_id

Are there any other mandatory fields in the import schema that are not referenced in Example.php?

And… what field from my database should I load to forums_table.the_topic_id ?

Thanks!

Syntax error in tools.php

Published on June 25th, 2018 by webmasterfreya

tools.php

function bbp_admin_repair_user_favorites() {

643		$values[]         = "('{$user->user_id}', '{$key}, '{$favorites_joined}')";

Should be

function bbp_admin_repair_user_favorites() {

643		$values[]         = "('{$user->user_id}', '{$key}','{$favorites_joined}')";

Error 404 after a multiple words search

Published on June 25th, 2018 by jpellegrino

Hello,

I got a 404 error when I type more than one word in the search.
I think the error comes with the “+” symbol between each word. If I replace the “+” by %20, it works…

Here is the forum with the search :
https://powersimtech.com/support/communities/

Thanks for your help

XSS in 2.5.14?

Published on June 25th, 2018 by SGURYGF

I see a few pages today mentioning XSS in version 2.5.14, I assume it is invalid?

Thanks

Skip to toolbar