slimserver
slimserver copied to clipboard
Error with MySQL: DBD::mysql::db do failed: BLOB/TEXT column 'url' used in key specification without a key length
Hi,
I just switched from SQLite to MySQL for a little performance boost with my large library. Unfortunately, the scanner throws the following error when indexing the files:
Slim::Schema::Storage::throw_exception (121) Error: DBI Exception: DBD::mysql::db do failed: BLOB/TEXT column 'url' used in key specification without a key length [for Statement "
CREATE TEMPORARY TABLE online_tracks (url TEXT PRIMARY KEY);
"]
Is there any chance to get this fixed for MySQL without affecting SQLite?
I'd appreciate your feedback and thanks in advance.
TOM