Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

#650 SQL query error

open
nobody
None
5
2009-11-07
2009-11-07
Frans
No

When I run the MySQL query from mysql_schema.sql to setup the data base with phpMyAdmin 2.7.0-pl2 and MySQL 4.1.12, the following error is shown:

"BLOB/TEXT Column Used in Key Specification Without a Key Length"

Following this url:
http://www.mydigitallife.info/2007/07/09/mysql-error-1170-42000-blobtext-column-used-in-key-specification-without-a-key-length/

I should change the length from 320 to 255 for all CONSTRAINT UNIQUE columns (4 times). Now it is working.

There is some documentation in mysql_schema.sql itself, but it is not clear it should be changed 4 times.

For backwards compatibility, I would set the value to 255 instead of 320.

Discussion