[mwdewitt]

I followed the directions to a “T” on your website. The install went fine until I wanted to finish everything up. Then it spits out this error message:

SQL ERROR!

>>> Database: acidhouse (localhost)

>>>>>> CREATE TABLE IF NOT EXISTS bb_posts (

post_id bigint(20) NOT NULL auto_increment,

forum_id int(10) NOT NULL default 1,

topic_id bigint(20) NOT NULL default 1,

poster_id int(10) NOT NULL default 0,

post_text text NOT NULL,

post_time datetime NOT NULL default ‘0000-00-00 00:00:00’,

poster_ip varchar(15) NOT NULL default ”,

post_status tinyint(1) NOT NULL default 0,

post_position bigint(20) NOT NULL default 0,

PRIMARY KEY (post_id),

KEY topic_time (topic_id, post_time),

KEY poster_time (poster_id, post_time),

KEY post_time (post_time),

FULLTEXT KEY post_text (post_text)

) TYPE = MYISAM 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 ‘TYPE = MYISAM DEFAULT CHARACTER SET ‘utf8” at line 16

SQL ERROR!

>>> Database: acidhouse (localhost)

>>>>>> ALTER TABLE wp_users DROP PRIMARY KEY;

>>>>>> Incorrect table definition; there can be only one auto column and it must be defined as a key

SQL ERROR!

>>> Database: acidhouse (localhost)

>>>>>> ALTER TABLE wp_users ADD PRIMARY KEY (ID);

>>>>>> Multiple primary key defined

SQL ERROR!

>>> Database: acidhouse (localhost)

>>>>>> ALTER TABLE wp_usermeta DROP PRIMARY KEY;

>>>>>> Incorrect table definition; there can be only one auto column and it must be defined as a key

SQL ERROR!

>>> Database: acidhouse (localhost)

>>>>>> ALTER TABLE wp_usermeta ADD PRIMARY KEY (umeta_id);

>>>>>> Multiple primary key defined

Key master email not sent!

I checked both the wp-config and bb-config file and the keys match up perfectly. I do not know what I am doing wrong here!

[mwdewitt]

I followed the directions to a “T” on your website. The install went fine until I wanted to finish everything up. Then it spits out this error message:

SQL ERROR!

>>> Database: acidhouse (localhost)

>>>>>> CREATE TABLE IF NOT EXISTS bb_posts (

post_id bigint(20) NOT NULL auto_increment,

forum_id int(10) NOT NULL default 1,

topic_id bigint(20) NOT NULL default 1,

poster_id int(10) NOT NULL default 0,

post_text text NOT NULL,

post_time datetime NOT NULL default ‘0000-00-00 00:00:00’,

poster_ip varchar(15) NOT NULL default ”,

post_status tinyint(1) NOT NULL default 0,

post_position bigint(20) NOT NULL default 0,

PRIMARY KEY (post_id),

KEY topic_time (topic_id, post_time),

KEY poster_time (poster_id, post_time),

KEY post_time (post_time),

FULLTEXT KEY post_text (post_text)

) TYPE = MYISAM 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 ‘TYPE = MYISAM DEFAULT CHARACTER SET ‘utf8” at line 16

SQL ERROR!

>>> Database: acidhouse (localhost)

>>>>>> ALTER TABLE wp_users DROP PRIMARY KEY;

>>>>>> Incorrect table definition; there can be only one auto column and it must be defined as a key

SQL ERROR!

>>> Database: acidhouse (localhost)

>>>>>> ALTER TABLE wp_users ADD PRIMARY KEY (ID);

>>>>>> Multiple primary key defined

SQL ERROR!

>>> Database: acidhouse (localhost)

>>>>>> ALTER TABLE wp_usermeta DROP PRIMARY KEY;

>>>>>> Incorrect table definition; there can be only one auto column and it must be defined as a key

SQL ERROR!

>>> Database: acidhouse (localhost)

