http://bbpress.org/forums/ bbPress support forums Tag: phpmyadmin en Tue, 02 Dec 2008 22:21:27 +0000 http://bbpress.org/forums/topic/phpbb-to-bbpress-easy-export#post-16628 Fri, 06 Jun 2008 18:07:24 +0000 rogermbyrne 16628@http://bbpress.org/forums/ <p>hi chrishajer</p> <p>after your suggestion i tried to think of a diff way so i installed phpbb via fantastico on a different domain iimported the odl database and then looked through phpmyadmin to see if i could find the posts, success! exported as .csv file and now i have all the data and email addresses ;)</p> <p>thanks for your help! </p> http://bbpress.org/forums/topic/phpbb-to-bbpress-easy-export#post-16624 Fri, 06 Jun 2008 14:48:35 +0000 chrishajer 16624@http://bbpress.org/forums/ <p>If you have direct access to the database with something like phpMyAdmin, you can view the existing posts. Sounds like the phpBB is not running now, otherwise I would just copy the text from there. Without the software running, you're going to need to view the posts in the database and copy them from there and paste into bbPress. With a small number of posts, I wouldn't bother with export and import, just copy them and post new at bbPress. </p> http://bbpress.org/forums/topic/phpbb-to-bbpress-easy-export#post-16623 Fri, 06 Jun 2008 13:45:52 +0000 rogermbyrne 16623@http://bbpress.org/forums/ <p>Hi Guys and Gals</p> <p>I have a very small phpbb database but not up and running as many problems i have installed bbpress everything is working fine! (except I forgot about moderation and akismet and within 27 mins of going online it had four spam comments ;) )</p> <p>Is there a way I can just see the posts from that phpbb database and then i will copy and paste into my new bbpress installation?</p> <p>or is their an easier way? I have xampp runnin locally but tried to move the phpbb files and import the db using phpmyadmin but i get errors.</p> <p>Like i said its a v small database and I just need the post text!</p> <p>Thanks in advance<br /> Roger </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/forum-disappeared-1#post-15465 Thu, 17 Apr 2008 04:39:05 +0000 BloggerDesign 15465@http://bbpress.org/forums/ <p>After a lot of digging and hacking I finally got a user set to admin level. Thank goodness for PHPmyAdmin. All is good now. </p> http://bbpress.org/forums/topic/forum-disappeared-1#post-15464 Thu, 17 Apr 2008 03:48:39 +0000 BloggerDesign 15464@http://bbpress.org/forums/ <p>Is there a manual way to get someone set to KeyMaster? I registered and was user #1. There seems to be no use #0 so there is no administer for the forum. I'm totally locked out. :( </p> http://bbpress.org/forums/topic/forum-disappeared-1#post-15462 Thu, 17 Apr 2008 03:34:45 +0000 BloggerDesign 15462@http://bbpress.org/forums/ <p>I found the issue. The table names were custom set to not interfear with anything that that wasn't called out anywhere in the install process except in an advanced (hidden) area.</p> <p>I've re-installed BBPress 4 times now and I finally go it to work, with all my old posts, but I can't log in. :( </p> http://bbpress.org/forums/topic/forum-disappeared-1#post-15459 Thu, 17 Apr 2008 03:25:42 +0000 chrishajer 15459@http://bbpress.org/forums/ <p>First, I think I would use a tool like phpMyAdmin to look at the database and see if the old tables and old posts are there. Maybe you just have something like a different table prefix in your new installation so it's not seeing the old installation any more?</p> <p>Do you have direct access to the database to look and see what tables are present, then, what's in the bb_posts table (or any other *_posts tables)? </p> http://bbpress.org/forums/topic/forum-disappeared-1#post-15458 Thu, 17 Apr 2008 03:19:55 +0000 BloggerDesign 15458@http://bbpress.org/forums/ <p>I followed the upgrade instructions and it never noticed my old posts. They are all gone and I'm back to zero! Help!!</p> <p>Is there a manual way to upgrade? Can I import them all? HELP. </p> http://bbpress.org/forums/topic/importexport-from-one-bbpress-to-another#post-15011 Fri, 04 Apr 2008 03:58:33 +0000 sambauers 15011@http://bbpress.org/forums/ <p>You have just described one of the Google Summer of Code ideas that might be going ahead.</p> <p><a href="http://codex.wordpress.org/GSoC2008#Web_Forums_Export.2FImport_Standard_and_Tools" rel="nofollow">http://codex.wordpress.org/GSoC2008#Web_Forums_Export.2FImport_Standard_and_Tools</a></p> <p>This is something I will be pursuing to create better interoperability between different forum platforms. </p> http://bbpress.org/forums/topic/importexport-from-one-bbpress-to-another#post-15001 Fri, 04 Apr 2008 01:43:02 +0000 chrishajer 15001@http://bbpress.org/forums/ <p>Why not just dump the database and restore on the new server? Why mess with XML at all if it's just bbPress &gt; bbPress? No plugin necessary. </p> http://bbpress.org/forums/topic/importexport-from-one-bbpress-to-another#post-14997 Fri, 04 Apr 2008 00:44:52 +0000 charliestout 14997@http://bbpress.org/forums/ <p>Any interest out there in a plugin that would make it possible to output bbPress content into an XML file similar to the Wordpress Export so that we could move easily from one server to the next? </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> http://bbpress.org/forums/topic/problem-with-gengo#post-9371 Thu, 26 Jul 2007 14:01:00 +0000 fel64 9371@http://bbpress.org/forums/ <p>Not being able to log in is usually a cookie problem. What's your $bb_domain and your $bb_path? Can you please clear your cookies, attempt to log in and tell us what cookies are set?</p> <p>Can you temporarily disable gengo and see if that fixes anything? </p> http://bbpress.org/forums/topic/problem-with-gengo#post-9365 Thu, 26 Jul 2007 11:15:19 +0000 gostallion 9365@http://bbpress.org/forums/ <p>Hi i just want to check if anyone knows installation of gengo on wp to support a 2nd language would interfere with bbpress?</p> <p>My bbpress totally tanked. I can't login, when I try to do a new registration, admin's email appears on the email field.</p> <p>Please help! </p>