[Inquirer]

I am new to this forum.

I had a corrupted bbPress forum install.

I have to drop the bb_ tables and do a reinstall.

Hopefully, it is ok if I post this.

My web hosting servers are Unix.

The servers have php v 4.4.0 installed

phpMyAdmin isn’t installed

Apparently, I have to download phpMyAdmin 2.10.2.tar.tz

It is unclear from my web hosting service support if I should

place phpMyAdmin 2.10.2.tar.tz in the public_html directory.

Should I create a directory phpAdmin?

I am running Windows 2000 Professional on my computer.

Then I should download and use PuTTY: A Free Telnet/SSH Client to telnet to my server.

Then use a command to unbundle the phpMyAdmin 2.10.2.tar.gz file

Then access my php database

issue the command show tables

then the command drop bb_ tables which are the bbPress tables

then try a reinstall of bbPress forum software

[Trent Adams]

Best bet would be for you host to install it for you since that is what almost 100% of good hosts do.

Trent

[Inquirer]

[Best bet would be for you host to install it for you since that is what almost 100% of good hosts do.]

Then I don’t have a good web hosting service.

I am reading through phpAdmin Quick Install at

http://wiki.cihar.com/pma/Quick_Install

I received the following from my web hosting support.

<public_html IS your document root.

MySQL v. 4.0.25 is running on my server

PHP Safemode is off by default.>

<You can also login to the server via ssh and connect to the database from a shell prompt.>

I installed WinSCP to login to my server via SSH.

Can I access my php database through Console using the WinSCP?

In other words, is phpAdmin a more friendly interface access my php database?

[Trent Adams]

For sure, it is a really easy user friendly interface. You don’t have WP installed somewhere do you? There is a plugin that adds the newest phpMyAdmin as an admin page for WP. Lifesaver for me since I don’t like logging into my host admin and then phpMyAdmin and then working. I just login to WP and do what I want.

Trent

[Inquirer]

Hi Trent:

[You don’t have WP installed somewhere do you?]

Actually, I installed WordPress blog 2.2 first. It installed on the first try.

I have WordPress 2.2 installed in my public_html directory.

I haven’t customized or begun blogging with WordPress blog 2.2 yet.

I decided to use bbPress for my forum Discussion software, but the install failed.

I want to set it up and implement it first.

[There is a plugin that adds the newest phpMyAdmin as an admin page for WP. Lifesaver for me since I don’t like logging into my host admin and then phpMyAdmin and then working. I just login to WP and do what I want.]

What is the plugin?

Where is the plugin download?

Is it tricky installing the phpMyAdmin plugin?

If I go this route do I have to or should I integrate WordPress 2.2 with bbPress?

Thanks.

[Trent Adams]

You will be able to find a link to the plugin off this page:

http://www.silpstream.com/blog/

It is really easy to install. Just read the readme.txt that is included for directions. If you plan on integrating WP and bbPress, it is best to have a running copy of WP up and going. Then just install your bbPRess in the same database as WP. WordPress will have the database prefix of wp_ and bbPress with bb_

If you have WP running, just install bbPress in the same database.

Trent

[Inquirer]

[If you plan on integrating WP and bbPress, it is best to have a running copy of WP up and going.]

I already have WordPress up and running.

[Then just install your bbPRess in the same database as WP. WordPress will have the database prefix of wp_ and bbPress with bb_]

I have WordPress installed in my public_html directory in a directory named blog

Do you mean install bbPress in the blog directory?

In other words, don’t create a separate directory forum to install bbPress?

I think I want mywebsitedomainname/blog and mywebsitedomainname/forum to be separate urls

But to integrate WordPress with bbPRess do they have to have the same url?

Thanks

---

On a separate note

I should be able to use WinSCP to login to my server via SSH, then access my database with a MySQL login, then drop the bb_ tables from the failed bbPress install.

I imagine this could be done through the WinSCP Console

I realize the phpAdmin is a more user friendly interface than the WinSCP Console.

I sent an e-mail to my web hosting support, but they haven’t responded.

[Trent Adams]

You can have the forum installed wherever, I was talking about having bbPress and WP in the same database.

Trent

[Inquirer]

I have read through phpAdmin Quick Install at

http://wiki.cihar.com/pma/Quick_Install

It reads Extract files

Untar or unzip the distribution (be sure to unzip the subdirectories):

tar -xzvf phpMyAdmin-2.*.*.*.tar.gz

in your web server’s document root.

When I login to my server using WinSCP to connect my server via SSH, there is a button with / to connect to the root directory. When I click the button it displays / <root>

The documentation recommends phpMyAdmin should be installed in the root directory (document root).

I already have WordPress installed in my public_html directory in a folder named blog, which isn’t a database nor is it my root directory (document root).

WordPress is up and running.

[Then just install your bbPRess in the same database as WP.]

Where on my web server is the database you are referring?

Are you referring to the database files portion of the bbPress and WordPress installation?

[You can have the forum installed wherever, I was talking about having bbPress and WP in the same database.]