>>>>>> ALTER TABLE wp_usermeta ADD PRIMARY KEY (umeta_id);

>>>>>> Multiple primary key defined

Key master email not sent!

I checked both the wp-config and bb-config file and the keys match up perfectly. I do not know what I am doing wrong here!

[mwdewitt]

Okay, I figured out I had to go to my wp-config file where I installed WordPress to find all that stuff. Okay, now I have a new problem. Now that I have bbPress installed, it is giving me this error:

SQL ERROR!

>>> Database: acidhouse-forums (localhost)

>>>>>> CREATE TABLE IF NOT EXISTS bb_posts

(

post_id bigint(20) NOT NULL auto_increment,

forum_id int(10) NOT NULL default 1,

topic_id bigint(20) NOT NULL default 1,

poster_id int(10) NOT NULL default 0,

post_text text NOT NULL,

post_time datetime NOT NULL default ‘0000-00-00 00:00:00’,

poster_ip varchar(15) NOT NULL default ”,

post_status tinyint(1) NOT NULL default 0,

post_position bigint(20) NOT NULL default 0,

PRIMARY KEY (post_id),

KEY topic_time (topic_id, post_time),

KEY poster_time (poster_id, post_time),

KEY post_time (post_time),

FULLTEXT KEY post_text (post_text)

) TYPE = MYISAM 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 ‘TYPE = MYISAM DEFAULT CHARACTER SET ‘utf8” at line 16

SQL ERROR!

>>> Database: acidhouse (localhost)

>>>>>> ALTER TABLE wp_users DROP PRIMARY KEY;

>>>>>> Incorrect table definition; there can be only one auto column and it must be defined as a key

SQL ERROR!

>>> Database: acidhouse (localhost)

>>>>>> ALTER TABLE wp_users ADD PRIMARY KEY (ID);

>>>>>> Multiple primary key defined

SQL ERROR!

>>> Database: acidhouse (localhost)

>>>>>> ALTER TABLE wp_usermeta DROP PRIMARY KEY;

>>>>>> Incorrect table definition; there can be only one auto column and it must be defined as a key

SQL ERROR!

>>> Database: acidhouse (localhost)

>>>>>> ALTER TABLE wp_usermeta ADD PRIMARY KEY (umeta_id);

>>>>>> Multiple primary key defined

Key master email not sent!

And when I try to go to bb-login it gives me a 404 error, saying that the page was not found. Okay, what did I do wrong?

I am running…

Windows XP SP3

Apache 2.2.17

PHP 5.3.5

MySQL 5.5.8

[mwdewitt]

Okay, I figured out I had to go to my wp-config file where I installed WordPress to find all that stuff. Okay, now I have a new problem. Now that I have bbPress installed, it is giving me this error:

SQL ERROR!

>>> Database: acidhouse-forums (localhost)

>>>>>> CREATE TABLE IF NOT EXISTS bb_posts

(

post_id bigint(20) NOT NULL auto_increment,

forum_id int(10) NOT NULL default 1,

topic_id bigint(20) NOT NULL default 1,

poster_id int(10) NOT NULL default 0,

post_text text NOT NULL,

post_time datetime NOT NULL default ‘0000-00-00 00:00:00’,

poster_ip varchar(15) NOT NULL default ”,

post_status tinyint(1) NOT NULL default 0,

post_position bigint(20) NOT NULL default 0,

PRIMARY KEY (post_id),

KEY topic_time (topic_id, post_time),

KEY poster_time (poster_id, post_time),

KEY post_time (post_time),

FULLTEXT KEY post_text (post_text)

) TYPE = MYISAM 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 ‘TYPE = MYISAM DEFAULT CHARACTER SET ‘utf8” at line 16

SQL ERROR!

>>> Database: acidhouse (localhost)

>>>>>> ALTER TABLE wp_users DROP PRIMARY KEY;

