http://bbpress.org/forums/ bbPress Support Forums Tag: collation en Fri, 09 Jan 2009 02:54:48 +0000 http://bbpress.org/forums/topic/problems-with-character-set-after-upgrade#post-22744 Thu, 08 Jan 2009 03:50:19 +0000 sambauers 22744@http://bbpress.org/forums/ <p>Those settings are wrong. The charset and collation should match what your DB actually is. </p> http://bbpress.org/forums/topic/problems-with-character-set-after-upgrade#post-22733 Wed, 07 Jan 2009 20:24:16 +0000 DanielJuhl 22733@http://bbpress.org/forums/ <p>I've solved the problem, by defining charset as latin1_swedish_ci and collate as utf8, even though I would been it should have been the other way around - or am I wrong? </p> http://bbpress.org/forums/topic/problems-with-character-set-after-upgrade#post-22732 Wed, 07 Jan 2009 20:00:52 +0000 DanielJuhl 22732@http://bbpress.org/forums/ <p>Nope, it's not shared or anything.. but it seems like being a problem between what character set of data bbPress thinks it getting and what it actually get. I'll try working on it, and see what happends.. </p> http://bbpress.org/forums/topic/problems-with-character-set-after-upgrade#post-22717 Wed, 07 Jan 2009 14:05:03 +0000 Ipstenu 22717@http://bbpress.org/forums/ <p>Are you using a shared DB with WordPress and, if so, did you happen to use Fantastico or some other installer app to install it?</p> <p>I've seen that (latin1_swedish_ci) borking recently with a weird WP install, but not with BBPress. </p> http://bbpress.org/forums/topic/problems-with-character-set-after-upgrade#post-22714 Wed, 07 Jan 2009 10:51:42 +0000 DanielJuhl 22714@http://bbpress.org/forums/ <p>Hi,</p> <p>I've just tested an upgrade of my bbPress 0.8.2.1 forum. The upgrade goes to bbPress 0.9.0.4, but after the upgrade has finished and the upgrade/installation script has asked, and been given permission, to upgrade the database, it seems like theres some problems with special characters. The forum is in danish, and therefore æ, ø and å is very common, but after the upgrade they just show up as their respective UTF8 codes. I can't figure out, and but the header and my browser is set to UTF8.</p> <p>I can tell, that the forum was and still are in UTF8, but the collation on the database tables is latin1_swedish_ci</p> <p>Anyone with an idea of the problem? </p> http://bbpress.org/forums/topic/database-character-collation#post-20670 Thu, 13 Nov 2008 21:37:49 +0000 junglecat 20670@http://bbpress.org/forums/ <p>I got it figured out and it's installed.</p> <p>Thanks! </p> http://bbpress.org/forums/topic/database-character-collation#post-20608 Tue, 11 Nov 2008 08:37:49 +0000 chrishajer 20608@http://bbpress.org/forums/ <p>You don't normally need to set anything there. The installation will continue fine without it.</p> <p>Every MySQL database uses character collation, but it's normally hidden from sight. For my bbPress installation, the collation is <code>utf8_general_ci</code>. But I didn't have to set it, it's already there. In a unique situation you might need to set it, but I've never messed with it. </p> http://bbpress.org/forums/topic/database-character-collation#post-20607 Mon, 10 Nov 2008 20:32:21 +0000 junglecat 20607@http://bbpress.org/forums/ <p>I'm in the middle of installing this, but I need the "database character collation"</p> <p>What is that and where do I find it? </p> <p>I created the database before installation, but I never heard of the "character collation value" and I've installed a lot of scripts.</p> <p>I use cpanel if that makes a difference. </p> http://bbpress.org/forums/topic/database-collation#post-19855 Sun, 12 Oct 2008 14:54:27 +0000 myu 19855@http://bbpress.org/forums/ <p>Hi,<br /> I have installed bbPress on local servers (MAMP / Apache that came with mac) and these installations made database tables with collation of "utf8_general_ci"</p> <p>Installed on online server, and this one made database tables with collation of "latin1_swedish_ci"</p> <p>Why?<br /> And more importantly, does it matter?</p> <p>Either way, a lot of entries are not going to be in English, so anything in db isn't human-readable, so if it doesn't matter, it doesn't matter, I guess.<br /> Though, if there is any way to be able to read non-ascii stuffs in database, I would love to know, please...</p> <p>Thanks. </p> http://bbpress.org/forums/topic/impossible-to-install-bbpress-revision-1595#post-17561 Wed, 23 Jul 2008 11:05:42 +0000 csseur3 17561@http://bbpress.org/forums/ <p>yes, it works now, but the adress of the site is not show at the end of install :)</p> <p>bye </p> http://bbpress.org/forums/topic/impossible-to-install-bbpress-revision-1595#post-17550 Wed, 23 Jul 2008 02:32:10 +0000 _ck_ 17550@http://bbpress.org/forums/ <p>I've confirmed the newest trunk build now fixes this problem (at least for me)</p> <p>build # 1598 </p> http://bbpress.org/forums/topic/impossible-to-install-bbpress-revision-1595#post-17549 Wed, 23 Jul 2008 02:10:01 +0000 sambauers 17549@http://bbpress.org/forums/ <p>My guess is that you didn't specify a charset collation for the database on install.</p> <p>I've just made a change that should fix your problem (if that was it). </p> http://bbpress.org/forums/topic/impossible-to-install-bbpress-revision-1595#post-17547 Wed, 23 Jul 2008 01:43:23 +0000 _ck_ 17547@http://bbpress.org/forums/ <p>Er that's the trunk and subject to being broken at times.</p> <p>I don't recommend you go beyond the 0.9 branch:<br /> <a href="http://trac.bbpress.org/browser/branches/0.9" rel="nofollow">http://trac.bbpress.org/browser/branches/0.9</a><br /> or if you are using svn<br /> <a href="http://svn.automattic.com/bbpress/branches/0.9/" rel="nofollow">http://svn.automattic.com/bbpress/branches/0.9/</a> </p> http://bbpress.org/forums/topic/impossible-to-install-bbpress-revision-1595#post-17546 Wed, 23 Jul 2008 01:30:25 +0000 csseur3 17546@http://bbpress.org/forums/ <p>Hello,</p> <p>with the last installation of bbpress revision 1595, i have sql errors:</p> <p>SQL ERROR!<br /> &gt;&gt;&gt; Database: forum_bbpress (localhost)<br /> &gt;&gt;&gt;&gt;&gt;&gt; CREATE TABLE IF NOT EXISTS <code>bb_forums</code> (<br /> <code>forum_id</code> int(10) NOT NULL auto_increment,<br /> <code>forum_name</code> varchar(150) NOT NULL default '',<br /> <code>forum_slug</code> varchar(255) NOT NULL default '',<br /> <code>forum_desc</code> text NOT NULL,<br /> <code>forum_parent</code> int(10) NOT NULL default 0,<br /> <code>forum_order</code> int(10) NOT NULL default 0,<br /> <code>topics</code> bigint(20) NOT NULL default 0,<br /> <code>posts</code> bigint(20) NOT NULL default 0,<br /> PRIMARY KEY (<code>forum_id</code>),<br /> KEY <code>forum_slug</code> (<code>forum_slug</code>)<br /> ) DEFAULT CHARACTER SET 'utf8' COLLATE '';<br /> &gt;&gt;&gt;&gt;&gt;&gt; Unknown collation: ''<br /> SQL ERROR!<br /> &gt;&gt;&gt; Database: forum_bbpress (localhost)<br /> &gt;&gt;&gt;&gt;&gt;&gt; CREATE TABLE IF NOT EXISTS <code>bb_meta</code> (<br /> <code>meta_id</code> bigint(20) NOT NULL auto_increment,<br /> <code>object_type</code> varchar(16) NOT NULL default 'bb_option',<br /> <code>object_id</code> bigint(20) NOT NULL default 0,<br /> <code>meta_key</code> varchar(255) default NULL,<br /> <code>meta_value</code> longtext default NULL,<br /> PRIMARY KEY (<code>meta_id</code>),<br /> KEY <code>object_type__meta_key</code> (<code>object_type</code>, <code>meta_key</code>),<br /> KEY <code>object_type__object_id__meta_key</code> (<code>object_type</code>, <code>object_id</code>, <code>meta_key</code>)<br /> ) DEFAULT CHARACTER SET 'utf8' COLLATE '';<br /> &gt;&gt;&gt;&gt;&gt;&gt; Unknown collation: ''<br /> SQL ERROR!</p> <p>etc, etc...</p> <p>why?</p> <p>bye </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/problem-with-gengo#post-9381 Thu, 26 Jul 2007 15:24:59 +0000 gostallion 9381@http://bbpress.org/forums/ <p>Hi fel64,</p> <p>I removed the gengo plugin from wp and things are back to normal. I noticed in phpmyadmin collation for database between bb and wp doesn;t match and I'm guessing it's partly responsible for my woes.</p> <p>Collation for wp is utf-8 while bb is latin1_swedish_ci. But I'm not sure how to change this.</p> <p>I need to check if gengo is supported in bb. </p>