[bugs] [Bug 1182] New - mysql_create reports "key too long"

[bugs at bugs.horde.org]

http://bugs.horde.org/show_bug.cgi?id=1182

*** shadow/1182	Sun Feb 23 03:13:47 2003
--- shadow/1182.tmp.12377	Sun Feb 23 03:13:47 2003
***************
*** 0 ****
--- 1,37 ----
+ Bug#: 1182
+ Product: Horde
+ Version: 2.3 Unstable
+ Platform: All Browsers
+ OS/Version: FreeBSD
+ Status: NEW   
+ Resolution: 
+ Severity: normal
+ Priority: P2
+ Component: Core
+ Area: BUILD
+ AssignedTo: chuck at horde.org                            
+ ReportedBy: twp at unchi.org               
+ URL: 
+ Summary: mysql_create reports "key too long"
+ 
+ Hi -
+ 
+ Installing horde from anonymous CVS.  scripts/db/mysql_create.sql is version 1.11.
+ 
+ mysql_create.sql generates this error:
+ 
+ ERROR 1064 at line 18: You have an error in your SQL syntax near ': Change this
+ password!
+         PASSWORD('horde')
+     )' at line 5
+ 
+ Removing the spaces in front of the comment on line 5 fixes this.  If I run
+ mysql_drop and then mysql_create.sql, I get:
+ 
+ ERROR 1071 at line 55: Specified key was too long. Max key length is 256
+ 
+ Could this all be due to having an old version of MySQL?  I am running:
+ 
+ $ mysql --version
+ mysql  Ver 9.32 Distrib 3.22.23b, for unknown-freebsd3.2 (i386)
+