[fel64]

You have to enter the right password and username in config.php to your databases.

I don’t know what Yahoo Webhosting entails, but unless it says MySQL tables somewhere you can’t use it. You need hosting that allows you to create MySQL databases, and they should be able to tell you your details to log into that.

[boomanfloral]

Thanks for the advice!

I’m using Yahoo Webhosting Services. I looked around, and I don’t see where to change those ‘permissions’ Does anyone know?

Thanks again!

daniel

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

[chrishajer]

So, it sounds like this is related to the conversion from phpBB. At least that narrows it down.

In phpMyAdmin, select the table (be that bb_users or wp_users) and then select the “operations” tab up top. On that page, near the bottom are “Table options:” and in there is a field that says [ xxx ] auto_increment where the xxx is the next auto_increment value that will be used. That’s where you would change it.

You should first figure out what that value should be, and you should also fix the other high numbered users. But that’s where you reset it with phpMyAdmin. *** Perform at your own risk. ***

You can also just do it with SQL:

ALTER TABLE 'wp_users' AUTO_INCREMENT =whatever-number

The wp_users tablename might be bb_users or something else in your install. Also, the table name should be backticked, but you can’t do that in a block of code that’s already backticked here

[Michael Nolan]

It also works quite nicely using:

onclick="this.disabled=true"

But I can’t get it to re-enable on pressing back – when there is no message for instance. I’ve tried onload="$('postformsub').disabled=false" in the body (we’re using Prototype) but it doesn’t seem to do anything. Is there another event that I’m forgetting that is called when the page is reloaded via the back button?

[spencerp]

Do you have any issues transitioning from a desktop environment to a server environment (as I did, with MySQL and PHP versions and configs and such)?

To tell you the truth, I didn’t have any issues going from my Xampp Lite localhost copies, straight to my live servers. I just find it odd though that this whole time of running that bbPress on the localhost, and just applying the SVN updated files from time to time. It was fine..

It was only when I installed it fresh, with the latest copies of Trunk that it gave me this problem. I SVN CO the trunk on my other new domain via SSH and it went smoothly… no troubles though, I guess that’s to be expected. Hmm.. I’ll have to look into the problem a little deeper.

I’m trying to when I have the time, but with being so busy.. it’s hard taking a gander at it…sigh.

How about installing a linux distro in house since your server is linux also?

Geesh, didn’t even think of that, or try it. Thanks for that, I’ll have to give it a go then.

spencerp

[fel64]

Chris, lovely code, works straight away. Implemented in my forum, the button instantly disappears and double-posting is impossible. Thanks a lot!

If anyone else wants to implement this but is unsure how, go to your theme (or Kakumei?) and open post-form.php using Notepad.

Find the line that says:

<input type=”submit” id=”postformsub” name=”Submit” value=”<?php echo attribute_escape( __(‘Send Post »’) ); ?>” tabindex=”4″ />

and change it to

<input type=”submit” id=”postformsub” name=”Submit” value=”<?php echo attribute_escape( __(‘Send Post »’) ); ?>” tabindex=”4″ onclick=”this.style.display=’none’;” />

(Could someone please add the overflow: auto property for posts in this theme’s CSS? It’s incredibly inconvenient for code running over several lines.)

[chrishajer]

Here is the JS I was thinking of. It would be added to the submit button input element:

onclick="this.style.display='none';"

I have no idea if that will work I just read it on the Internet. There are lots of hits in Google if you’re curious. In my experience, once people do it a few times, they realize it just takes a couple seconds to appear, so they become more patient and avoid double posting.

[chrishajer]

You could disable it just to see if that’s the problem. In addition to removing or modifying the .htaccess file, you need to set

$bb->mod_rewrite = false;

in your config. That will turn off the rewriting completely. Both need to be working for the pretty permalinks to work (i.e. the .htaccess is present, and the $bb->mod_rewrite = true. It doesn’t work on all servers though. Oddly, it works for my WordPress just fine, but not for bbPress which is in a subdirectory, so I have mine set to false for bbPress.)

I would disable it for now, just to see if that’s causing your problem.

[wittmania]

From doing a quick search in Dreamweaver for bb_option, I found several different parameters that can be passed to the bb_option() function, as listed below:

1. version
2. uri
3. admin_email
4. name
5. path

I’m sure there are more, but I don’t know what they would be. Also, for this specific application you could just hard-code in your site’s uri, and the only dynamic portion would be the number tacked onto the end. But, since code is poetry, the bb_option() method seemed much more poetic to me.

As for the get_post_author_id() function, I think I just scrounged around in other files (including plugins) until I found one that looked like it would work. And it does.

[spencerp]

Here’s one site’s informations:

http://spencerp.net/blah.php

Yeah, I’ve played on the live environments before. Sub domains and such. However, I’m also on crap dial-up connections and don’t always have time to be online. Also, since there is only ONE phone line in the house and the family using the line .. it sucks.

But this issue wasn’t that bad before, it just started up I think the past few times of fondling the bbPress software. They need to fix this shit, and once it’s working good.. leave it the hell alone! LoL!

spencerp

[fel64]

Oh yes, I forgot about that. Sorry.

This should work only in posts:

.post img {

max-width: 600px;

max-height: 800px;

}

I think the max-dimension doesn’t work in Internet Explorer, not sure how much that bothers you? You can additionally add:

.post {

overflow: auto;

}

so that images larger than your post area will not break the layout but simply have a scrollbar at the bottom to navigate it.

[fel64]

Chrishajer, a neater version of your code is:

.post {

overflow: hidden;

}

I suspect although I haven’t tried it.

What I use is

