detail.php
OW2 Forge: Detail: 306350 create_engine.ddl fails on mySQL with “Specified key was too long. Max key length is 500”

Advanced - Powered by Google


   
Log In
New Account
  
 
Home
My Page
Project Tree
Project Openings
Funambol
          
 
 
Summary
Tracker
Lists
Tasks
Docs
News
CVS
Files
                
 

Tracker: Bugs

Submit New | Browse | Admin | ExportToXml

[ #306350 ] create_engine.ddl fails on mySQL with “Specified key was too long. Max key length is 500”

Date:
2006-11-04 20:30
Priority:
5
Submitted By:
Ralph Plawetzki (ng-corsar)
Assigned To:
Stefano Nichele (nichele)
Category:
distribution/installation
State:
Open
Summary:
create_engine.ddl fails on mySQL with “Specified key was too long. Max key length is 500”

Detailed description:
Trying to install the non-bundled version of funambol-ds-server-5.0.10 on Debian 3.1 including these components: Java: JDK 5.0 Update 9 from java.sun.com, installed with included install script Application Server:Tomcat 5.0.30-12 installed Debian Package DBMS: mySQL 4.0.24-10s installed Debian Package I followed the installations instructions in funambol_ds_server_administration_guide.pdf until the step where “sh bin/install.sh tomcat50” is executed After asking, if I want to recreate the database (“y”), the script Funambol/ds-server/default/sql/mysql/create_engine.ddl fails in line 311. The statement “create index ind_user on fnbl_user (username, password);” leads to “Specified key was too long. Max key length is 500” All other sql statements in the scipt before were executed without errors and the tables have been created. The workaround as described in http://sourceforge.net/mailarchive/message.php?msg_id=13135170 worked.

Add A Comment:

Please login

Followup

No Followups Have Been Posted

Attached Files:

Name Description Download
No Files Currently Attached

Changes:

Resource id #66listtable
resolution_id
Field Old Value Date By
resolution_idNone2007-02-20 15:20cristiano

Copyright © 1999-2008, OW2 Consortium | contact | You've got a problem ? Please report an issue using your OW2 forge account credentials