Mysql tables creation error for 3.0
| From: | José A. Guzmán | Date: | Wed, 20 Feb 2002 00:16:05 +0000 |
| Subject: | Mysql tables creation error for 3.0 | ||
| Groups: | php.install | ||
| Request: | Send a blank email to php-install+get-6069@lists.php.net to get a copy of this message | ||
Hi all
I'm using MySQL 3.22.32
When running the sql scripts in horde,
the horde_prefs needs : primary key (pref_uid, pref_scope, pref_name)
but MySQL complains with:
ERROR 1071: Specified key was too long. Max key length is 256
I created the table with a primary key of only pref_uid anyway to see if
I could get away with this limitation, but when activating 'sql' preferences
in horde, IMP just states session terminated and does not allow logins.
If I create the table with primary key (pref_scope, pref_name) only MySQL
does not complain.
Can I reduce the size of pref_uid? is there a workaround? I would'nt like to
'upgrade' MySQL to a different version if possible...
This is what 'should' be created:
CREATE TABLE horde_prefs (
pref_uid char(255) not null, pref_scope char(16) not null default '', pref_name char(32) not null, pref_value text null,primary key (pref_uid, pref_scope, pref_name) );