View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000070 | WackoWiki | installer | public | 2007-08-31 16:46 | 2009-08-19 09:39 |
| Reporter | EoNy | Assigned To | Tann San | ||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | resolved | Resolution | fixed | ||
| Product Version | 4.2 | ||||
| Target Version | 4.3.rc | Fixed in Version | 4.3.rc | ||
| Summary | 0000070: can't install to UTF-8 database, table creation error | ||||
| Description | Could not install into an UTF-8 character set and utf8_unicode_ci collate MySQL 4.1 database. Installer complained, that it can't create the `links` table. MySQL said for `CREATE TABLE links...`: ERROR 1071 (42000): Specified key was too long; max key length is 1000 bytes | ||||
| Additional Information | WackoWiki version: R4.2 MySQL version: 4.1.15-1ubuntu5 Database created with command: CREATE DATABASE wakka CHARACTER SET utf8 COLLATE utf8_unicode_ci ; In `CREATE TABLE links...` quoery, ffter changing all varchar field length from 250 to 165 characters, CREATE TABLE command was succeed. | ||||
| Tags | No tags attached. | ||||
|
|
mb 31-10-2006 18:13 http://bugs.mysql.com/bug.php?id=4541 link tracking – ERROR My Sql 4.1 Compatibility only with DB locale Latin-1; no UTF8! change \mysql\bin\my.cnf from MySQL and comment out the line «set-variable = default-character-set=utf8», restart MySQL – now it should work again. MiroslawGo 06-11-2006 10:21 It's MySQL bug. Another workaround: Change line 89 in setup/install.php from: "KEY from_tag (from_tag,to_tag),". to: "KEY from_tag (from_tag,to_tag(78)),". Now WackoWiki is UTF-8 compatible... ????????????: 06-11-2006 11:12 |
|
|
I'm re-writing the entire installation procedure, well doing large update to it. I've implemented MiroslawGos suggestion about changing line 89. Count this bug as squashed. |
|
|
check my last comment. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2007-08-31 16:46 | EoNy | New Issue | |
| 2007-08-31 16:46 | EoNy | Legacy | => NEW |
| 2007-08-31 16:46 | EoNy | Note Added: 0000062 | |
| 2007-08-31 21:02 | administrator | Legacy | NEW => NPJ |
| 2007-09-12 21:45 | Tann San | Note Added: 0000073 | |
| 2007-09-12 21:45 | Tann San | Status | new => assigned |
| 2007-09-12 21:45 | Tann San | Assigned To | => Tann San |
| 2007-09-12 21:46 | Tann San | Status | assigned => resolved |
| 2007-09-12 21:46 | Tann San | Fixed in Version | => 5.0.0 |
| 2007-09-12 21:46 | Tann San | Resolution | open => fixed |
| 2007-09-12 21:46 | Tann San | Note Added: 0000074 | |
| 2007-09-20 13:12 | administrator | Target Version | => 5.0.0 |
| 2009-08-19 09:18 | administrator | Fixed in Version | 5.0.0 => 4.3.rc |
| 2009-08-19 09:39 | administrator | Target Version | 5.0.0 => 4.3.rc |
| 2010-03-08 10:14 | administrator | Category | Installer => installer |
