Install schema Issue

[dave0]

Originally filed by angus.carr on 2007-09-08T07:12:58

What steps will reproduce the problem?

1. Install according to the instructions
2. When the schema is being created, mysql 5 returns a failure from lack of
   commas in the creation of two tables

What is the expected output? What do you see instead?
mysql failure in lines 222 and 232. Missing commas before the primary key
statement for two tables.

Please use labels and text to provide additional information.

I have a fix ready to check in, but I thought I would ask if anyone else
has had this issue.

[dave0]

Updated by eindgebruiker on 2007-12-10T12:42:17

I had the same issue, using MySQL 5.0.

[dave0]

Updated by flyswatta on 2008-01-21T21:18:31

Same issue using MySQL 5.0.51. Thanks for the fix!

[dave0]

Updated by trawna.com on 2008-03-26T19:34:17

Schema has been fixed in version 2.6.

Original ticket set status to Fixed (we converted to closed)

[dave0]

Updated by ChrisFizik on 2008-05-27T04:00:40

uggh ..........a problem around this point in the 2.5 schema code threw me off for
multiple hours.

something about:
ERROR 1071 (42000) at line 215: Specified key was too long; max key length is 1000
bytes

Eventually the fix, and I found numerous instances of similar problems with other
database web apps with sql schema files
was to do something with the db character set:

alter database leaguerunner default character set latin1;

I just picked latin1 arbitrarily, but the whole problem is with key sizes and the
UTF8 char set....so heads up .....
Surprised this wasn't documented/complained about more on here.