bbPress.org

Dear Developers, dear community

currently I am trying to set up the following combination: WordPress MU (2.7.1), Buddypress (tried both, 1.0.1 and 1.0.2) as well as bbpress (1.0-rc-3). My problem is the following error that appears on the “Installation success”-page:

Database error: [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 ') /* WP_Users::append_meta */' at line 1]

SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN () /* WP_Users::append_meta */

Caller: BB_Install->BB_Install, BB_Install->process_form, BB_Install->process_form_finalise_installation, bb_get_user, WP_Users->get_user, WP_Users->append_meta



Database error: [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 ') /* WP_Users::append_meta */' at line 1]

SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN () /* WP_Users::append_meta */

Caller: BB_Install->BB_Install, BB_Install->process_form, BB_Install->process_form_finalise_installation, bb_new_user, bb_get_user_by_nicename, WP_Users->get_user, WP_Users->append_meta



Warning: Cannot modify header information - headers already sent by (output started at [...] bbpressbb-includesbackpressclass.bpdb.php:569) in [...] bbpressbb-includesfunctions.bb-core.php on line 1095

To track down the error I will try to explain my installation procedure – the starting point is a vanilla installation of WordPress MU 2.71 and Buddypress 1.0.2:

1) Put bbpress into the same directory as wp-admin, wp-content and wp-includes – basically (“/”)

2) Go to the installation routine on ./bbpress/bb-admin/install.php and start step 1

3) Enter the same database name, user and password as for the WordPress MU installation

4) “Show advanced settings” and set database character collation to “utf8_general_ci”

5) Save and go to step two

6) Add integration settings

7) Add cookie integration

Enter the URL of the page (Note: The description “This value should exactly match the WordPress address (URL) setting in your WordPress general settings.” is wrong, there is no such value under Admin Panel > Settings > General nor under Admin Panel > Buddypress > General settings

9) Have already tried both: Setting the page URL again as well as setting URL + “/bbpress/” (Note: Again the description “This value should exactly match the Blog address (URL) setting in your WordPress general settings.” does no match since there is no such value in the Admin Panel in General Settings

10) Copying all cookie keys from the wp-config.php

11) Add user database integration settings

12) Set MU primary blog id to: 1

13) Save and go to step three

14) Enter site name, enter side address as base URL + “/bbpress/”, enter keymaster and according email address as well as a title for the first board

15) Save and install

From here on I get the error message (white one white background), the installation routine shows a successful installation nonetheless. The protocol is:

Referrer is OK, beginning installation…

>>> Setting up custom user table constants



Step 1 - Creating database tables

>>> Modifying database: [...] (localhost)

>>>>>> Table: bb_forums

>>>>>>>>> Creating table

>>>>>>>>>>>> Done

>>>>>> Table: bb_meta

>>>>>>>>> Creating table

>>>>>>>>>>>> Done

>>>>>> Table: bb_posts

>>>>>>>>> Creating table

>>>>>>>>>>>> Done

>>>>>> Table: bb_terms

>>>>>>>>> Creating table

>>>>>>>>>>>> Done

>>>>>> Table: bb_term_relationships

>>>>>>>>> Creating table

>>>>>>>>>>>> Done

>>>>>> Table: bb_term_taxonomy

>>>>>>>>> Creating table

>>>>>>>>>>>> Done

>>>>>> Table: bb_topics

>>>>>>>>> Creating table

>>>>>>>>>>>> Done



Step 2 - WordPress integration (optional)

>>> WordPress address (URL): http://[...]/

>>> Blog address (URL): http://[...]/

>>> WordPress cookie keys set.

>>> WordPress "auth" cookie salt set from input.

>>> WordPress "secure auth" cookie salt set from input.

>>> WordPress "logged in" cookie salt set from input.

>>> User database table prefix: wp_



Step 3 - Site settings

>>> Site name: [...]

>>> Site address (URL): http://[...]/bbpress/

>>> From email address: [...]

>>> Key master created

>>>>>> Username: forumadmin

>>>>>> Email address: [...]

>>>>>> Password: [...]

>>> Description: Just another bbPress community

>>> Forum name: General

