bbPress Support Forums Tag: cannot select db

bbPress Support Forums Tag: cannot select db http://bbpress.org/forums/ bbPress Support Forums Tag: cannot select db en Thu, 08 Jan 2009 23:10:43 +0000 chrishajer on "Unable to install need help!" http://bbpress.org/forums/topic/unable-to-install-need-help#post-14562 Thu, 20 Mar 2008 13:49:44 +0000 chrishajer 14562@http://bbpress.org/forums/ Only you can help you install this, or you will need to find someone you trust with a control panel login. If you are getting a "Cannot select DB" error, it's because your connection details are wrong. We cannot see the connection details and instructions for your host, and you posting them here is a bad idea. Posting an edited config does not help either. If you would like to contact me I can help off list (check the link in my profile and find an email address there). I will need a control panel login and access to the config.php on your server (shell, FTP or some sort of file manager.) audiomad on "Unable to install need help!" http://bbpress.org/forums/topic/unable-to-install-need-help#post-14559 Thu, 20 Mar 2008 11:50:07 +0000 audiomad 14559@http://bbpress.org/forums/ I am unable to install this I get an error Cannot select DB can anyone help me to get this working? chrishajer on "can not select db error" http://bbpress.org/forums/topic/can-not-select-db-error#post-14222 Sun, 02 Mar 2008 17:59:51 +0000 chrishajer 14222@http://bbpress.org/forums/ You can also contact me using any of the contact information on the website linked in my profile if you would like help resolving this off list. You will need to be willing to share the control panel log in and access to your config.php. chrishajer on "can not select db error" http://bbpress.org/forums/topic/can-not-select-db-error#post-14221 Sun, 02 Mar 2008 17:58:55 +0000 chrishajer 14221@http://bbpress.org/forums/ I would not recommend posting your connection details here. Please change your database connection details with the host if you can. I guess since they're not working anyway there's probably not much harm. I would change the password at least. Here's the problem. You can post the connection details here, but without someone having access to what the host says the connection details SHOULD be, there's no way to verify that what you are posting here and using are correct. Only you can verify that they are identical. You can triple check the database name, username and password and verify that they're correct, letter my letter. So, my guess is that the host is wrong. It's trying localhost and not finding a database there by that name. So my SWAG is that you need to put a hostname there. MySQL 4 is required, so MySQL 4.1 should be fine. That's an interesting warning though, I don't think I've seen that before. Once your forum is installed, you should probably file a trac bug on that since I don't think the possibility of that function being disabled has been covered. techhost on "can not select db error" http://bbpress.org/forums/topic/can-not-select-db-error#post-14217 Sun, 02 Mar 2008 17:25:04 +0000 techhost 14217@http://bbpress.org/forums/ Wait, what's this: Warning: version_compare() has been disabled for security reasons in d:\hosting\arock1\rockline_forum\bbpress\bb-includes\db-base.php on line 479 Cannot select DB. I don't know what this is either .. .. I got this the first time i tried the install.php . .. .. .. Then I fixed the (uri)line, because I had forgotten the '.com' in the address $bb->uri = 'http://www.rocklineproduction.com/rockline_forum/bbpress/'; then first part of the error went away and all I had was the 'Connot selectDB' .. . .and now the first part is back again .. ... ... techhost on "can not select db error" http://bbpress.org/forums/topic/can-not-select-db-error#post-14216 Sun, 02 Mar 2008 17:10:50 +0000 techhost 14216@http://bbpress.org/forums/ I even tried to replace 'localhost' with the real hostname path .. . .but as u know that didn't work either(should the real hostname address work..? on a good config setup) .. .. techhost on "can not select db error" http://bbpress.org/forums/topic/can-not-select-db-error#post-14214 Sun, 02 Mar 2008 17:04:59 +0000 techhost 14214@http://bbpress.org/forums/ chrishajer .. ... the version of mysql is 4.1 techhost on "can not select db error" http://bbpress.org/forums/topic/can-not-select-db-error#post-14213 Sun, 02 Mar 2008 17:00:44 +0000 techhost 14213@http://bbpress.org/forums/ I believe I have 4.? mysql . . I will double check that right now . . . techhost on "can not select db error" http://bbpress.org/forums/topic/can-not-select-db-error#post-14212 Sun, 02 Mar 2008 16:59:22 +0000 techhost 14212@http://bbpress.org/forums/ chrishajer ... I was relutant to post the total access info for security reason . . .. so heres the details . . . define('BBDB_NAME', 'rocklineforum'); // The name of the database define('BBDB_USER', 'rocklineforum'); // Your MySQL username define('BBDB_PASSWORD', 'Arnoldie1'); // ...and password define('BBDB_HOST', 'localhost'); // 99% chance you won't need to change these last few chrishajer on "can not select db error" http://bbpress.org/forums/topic/can-not-select-db-error#post-14211 Sun, 02 Mar 2008 16:54:44 +0000 chrishajer 14211@http://bbpress.org/forums/ Wait, what's this: <pre><code>Warning: version_compare() has been disabled for security reasons in d:\hosting\arock1\rockline_forum\bbpress\bb-includes\db-base.php on line 479 Cannot select DB.</code></pre> You didn't post the first part of that message which I received when trying to access your forum. Do you know what version MySQL is installed? You could probably work around that. The fact that you still have a "Cannot select DB" error after the warning means there is probably still a problem with your four connection details. chrishajer on "can not select db error" http://bbpress.org/forums/topic/can-not-select-db-error#post-14210 Sun, 02 Mar 2008 16:50:18 +0000 chrishajer 14210@http://bbpress.org/forums/ What I was saying before is that no one will be able to help you without access to your server. Since you obfuscated the connection details to post them here, no one can look at them and see what's wrong with them. Someone needs to be able to log into your control panel or host, see the database details there, then ensure that those same exact details are entered in your config.php. You don't have a syntax error in your config.php, one of the pieces of information you've entered there is incorrect and only you can see what that is. techhost on "can not select db error" http://bbpress.org/forums/topic/can-not-select-db-error#post-14209 Sun, 02 Mar 2008 16:42:58 +0000 techhost 14209@http://bbpress.org/forums/ here are my settings for the config.php Sorry for not posting it at first. // ** MySQL settings ** // define('BBDB_NAME', 'sameasUSER'); define('BBDB_USER', 'sameasDB'); define('BBDB_PASSWORD', 'xxxxxxxxx'); define('BBDB_HOST', 'localhost'); define('BBDB_CHARSET', 'utf8'); define('BBDB_COLLATE', ''); // 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://www.rocklineproduction.com/rockline_forum/bbpress/'; // What are you going to call me? $bb->name = 'Rockline Production Forum'; // This must be set before you run the install script. $bb->admin_email = 'myemail@hosttechs.net'; // Set to true if you want pretty permalinks, set to 'slugs' if you want to use slug based pretty permalinks. $bb->mod_rewrite = true; // 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: -7 for Pacific Daylight Time. $bb->gmt_offset = 8; // 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' // I didn't change anything below that which is above .. . .. . chrishajer on "can not select db error" http://bbpress.org/forums/topic/can-not-select-db-error#post-14179 Sat, 01 Mar 2008 17:22:05 +0000 chrishajer 14179@http://bbpress.org/forums/ It is an easy setup. There is something wrong with your configuration. It's difficult for anyone here to diagnose since we won't be able to see your actual database connection details to help. JanEllers on "can not select db error" http://bbpress.org/forums/topic/can-not-select-db-error#post-14176 Sat, 01 Mar 2008 15:45:22 +0000 JanEllers 14176@http://bbpress.org/forums/ Do the user have enough rights? techhost on "can not select db error" http://bbpress.org/forums/topic/can-not-select-db-error#post-14175 Sat, 01 Mar 2008 15:02:31 +0000 techhost 14175@http://bbpress.org/forums/ Help .... I have logged onto my database locally . ..and its fine .. . I have the exact database name, user, and password in the config file. I have tried 'localhost' and the actual server name/path and I still can not get the the installation started. I can not get past "cannot select db" What is the mistery and i thought this was an easy setup? Please help with this install .. .. . Chinkerfly on "Installation for Dummy" http://bbpress.org/forums/topic/installation-for-dummy#post-13243 Sat, 19 Jan 2008 14:29:34 +0000 Chinkerfly 13243@http://bbpress.org/forums/ Oh my god... it was because I didn't capitalize the "C" in the username. Jeez... I told you I was a dummy... Thanks for your help! finalwebsites on "Installation for Dummy" http://bbpress.org/forums/topic/installation-for-dummy#post-13242 Sat, 19 Jan 2008 13:53:18 +0000 finalwebsites 13242@http://bbpress.org/forums/ I'm sure your database settings are wrong (cpanel has added something your names). Check cpanel for the complete name (database and user) Chinkerfly on "Installation for Dummy" http://bbpress.org/forums/topic/installation-for-dummy#post-13241 Sat, 19 Jan 2008 12:36:31 +0000 Chinkerfly 13241@http://bbpress.org/forums/ It's been two days since I started trying to install bbpress and I've scoured the forums and the internet to try to find an answer without much luck (isn't there a FAQ somewhere for people like me?) Here's the details on what I did. 1. Created a new database called "bbpress" in cpanel, the database name it gives me is thechonx_bbpress 2. Added user from my wordpress database, thechonx_chinker 3. downloaded, unzipped bbpress, edited config-sample.php and renamed it to config.php (how I edited it is shown below--I think I should change BBDB Host, but don't know what to change it to) 4. Created a folder in my public_html root (where all my wp files are uploaded) called "forum" 5. Uploaded all the files (minus original "bbpress" folder) to "forum" 6. Opened this address in my Firefox browser (I am running Mac OS Leopard 10.5.1): <a href="http://www.thechonx.com/forum/bb-admin/install.php" rel="nofollow">http://www.thechonx.com/forum/bb-admin/install.php</a> --attempted other URLs like localhost led to blank pages or 404 pages 7. Received "Cannot Select DB" error I've tried a dozen other variations of the above, mostly changing config file info but no dice. Help please! <blockquote> <?php // ** MySQL settings ** // define('BBDB_NAME', 'thechonx_wordpress'); // The name of the database define('BBDB_USER', 'thechonx_chinker'); // Your MySQL username define('BBDB_PASSWORD', 'xxxxxxxxxxx'); // ...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://www.thechonx.com/forum/'; // What are you going to call me? $bb->name = 'Rumble in The Chonx'; // This must be set before you run the install script. $bb->admin_email = 'thalia.kwok@XXXXX'; // Set to true if you want pretty permalinks, set to 'slugs' if you want to use slug based pretty permalinks. $bb->mod_rewrite = 'slugs'; // 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: -7 for Pacific Daylight Time. $bb->gmt_offset = 8; // 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_'; // WordPress table prefix. Example: 'wp_'; $bb->wp_home = 'http://www.thechonx.com'; // WordPress - Options->General: Blog address (URL) // Example: 'http://example.com' $bb->wp_siteurl = 'http://www.thechonx.com'; // 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' ); ?></blockquote> pwdrskier4 on "Cannot select DB error!" http://bbpress.org/forums/topic/cannot-select-db-error#post-12436 Tue, 04 Dec 2007 22:50:04 +0000 pwdrskier4 12436@http://bbpress.org/forums/ SUCCESS!!! It was the changes to bb-settings.php that did it, the 757 patch: <a href="http://trac.bbpress.org/ticket/757" rel="nofollow">http://trac.bbpress.org/ticket/757</a> Thanks for all the help chrishajer and livibetter. I could still be staring at my password wondering why it won't work. So now I have reinstalled again (to get rid of any bad changes I made while trying to figure this out) and we are good to go. And yes, this was a "all of the sudden" problem, don't know how, don't know why. I have some other similar sites running the same code/settings and they still work fine without the patch even though they too have the host: 'localhost:/tmp/mysql5.sock' Also, yes, I am on 0.8.3 and was before the issue - if you were still curious. livibetter on "Cannot select DB error!" http://bbpress.org/forums/topic/cannot-select-db-error#post-12434 Tue, 04 Dec 2007 21:21:08 +0000 livibetter 12434@http://bbpress.org/forums/ Are you using 0.8.3? Try to patch with <a href="http://trac.bbpress.org/ticket/757" rel="nofollow">http://trac.bbpress.org/ticket/757</a> or modify <a href="http://trac.bbpress.org/browser/trunk/bb-includes/db-mysqli.php#L56" rel="nofollow">http://trac.bbpress.org/browser/trunk/bb-includes/db-mysqli.php#L56</a> to be <code>$this->$dbhname = @mysqli_connect( $server->host, $server->user, $server->pass, null, null, $server->port );</code> chrishajer on "Cannot select DB error!" http://bbpress.org/forums/topic/cannot-select-db-error#post-12433 Tue, 04 Dec 2007 21:16:33 +0000 chrishajer 12433@http://bbpress.org/forums/ Was it "all of the sudden" all on it's own (like it was working last night, and "all of the sudden" it was not working today?) or did you make a change that might have broken something? If you made a change, you need to figure out how that change might have caused this. chrishajer on "Cannot select DB error!" http://bbpress.org/forums/topic/cannot-select-db-error#post-12432 Tue, 04 Dec 2007 21:15:14 +0000 chrishajer 12432@http://bbpress.org/forums/ Did you change that from how it was working before, or did you recently upgrade to 0.83? I ask because 0.83 made the switch to db-mysqli.php and as far as I know db-mysqli.php does not accept the port parameter (the part after the localhost:) So, was it working before and it stopped all of the sudden or did you upgrade something that might have broken it. If you upgraded to 0.83, I think this ticket might be of interest to you: <a href="http://trac.bbpress.org/ticket/745" rel="nofollow">http://trac.bbpress.org/ticket/745</a> <a href="http://bbpress.org/forums/topic/bbpress-on-localhost?replies=4#post-12105" rel="nofollow">http://bbpress.org/forums/topic/bbpress-on-localhost?replies=4#post-12105</a> pwdrskier4 on "Cannot select DB error!" http://bbpress.org/forums/topic/cannot-select-db-error#post-12431 Tue, 04 Dec 2007 20:33:57 +0000 pwdrskier4 12431@http://bbpress.org/forums/ as my HOST, I do not use 'localhost' instead I have to use 'localhost:/tmp/mysql5.sock' but this is the same as my WP and it still works. pwdrskier4 on "Cannot select DB error!" http://bbpress.org/forums/topic/cannot-select-db-error#post-12430 Tue, 04 Dec 2007 20:31:33 +0000 pwdrskier4 12430@http://bbpress.org/forums/ I am tried resetting my mysql password. I have tried creating another mysql user. I have blown up my bbpress install and started over (I only had a couple topics going). I don't know what else to try. chrishajer on "Cannot select DB error!" http://bbpress.org/forums/topic/cannot-select-db-error#post-12429 Tue, 04 Dec 2007 20:07:01 +0000 chrishajer 12429@http://bbpress.org/forums/ I wouldn't blow away your bbPress install completely. It's a simple error that will have a simple solution. It just cannot connect to the database for some reason... chrishajer on "Cannot select DB error!" http://bbpress.org/forums/topic/cannot-select-db-error#post-12428 Tue, 04 Dec 2007 20:06:14 +0000 chrishajer 12428@http://bbpress.org/forums/ <a href="http://bbpress.org/forums/topic/cannot-select-db-3?replies=6#post-11248" rel="nofollow">http://bbpress.org/forums/topic/cannot-select-db-3?replies=6#post-11248</a> pwdrskier4 on "Cannot select DB error!" http://bbpress.org/forums/topic/cannot-select-db-error#post-12427 Tue, 04 Dec 2007 20:05:41 +0000 pwdrskier4 12427@http://bbpress.org/forums/ Okay now the latest discussions do not show up on frontpage because I have attempted to completely reinstall bbpress but it still gets the same error. chrishajer on "Cannot select DB error!" http://bbpress.org/forums/topic/cannot-select-db-error#post-12426 Tue, 04 Dec 2007 20:04:51 +0000 chrishajer 12426@http://bbpress.org/forums/ My guess is that there is something wrong with the database settings in config.php (sorry) - if it is using the same database as the WordPress site, and the WordPress site is still up, then I think there's something wrong with the config.php. Unless you changed something else recently with your files, I can't think of anything else that would cause it. Since posting an edited wp-config.php and config.php would be useless since you'd be destroying information, I would have another set of eyes look at both config files and see if there are any differences. Maybe the config.php was edited with some editor that mangled a character or line ending or something. Also, can you connect to the database with phpMyAdmin or something using the details from config.php? Make sure the database is still there? pwdrskier4 on "Cannot select DB error!" http://bbpress.org/forums/topic/cannot-select-db-error#post-12425 Tue, 04 Dec 2007 19:09:02 +0000 pwdrskier4 12425@http://bbpress.org/forums/ I am getting a new error: Cannot select DB. My forums were set up and working at <a href="http://www.snownation.com/forums/" rel="nofollow">www.snownation.com/forums/</a> All of the sudden, now I am getting this error. I have checked the DB settings like 10 times. You will notice on my frontpage at snownation.com the latest discussions pluggin is still pulling info and it has the same login info as does my wordpress setup. Any ideas??? Lookfab on "Cannot select DB" http://bbpress.org/forums/topic/cannot-select-db-3#post-11248 Tue, 02 Oct 2007 05:53:32 +0000 Lookfab 11248@http://bbpress.org/forums/ Well, problem solved. The Wordpress FAQ suggests resetting your MySQL password manually if you have problems connecting to the db. I did so using the MySQL client and now both WP and bbpress seem to be working fine. Thanks for the input.