bbPress support forums Tag: step

bbPress support forums Tag: step http://bbpress.org/forums/ bbPress support forums Tag: step en Tue, 02 Dec 2008 06:08:42 +0000 feelie75 on "Had to comment out 'return false' to get install to work" http://bbpress.org/forums/topic/had-to-comment-out-return-false-to-get-install-to-work#post-15299 Sat, 12 Apr 2008 04:38:14 +0000 feelie75 15299@http://bbpress.org/forums/ This is the code that was making the call and getting the return false returned to it, thus resulting in this error: if (!$bbdb->db_connect('SHOW TABLES;')) { $this->step_status[1] = 'incomplete'; $this->strings[1]['messages']['error'][] = __('There was a problem connecting to the database you specified. Please check the settings, then try again.'); return 'error'; } db_connect was returning false when it detected $this->$dbhname was undef. So by removing the return false when that happened, the db_connect call then succeeded and all was happy :). To answer the other person, I'm hosting on localhost. I have an old PowerPC Mac running OS X 10.4.11 or something. It's a spare computer; thought I'd stick a forum on it and learn some php. chrishajer on "Had to comment out 'return false' to get install to work" http://bbpress.org/forums/topic/had-to-comment-out-return-false-to-get-install-to-work#post-15197 Wed, 09 Apr 2008 18:20:45 +0000 chrishajer 15197@http://bbpress.org/forums/ What host are you using? sambauers on "Had to comment out 'return false' to get install to work" http://bbpress.org/forums/topic/had-to-comment-out-return-false-to-get-install-to-work#post-15188 Wed, 09 Apr 2008 15:39:24 +0000 sambauers 15188@http://bbpress.org/forums/ Were you getting an error message when it didn't work? It would be useful to know it if you did. feelie75 on "Had to comment out 'return false' to get install to work" http://bbpress.org/forums/topic/had-to-comment-out-return-false-to-get-install-to-work#post-15178 Wed, 09 Apr 2008 07:26:23 +0000 feelie75 15178@http://bbpress.org/forums/ I'm sure this ISNT the proper solution, heh, but since it worked I thought I'd point it out. After Step 1 failed many times, I set out to debug it. My travel took me here: bb-includes/db-mysql.php $this->$dbhname = @mysql_connect( $server->host, $server->user, $server->pass, true ); if (!$this->$dbhname) return false; That was failing and returning false everytime. I couldn't figure it out. I printed out the hose and user and password, and it looked good. I could connect just fine from a shell prompt. After confirming that it actually WAS connecting, and that it was simply the lack of $this->$dbhname that was causing the failure, I just commented out the return false; and VOILA! It worked! Installation finished and I can post messages, etc, etc, everything seems fine. Soooo... What's up with that?! hehe. $dbhname was == 'dbh_local'. Not sure what other details I can provide. Just thought I'd share the rather strange experience and oddness that I'd have to hack the db_connect code to get the install to complete... Weird!! fel64 on "Step Two Database Error" http://bbpress.org/forums/topic/step-two-database-error#post-5539 Thu, 15 Mar 2007 00:36:23 +0000 fel64 5539@http://bbpress.org/forums/ You have to enter the right password and username in <code>config.php</code> to your databases. I don't know what Yahoo Webhosting entails, but unless it says MySQL tables somewhere you can't use it. You need hosting that allows you to create MySQL databases, and they should be able to tell you your details to log into that. :) boomanfloral on "Step Two Database Error" http://bbpress.org/forums/topic/step-two-database-error#post-5538 Thu, 15 Mar 2007 00:12:09 +0000 boomanfloral 5538@http://bbpress.org/forums/ Thanks for the advice! I'm using Yahoo Webhosting Services. I looked around, and I don't see where to change those 'permissions' :( Does anyone know? Thanks again! daniel Trent on "Step Two Database Error" http://bbpress.org/forums/topic/step-two-database-error#post-5536 Wed, 14 Mar 2007 23:08:19 +0000 Trent 5536@http://bbpress.org/forums/ It would seem that it didn't work from the errors because your database user doesn't have the proper permissions to create tables. You will need to update the permissions of the database user and then run the script again! Once the permissions are set right, it will install easy for you! Trent boomanfloral on "Step Two Database Error" http://bbpress.org/forums/topic/step-two-database-error#post-5535 Wed, 14 Mar 2007 22:58:56 +0000 boomanfloral 5535@http://bbpress.org/forums/ Hi, I just installed bbPress and on STEP TWO I got a screen with the error below. I'm not a programmer or anything, I just know basic HTML and that's it, so I don't know where to look for a way to fix this. Can anyone give me some pointers on how to fix this? Or is there a service where I can pay to have this fixed and running smoothly? Thanks! <pre><code>bbPress database error Second Step Now we’re going to create the database tables and fill them with some default data. bbPress database error: [Access denied for user 'boomanfloral'@'localhost' to database 'mysql'] CREATE TABLE bb_forums ( forum_id int(10) NOT NULL auto_increment, forum_name varchar(150) NOT NULL default '', forum_desc text NOT NULL, forum_order int(10) NOT NULL default '0', topics bigint(20) NOT NULL default '0', posts bigint(20) NOT NULL default '0', PRIMARY KEY (forum_id) ) bbPress database error: [Access denied for user 'boomanfloral'@'localhost' to database 'mysql'] CREATE TABLE bb_posts ( post_id bigint(20) NOT NULL auto_increment, forum_id int(10) NOT NULL default '1', topic_id bigint(20) NOT NULL default '1', poster_id int(10) NOT NULL default '0', post_text text NOT NULL, post_time datetime NOT NULL default '0000-00-00 00:00:00', poster_ip varchar(15) NOT NULL default '', post_status tinyint(1) NOT NULL default '0', post_position bigint(20) NOT NULL default '0', PRIMARY KEY (post_id), KEY topic_id (topic_id), KEY poster_id (poster_id), KEY post_time (post_time), FULLTEXT KEY post_text (post_text) ) TYPE = MYISAM bbPress database error: [Access denied for user 'boomanfloral'@'localhost' to database 'mysql'] CREATE TABLE bb_topics ( topic_id bigint(20) NOT NULL auto_increment, topic_title varchar(100) NOT NULL default '', topic_poster bigint(20) NOT NULL default '0', topic_poster_name varchar(40) NOT NULL default 'Anonymous', topic_last_poster bigint(20) NOT NULL default '0', topic_last_poster_name varchar(40) NOT NULL default '', topic_start_time datetime NOT NULL default '0000-00-00 00:00:00', topic_time datetime NOT NULL default '0000-00-00 00:00:00', forum_id int(10) NOT NULL default '1', topic_status tinyint(1) NOT NULL default '0', topic_open tinyint(1) NOT NULL default '1', topic_last_post_id bigint(20) NOT NULL default '1', topic_sticky tinyint(1) NOT NULL default '0', topic_posts bigint(20) NOT NULL default '0', tag_count bigint(20) NOT NULL default '0', PRIMARY KEY (topic_id), KEY forum_id (forum_id), KEY topic_time (topic_time), KEY topic_start_time (topic_start_time) ) bbPress database error: [Access denied for user 'boomanfloral'@'localhost' to database 'mysql'] CREATE TABLE bb_topicmeta ( meta_id bigint(20) NOT NULL auto_increment, topic_id bigint(20) NOT NULL default '0', meta_key varchar(255) default NULL, meta_value longtext, PRIMARY KEY (meta_id), KEY user_id (topic_id), KEY meta_key (meta_key) ) bbPress database error: [Access denied for user 'boomanfloral'@'localhost' to database 'mysql'] CREATE TABLE bb_users ( ID bigint(20) unsigned NOT NULL auto_increment, user_login varchar(60) NOT NULL default '', user_pass varchar(64) NOT NULL default '', user_nicename varchar(50) NOT NULL default '', user_email varchar(100) NOT NULL default '', user_url varchar(100) NOT NULL default '', user_registered datetime NOT NULL default '0000-00-00 00:00:00', user_status int(11) NOT NULL default '0', display_name varchar(250) NOT NULL default '', PRIMARY KEY (ID), UNIQUE KEY user_login (user_login) ) bbPress database error: [Access denied for user 'boomanfloral'@'localhost' to database 'mysql'] CREATE TABLE bb_usermeta ( umeta_id bigint(20) NOT NULL auto_increment, user_id bigint(20) NOT NULL default '0', meta_key varchar(255) default NULL, meta_value longtext, PRIMARY KEY (umeta_id), KEY user_id (user_id), KEY meta_key (meta_key) ) bbPress database error: [Access denied for user 'boomanfloral'@'localhost' to database 'mysql'] CREATE TABLE bb_tags ( tag_id bigint(20) unsigned NOT NULL auto_increment, tag varchar(200) NOT NULL default '', raw_tag varchar(50) NOT NULL default '', tag_count bigint(20) unsigned NOT NULL default '0', PRIMARY KEY (tag_id) ) bbPress database error: [Access denied for user 'boomanfloral'@'localhost' to database 'mysql'] CREATE TABLE bb_tagged ( tag_id bigint(20) unsigned NOT NULL default '0', user_id bigint(20) unsigned NOT NULL default '0', topic_id bigint(20) unsigned NOT NULL default '0', tagged_on datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (tag_id,user_id,topic_id), KEY tag_id_index (tag_id), KEY user_id_index (user_id), KEY topic_id_index (topic_id) ) 1. Created table bb_forums 2. Created table bb_posts 3. Created table bb_topics 4. Created table bb_topicmeta 5. Created table bb_users 6. Created table bb_usermeta 7. Created table bb_tags 8. Created table bb_tagged bbPress database error: [Table 'mysql.bb_topicmeta' doesn't exist] SELECT * FROM bb_topicmeta WHERE topic_id = '0' AND meta_key = 'bb_db_version' bbPress database error: [Table 'mysql.bb_topicmeta' doesn't exist] INSERT INTO bb_topicmeta ( topic_id, meta_key, meta_value ) VALUES ( '0', 'bb_db_version', '688' ) bbPress database error: [Table 'mysql.bb_users' doesn't exist] INSERT INTO bb_users (user_login, user_pass, user_email, user_url, user_registered) VALUES ('daniel', 'fae46cfefe5fb87eedf6f8801e497d06', 'daniel@boomanfloral.com', 'http://boomanfloral.com', '2007-03-14 22:01:31') bbPress database error: [Table 'mysql.bb_usermeta' doesn't exist] SELECT * FROM bb_usermeta WHERE user_id = '1' AND meta_key = 'from' bbPress database error: [Table 'mysql.bb_usermeta' doesn't exist] INSERT INTO bb_usermeta ( user_id, meta_key, meta_value ) VALUES ( '1', 'from', 'Vista, CA' ) bbPress database error: [Table 'mysql.bb_usermeta' doesn't exist] SELECT * FROM bb_usermeta WHERE user_id = '1' AND meta_key = 'interest' bbPress database error: [Table 'mysql.bb_usermeta' doesn't exist] INSERT INTO bb_usermeta ( user_id, meta_key, meta_value ) VALUES ( '1', 'interest', 'Unusual Plants & Internet' ) 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 ' '', , '', '2007] INSERT INTO bb_topics (topic_title, topic_poster, topic_poster_name, topic_last_poster, topic_last_poster_name, topic_start_time, topic_time, forum_id) VALUES ('Your first topic', , '', , '', '2007-03-14 22:01:31', '2007-03-14 22:01:31', 1) bbPress database error: [Table 'mysql.bb_topics' doesn't exist] SELECT * FROM bb_topics WHERE topic_id = 0 AND topic_status = 0 bbPress database error: [Table 'mysql.bb_forums' doesn't exist] UPDATE bb_forums SET topics = topics + 1 WHERE forum_id = 1 bbPress database error: [Table 'mysql.bb_topics' doesn't exist] SELECT * FROM bb_topics WHERE topic_id = 1 AND topic_status = 0 Finished!</code></pre>