That didn't work quite the way I expected. All posts and post titles were truncated at the firs special character. :S
Any other ideas? Oh, and how do I disable the Pingback plugin? I don't want to have this activated while importing, as it just takes too damn long. When I try to deactivate it from the plugin page, the following error message appears: Warning: PDOStatement::execute() [function.PDOStatement-execute]: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'henricia_wordpress.log' doesn't exist in system/classes/ databaseconnection.php line 261 Thanks! On 26 Jan, 15:56, Chris Meller <[email protected]> wrote: > Sounds like you're using 0.5.2. There have been several database-encoding > related changes in the code since that release. Unfortunately, I don't think > the WordPress importer works in the latest SVN either, so you're stuck > between a rock and a hard place. > You can try converting all your tables to utf8 manually. I find the easiest > way to do that is to set the database encoding to utf8_unicode_ci before > installing Habari - the tables will inherit that encoding. You can do this > through phpMyAdmin by navigating to the database and clicking the Operations > tab - it should be the last item on the page. After that, you should be able > to install Habari and import without a problem. > > If that doesn't work, you can run a query for each table to update them > manually, then import. Substitute your own prefix (assuming it's not > habari__) in the queries below and dump them in the phpMyAdmin SQL window > for your database: > > ALTER TABLE habari__posts CONVERT TO CHARACTER SET utf8 COLLATE > utf8_unicode_ci; > ALTER TABLE habari__postinfo CONVERT TO CHARACTER SET utf8 COLLATE > utf8_unicode_ci; > ALTER TABLE habari__posttype CONVERT TO CHARACTER SET utf8 COLLATE > utf8_unicode_ci; > ALTER TABLE habari__poststatus CONVERT TO CHARACTER SET utf8 COLLATE > utf8_unicode_ci; > ALTER TABLE habari__options CONVERT TO CHARACTER SET utf8 COLLATE > utf8_unicode_ci; > ALTER TABLE habari__users CONVERT TO CHARACTER SET utf8 COLLATE > utf8_unicode_ci; > ALTER TABLE habari__userinfo CONVERT TO CHARACTER SET utf8 COLLATE > utf8_unicode_ci; > ALTER TABLE habari__tags CONVERT TO CHARACTER SET utf8 COLLATE > utf8_unicode_ci; > ALTER TABLE habari__tag2post CONVERT TO CHARACTER SET utf8 COLLATE > utf8_unicode_ci; > ALTER TABLE habari__comments CONVERT TO CHARACTER SET utf8 COLLATE > utf8_unicode_ci; > ALTER TABLE habari__commentinfo CONVERT TO CHARACTER SET utf8 COLLATE > utf8_unicode_ci; > ALTER TABLE habari__rewrite_rules CONVERT TO CHARACTER SET utf8 COLLATE > utf8_unicode_ci; > ALTER TABLE habari__crontab CONVERT TO CHARACTER SET utf8 COLLATE > utf8_unicode_ci; > ALTER TABLE habari__log CONVERT TO CHARACTER SET utf8 COLLATE > utf8_unicode_ci; > ALTER TABLE habari__log_types CONVERT TO CHARACTER SET utf8 COLLATE > utf8_unicode_ci; > ALTER TABLE habari__groups CONVERT TO CHARACTER SET utf8 COLLATE > utf8_unicode_ci; > ALTER TABLE habari__permissions CONVERT TO CHARACTER SET utf8 COLLATE > utf8_unicode_ci; > ALTER TABLE habari__users_groups CONVERT TO CHARACTER SET utf8 COLLATE > utf8_unicode_ci; > ALTER TABLE habari__groups_permissions CONVERT TO CHARACTER SET utf8 COLLATE > utf8_unicode_ci; > ALTER TABLE habari__sessions CONVERT TO CHARACTER SET utf8 COLLATE > utf8_unicode_ci; > > Good luck and let us know how it goes. Hopefully 0.6 will be out soon and > people won't have these kinds of problems anymore. :) > > On Mon, Jan 26, 2009 at 6:59 AM, HenrikWL <[email protected]> wrote: > > > I'm having some issues when porting my blog from WP to Habari. All the > > posts get imported ok, but all special characters ends up like > > question marks. It's obviously some encoding issue, but I don't know > > how to fix it. The WP database is all in utf8_general_ci, but I notice > > that the Habari database is all in latin1_swedish_ci. May this be the > > culprit, perchance? > > > Oh, this is double-posted here and in the forums. This group is more > > active than the forums, so I guessed I had better luck here. :) --~--~---------~--~----~------------~-------~--~----~ To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/habari-users -~----------~----~----~----~------~----~------~--~---