>>>>>> Topic: Your first topic

>>>>>>>>> Post: First Post!  w00t.

>>> Making plugin directory at [...] bbpress/my-plugins/.

>>> Making theme directory at [...] bbpress/my-templates/.

>>> Key master email sent



Installation complete!

I mean the forum is working, but I fear still something might have gone wrong after the above error message. What do you think?

Kind regards

I apologize if this has already been requested but how did/do you add the rss feed button to your forum not the individual topics?

Is there a plugin available to do this?

I am testing bbpress to use as a knowledge centre at our office and need to find a easy way to subscribe to the forums section including all the subtopics or the latest discussions so new posts/replys or when new topics are created I will be notified and have the option to sign up to a rss feed?

As currently I can select a forum and then a topic and add as a favorite which works great, I get emails when this topic changes and I can add as a rss feed to say internet explorer. BUT I have to individually do this to each topic that I am interested in.

When a new topic is created I am not aware that this has happened (I am the key master) unless I find it in the latest dsicussions..

Any help would be greatly appreciated.

Cheers, Dan.

Hi,

I get the following errors when using bbPress:

Warning: array_map() [function.array-map]: Argument #2 should be an array in /var/www/example.com/forums/bb-includes/class.bb-query.php on line 71



Warning: join() [function.join]: Bad arguments. in /var/www/example.com/forums/bb-includes/class.bb-query.php on line 71



Warning: Invalid argument supplied for foreach() in /var/www/example.com/forums/bb-includes/class.bb-query.php on line 85

I’m using bbPress 1.0 alpha 6 and I should also mention that I have integrated BuddyPress and WordPress MU and enabled WordPress’ WP_CACHE as stated here:

https://codex.buddypress.org/getting-started/improving-performance/

Does that have anything to do with the error messages?

Thanks for reading!

Can’t find any post about this error and my SQL is quite rusted.

Fresh install, no WP integration, MySQL 5.0.40

>>>>>> CREATE TABLE IF NOT EXISTS bb_vj_usermeta (

umeta_id bigint(20) NOT NULL auto_increment,

user_id bigint(20) NOT NULL default 0,

meta_key default NULL,

meta_value default NULL,

PRIMARY KEY (umeta_id),

KEY user_id (user_id),

KEY meta_key (meta_key)

) DEFAULT CHARACTER SET ‘utf8’;

>>>>>> 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 ‘default NULL,

meta_value default NULL,

PRIMARY KEY (umeta_id),

KEY `user_’ at line 4

Forum could not be created!

To have everything looking like one website.. like example: http://www.bliuzonaktys.lt/?page_id=75

Maybe posible to have forum communication without registration,that people can write theirs nicknames?

And posible maybe to convert db form wp-forum to bbpress?

I’ve had a good hunt around, but am not sure if I’m in wood-for-trees mode on this one.

Is there a way to limit the size of posts people can make? I’ve set up a new forum, where some members may join via another forum we belong to. Some of them make posts there of pages and pages of text. Can I limit posts to say, 3000 characters?

Hello, in 0.9.0.5 is impossible to make user with cyrillic name.

How to register that user with national symbols?

Before I spend a lot of time trying to customize this, I want to know if the discussions i have with clients in bbpress (I plan to download a plugin to allow me to make a discussion hidden except for a specified user), be also logged in the client’s profile on wp?

– also can thumbnail images be uploaded into a forum post?

– has anyone tried to integrate a shopping cart or even paypal button into a profile on bbpress before?

I managed to get my 1.0 bbPress installed (after having to manually edit the database), and bb-admin works just fine (or appears to), but when I browse to the bb itself, all I ever get is a 404 error. First, I’ve checked the obvious. ‘index.php’ exists in the bb root directory, and everything *seems* to be fine. Is there a log or something somewhere that tells me what it was trying to do so I can debug this?

Thanks in advance, ye BB-ers!

Steve

I flawlessly installed bbPress yesterday to have a forum to go along with my website: http://iphonecustoms.com. However, on all my posts and pages, I have a “Leave a comment” option towards the end, and it either links to my forum.. or nothing at all!! Can someone help? I just would like my comments option back.