[JeffVoegtlin]

After filling in step one of the installation I get this message:

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

bbPress database error: [A table must have at least 1 column]

CREATE TABLE wp_

Created table wp_

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 ‘;$bb->wp_homeusers (user_login, user_pass, user_email, us]

INSERT INTO wp_;$bb->wp_homeusers (user_login, user_pass, user_email, user_url, user_registered) VALUES (‘JeffV’, ‘145d638abb3245b4362f959f774bf1b2’, ‘jeff@jackhammr.org’, ”, ‘2007-11-13 06:30:26’)

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 ‘ ”, , ”, ‘200]

INSERT INTO bb_topics (topic_title, topic_slug, topic_poster, topic_poster_name, topic_last_poster, topic_last_poster_name, topic_start_time, topic_time, forum_id) VALUES (‘Your first topic’, ‘your-first-topic’, , ”, , ”, ‘2007-11-13 06:30:26’, ‘2007-11-13 06:30:26’, 1)

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 ‘;$bb->wp_homeusers WHERE ID = 0’ at line 1]

SELECT * FROM wp_;$bb->wp_homeusers WHERE ID = 0

Finished!

I’m sorry I don’t understand what all that means. Can someone here help me? Thanks.

Jeff Voegtlin

[chrishajer]

Looks like you’ve got some weird stuff in your config.php. There should not be any wp_ stuff showing up there, just bb_ for the tables.

Can you post your config.php (edit out the password)?

[JeffVoegtlin]

<?php

// ** MySQL settings ** //

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

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

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

define(‘BBDB_HOST’, ‘localhost’); // 99% chance you won’t need to change these last few

define(‘BBDB_CHARSET’, ‘utf8’); // If you are *upgrading*, and your old config.php does

define(‘BBDB_COLLATE’, ”); // not have these two contstants in them, DO NOT define them

// If you are installing for the first time, leave them here

// Change the prefix if you want to have multiple forums in a single database.

$bb_table_prefix = ‘bb_’; // Only letters, numbers and underscores please!

// The full URL of your bbPress install

$bb->uri = ‘http://jackhammr.org/bbpress/&#8217;;

// What are you going to call me?

$bb->name = ‘JackHammer Forums’;

// This must be set before you run the install script.

$bb->admin_email = ‘jeff@jackhammr.org’;

// Set to true if you want pretty permalinks, set to ‘slugs’ if you want to use slug based pretty permalinks.

$bb->mod_rewrite = false;

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

$bb->page_topics = 30;

// A user can edit a post for this many minutes after submitting.

$bb->edit_lock = 60;

// Your timezone offset. Example: -6 for Pacific Daylight Time.

$bb->gmt_offset = -6;

// Change this to localize bbPress. A corresponding MO file for the

// chosen language must be installed to bb-includes/languages.

// For example, install de.mo to bb-includes/languages and set BBLANG to ‘de’

// to enable German language support.

define(‘BBLANG’, ”);

// Your Akismet Key. You do not need a key to run bbPress, but if you want to take advantage

// of Akismet’s powerful spam blocking, you’ll need one. You can get an Akismet key at

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

$bb->akismet_key = ‘****************; // Example: ‘0123456789ab’

// 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_;$bb->wp_home’; // WordPress table prefix. Example: ‘wp_’;

$bb->wp_home = ”; // WordPress – Options->General: Blog address (URL) // Example: ‘http://jackhammr.org&#8217;

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

/* Stop editing */

if ( !defined(‘BBPATH’) )

define(‘BBPATH’, dirname(__FILE__) . ‘/’ );

require_once( BBPATH . ‘bb-settings.php’ );

?>

[JeffVoegtlin]

I think you’re right and that it is somewhere in the “integrating with WordPress” section. I tried to follow the example, but I didn’t know what I was doing or what what I did would do.

Thanks for your help.

[chrishajer]

I think this line is the problem:

$bb->wp_table_prefix = 'wp_;$bb->wp_home';

That should be something like:

$bb->wp_table_prefix = 'wp_';

and

$bb->wp_home = 'http://jackhammr.org';

Somehow you got part of the 2nd line onto the end of the first line. Fixing that will fix your problem.

[chrishajer]

These are how the 3 lines look before any customization (I took the comments out):

$bb->wp_table_prefix = '';

$bb->wp_home = '';

$bb->wp_siteurl = '';

Yours might look like:

$bb->wp_table_prefix = 'wp_';

$bb->wp_home = 'http://jackhammr.org';

$bb->wp_siteurl = 'http://jackhammr.org';

when you’re done.

[JeffVoegtlin]

Well, I did a little fiddling around and I’ve been set up.

Thanks, chrishajer, for your helpful suggestions.

[JeffVoegtlin]

I was doing that while you were writing that. I can’t say that I figured it out myself. I just tried several different things and the one you were writing is what worked.

Thanks again,

[chrishajer]

Cool – enjoy.