I can have WordPress installed in my public_html directory in a folder named blog.

I can have bbPress installed in my public_html directory in a folder named forum.

I apologize for my confusion.

[Trent Adams]

You must have a MySQL database that WP is installed in. For bbPress and WP to be integrated you have to configure your config.php before install to have your WP specific data in it (there is a portion near bottom) and then install bbPress in the same MySQL database regardless of where the physical files actually reside (your case /blog/ and /forum/). Does that make sense?

Trent

[Inquirer]

At the top of the config.php files of bbPress and WordPress these values will be the same.

<?php

// ** MySQL settings ** //

define(‘BBDB_NAME’, ”); // The name of the database

define(‘BBDB_USER’, ”); // Your MySQL username

define(‘BBDB_PASSWORD’, ”); // …and password

define(‘BBDB_HOST’, ‘localhost’); // 99% chance you won’t need to change this value

Trent wrote:

[For bbPress and WP to be integrated you have to configure your config.php before install to have your WP specific data in it (there is a portion near bottom) and then install bbPress in the same MySQL database regardless of where the physical files actually reside (your case /blog/ and /forum/).}

// The rest is only useful if you are integrating bbPress with WordPress.

// If you’re not, just leave it as it is.

$bb->wp_table_prefix = ‘wp_’; // WordPress table prefix. Example: ‘wp_’;

$bb->wp_home = ‘http://mywebsite.com/blog/&#8217;; // WordPress – Options->General: Blog address (URL) // Example: ‘http://example.com&#8217;

$bb->wp_siteurl = ‘http://mywebsite.com/blog/&#8217;; // WordPress – Options->General: WordPress address (URL) // Example: ‘http://example.com&#8217;

/* Stop editing */

---

I already have WordPress installed in my public_html directory in a folder named blog.

Above, I put in examples of how to fill-in ‘examples’

Apparently it would be wp_home = http://mywebsite.com/blog/

and wp_siteurl = http://mywebsite.com/blog/

Apparently, only the WordPress has to have the bottom portion filled-in?

If this is correct then I would have to fill-in bottom portion of the WordPress config.php and FTP it before I reinstalled bbPress.

[regardless of where the physical files actually reside]

I was thinking of the physical storage of the files.

[Does that make sense?]

I think so.

[Trent Adams]

What the integration in the bbPress config.php does is tell bbPress to use the WP users instead of installing its own users table in the database. No configuration has to go into WP unless later you want to have registrations of bbPress make users in WP (that is a WP plugin) but not needed for an integration installation.

Good luck and let us know how you are making out!

Trent

[Inquirer]

I was using WinSCP to connect my server via SSH.

According to the WinSCP web site their SSH protocol core is based on PuTTY.

I entered the command mysql -p in the command text box and clicked the Enter button

It kept timing out.

It is odd the WinSCP FTP client part of the software works fine.

I installed PuTTY and I was able to login to my database and dropped the bbPress tables.

I realize that the phpAdmin software provides a more user friendly interface to a MySql database.

[Inquirer]

In the bbPress config.php file is the following

You can get an Akismet key at

// http://wordpress.com/api-keys/

I registered with wordpress.com and received an Akismet key, which I have put in the bbPress config.php

I posted a question WordPress.com forum and discovered that there is a WordPress.org and a WordPress.com. I have WordPress.org blog software, which is able to be customized.

I then registered with WordPress.org forums.

Is bbPress related with WordPress.com or WordPress.org?

[Trent Adams]

It is related with wordpress.org. Let me explain. Akismet keys are given from wordpress.com (free hosted blog service) and that key can be used with bbPress and the Akismet plugin for WordPress (downloaded from wordpress.org) or with other blog softwares have the Akismet plugin.

bbPress integration is dealt with here or in the wordpress.org/support/ forums and issues with your Akismet key are dealt with through the ‘feedback’ or ‘support’ tab in the wordpress.com forums.

Hope that clears it up a little.

Trent

[Inquirer]

I dropped the bbPress tables in my database and did a reinstall.

The installation went fine.

I discovered my original installation falied because of a typo

I had entered ‘http://mywebsite.com/forums/&#8217;;

I should have entered ‘http://mywebsite.com/forum/&#8217;;

On this install I didn’t want to integrate with the WordPress database.

Now I need to learn how to customize the forum’s appearance.

Is there a way to change the forum name within Administration or will I have to edit the config.php file and FTP it?

Is a lot of customization done through plugins and php templates?

I found this online.

[The best way to start off is to create a new directory inside the root folder of the bbpress install called “my-templates”. Any php templates place in this folder with the same name as in “bb-templates” will override the original files. For example, if you modify front-page.php and upload it to “my-templates”, bbpress will pull the customized front-page.php file.]

Fore instance I like adding the ‘This topic is one of your favorites’ feature.

[fel64]

I believe that the forum name has to be edited in config.php.

Yes. In theory and hopefully in practise, all customization is done through plugins and templates.

The excerpt you found online is correct.

The favourites feature is already present. It is a core feature, not a plugin.