[startribe]

it appears that my options page is not making changes to the plugin. Hmmm, I checked the plugin file, and it looks like the changes I made are still set to the defaults.

[boomanfloral]

Hi,

I just installed bbPress and on STEP TWO I got a screen with the error below. I’m not a programmer or anything, I just know basic HTML and that’s it, so I don’t know where to look for a way to fix this. Can anyone give me some pointers on how to fix this? Or is there a service where I can pay to have this fixed and running smoothly? Thanks!

bbPress database error



Second Step



Now we’re going to create the database tables and fill them with some default data.



bbPress database error: [Access denied for user 'boomanfloral'@'localhost' to database 'mysql']

CREATE TABLE bb_forums ( forum_id int(10) NOT NULL auto_increment, forum_name varchar(150) NOT NULL default '', forum_desc text NOT NULL, forum_order int(10) NOT NULL default '0', topics bigint(20) NOT NULL default '0', posts bigint(20) NOT NULL default '0', PRIMARY KEY (forum_id) )



bbPress database error: [Access denied for user 'boomanfloral'@'localhost' to database 'mysql']

CREATE TABLE 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_id (topic_id), KEY poster_id (poster_id), KEY post_time (post_time), FULLTEXT KEY post_text (post_text) ) TYPE = MYISAM



bbPress database error: [Access denied for user 'boomanfloral'@'localhost' to database 'mysql']

CREATE TABLE bb_topics ( topic_id bigint(20) NOT NULL auto_increment, topic_title varchar(100) NOT NULL default '', topic_poster bigint(20) NOT NULL default '0', topic_poster_name varchar(40) NOT NULL default 'Anonymous', topic_last_poster bigint(20) NOT NULL default '0', topic_last_poster_name varchar(40) NOT NULL default '', topic_start_time datetime NOT NULL default '0000-00-00 00:00:00', topic_time datetime NOT NULL default '0000-00-00 00:00:00', forum_id int(10) NOT NULL default '1', topic_status tinyint(1) NOT NULL default '0', topic_open tinyint(1) NOT NULL default '1', topic_last_post_id bigint(20) NOT NULL default '1', topic_sticky tinyint(1) NOT NULL default '0', topic_posts bigint(20) NOT NULL default '0', tag_count bigint(20) NOT NULL default '0', PRIMARY KEY (topic_id), KEY forum_id (forum_id), KEY topic_time (topic_time), KEY topic_start_time (topic_start_time) )



bbPress database error: [Access denied for user 'boomanfloral'@'localhost' to database 'mysql']

CREATE TABLE bb_topicmeta ( meta_id bigint(20) NOT NULL auto_increment, topic_id bigint(20) NOT NULL default '0', meta_key varchar(255) default NULL, meta_value longtext, PRIMARY KEY (meta_id), KEY user_id (topic_id), KEY meta_key (meta_key) )



bbPress database error: [Access denied for user 'boomanfloral'@'localhost' to database 'mysql']

CREATE TABLE bb_users ( ID bigint(20) unsigned NOT NULL auto_increment, user_login varchar(60) NOT NULL default '', user_pass varchar(64) NOT NULL default '', user_nicename varchar(50) NOT NULL default '', user_email varchar(100) NOT NULL default '', user_url varchar(100) NOT NULL default '', user_registered datetime NOT NULL default '0000-00-00 00:00:00', user_status int(11) NOT NULL default '0', display_name varchar(250) NOT NULL default '', PRIMARY KEY (ID), UNIQUE KEY user_login (user_login) )



bbPress database error: [Access denied for user 'boomanfloral'@'localhost' to database 'mysql']

CREATE TABLE bb_usermeta ( umeta_id bigint(20) NOT NULL auto_increment, user_id bigint(20) NOT NULL default '0', meta_key varchar(255) default NULL, meta_value longtext, PRIMARY KEY (umeta_id), KEY user_id (user_id), KEY meta_key (meta_key) )



bbPress database error: [Access denied for user 'boomanfloral'@'localhost' to database 'mysql']

CREATE TABLE bb_tags ( tag_id bigint(20) unsigned NOT NULL auto_increment, tag varchar(200) NOT NULL default '', raw_tag varchar(50) NOT NULL default '', tag_count bigint(20) unsigned NOT NULL default '0', PRIMARY KEY (tag_id) )



