bbPress support forums Topic: Problem at step 2 of installation

bbPress support forums Topic: Problem at step 2 of installation http://bbpress.org/forums/ bbPress support forums Topic: Problem at step 2 of installation en Sat, 30 Aug 2008 11:48:08 +0000 chrishajer on "Problem at step 2 of installation" http://bbpress.org/forums/topic/problem-at-step-2-of-installation#post-11969 Tue, 13 Nov 2007 14:57:41 +0000 chrishajer 11969@http://bbpress.org/forums/ Cool - enjoy. JeffVoegtlin on "Problem at step 2 of installation" http://bbpress.org/forums/topic/problem-at-step-2-of-installation#post-11958 Tue, 13 Nov 2007 14:37:13 +0000 JeffVoegtlin 11958@http://bbpress.org/forums/ 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, JeffVoegtlin on "Problem at step 2 of installation" http://bbpress.org/forums/topic/problem-at-step-2-of-installation#post-11956 Tue, 13 Nov 2007 14:35:39 +0000 JeffVoegtlin 11956@http://bbpress.org/forums/ Well, I did a little fiddling around and I've been set up. Thanks, chrishajer, for your helpful suggestions. chrishajer on "Problem at step 2 of installation" http://bbpress.org/forums/topic/problem-at-step-2-of-installation#post-11952 Tue, 13 Nov 2007 14:26:07 +0000 chrishajer 11952@http://bbpress.org/forums/ These are how the 3 lines look before any customization (I took the comments out): <pre><code>$bb->wp_table_prefix = ''; $bb->wp_home = ''; $bb->wp_siteurl = '';</code></pre> Yours might look like: <pre><code>$bb->wp_table_prefix = 'wp_'; $bb->wp_home = 'http://jackhammr.org'; $bb->wp_siteurl = 'http://jackhammr.org';</code></pre> when you're done. chrishajer on "Problem at step 2 of installation" http://bbpress.org/forums/topic/problem-at-step-2-of-installation#post-11951 Tue, 13 Nov 2007 14:23:41 +0000 chrishajer 11951@http://bbpress.org/forums/ I think this line is the problem: <code>$bb->wp_table_prefix = 'wp_;$bb->wp_home';</code> That should be something like: <code>$bb->wp_table_prefix = 'wp_';</code> and <code>$bb->wp_home = 'http://jackhammr.org';</code> Somehow you got part of the 2nd line onto the end of the first line. Fixing that will fix your problem. JeffVoegtlin on "Problem at step 2 of installation" http://bbpress.org/forums/topic/problem-at-step-2-of-installation#post-11947 Tue, 13 Nov 2007 12:36:56 +0000 JeffVoegtlin 11947@http://bbpress.org/forums/ 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. JeffVoegtlin on "Problem at step 2 of installation" http://bbpress.org/forums/topic/problem-at-step-2-of-installation#post-11946 Tue, 13 Nov 2007 12:30:43 +0000 JeffVoegtlin 11946@http://bbpress.org/forums/ <?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 // <a href="http://wordpress.com/api-keys/" rel="nofollow">http://wordpress.com/api-keys/</a> $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' ); ?> chrishajer on "Problem at step 2 of installation" http://bbpress.org/forums/topic/problem-at-step-2-of-installation#post-11940 Tue, 13 Nov 2007 06:40:14 +0000 chrishajer 11940@http://bbpress.org/forums/ 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 on "Problem at step 2 of installation" http://bbpress.org/forums/topic/problem-at-step-2-of-installation#post-11939 Tue, 13 Nov 2007 06:32:04 +0000 JeffVoegtlin 11939@http://bbpress.org/forums/ 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