Re: Jahia with MYSQL : Specified key was too long. Max key length is 1024

Hi, 
	That functions very well with the version of MySQL 4.0.23.
Bye

"Douglas Doyer" <[email protected]> a écrit dans le message news:<[email protected]>...
> Hi,
> I try to install Jahia on a Windows server with MySQL and I obtain the 
> following error:
> Jahia Configuration Wizard generates some error(s) :
> Error : Specified key was too long; max key length is 1024 bytes
> 
> Here the answers which I gave:
> 
> ********************************************************************************
> SuperUser settings :
> 
> Username :    jahia
> Password :  **************
> First name :  Jahia
> Last name :  Super Administrator
> E-mail address :  --- not specified --- 
> 
> Server settings :
> 
> Server home :    C:\Program Files\jahia404\tomcat\
> Host URL :  http://localhost:8080
> Jahia Files path : $context/WEB-INF
> 
> Database settings :
> 
> Driver :    com.mysql.jdbc.Driver
> Database URL : 
> jdbc:mysql://localhost/jahia?useUnicode=true&characterEncoding=UTF-8
> or
> Database URL : 
> jdbc:mysql://localhost/jahia?useUnicode=true&characterEncoding=cp1250
> Username :  jahia
> 
> UTF-8 compliance :
> 
> This server is UTF-8 compliant :    false
> or
> This server is UTF-8 compliant :    true
> 
> Mail settings :
> 
> Server :    --- not specified --- 
> Recipient :  --- not specified --- 
> From address :  --- not specified --- 
> Event notification :  --- disabled --- 
> ********************************************************************************
> 
> I made some research and it seems to have a limitation in MySQL on this 
> subject:
> 
> Mysql cannot have more than 1024 bytes in a key for a InnoDB table :
> http://jira.undersunconsulting.com/browse/OFBIZ-66
> http://bugs.mysql.com/bug.php?id=4541
> http://dev.mysql.com/doc/connector/j/en/cj-character-sets.html
> 
> Here my configuration:
> Jahia 4.04
> Windows 2003
> MySQL 4.1.9nt
> J2SDK 1.4.2-7
> mysql-connector-java 3.1.6
> IE 6.0.3790.0
> 
> Is there any workaround to install Jahia in this configuration ?
> Thanks. 
> 
> 
> 
>