Hi Nikita,
This is a bug. All database tables should be utf8_general_ci, but I see on my own installation that a few module tables - and more importantly the generated form tables - are latin1_swedish_ci. This can cause that error message you saw (but this is pretty rare, actually - most database configurations won't care). But more importantly, it can cause problems on non-latin based language sites.
Ack! I'll release a fix for both of these things today.
However: it WON'T fix your problem for your existing table, since it's already been created. To fix it, you'll need to manually edit the database table collation. To do this in phpMyAdmin, click on the "structure" icon/link for the table, then on "Operations" in the top nav. Then change the collation to utf8_general_ci.
Sorry for the fuss.
- Ben
P.S. I've reported the bug here: http://bugs.formtools.org/index.php?cmd=view&id=146
This is a bug. All database tables should be utf8_general_ci, but I see on my own installation that a few module tables - and more importantly the generated form tables - are latin1_swedish_ci. This can cause that error message you saw (but this is pretty rare, actually - most database configurations won't care). But more importantly, it can cause problems on non-latin based language sites.
Quote:PS: I've upgraded to the latest version 2.0.0-beta-20090923 and noticed that there is a bug on the version name. When I click on the button "Check for updates", it says "2.0.0-beta-20090923 is an invalid core version!" - on your file you put 2.0.0-beta-20090823 instead of 2.0.0-beta-20090923!
Ack! I'll release a fix for both of these things today.
However: it WON'T fix your problem for your existing table, since it's already been created. To fix it, you'll need to manually edit the database table collation. To do this in phpMyAdmin, click on the "structure" icon/link for the table, then on "Operations" in the top nav. Then change the collation to utf8_general_ci.
Sorry for the fuss.
- Ben
P.S. I've reported the bug here: http://bugs.formtools.org/index.php?cmd=view&id=146