bbPress Support Forums Tag: DB

bbPress Support Forums Tag: DB http://bbpress.org/forums/ bbPress Support Forums Tag: DB en Fri, 09 Jan 2009 04:29:57 +0000 saintmain on "empty site" http://bbpress.org/forums/topic/empty-site#post-14058 Mon, 25 Feb 2008 12:56:35 +0000 saintmain 14058@http://bbpress.org/forums/ Hehe, I think I figured it out, but Im at work, so Ill try when i get off. That damn mysqli.. well hope this works :) saintmain on "empty site" http://bbpress.org/forums/topic/empty-site#post-14057 Mon, 25 Feb 2008 11:47:11 +0000 saintmain 14057@http://bbpress.org/forums/ think I found it.. cant see why bbpress not simply makes mysql standart, if it works just as well. <a href="http://trac.bbpress.org/ticket/745" rel="nofollow">http://trac.bbpress.org/ticket/745</a> <a href="http://trac.bbpress.org/ticket/757" rel="nofollow">http://trac.bbpress.org/ticket/757</a> Still dont know how to fix the problem :( saintmain on "empty site" http://bbpress.org/forums/topic/empty-site#post-14056 Mon, 25 Feb 2008 10:08:41 +0000 saintmain 14056@http://bbpress.org/forums/ Now, some text is pupping up: Warning: Invalid argument supplied for foreach() in /customers/cobain.dk/cobain.dk/httpd.www/bbpress/bb-settings.php on line 169 Warning: Cannot modify header information - headers already sent by (output started at /customers/cobain.dk/cobain.dk/httpd.www/bbpress/config.php:1) in /customers/cobain.dk/cobain.dk/httpd.www/bbpress/bb-includes/pluggable.php on line 37 Warning: Cannot modify header information - headers already sent by (output started at /customers/cobain.dk/cobain.dk/httpd.www/bbpress/config.php:1) in /customers/cobain.dk/cobain.dk/httpd.www/bbpress/bb-includes/pluggable.php on line 37 Warning: Cannot modify header information - headers already sent by (output started at /customers/cobain.dk/cobain.dk/httpd.www/bbpress/config.php:1) in /customers/cobain.dk/cobain.dk/httpd.www/bbpress/bb-includes/pluggable.php on line 164 ---------------------- bbPress and WordPress have different table prefixes bb_forums bb_posts bb_tagged bb_tags bb_topicmeta bb_topics bb_usermeta bb_users wp_comments wp_links wp_options wp_postmeta wp_posts wp_terms wp_term_relationships wp_term_taxonomy wp_usermeta wp_users saintmain on "empty site" http://bbpress.org/forums/topic/empty-site#post-14055 Mon, 25 Feb 2008 09:00:09 +0000 saintmain 14055@http://bbpress.org/forums/ It is a standard installation, no language or mod. I have installed Wordpress on the same server but not in the same folder, is that a problem? Im using PHP4, should I upgrade to PHP5 to make bbpress work? The server has "PHP - Register globals" set to OFF. *update. php5 is now installed on the server, still ampty site :( chrishajer on "empty site" http://bbpress.org/forums/topic/empty-site#post-14054 Mon, 25 Feb 2008 06:44:46 +0000 chrishajer 14054@http://bbpress.org/forums/ That looks like a server error, probably error code 500. Hard to say since the errors are not shown in the browser. If you have access to error logs, finding the problem will be easier. Did you try to integrate bbPress and WordPress? Are you using a different language file? Anything else modified from a standard installation? saintmain on "empty site" http://bbpress.org/forums/topic/empty-site#post-14051 Sun, 24 Feb 2008 22:49:24 +0000 saintmain 14051@http://bbpress.org/forums/ I installed bbpress today, and the installation worked out great. After installing, I went on to log in using my new password. then came up an empty site, all white. I then uninstalled it and deleted the db, I reinstalled it, and the same thing happened?! I cant quite fugure out whats wrong. <a href="http://www.cobain.dk/bbpress" rel="nofollow">www.cobain.dk/bbpress</a> milo317 on "constant BBDB_HOST problem" http://bbpress.org/forums/topic/constant-bbdb_host-problem#post-12692 Mon, 17 Dec 2007 00:39:17 +0000 milo317 12692@http://bbpress.org/forums/ Big Sorry, folks: last post showed me my mistake. Entering the RIGHT db host line solved my prob. milo317 on "constant BBDB_HOST problem" http://bbpress.org/forums/topic/constant-bbdb_host-problem#post-12691 Mon, 17 Dec 2007 00:36:50 +0000 milo317 12691@http://bbpress.org/forums/ BBDB_HOST line in config.php: define('DB_HOST', $_ENV{DATABASE_SERVER}); milo317 on "constant BBDB_HOST problem" http://bbpress.org/forums/topic/constant-bbdb_host-problem#post-12690 Mon, 17 Dec 2007 00:35:16 +0000 milo317 12690@http://bbpress.org/forums/ Warning info: Warning: constant() [function.constant]: Couldn't find constant BBDB_HOST in /mnt/.../html/bb-includes/db.php on line 61 Warning: mysql_get_server_info() [function.mysql-get-server-info]: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /mnt/.../html/bb-includes/db.php on line 73 Warning: mysql_get_server_info() [function.mysql-get-server-info]: A link to the server could not be established in /mnt/.../html/bb-includes/db.php on line 73 Cannot select DB. sambauers on "constant BBDB_HOST problem" http://bbpress.org/forums/topic/constant-bbdb_host-problem#post-12683 Sun, 16 Dec 2007 23:03:10 +0000 sambauers 12683@http://bbpress.org/forums/ DB_HOST is not the right constant, do you mean BBDB_HOST ? chrishajer on "constant BBDB_HOST problem" http://bbpress.org/forums/topic/constant-bbdb_host-problem#post-12660 Sun, 16 Dec 2007 16:39:39 +0000 chrishajer 12660@http://bbpress.org/forums/ It will support a host name, but are you trying to use a port or a socket? I use MySQL servers on different hosts all the time, but they are always on the default port of 3306. Can you post the <code>BBDB_HOST</code> line from your config.php? Also, you didn't post the actual warnings: what were those? milo317 on "constant BBDB_HOST problem" http://bbpress.org/forums/topic/constant-bbdb_host-problem#post-12658 Sun, 16 Dec 2007 11:14:15 +0000 milo317 12658@http://bbpress.org/forums/ hi, having some problems with installing: install.php gives me this warning: ...bbpress/bb-includes/db.php on line 61 followed by this ...bbpress/bb-includes/db.php on line 73 DB_HOST is not localhost, changed to db server mt info, apparently it won't support the db host name? chrishajer on "I have a problem before the installation" http://bbpress.org/forums/topic/i-have-a-problem-before-the-installation#post-11165 Sat, 29 Sep 2007 01:33:52 +0000 chrishajer 11165@http://bbpress.org/forums/ Sounds similar to this problem: <a href="http://bbpress.org/forums/topic/intergration-will-not-let-me-logon-using-my-wordpress-login?replies=6" rel="nofollow">http://bbpress.org/forums/topic/intergration-will-not-let-me-logon-using-my-wordpress-login?replies=6</a> Maybe it's a bug? I don't see a trac ticket for it. winiberto on "I have a problem before the installation" http://bbpress.org/forums/topic/i-have-a-problem-before-the-installation#post-11161 Sat, 29 Sep 2007 00:07:04 +0000 winiberto 11161@http://bbpress.org/forums/ Warning: mysql_get_server_info() [function.mysql-get-server-info]: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /home/****/******/votalibre.org/foro/bb-includes/db-mysqli.php on line 80 this is the error... but i try to install, and the tables work and everithing, but always show me that lines! Ajd777 on "WP and BBpress in 2 separate dbs?" http://bbpress.org/forums/topic/wp-and-bbpress-in-2-separate-dbs#post-10387 Wed, 22 Aug 2007 17:30:23 +0000 Ajd777 10387@http://bbpress.org/forums/ This is a little off-topic, but iif you are getting that much spam, you may consider looking at <a href="http://error.wordpress.com/2006/07/04/bad-behavior-2/">Bad Behavior </a> It blocks spambots before they can add content to the database. rfleigh on "WP and BBpress in 2 separate dbs?" http://bbpress.org/forums/topic/wp-and-bbpress-in-2-separate-dbs#post-10365 Wed, 22 Aug 2007 01:14:29 +0000 rfleigh 10365@http://bbpress.org/forums/ i dont understand what "define USER_BBDB_NAME, USER_BBDB_USER, USER_BBDB_PASSWORD, and USER_BBDB_HOST" means.. here is my config.php file. please let me know if this is correct. <?php // ** MySQL settings ** // define('USER_BBDB_NAME', 'XXXXX'); // The name of the database define('USER_BBDB_USER', 'XXXXX'); // Your MySQL username define('USER_BBDB_PASSWORD', 'XXXXXX'); // ...and password define('USER_BBDB_HOST', 'localhost'); // 99% chance you won't need to change this value define('BBDB_NAME', 'XXXXX'); // The name of the database define('BBDB_USER', 'XXXXXX'); // Your MySQL username define('BBDB_PASSWORD', 'XXXXXX'); // ...and password define('BBDB_HOST', 'localhost'); // 99% chance you won't need to change this value // 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://richardfleigh.com/richardfleigh/bbpress/'; // What are you going to call me? $bb->name = 'Richards new bbpress site'; // This must be set before you run the install script. $bb->admin_email = 'richard@mediosone.com'; // 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 = -5; // 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://blog.richardfleigh.com/'; // WordPress - Options->General: Blog address (URL) // Example: 'http://example.com' $bb->wp_siteurl = 'http://blog.richardfleigh.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' ); ?> Trent on "Cannot select DB." http://bbpress.org/forums/topic/cannot-select-db-2#post-8354 Thu, 21 Jun 2007 12:40:33 +0000 Trent 8354@http://bbpress.org/forums/ The name and password of the database are usually not involved with URL's at all. Ask your host how to create a database and the information needed from the config.php. Trent gostallion on "Cannot select DB." http://bbpress.org/forums/topic/cannot-select-db-2#post-8342 Thu, 21 Jun 2007 03:50:41 +0000 gostallion 8342@http://bbpress.org/forums/ Have you created a SQL database in your admin control panel of your site? RatherBeBiking on "Cannot select DB." http://bbpress.org/forums/topic/cannot-select-db-2#post-8339 Thu, 21 Jun 2007 02:32:16 +0000 RatherBeBiking 8339@http://bbpress.org/forums/ // ** MySQL settings ** // define('BBDB_NAME', 'http://www.lagca.com/bbpress'); // The name of the database I'm not sure what to put in here. For reference, our website is <a href="http://www.lagca.com" rel="nofollow">www.lagca.com</a> the blog will be located at <a href="http://www.lagca.com/forums" rel="nofollow">www.lagca.com/forums</a> the folder is in <a href="http://www.lagca.com/bbpress" rel="nofollow">www.lagca.com/bbpress</a> Help! Trent on "WP and BBpress in 2 separate dbs?" http://bbpress.org/forums/topic/wp-and-bbpress-in-2-separate-dbs#post-7555 Sun, 20 May 2007 23:15:37 +0000 Trent 7555@http://bbpress.org/forums/ I actually have done this and those definitions will work, but it sometimes takes some working with your host to get the proper syntax for being able to connect! Trent djuggler on "WP and BBpress in 2 separate dbs?" http://bbpress.org/forums/topic/wp-and-bbpress-in-2-separate-dbs#post-7511 Sat, 19 May 2007 17:45:11 +0000 djuggler 7511@http://bbpress.org/forums/ How'd I overlook this?! From <a href="http://bbpress.org/documentation/integration-with-wordpress/" rel="nofollow">http://bbpress.org/documentation/integration-with-wordpress/</a> <blockquote>If you would like to pull user information from a different database, define USER_BBDB_NAME, USER_BBDB_USER, USER_BBDB_PASSWORD, and USER_BBDB_HOST.</blockquote> djuggler on "WP and BBpress in 2 separate dbs?" http://bbpress.org/forums/topic/wp-and-bbpress-in-2-separate-dbs#post-7510 Sat, 19 May 2007 17:18:13 +0000 djuggler 7510@http://bbpress.org/forums/ My dbs are limited to 100MB and I've watched a spam attack add 20-40MB in a heartbeat on WordPress alone. Granted part of the solution is having SpamKarma purge more frequently. I was concerned that if I added bbpress to the same database, and if it received any significant traffic, that I would find myself faced with running out of space in my database. Naturally, the solution seems to be to have wordpress and bbpress use two separate databases but pull user information from the wordpress db. (Or find a hosting provider that doesn't limit the db size to 100mb) fel64 on "WP and BBpress in 2 separate dbs?" http://bbpress.org/forums/topic/wp-and-bbpress-in-2-separate-dbs#post-7479 Thu, 17 May 2007 15:34:18 +0000 fel64 7479@http://bbpress.org/forums/ I don't know. I doubt it, because bbdb (the object used to do any database stuff) is hardcoded all over the place and you need a new bbdb object for every database you connect to, as far as I'm aware. So integration - which consists of sharing the users and usermeta table I think - would be impossible, unless you changed all references to the user tables to use your second bbdb object. Why do you want to? djuggler on "WP and BBpress in 2 separate dbs?" http://bbpress.org/forums/topic/wp-and-bbpress-in-2-separate-dbs#post-7478 Thu, 17 May 2007 12:30:13 +0000 djuggler 7478@http://bbpress.org/forums/ Has anyone tried to do a Wordpress / BBPress integration using 2 separate databases? Is it possible? Any caveats? Doug fel64 on "Cannot select DB." http://bbpress.org/forums/topic/cannot-select-db#post-7128 Mon, 30 Apr 2007 08:53:27 +0000 fel64 7128@http://bbpress.org/forums/ Have you tried abc's fix? You're sure you have the right details? atlaswu on "Cannot select DB." http://bbpress.org/forums/topic/cannot-select-db#post-7124 Mon, 30 Apr 2007 04:17:25 +0000 atlaswu 7124@http://bbpress.org/forums/ I use php5+mysql 4.1.22 on a Mac, also get message Cannot select DB. I cannot insall and use the bbpress!? Trent on "Cannot select DB. at Install" http://bbpress.org/forums/topic/cannot-select-db-at-install#post-4902 Mon, 26 Feb 2007 00:46:44 +0000 Trent 4902@http://bbpress.org/forums/ Glad to hear you got it working! Cheers, Trent dld on "Cannot select DB. at Install" http://bbpress.org/forums/topic/cannot-select-db-at-install#post-4901 Mon, 26 Feb 2007 00:01:38 +0000 dld 4901@http://bbpress.org/forums/ Thanks, Trent! It was the BBDB_HOST setting - I just had to find out the host for my database. Trent on "Cannot select DB. at Install" http://bbpress.org/forums/topic/cannot-select-db-at-install#post-4897 Sun, 25 Feb 2007 23:38:32 +0000 Trent 4897@http://bbpress.org/forums/ What are you trying to install bbPress on? php and mySQL on a unix, windows, mac, etc? <a href="http://bbpress.org/forums/topic/100?replies=9#post-550">Here</a> is a common issue with installing on a MAC and is the database a localhost installation? If you could give us a bit more we should be able to work towards a solution for you! Check to make sure you have all the correct information in your config.php because it isn't able to see the database that you are putting in it. Trent dld on "Cannot select DB. at Install" http://bbpress.org/forums/topic/cannot-select-db-at-install#post-4893 Sun, 25 Feb 2007 22:55:26 +0000 dld 4893@http://bbpress.org/forums/ I am having this same problem at install, "Cannot select DB." I have only bbPress and not wordPress, so mine is a simple setup. Any ideas on what the problem could be?