Skip to:
Content
Pages
Categories
Search
Top
Bottom

Problem at step 2 of installation


  • JeffVoegtlin
    Member

    @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

Viewing 8 replies - 1 through 8 (of 8 total)

  • chrishajer
    Participant

    @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
    Member

    @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/’;

    // 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’ );

    ?>


    JeffVoegtlin
    Member

    @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
    Participant

    @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
    Participant

    @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
    Member

    @jeffvoegtlin

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

    Thanks, chrishajer, for your helpful suggestions.


    JeffVoegtlin
    Member

    @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
    Participant

    @chrishajer

    Cool – enjoy.

Viewing 8 replies - 1 through 8 (of 8 total)

You must be logged in to reply to this topic.