[OpenSER-Users] ERROR 1071 (42000) at line 2: Specified key was too long; max key length is 1000 bytes
21 May
2008
21 May
'08
10:13 a.m.
Hi,
When I try to create openser database (openserdbctl create) on Gentoo, I
have the message:
INFO: creating database openser ...
ERROR 1071 (42000) at line 2: Specified key was too long; max key length is
1000 bytes
ERROR: Creating core tables failed!
I search when i can modify TABLE_TYPE but i not found.
Regards,
Yazid
21 May
21 May
11:17 a.m.
New subject: [OpenSER-Users] ERROR 1071 (42000) at line 2: Specified key was too long; max key length is 1000 bytes
hi,
I tried it quickly under gentoo.
in the install folder:
share/openser/mysql/
alias_db-create.sql -> dbaliases
registrar-create.sql -> aliases
usrloc-create.sql -> location
those 3 tables have the problem.
changing type from myisam to innodb solves the problem, though I don't know what
consequences this has ;)
cheers,
Patrick.
Hi,
When I try to create openser database (openserdbctl create) on Gentoo, I
have the message:
INFO: creating database openser ...
ERROR 1071 (42000) at line 2: Specified key was too long; max key length is
1000 bytes
ERROR: Creating core tables failed!
I search when i can modify TABLE_TYPE but i not found.
Regards,
Yazid
11:20 a.m.
New subject: [OpenSER-Users] ERROR 1071 (42000) at line 2: Specified key was too long; max key length is 1000 bytes
You can also change the UTF-8 charset:
ENGINE=MyISAM DEFAULT CHARSET=latin1
works as well, just tried it.
cheers,
Patrick.
Hi,
When I try to create openser database (openserdbctl create) on Gentoo, I
have the message:
INFO: creating database openser ...
ERROR 1071 (42000) at line 2: Specified key was too long; max key length is
1000 bytes
ERROR: Creating core tables failed!
I search when i can modify TABLE_TYPE but i not found.
Regards,
Yazid
11:22 a.m.
New subject: [OpenSER-Users] ERROR 1071 (42000) at line 2: Specified key was too long; max key length is 1000 bytes
On Wednesday 21 May 2008, Yazid Hadj Said wrote:
When I try to create openser database (openserdbctl
create) on Gentoo, I
have the message:
INFO: creating database openser ...
ERROR 1071 (42000) at line 2: Specified key was too long; max key length is
1000 bytes
ERROR: Creating core tables failed!
I search when i can modify TABLE_TYPE but i not found.
Hi Yazid,
are you using UTF-8 as server character set? If yes, then this problem was
discussed some time ago at:
http://lists.openser.org/pipermail/devel/2008-March/012765.html
There is a patch that should solve this issue, i'll try to reproduce the
problem.
Cheers,
Henning
11:50 a.m.
New subject: [OpenSER-Users] ERROR 1071 (42000) at line 2: Specified key was too long; max key length is 1000 bytes
On Wednesday 21 May 2008, Henning Westerholt wrote:
Hi Yazid,
i just commited a fix to trunk and 1.3 branch. The UTF-8 charset is now
correctly recognised during the DB setup, this should fix the problem.
Cheers,
Henning
When I try to
create openser database (openserdbctl create) on Gentoo, I
have the message:
INFO: creating database openser ...
ERROR 1071 (42000) at line 2: Specified key was too long; max key length
is 1000 bytes
ERROR: Creating core tables failed!
I search when i can modify TABLE_TYPE but i not found.
Hi Yazid,
are you using UTF-8 as server character set? If yes, then this problem was
discussed some time ago at:
http://lists.openser.org/pipermail/devel/2008-March/012765.html
There is a patch that should solve this issue, i'll try to reproduce the
problem.
6065
days inactive
6065
days old
4 comments
3 participants
participants (3)
-
Henning Westerholt -
Patrick Miccio -
Yazid Hadj Said