[OpenSER-Users] ERROR 1071 (42000) at line 2: Specified key was too long; max key length is 1000 bytes

[Henning Westerholt]

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