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

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