http://bbpress.org/forums/ bbPress support forums Tag: database en Fri, 04 Jul 2008 20:53:34 +0000 http://bbpress.org/forums/topic/unable-to-upgrade-081-to-0902#post-16954 Thu, 26 Jun 2008 08:50:37 +0000 PaulMyatt 16954@http://bbpress.org/forums/ <p>The errors I saw were:<br /> "bbPress database error: [Duplicate key name 'user_nicename']<br /> ALTER TABLE wp_users ADD UNIQUE KEY user_nicename (user_nicename)</p> <p>Fatal error: Maximum execution time of 600 seconds exceeded in /var/www/html/forum/bb-admin/upgrade-functions.php on line 499"</p> <p>After seeing that I had a look at the WP user table to examine user_nicename. I renamed the field and reran the upgrade. This time I got the error:</p> <p>"Fatal error: Maximum execution time of 600 seconds exceeded in /var/www/html/forum/bb-includes/functions.php on line 2644".</p> <p>WordPress is version 2.5.1. MySQL is "4.1.22-standard". </p> http://bbpress.org/forums/topic/unable-to-upgrade-081-to-0902#post-16895 Tue, 24 Jun 2008 14:46:54 +0000 chrishajer 16895@http://bbpress.org/forums/ <p>Interesting. Do you have access to any sort of MySQL logs? I doubt you will be able to see this from a browser since the script is just timing out.</p> <p>I have not tried to upgrade my old installation to a current one so I have not experienced this. Now I'm scared :-) </p> http://bbpress.org/forums/topic/unable-to-upgrade-081-to-0902#post-16890 Tue, 24 Jun 2008 12:50:17 +0000 PaulMyatt 16890@http://bbpress.org/forums/ <p>I'm trying to upgrade BBPress 0.8.1 to 0.9.0.2.</p> <p>I've followed the instructions to the letter and all is fine until I try and login as admin.</p> <p>I get the message:<br /> "Database upgrade required. It looks like your database is out-of-date. You can update it here". When I click "Upgrade Database" after 10 minutes or more I get a php script timeout error.</p> <p>Any ideas? </p> http://bbpress.org/forums/topic/integration-and-second-database#post-15850 Tue, 29 Apr 2008 01:38:41 +0000 arlene476 15850@http://bbpress.org/forums/ <p>Is there any doc for a forum in a subdomain? </p> http://bbpress.org/forums/topic/bbpress-on-a-ms-sql-server#post-15762 Fri, 25 Apr 2008 15:20:15 +0000 sambauers 15762@http://bbpress.org/forums/ <p>You would have to write a replacement for bb-includes/db.php to get bbPress to work with MSSQL. </p> http://bbpress.org/forums/topic/bbpress-on-a-ms-sql-server#post-15755 Fri, 25 Apr 2008 08:50:47 +0000 anjap 15755@http://bbpress.org/forums/ <p>Has anyone tried to install bbpress on ms sql server ?</p> <p>I know mysql is required, but we already have a ms sql 2003 server up and runnig and would like to use bbpress on our intranet. </p> <p>Of cource we don't want to mess up the existing stuff, but on other hand we would like to avoid having both mssql and mysql runnig.</p> <p>So any experience, good advices or hints would be appreciated... </p> http://bbpress.org/forums/topic/error-when-deleting-entire-topic#post-15742 Thu, 24 Apr 2008 11:51:19 +0000 fokjulle 15742@http://bbpress.org/forums/ <p>Well, everything installed smoothly, so I don't know what more to say... </p> http://bbpress.org/forums/topic/error-when-deleting-entire-topic#post-15741 Thu, 24 Apr 2008 11:26:15 +0000 _ck_ 15741@http://bbpress.org/forums/ <p>The word "swedish" is in there only because MySQL was originally a Swedish product and it's legacy. Has nothing to do with any local language settings - just means it's at the default.</p> <p>Perhaps a database upgrade failed at some point and left it at a weird miss-match? </p> http://bbpress.org/forums/topic/error-when-deleting-entire-topic#post-15739 Thu, 24 Apr 2008 07:17:47 +0000 fokjulle 15739@http://bbpress.org/forums/ <p>Still throwing the same error message... </p> http://bbpress.org/forums/topic/error-when-deleting-entire-topic#post-15731 Thu, 24 Apr 2008 00:06:42 +0000 sambauers 15731@http://bbpress.org/forums/ <p>Try editing this line in your bb-config.php file.</p> <pre><code>define(&#39;BBDB_COLLATE&#39;, &#39;&#39;);</code></pre> <p>.<br /> To this:</p> <pre><code>define(&#39;BBDB_COLLATE&#39;, &#39;utf8_general_ci&#39;);</code></pre> http://bbpress.org/forums/topic/error-when-deleting-entire-topic#post-15710 Wed, 23 Apr 2008 07:35:45 +0000 fokjulle 15710@http://bbpress.org/forums/ <p>I have no idea what you're talking about... </p> http://bbpress.org/forums/topic/error-when-deleting-entire-topic#post-15692 Tue, 22 Apr 2008 21:51:42 +0000 chrishajer 15692@http://bbpress.org/forums/ <p>Sounds like the collation on some tables or fields in the database don't match some others. I think they should all be the same. If you log in with phpMyAdmin, you should be able to check what the database collation is, then make all the tables and fields the same.</p> <p>This is only a guess though, but if it were my forum and my error, that's what I would do. </p> http://bbpress.org/forums/topic/error-when-deleting-entire-topic#post-15691 Tue, 22 Apr 2008 21:21:40 +0000 fokjulle 15691@http://bbpress.org/forums/ <p>Has someone had a chance to look at this?... </p> http://bbpress.org/forums/topic/error-when-deleting-entire-topic#post-15603 Mon, 21 Apr 2008 12:37:12 +0000 fokjulle 15603@http://bbpress.org/forums/ <p>Here is config.php:</p> <p><code><br /> &lt;?php</p> <p>// ** MySQL settings ** //<br /> define('BBDB_NAME', '*********'); // The name of the database<br /> define('BBDB_USER', '********'); // Your MySQL username<br /> define('BBDB_PASSWORD', '*********'); // ...and password<br /> define('BBDB_HOST', '**********'); // 99% chance you won't need to change these last few</p> <p>define('BBDB_CHARSET', 'utf8'); // If you are *upgrading*, and your old bb-config.php does<br /> define('BBDB_COLLATE', '');<br /> define('BB_LANG', ''); // not have these two contstants in them, DO NOT define them<br /> // If you are installing for the first time, leave them here</p> <p>// Change BB_SECRET_KEY to a unique phrase. You won't have to remember it later,<br /> // so make it long and complicated. You can visit <a href="https://www.grc.com/passwords.htm" rel="nofollow">https://www.grc.com/passwords.htm</a><br /> // to get a phrase generated for you, or just make something up.<br /> // If you are integrating logins with WordPress, you will need to match the value<br /> // of the "SECRET_KEY" in the WordPress file wp-config.php<br /> define('BB_SECRET_KEY', ''); // Change this to a unique phrase.</p> <p>// If you are running multiple bbPress installations in a single database,<br /> // you will probably want to change this.<br /> $bb_table_prefix = 'bb_'; // Only letters, numbers and underscores please!</p> <p>// Change this to localize bbPress. A corresponding MO file for the<br /> // chosen language must be installed to bb-includes/languages.<br /> // For example, install de.mo to bb-includes/languages and set BB_LANG to 'de'<br /> // to enable German language support.<br /> define('BB_LANG', '');</p> <p>/* Stop editing */</p> <p>if ( !defined('BB_PATH') )<br /> define('BB_PATH', dirname(__FILE__) . '/' );<br /> require_once( BB_PATH . 'bb-settings.php' );</p> <p>?&gt;<br /> </code></p> <p>Yes, I use PHPMyAdmin... </p> http://bbpress.org/forums/topic/error-when-deleting-entire-topic#post-15601 Mon, 21 Apr 2008 12:27:20 +0000 chrishajer 15601@http://bbpress.org/forums/ <p>Maybe the database you used for WordPress has a different collation, but WordPress didn't care about the difference where bbPress does care and gives you an error? </p> <p>Do you have access to the database with something like phpMyAdmin? </p> http://bbpress.org/forums/topic/error-when-deleting-entire-topic#post-15600 Mon, 21 Apr 2008 12:09:56 +0000 sambauers 15600@http://bbpress.org/forums/ <p>Can you post the database section of your bb-config.php here (the first 15 or so lines). Turn anything sensitive, like the password, into ********. </p> http://bbpress.org/forums/topic/error-when-deleting-entire-topic#post-15594 Mon, 21 Apr 2008 08:59:20 +0000 fokjulle 15594@http://bbpress.org/forums/ <p>If anyone can help, <a href="http://trashmedia.co.za/forums">here</a> is my forum. </p> http://bbpress.org/forums/topic/error-when-deleting-entire-topic#post-15593 Mon, 21 Apr 2008 08:58:38 +0000 fokjulle 15593@http://bbpress.org/forums/ <p>I have the latest MySQL, or, my host company, at least, does. They're very good that way. I've tried the above fixes, and nothing works. I've adjusted nothing in my config file.</p> <p>Also, I'm not Swedish, so I'm not sure why anything needs to be Swedish... </p> http://bbpress.org/forums/topic/error-when-deleting-entire-topic#post-15579 Sun, 20 Apr 2008 23:25:07 +0000 sambauers 15579@http://bbpress.org/forums/ <p>I imagine you have this set in your bb-config.php:</p> <pre><code>define(&#39;BBDB_COLLATE&#39;, &#39;utf8_general_ci&#39;);</code></pre> <p>.<br /> When it should be (in your case):</p> <pre><code>define(&#39;BBDB_COLLATE&#39;, &#39;latin1_swedish_ci&#39;);</code></pre> http://bbpress.org/forums/topic/error-when-deleting-entire-topic#post-15570 Sun, 20 Apr 2008 15:45:09 +0000 chrishajer 15570@http://bbpress.org/forums/ <p>I have no idea what that is, but I can try and help until someone more knowledgeable comes along.</p> <p>Did you set any of these three lines to something different than the default in your bb-config.php:</p> <pre><code>define(&#39;BBDB_CHARSET&#39;, &#39;utf8&#39;); define(&#39;BBDB_COLLATE&#39;, &#39;&#39;); define(&#39;BB_LANG&#39;, &#39;&#39;);</code></pre> <p>&nbsp;<br /> I found this online:<br /> <a href="http://www.datutorials.com/mysql/mysql_ref_manual_Charset.php" rel="nofollow">http://www.datutorials.com/mysql/mysql_ref_manual_Charset.php</a></p> <p>What is your MySQL version? </p> http://bbpress.org/forums/topic/error-when-deleting-entire-topic#post-15558 Sun, 20 Apr 2008 08:04:54 +0000 fokjulle 15558@http://bbpress.org/forums/ <p>What is this, and how do I fix it?</p> <p>**************<br /> bbPress database error: [Illegal mix of collations (utf8_general_ci,COERCIBLE) and (latin1_swedish_ci,IMPLICIT) for operation 'find_in_set']<br /> SELECT user_id, meta_value FROM bb_usermeta WHERE meta_key = 'favorites' and FIND_IN_SET('3', meta_value) &gt; 0</p> <p>Warning: Cannot modify header information - headers already sent by (output started at /usr/www/users/trashm/forums/bb-includes/db-mysql.php:106) in /usr/www/users/trashm/forums/bb-includes/pluggable.php on line 224 </p> http://bbpress.org/forums/topic/post_status#post-15298 Sat, 12 Apr 2008 04:34:59 +0000 patrace 15298@http://bbpress.org/forums/ <p>Thanks! </p> http://bbpress.org/forums/topic/add-new-fields-to-user-profile#post-14782 Sat, 29 Mar 2008 05:32:58 +0000 djquinn 14782@http://bbpress.org/forums/ <p>rock on </p> http://bbpress.org/forums/topic/add-new-fields-to-user-profile#post-14773 Fri, 28 Mar 2008 19:58:08 +0000 chrishajer 14773@http://bbpress.org/forums/ <p><a href="http://bbpress.org/forums/topic/adding-custom-profile-fields" rel="nofollow">http://bbpress.org/forums/topic/adding-custom-profile-fields</a> ?</p> <p>It's old but the idea is the same now as it was then. The process may have changed a bit. </p> http://bbpress.org/forums/topic/add-new-fields-to-user-profile#post-14767 Fri, 28 Mar 2008 17:48:27 +0000 djquinn 14767@http://bbpress.org/forums/ <p>Anyone know how I might hook into the user profile to add new fields (I'm talking broad advice here! If you can give me a idea as to where to hook, I'll figure the rest out). I want to add new fields in the "Edit Profile" section, have them stored in bbpress database, and then display the fields on the user profile page. </p> <p>I don't care about editing the core, if that's the easiest way. </p> http://bbpress.org/forums/topic/two-different-databases#post-14485 Sat, 15 Mar 2008 17:42:58 +0000 r00n 14485@http://bbpress.org/forums/ <p>I will have a look on it on monday. I will start over with a fresh mind. When everything will be easier why should I try to get it working this weekend. Thanks for the hint! </p> http://bbpress.org/forums/topic/two-different-databases#post-14483 Sat, 15 Mar 2008 15:38:07 +0000 _ck_ 14483@http://bbpress.org/forums/ <p>Separate db vs one table is something new for 0.9 I believe.</p> <p>Those are constants that have to be defined in bb-config.php just like any of the other constants. ie.<br /> <code>define(&#39;USER_BBDB_NAME&#39;,&#39;blahblah&#39;);</code></p> <p>If you are just now installing bbpress and not already integrating an existing install, if you wait for the 0.9 release on monday, it will do most of the integration for you.</p> <p>There are endless instructions for integration, I've gathered most of them here (though that list is getting outdated for 0.9)</p> <p><a href="http://bbshowcase.org/forums/topic/better-bbpress-wordpress-integration-the-missing-faq" rel="nofollow">http://bbshowcase.org/forums/topic/better-bbpress-wordpress-integration-the-missing-faq</a> </p> http://bbpress.org/forums/topic/two-different-databases#post-14481 Sat, 15 Mar 2008 14:24:53 +0000 r00n 14481@http://bbpress.org/forums/ <p>I know the idea of integrate. When I check the documentation on the BBpress site about integrate I find this: </p> <p>"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."</p> <p>Now I don't how to do this. I should add this to the config.php file, but how and where exactly to put this is not clear to me. A visitor doesn't seem any difference and I will not have big MySQL databases. </p> <p>When I find out in a later stage that I have a lack of visitors I can remove all the data within an eye wink instead of the big adventure of finding everything concerning BBpress in the Wordpress database. </p> http://bbpress.org/forums/topic/two-different-databases#post-14480 Sat, 15 Mar 2008 13:50:45 +0000 chrishajer 14480@http://bbpress.org/forums/ <p>With integration, you are sharing the wp_users table. Even if bbPress and WordPress are in different databases, there is going to be some shared data - that's what the integration does. So having bbPress and WordPress in different databases doesn't actually help with that. If you have them in the same database, just drop the bb_ tables and edit the users to remove any bbPress users. I don't think using different databases helps you down the road. </p> http://bbpress.org/forums/topic/two-different-databases#post-14479 Sat, 15 Mar 2008 13:20:59 +0000 r00n 14479@http://bbpress.org/forums/ <p>I try to integrate BBpress and WordPress. I've already read that it isn't a problem to have BBpress on a sub-domain. So that is something I will do. Another problem I have is that I want to have two different databases. In a later stage I want to be able (doesn't say that I will do it) to remove the forum with all his database information. Is there a simple way of doing that? </p>