.post {

overflow: auto;

}

which annoyingly is not the automatic setting … what it does is wrap text normally unless text/links are really long, in which case it displays a scroll bar at the bottom of the post. Works a treat for images, too. Also good for code which isn’t wrapped.

[fel64]

Never click their links – they’ll be able to see where the clicks come from, and if they get traffic from here they’ll try again Copy and paste the URL into the browser if necessary.

[fel64]

Thanks a lot for posting it here afterwards. What other bb_options are there/where did you find them?

[wittmania]

I searched for this and didn’t find anything, but by scrounging through the code I found the necessary functions to make it work. I long for the day when the tags/functions in bbpress are documented like they are in WP.

At any rate, I don’t really care for the “Title” line under a post author’s name, and I wanted to replace it with a simple link to the post author’s profile instead. The code I used was:

<a href="<?php bb_option('uri'); ?>profile.php?id=<?php echo (get_post_author_id()); ?>">View Profile</a>

I added this in post.php, where the <?php post_author_title(); ?> line had been inside the threadauthor div.

I’m so proud of myself, I think I’ll go have a snack!

[flaerpen]

if you have a really long link it’s a problem

I have that problem actually..

[Michael Nolan]

Change your template to set a limit on the number of tags:

<?php tag_heat_map(array('limit'=>10)); ?>

[spencerp]

Just a note, and it would be nice if this was FIXED in core soon please! I currently just did a fresh install of the TRUNK on localhost, and have the same problem as Kirkk here:

https://bbpress.org/forums/topic/700?replies=36#post-4849

Stylesheet URL is this:

<link rel="stylesheet" href="http://localhostforum/bb-templates/kakumei/style.css" type="text/css" />

That plugin Trent posted is applied, and is NOT working… Please, fix this issue soon guys.. And by the way, no, my localhost copy of the forums are still borked.. >_<

And course! My config.php file settings are right.. I’ve done this numerous of times before.. wheee! Even used the original config.php file from before, when it was installed before and working.. she still borked regardless sigh..

spencerp

[john001]

hi dear, you must go to php.net, they people always have good samples code there. for more detail you must visit http://www.webdesigningcompany.net

[chrishajer]

Are your words really that long? I know long words will do that, but with shorter length words, they wrap normally, normally.

Do you have an example with real, not fake, text? Or an example URL where one can see the actual layout and CSS being used?

Maybe you can do something like this in the CSS:

.post {

overflow-x: hidden;

overflow-y: hidden;

}

[fel64]

If you log in incorrectly it should take you to the ‘incorrect login’ page. It should always do this.

Otherwise, force refresh by pressing Ctrl + F5. I found it an annoyingly simple solution when I was accessing the forums from somewhere other than the usual and I just couldn’t log in – turns out I was always logging in and it just cached the old, unlogged-in version of the page.

They don’t have to be in the same folder, I for example have got them in different subdomains and have no problem.

[Trent Adams]

This is a setting in your config.php, but if you are interested in limiting discussion based on time, check out this plugin:

https://bbpress.org/plugins/topic/21?replies=1

Otherwise:

// The number of topics that show on each page.

$bb->page_topics = 30;

Trent

[wittmania]

OK… so I do have access to phpMyAdmin, which may not be such a good thing.

Somehow I got some things crossed up so I am now getting these messages from within the wp_users table:

!!! PRIMARY and INDEX keys should not both be set for column ID

!!!More than one INDEX key was created for column ID

!!!UNIQUE and INDEX keys should not both be set for column user_login

Here is the raw text of the indexes from that page:

Indexes:

Keyname Type Cardinality Action Field

PRIMARY PRIMARY 5 Edit Drop ID

user_login UNIQUE 5 Edit Drop user_login

user_login_key INDEX None Edit Drop user_login

ID_2 INDEX None Edit Drop ID

ID_3 INDEX None Edit Drop ID

ID_4 INDEX None Edit Drop ID

This is a longshot, but can you tell what I messed up, and how I should fix it? Sorry. I really appreciate the help.

While I wait for a response I will be banging my head against my desk for not backing up the DB before I started messing around with it.

[CMoseley]

Does this still work anymore in bbPress 8.2?

When I went to modify the functions.php as requested in the top thread, I didn’t find a seemingly logical place to put the code.

Between lines 1382 and 1394:

$topics = array_flip((array) $bbdb->get_col("SELECT topic_id, COUNT(*) FROM $bbdb->tagged WHERE tag_id = '$tag_id' GROUP BY topic_id"));

$counts = (array) $bbdb->get_col('', 1);

if ( $tags = $bbdb->query("DELETE FROM $bbdb->tagged WHERE tag_id = '$tag_id' AND user_id = '$user_id' AND topic_id = '$topic_id'") ) :

if ( 1 == $counts[$topics[$topic_id]] ) :

$tagged = $bbdb->query("UPDATE $bbdb->tags SET tag_count = tag_count - 1 WHERE tag_id = '$tag_id'");

$bbdb->query("UPDATE $bbdb->topics SET tag_count = tag_count - 1 WHERE topic_id = '$topic_id'");

$bb_cache->flush_one( 'topic', $topic_id );

if ( 1 == count($counts) )

$destroyed = destroy_tag( $tag_id );

endif;

endif;

return array( 'tags' => $tags, 'tagged' => $tagged, 'destroyed' => $destroyed, 'sig' => array(0, __('Signature')) );

}

I put it on the second to last line, but somehow I don’t think this is correct as its not working .

When I go to my profile page, there is no option to input a signature of any sorts, so obviously I can’t have a signature show up.

Any help would be much appreciated.