[Kurt Glen]

hey guys its a database problem where the table for posts arent being created any1 have any ideas why? this is the error im getting:

SQL ERROR!

>>> Database: xxxxxxxx (127.0.0.1)

>>>>>> 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

[Kurt Glen]

hey guys its a database problem where the table for posts arent being created any1 have any ideas why? this is the error im getting:

SQL ERROR!

>>> Database: xxxxxxxx (127.0.0.1)

>>>>>> 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

[technomaniacs.co.uk]

I installed bbpress the other day, I then found that when i tried to edit the theme I got error messages, so I reuploaded bbpress, and now i’ve got error messages at the top, http://technomaniacs.co.uk/bbpress/bb-admin/install.php, take a look for yourself. The code is in white at the top so you’ll have to highlight it to read it. Also, when i installed the first time i think these error messages where there then.

How do i fix this?

thanks

[John James Jacoby]

@ryangannon

bbp_reply_author_link( array( 'type' => 'avatar', 'size' => '100' ) );

[John James Jacoby]

@alexvorn2 – Fixed in r2970. Review your ticket for details.

[guppydas]

I may be wrong. I am just a curious user and not very technical as I am not a coder.

Here is what I did and finally all these steps together, worked.

First of all, let me make it clear, I would not try ANYTHING on a site that is online. So I try is on WAMP first. 101% of time this choice is clever choice as I get to see any potential glitches before hand.

I run WAMP on Windows 7

This is what I did, in order to get rid of those annoying errors.

1) Downgrade PHP to 5.2.11 (I could get that for WAMP)

2) As mentioned here, above, changed the bb-load.pbp line 25

3) I also changed(added) the above code to bb-config.php at the end.

Only then I was able to get rid of the errors. Hope this helps.

Cheers!!!

[expose]

I wonder if anyone can help please. I have run an update to a WordPress site (created by someone else) that had bbpress integrated. I didn’t upgrade BBpress. Before the WP upgrade, the forum was working fine. However since the wordpress upgrade (from 2.9.2 to 3.1) we are having the following problems:

1) I cannot access the bbpress admin panel

2) The Forum is showing posts and topics but the reply form is missing (only the heading shows)

3) I cant see any way of creating posts, topics or threads so I presume something else is missing…

I had to rewrite the WordPress theme files as the original custom theme had been so badly coded / core hacked etc. I haven’t touched the custom bbpress theme so thought it would be something to do with that. So first thing I did was disable it and enabled the default bbpress theme (through phpmyadmin) but have exactly the same set of problems – which to me rules out a theme issue.

Anybody have any ideas where to start? Sorry I am not sure of bbpress version. Where do I find that?

[zaerl]

Your question is too generic. In order to add content to your site you must edit template files but you must be skilled with HTML/CSS/PHP.

[zaerl]

Your question is too generic. In order to add content to your site you must edit template files but you must be skilled with HTML/CSS/PHP.

[jnw]

Hi all,

I’m sure this has been covered a few times, but here goes.

Cookies obviously aren’t working, because I’m getting booted out of wp-admin when logged into bbpress and visa versa.

Have installed the bbPress integration plugin with settings in wp-admin like so:

bbPress URL: http://website.com/forum/

Your Plugins URL: http//website.com/forum/bb-admin/plugins.php

Wordpress type: WordPress

Added this code to the very bottom of wp-config.php

define( ‘COOKIEPATH’, ‘/’ );

In bb-admin, I’ve got:

Wordpress address: http://website.com

Blog address: http://website.com

WordPress “auth” cookie salt: (auth_salt wasn’t present in the wp admin page, anyway I took the code from wp-config.php)

WordPress “secure auth” cookie salt: (as above)

WordPress “logged in” cookie salt: (as above)

Manually entered codes so the following match

AUTH_KEY / BB_AUTH_KEY

SECURE_AUTH_KEY / BB_SECURE_AUTH_KEY

LOGGED_IN_KEY / BB_LOGGED_IN_KEY

And that’s where I’m at. Can someone tell me what I’m missing?

I’m not going to worry about database sharing right now – is that advisable? Or is it highly recommended?

