Forums

Join
bbPress Support Forums › Installation › Problem at step 2 of installation

Info

Problem at step 2 of installation

    • Posted 4 years ago #

    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

    • Posted 4 years ago #

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

    • Posted 4 years ago #

    <?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/';

    // 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'
    $bb->wp_siteurl = 'http://jackhammr.org'; // WordPress - Options->General: WordPress address (URL) // Example: 'http://example.com'

    /* Stop editing */

    if ( !defined('BBPATH') )
    define('BBPATH', dirname(__FILE__) . '/' );
    require_once( BBPATH . 'bb-settings.php' );

    ?>

    • Posted 4 years ago #

    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.

    • Posted 4 years ago #

    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.

    • Posted 4 years ago #

    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.

    • Posted 4 years ago #

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

    Thanks, chrishajer, for your helpful suggestions.

    • Posted 4 years ago #

    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,

    • Posted 4 years ago #

    Cool - enjoy.

  10. You must log in to post.