>>>>>> Incorrect table definition; there can be only one auto column and it must be defined as a key

SQL ERROR!

>>> Database: acidhouse (localhost)

>>>>>> ALTER TABLE wp_users ADD PRIMARY KEY (ID);

>>>>>> Multiple primary key defined

SQL ERROR!

>>> Database: acidhouse (localhost)

>>>>>> ALTER TABLE wp_usermeta DROP PRIMARY KEY;

>>>>>> Incorrect table definition; there can be only one auto column and it must be defined as a key

SQL ERROR!

>>> Database: acidhouse (localhost)

>>>>>> ALTER TABLE wp_usermeta ADD PRIMARY KEY (umeta_id);

>>>>>> Multiple primary key defined

Key master email not sent!

And when I try to go to bb-login it gives me a 404 error, saying that the page was not found. Okay, what did I do wrong?

I am running…

Windows XP SP3

Apache 2.2.17

PHP 5.3.5

MySQL 5.5.8

[Pomy]

Hi Zaerl, Thanks for your interest in this topic

I also tried your method, but I’m sorry its little bit different.

its shows content from “whatever-you-want.php” when slug is “this” but the forum structure remain same.

something like

**************Forum Template**************

— Default Header

— Default latest discussion

— Default forums

— Default Footer

— Custom content from whatever-you-want.php

********************************************

But I’m searching, that when forum slug is “this” then i can handle every thing from scratch from “whatever-you-want.php”

like

*************Forum Template***************

— My Custom Header for forum slug “this”

— My Custom latest discussion

— My Custom forums categories

— My Custom style for footer

*******************************************

Keep in mind that this is a rude approach and that everything can be packed in a plugin.

I’m afraid what you are talking about. Is this not a secure method?

Can you please pack this code into a plugin, I’ll really appreciate your kindness. Thanks

[Pomy]

Hi Zaerl, Thanks for your interest in this topic

I also tried your method, but I’m sorry its little bit different.

its shows content from “whatever-you-want.php” when slug is “this” but the forum structure remain same.

something like

**************Forum Template**************

— Default Header

— Default latest discussion

— Default forums

— Default Footer

— Custom content from whatever-you-want.php

********************************************

But I’m searching, that when forum slug is “this” then i can handle every thing from scratch from “whatever-you-want.php”

like

*************Forum Template***************

— My Custom Header for forum slug “this”

— My Custom latest discussion

— My Custom forums categories

— My Custom style for footer

*******************************************

Keep in mind that this is a rude approach and that everything can be packed in a plugin.

I’m afraid what you are talking about. Is this not a secure method?

Can you please pack this code into a plugin, I’ll really appreciate your kindness. Thanks

[zaerl]

Default theme kakumei does print the IP of poster after the post if you are an administrator.

[zaerl]

Default theme kakumei does print the IP of poster after the post if you are an administrator.

[Pomy]

I’m searching a method to customize some forums and Sub-forums separately.

Something like WordPress Template Hierarchy. Which says,

In the case of categories, the hierarchy is fairly simple. For instance, suppose the slug of the Category in question is default and the Category ID is 6. The Template Hierarchy specifies that WordPress will use the first Template file it finds in your current Theme’s directory from the following list:

category-slug.php (Note: available with Version 2.9)

category-ID.php

category.php

archive.php

index.php

That is, if you do not have a category-slug.php (lets say category-news.php), WordPress will check for a category-ID.php (like category-6.php), and so on.

Did bbPress have this function? How can I get this?

Can I make a separate template file for a separate forum?

Thanks

[RoyalManG]

I have followed the procedure in the readme.txt, default avatar is displayed in the post and in profile, but I can not change it when I click the Upload Avatar, so I diverted to the home page forum (translate by google tranaslate O )

[John James Jacoby]

Original post updated with progress on various parts.