Also what should I have the wordpress roles set to for each one of these?

WordPress Administrator

WordPress Editor

WordPress Author

WordPress Contributor

WordPress Subscriber

Thanks for the help!

[1onely]

where are you ?

[1onely]

where are you ?

[Rodney]

Thanks ajz! You rock! I was looking all over for that text

[Rodney]

Thanks ajz! You rock! I was looking all over for that text

[_ck_]

There is a security bulletin being circulated this week about a “path disclosure” bug in bbPress 1.0.3 – it actually affects all versions.

It’s not a super-serious security bug in itself but it can be used to gain leverage.

Basically someone can discover the real path your files are in by causing a PHP error by trying to access a template file directly, where there is an error in the template because bbPress is not loaded at that time.

Here is a simple workaround for users on Apache (vast majority of users).

Make a file called .htaccess (note the dot at the start)

in it, put this line

php_flag display_errors off

Then upload that file to bb-templates and my-templates

The reason why we don’t put that in the master .htaccess file for all of bbPress is because you may need to see any regular errors in the future. However for the template subdirectories, there is no need because those files are never (supposed to be) loaded directly by the browser.

[WPsites]

Just thought I would update this post as nothing seems to have been said about the threaded posts plugin recently (https://bbpress.org/plugins/topic/threaded-posts/)

I’m in the process of setting up a forum and one of the requirements was for threaded posts so I have used this plugin.

I have it installed on the most recent version of BBpress (“Bechet” version 1.0.3) and on it’s own it works fine.

To get it to work I did have to follow the comments on the info page for this plugin. Pretty much just changed some file names.

If you want to use the threaded post plugin along with the BBpress moderation suite then you will run into problems when you come to moving and splitting threads since the moderation suite doesn’t know anything about the threaded post functionality and just cannot deal with it. So you will have your work cut out trying to hack the moderation suite to take into account the threaded posts (it is doable though).

Also the threaded post plugin may fail to list the threaded posts correctly if used in conjunction with other plugins that change the mysql query for displaying posts on the topic page. Since this plugin checks EVERY database query and if it matches what the plugin thinks is a request to display all posts from a topic then it intervenes and add something extra to the query to list the threaded posts in the right place.

As part of that, in the code for this plugin it actually says “# FIXME: This is a horrible horrible hack” in the no_child_posts function. Well I had to fix it in order for it to play nicely with some private forum functionality that changes the mysql query when requesting posts for a topic. The code I created that replaces the no_child_posts functionality is below.

function threaded_sql_where($where){

return $where . ” AND pp.post_id is NULL “;

}

add_filter(‘get_thread_where’, ‘threaded_sql_where’, 10, 1);

function threaded_sql_join(){

return “LEFT JOIN bb_post_parent AS pp ON pp.post_id = p.post_id”;

}

add_filter(‘get_thread_join’, ‘threaded_sql_join’, 10, 1);

You can download my modified version of the threaded posts plugin here: http://www.wpsites.co.uk/threaded_posts.zip

[shinigami87]

I solved thanks this topic: https://bbpress.org/forums/topic/wp-integration-coockie-does-not-work

I moved wordpress from “/wordpress” to the root and cookies integration now works!

[shinigami87]

I solved thanks this topic: https://bbpress.org/forums/topic/wp-integration-coockie-does-not-work

I moved wordpress from “/wordpress” to the root and cookies integration now works!

[ajz]

In functions.bb-template.php on line 311.

Hope this helps.

[ajz]

In functions.bb-template.php on line 311.

Hope this helps.

[Rodney]

Anyone have any ideas?

[Rodney]

Anyone have any ideas?

[John James Jacoby]

@tooltrainer – Closed topic issue is now fixed. Favorites and subscriptions should be viewable in your profile, and subscriptions trigger email messages on new replies. If these aren’t working for you, are normal WP emails working?

@yutt – If you want it out sooner, lend us a hand.

@darkwolf.it – Signature could possibly have room in bbPress core, since it’s an often requested feature and popular plugin. Will consider it.

[shinigami87]

Hi there!

I’m an italian user, so sorry for my bad english.

I’m a WordPress’ user since some years and I love it!

I have found bbpress searching an alternative forum for my site (actually I use phpBB).

Testing bbpress and wordpress integration I have a problem with the login…

If I login/logout in bbpress, automatically login/logout in wordpress works, but not the reverse…

If I login in WordPress, I’m not logged in in bbpress…

I have tested it in local with this configuration:

Wordpress folder: /wordpress

BBpress folder: /forum

in wp-config.php:

define(‘AUTH_KEY’, ‘<I;b3RJ:>Fu6.?*uJhfh UUBWA)MRP+.t}q,3dunpj+a!He329#;i,^:Aj~|7tDB’);

