pyrocms/pyrocms — Issue #861: database table collation inconsistent
Author: boazhachlili
Created: 2011-11-01 13:10:29+00:00
State: open

The table default ci_sessions, which is created in installer/libraries/Module_import.php, is missing the engine / charset / collation statement from it's creation script (" ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; ").

See line 141 of this file.

This caused a problem when I installed a site and created a home page called "home" in Hebrew characters.
Since I *love* to hear the sound of my keyboard clicking, here's an error snapshot: http://tinypic.com/r/11uf77a/5

I'll submit a pull request to add the missing line.