@luminis – bbPress should follow the language that your WordPress installation is, however there currently aren’t any language packs that I know of. To change the various things in your theme, you’ll want to create a new theme that you can modify safely. The easiest way to do that is to copy the bbp-twentyten folder out of /bbp-themes and into your /wp-content/themes/ folder, rename it, and edit the name of your new theme in style.css so that you don’t get the two confused. Your # 3 can be found in form-bbp_topic.php, and # 4 would require a helper plugin to hook into ‘bbp_is_user_subscribed’ and adjust the default value.

[luminis]

Hello, thanks for this great plugin! Really the one I was looking for after trying every forum software there.

I’ve got some questions if you could help me :

1. How can I add bbpress plugin to this plugin ? Is it possible ?

2. How can I change the language ?

3. When the user isn’t logged in, he will get that message after the forums : “Sorry! You must be logged in to create new topics.”

How can I change this text ? I’d like to tell the user “You can register here” instead.

4. Last, how to make the option “Notify me of follow-ups via email” it checked by default ?

Thanks!

[qprints]

Jumping the gun a little here but…

When/if the default theme for the bbpress plugin is setup, can it be more like here or the wordpress forum and absolutly nothing like the buddypress forum? (please!!)

[Adrienkb]

Issue with your theme.

if you have:

Main forum

Sub forum A