define(‘SECURE_AUTH_KEY’, ‘ytd&KN0gfMto{0>i0U7:9]R*%tc5gt/B89wVabirZUNASo1Xw@)F63Nofs7#[7′);

define(‘LOGGED_IN_KEY’, ‘lS!u]1H=nf=+-/@t.p+15OrfWljzI8&e&-.hs|HE?rH9@&[{t`/1Z0AEl22/~{‘);

define(‘NONCE_KEY’, ‘){P:2X}-s[v7PSqS)^%AL<&u)_Qpg,7AtSeN-x:}/SHr–RYq-G hG:8vM9dB8|L’);

define(‘AUTH_SALT’, ‘u2L_v<Prb:`Zr. 9UmDmbkc4d=L[C6NV}(nj<7[%]q|debm4sA,O9f]Y%,(&A7)3’);

define(‘SECURE_AUTH_SALT’, ‘#x9M#;SAy*nnW4QY{; 9l^s1:4Q]glup}NN]/9gX1W2va1{ 2QG7TiE};)rsZj12’);

define(‘LOGGED_IN_SALT’, ‘|2vq/Z6S53Z>*U^2(&kVc`F{d:7QGu[|J(@WJU<uKx:SXA+zx?<.qkM=#-m_V9F.’);

define(‘NONCE_SALT’, ‘<3sR0o>)<!sElq(|DW=s:FqL|XJ_Venp4Flp&K*|FGF(*klrdZ6&7W;uo>lz)7TK’);

in bb-config.php:

define(‘BB_AUTH_KEY’, ‘<I;b3RJ:>Fu6.?*uJhfh UUBWA)MRP+.t}q,3dunpj+a!He329#;i,^:Aj~|7tDB’);

define(‘BB_SECURE_AUTH_KEY’, ‘ytd&KN0gfMto{0>i0U7:9]R*%tc5gt/B89wVabirZUNASo1Xw@)F63Nofs7#[7′);

define(‘BB_LOGGED_IN_KEY’, ‘lS!u]1H=nf=+-/@t.p+15OrfWljzI8&e&-.hs|HE?rH9@&[{t`/1Z0AEl22/~{‘);

define(‘BB_NONCE_KEY’, ‘){P:2X}-s[v7PSqS)^%AL<&u)_Qpg,7AtSeN-x:}/SHr–RYq-G hG:8vM9dB8|L’);

define(‘BB_AUTH_SALT’, ‘u2L_v<Prb:`Zr. 9UmDmbkc4d=L[C6NV}(nj<7[%]q|debm4sA,O9f]Y%,(&A7)3’);

define(‘BB_SECURE_AUTH_SALT’, ‘#x9M#;SAy*nnW4QY{; 9l^s1:4Q]glup}NN]/9gX1W2va1{ 2QG7TiE};)rsZj12’);

define(‘BB_LOGGED_IN_SALT’, ‘|2vq/Z6S53Z>*U^2(&kVc`F{d:7QGu[|J(@WJU<uKx:SXA+zx?<.qkM=#-m_V9F.’);

define(‘BB_NONCE_SALT’, ‘<3sR0o>)<!sElq(|DW=s:FqL|XJ_Venp4Flp&K*|FGF(*klrdZ6&7W;uo>lz)7TK’);

Please, help me!

[Luzifull57]

yess Ok Thankss!

____________________

In the world of sbobet filled with an extremely fun game is the winner of the world does not believe, try to touch the sbobet

then you’ll know.