bbPress database error: [Access denied for user 'boomanfloral'@'localhost' to database 'mysql']

CREATE TABLE bb_tagged ( tag_id bigint(20) unsigned NOT NULL default '0', user_id bigint(20) unsigned NOT NULL default '0', topic_id bigint(20) unsigned NOT NULL default '0', tagged_on datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (tag_id,user_id,topic_id), KEY tag_id_index (tag_id), KEY user_id_index (user_id), KEY topic_id_index (topic_id) )



1. Created table bb_forums

2. Created table bb_posts

3. Created table bb_topics

4. Created table bb_topicmeta

5. Created table bb_users

6. Created table bb_usermeta

7. Created table bb_tags

8. Created table bb_tagged



bbPress database error: [Table 'mysql.bb_topicmeta' doesn't exist]

SELECT * FROM bb_topicmeta WHERE topic_id = '0' AND meta_key = 'bb_db_version'



bbPress database error: [Table 'mysql.bb_topicmeta' doesn't exist]

INSERT INTO bb_topicmeta ( topic_id, meta_key, meta_value ) VALUES ( '0', 'bb_db_version', '688' )



bbPress database error: [Table 'mysql.bb_users' doesn't exist]

INSERT INTO bb_users (user_login, user_pass, user_email, user_url, user_registered) VALUES ('daniel', 'fae46cfefe5fb87eedf6f8801e497d06', 'daniel@boomanfloral.com', 'http://boomanfloral.com', '2007-03-14 22:01:31')



bbPress database error: [Table 'mysql.bb_usermeta' doesn't exist]

SELECT * FROM bb_usermeta WHERE user_id = '1' AND meta_key = 'from'



bbPress database error: [Table 'mysql.bb_usermeta' doesn't exist]

INSERT INTO bb_usermeta ( user_id, meta_key, meta_value ) VALUES ( '1', 'from', 'Vista, CA' )



bbPress database error: [Table 'mysql.bb_usermeta' doesn't exist]

SELECT * FROM bb_usermeta WHERE user_id = '1' AND meta_key = 'interest'



bbPress database error: [Table 'mysql.bb_usermeta' doesn't exist]

INSERT INTO bb_usermeta ( user_id, meta_key, meta_value ) VALUES ( '1', 'interest', 'Unusual Plants & Internet' )



bbPress 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 ' '', , '', '2007]

INSERT INTO bb_topics (topic_title, topic_poster, topic_poster_name, topic_last_poster, topic_last_poster_name, topic_start_time, topic_time, forum_id) VALUES ('Your first topic', , '', , '', '2007-03-14 22:01:31', '2007-03-14 22:01:31', 1)



bbPress database error: [Table 'mysql.bb_topics' doesn't exist]

SELECT * FROM bb_topics WHERE topic_id = 0 AND topic_status = 0



bbPress database error: [Table 'mysql.bb_forums' doesn't exist]

UPDATE bb_forums SET topics = topics + 1 WHERE forum_id = 1



bbPress database error: [Table 'mysql.bb_topics' doesn't exist]

SELECT * FROM bb_topics WHERE topic_id = 1 AND topic_status = 0



Finished!

[wittmania]

I have recently integrated a bbpress install with an existing wordpress blog/site. The WP blog had three users prior to the integration, and all three made it over to the bbpress install with no problems. However, today a new user registered on the WP side and her ID defaulted to 999999999.

I proceeded to register a “dummy” user, just to see what happened. The next registration ticked up to user ID #1000000000. While I doubt that this will lead to any serious problems, it seems silly to me to have user IDs starting around ONE BILLION, when even 1,000 would be plenty high enough for my lil’ ol’ site. Having McDonald’s-esque “XX billions served” sized numbers seems to fly in the face of the “Code is poetry” mantra.

Any ideas as to what’s going on here?

[Trent Adams]

As long as your wordpress default user role is subscriber, it should be working…hmm. If not, maybe post a comment on that plugin in the bbpress.org/plugins/ repository. I am pretty sure it should work that way.

Trent

[Trent Adams]

I don’t think the way the default system calls the favorites changing will happen anytime soon, but a plugin would definetely work to pull that information from the database in the way you want…..just need a plugin author to take this on!

Trent

[fel64]

Very simple way to softly resize your images: go to your theme’s folder, open style.css, and copy in this code at the bottom:

img {

max-width: 600px;

max-height: 800px;

}

You can change this to any values you like, but I think 600px width works with the default theme at least. Make sure there are no spaces between the number and the px. If you don’t care about height you can just take that line out. Any bigger images will be scaled down automatically – they will still load at full resolution/size, but they will display smaller.

[Trent Adams]

You would need to edit your template files to get rid of all the places that tags show up. If you are using the default theme, the best thing would be to edit all the files that need editing and upload them to a new folder /my-templates/themename/ as that will allow you to edit the files that you need without doing anything to the themes in /bb-templates/. Any file in the folder inside /my-templates/ will be read and if it doesn’t exist there, it uses the originals in /bb-templates/.

Off thet top of my head, it would require editing the following files:

front-page.php

topic.php

forum.php (to get rid of the place to create topic and tags)

new-topic.php

There might be more and I might be off on the names, but just comment out <! — and –> around any code that deals with the tags.

Trent

[fel64]

Judging by the wordpress system (the documentation is quite good), 10 is default priority and plugins are executed in order of descending priority (so a plugin of 1 comes before 2). In WP the last two arguments are optional.

Preview sounds good – but better yet would be an AJAX thing that means you don’t even have to reload the page when you post.

[macwise]

Kannued,

I looked closer at your css…is there a reason why everything is position:absolute;? When I took out the position: absolute, the input boxes were fine…Once again, this is a bit dicey because IE isn’t showing me the full page, (no images showing up, etc). I’m not sure why I can’t see the full thing in IE, and everything works fine in Saf.

In my experience with CSS, position absolute should be the exception, not the rule. It can usually be used extremely sparingly, and you can often if not always get by with the default, which is position: relative. Using floats, relative positioning, proper clearing, etc, and then applying margins and padding to create the proper spacing you’d like, there isn’t much you CAN’T do in regards to layout.

Position: absolute creates a lot of potential problems because it takes those absolute elements out of the document flow. This causes many issues just like the one you’re facing.

I think if you retool your page to reflect a more standard design approach, (ie changing abs. positioning to relative and making that work), then you’ll see a huge difference.

If you can’t make a go of it, you can send me over your template folder and I can activate it and really get to the root of it. Like I said earlier, my hands are somewhat tied here with IE.

[kannued]

Hello Ron

The encapsulating of the label is in the default for version 75. It was not something I modified.

[marky]

I noticed there are a lot of changes to the default theme in this security update. My custom theme was heavily based on the default; will I somehow have to locate and propagate these changes to my custom theme? Or were the changes merely cosmetic?

[Trent Adams]

You can define the parameters like the cookie name and domain, so you should be able to do what you want here. There is already functions though that can do things if a user is logged in. For example:

<?php if (bb_current_user_can('write_posts')) : ?>

DO SOMETHING

<?php endif; ?>

This has it so if the user is logged in and can write posts (default member) then do something or put in a piece of code.

Hope that helps.

Trent

[ccmve]

I can’t use a custom these after upgrading to 0.8.1.

Under the presentation tab it lists my custom theme, but with this URL:

http:// forum.mybbpress.com/bb-admin/themes.php? theme=C:\WWW\PUBLIC\forums.mybbpress.com/ bb-templates/mytheme/&_wpnonce=36ec0251eb

How can I eliminate the extra slashes and the reference to the absolute path?

The default theme is working, and it works great, but I’d like to be able to use my custom theme again!

[Trent Adams]

I don’t know if I fully understand. You have your own template in /my-templates/kakumei2/ and that is all you should have to do. If that is your ‘bug free’ version of default theme, then you don’t have to copy over the default theme to /my-templates/ as it is the constant one that changes (hopefully bug free) into /bb-templates/kakumei/ and you shouldn’t worry about that one. Just the templates that you work on or change in your /my-templates/ directory.

Trent

[ccmve]

I’m having a similar problem.

I’ve uploaded my custom theme to /my-templates/mytheme

The default theme is in /bb-templates/kakumei/

The site is working fine, but I see this error: “Theme not found. Default theme applied.” And I cannot switch to my custom theme. The reason is in the URL to the custom theme in the presentation>themes panel:

http:// forum.mybbpress.com/bb-admin/themes.php? theme=C:\WWW\PUBLIC\forums.mybbpress.com/ bb-templates/mytheme/&_wpnonce=36ec0251eb

Obviously that URL won’t work. I’ve uploaded both plugins above. Neither worked. How do I fix the URL to mytheme?

[fel64]

While it sounds like somewhat useful functionality, I don’t want it – if it was enabled by default in bbPress, I’d even want to turn it off. Anything that means users can just visit once, know that they’re going to get any answers and never have to come back is that you’re going to get a lot of users who do just that. I would much rather they check regularly, sometimes see something that catches their eye and hang around … It just sounds like a feature that hinders a community building up.

[Fakey]

Oh no, quite the contrary. The results are shown fine too. The problem is when the titles are show a local variable $topics is created:

<?php

foreach ( $titles as $topic ) :

$count = $topic->topic_posts;

?>

This is all fine and dandy, but, as you can see, $topic is a local variable and won’t be any use further down the page when the code checks whether results have been returned or not.

I hope I’m making myself clear. Let me reiterate just for kicks: The title results show up fine, but the php code prints “No results found.” as well. Just change $topics to $titles in the following code in the template file “search.php”:

<?php if ( !$topics && !$recent && !$relevant && !$users) : ?>

<?php _e('No results found.') ?>



<?php endif; ?>

[FCB]

So i think the database field title is not included in the search ?

[Fakey]

After a search for a word that appears only in the topic title (but not the tags, nor post content) the results are listed, followed by:

No results found.

This is because the if statement is looking for the local variable $topics, instead of the correct variable $titles.

It’s a small fix, but I didn’t know how to post on the bbPress bugtracker.

[AphelionZ]

How difficult would it be to create a plugin that allows users to be able to post under different names for different posts? They could have a maximum number (let’s say 5) of options, and they could select at post-time with their default name pre-selected.

[intellivision]

Null, I couldn’t get this to work. I experienced the same issues as suleiman. I looked at your SQL, and found some errors involving your column names: you’re using mySQL keywords as column names, like “set”.

I tried

CREATE TABLE bb_menu(

sett varchar( 50 ) NOT NULL default ”,

item varchar( 50 ) NOT NULL default ”,

page varchar( 50 ) NOT NULL default ”,

location varchar( 50 ) NOT NULL default ”,

orderr int( 9 ) NOT NULL default ‘0’,

PRIMARY KEY ( sett, item )

but still got an error:

MySQL said: Documentation

#1064 – 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 ” at line 7

Notice I changed “set” to “sett” and “order” to “orderr”. I think you’re on the right track tho. Let me know if I can help further. I’ll check this thread periodically because I’d like to see this plugin work.

[linickx]

I’ve seen lots of posts requesting this functionality, but couldn’t find any plugins. Well I’ve had a go at porting Jeff Moore wordpress plugin, not all bbcode tags work as the markup isn’t allowed by default within bbpress, but it’s a start !

Download Here.

Blog Post.

[phery]

just in case you’d like to move the hottags to the top:

seperate #frontpage and #hottags in the css and change the pos. from absolute to relative.

[netsleds]

I do have the template files in /my-template/ folder (I even put them in the default template directory too), I am using mod-rewrite, and when I initially set up the pm plugin, the database did not install, so I grabbed the query from the bb-privatemessage.php file to create the bb_privatemessage table and when I ran the query it gave me an error with the “message” column saying

“#1074 – Too big column length for column ‘message’ (max = 255). Use BLOB instead”

So I set it to BLOB and Even tried LONGTEXT. I don’t see if it would make a difference or not, but maybe that is why?

[marky]

If you visit http://bbpress.org/forums/bb-login.php and use the top-most login form (the one in header.php), a recursive redirect occurs, which displays an error message in Safari. (I haven’t tested it in other browsers.)

This happens in all bbPress installations using the default template (and a few other templates that include the login form in the header). Is there a way to avoid this situation?