Sum form of A (

going into either of those sub forums you dont see any of the post and topics that belong to those forums, you only see them if you go to the mian forum that shows an over view of all the topics

Switching back to the default theme fixes this.

[Adrienkb]

Issue with your theme.

if you have:

Main forum

Sub forum A

Sum form of A (

going into either of those sub forums you dont see any of the post and topics that belong to those forums, you only see them if you go to the mian forum that shows an over view of all the topics

Switching back to the default theme fixes this.

[Adrienkb]

Sorry for the bump but they took away the edit button >_<

Your registratiuon page does nothing.

Upon registiring for a new account using this theme, I dont get any message and the admin side shows that I do not have a new user, switching back to the default theme this is fixed.

[Adrienkb]

Sorry for the bump but they took away the edit button >_<

Your registratiuon page does nothing.

Upon registiring for a new account using this theme, I dont get any message and the admin side shows that I do not have a new user, switching back to the default theme this is fixed.

[John James Jacoby]

@willabee – This is fixed now. Subforums were still defaulting to 5 instead of adhering to the setting.

@ch8rt – How about removing the plugin entirely, and reinstalling it?

@alanchrishughes – Development has sped up in the past 2 months, and we’ve been able to get a lot more features in as a result.

[Donald Ruskin]

~The bbpress application was available through my hosting package and so I installed from cpanel. Adding a theme was straightforward too after reading through this forum. However thereafter it got a bit weird.

I was surprised that you cannot upload or link an avatar icon but I found the plugin to do that here. I spent hours trying to follow the seemingly simply directions to get it installed but to no avail. After unzipping it, it looks like this:

<AVATAR-UPLOAD.0.8.3>

<AVATAR-UPLOAD>

bb-avatar-upload.php

identicon.php

readme.txt

unsharpmask.php

<ADDITIONAL-FILES>

avatar-upload.php

<AVATARS>

default.png

<MY-TEMPLATES>

avatar.php

With just seven files to handle, how can it be so complicated to find out where to put these files. The guides I have read seem to conflict.

I found the same thing with the PM plugin, there is not much clear guidance as to where the files actually go.

Has anyone got the avatar pic plugin working and can spare a few minutes to tell me where to put these, I would be grateful. My bbpress structure looks like this:

<BBPRESS>

<BB-ADMIN>

<AVATARS>

default.png

<BB-INCLUDES>

<BB-PLUGINS>

bb-avatar-upload.php

<BB-TEMPLATES>

<TRIPRESS> (<—theme)

<MY-LANGUAGES>

<MY-PLUGINS>

avatar-upload.php

identicon.php

unsharpmask.php

Many thanks to anyone who can take a look at this and instantly can see what I have done wrong.

[Crynix]

Okay so my forum is androidtalk.us and I was to have a large amount of categories (one for each phone and each phone will have sub-categories), but I have noticed that a large amount of sub-categories does not play nice with the user’s scrolling experience with bbPress. Is there some sort of plugin that I could install to make it so all my sub-categories are collapsed and they can expand them to their own will?

PS: Is there a way to do this with the default theme?

[ELundby45]

You could accomplish this by modifying the header.php file of the theme.

If you are using the default template, you should copy the kakumei folder to the my-templates. Follow the readme in the bb-templates folder.

Once in the header.php file:

Replace:

<h1><a href="<?php bb_uri(); ?>"><?php bb_option('name'); ?></a></h1>

With:

<h1><a href="http://blackberryverse.co"><BlackBerryVerse></a></h1>

Modify the style.css to include your description and activate the template in the admin section.

I am new to BBPress/PHP, there may be better solutions.

[ELundby45]

You could accomplish this by modifying the header.php file of the theme.

If you are using the default template, you should copy the kakumei folder to the my-templates. Follow the readme in the bb-templates folder.

Once in the header.php file:

Replace:

<h1><a href="<?php bb_uri(); ?>"><?php bb_option('name'); ?></a></h1>

With:

<h1><a href="http://blackberryverse.co"><BlackBerryVerse></a></h1>

Modify the style.css to include your description and activate the template in the admin section.

I am new to BBPress/PHP, there may be better solutions.

[lepardman]

Hello guys!

Im running bbPress 1.0.2 and I’ve changed the default language to Swedish, like this:

define( 'BB_LANG', 'sv_SE' );

And a folder “my-languages” with the .mo/.po-files in bbPress root. Working excellent.

I’m wondering if it’s possible to switch between Swedish and English with a front-end link? So the user him-/herself can change to preferred language.

Cheers and thank you!

Edit: This would be obvious but just to clarify – Don’t mind the language of the topics/posts. The topics are set in respectively language. I’m just looking for a way to translate the static text.

[gfsymon]

I am taken back to the main forum page as well, when I use this plugin. The template/default image, works etc., but I cannot set an image for the avatar.

I’m just setting up BBPress, as a first ever bulletin board and am beginning to think that this software is waaaayyy to complex/geeky. No Avatars on a web-forum software???

Grant

[Raam Dev]

If you’re getting a message that says bbPress is already installed, make sure you’ve done the following:

• Deleted all bbPress files on your site
• Deleted the bbPress database or related tables (likely prefixed with bb_)

Now, you can install a fresh copy of bbPress and run the installation process by visiting the bbpress directory.

Step 1: Use the same database information as you did for your WordPress install (if you’re not sure what you used, check the wp-config.php file).

Step 2: Check all three boxes and fill in the necessary details:

• Add integration settings

(no options)

• Add cookie integration settings

Fill in all of the boxes. You can get the keys and salts from your WordPress wp-config.php and the rest of the settings from the General Settings section in WordPress Admin.

• Add user database integration settings

If you used the default table prefix (wp_) when you installed WordPress, you don’t need to change any of these options.

• Show advanced database settings

(Leave unchecked) If you used your WordPress database information in Step 1 as I explained, you don’t need to check this box.

Step 3: If you did everything correctly, you should get a drop-down box that lets you select the WordPress user that should become the bbPress admin. If you get boxes to create a bbPress admin, you did something wrong in Step 1 or Step 2.

Configuring WordPress

To ensure that logging into WordPress sets all the necessary cookies for using bbPress, you should install the bbPress Integration Plugin and then set the “bbPress URL” option to match the URL to your bbPress forum (Settings -> bbPress Integration).

Also, make sure you add this line to the top of your wp-config.php file, just below <?php:

define( 'COOKIEPATH', '/' );

If you’ve done everything I explained here, single-login should work as expected.