slimserver icon indicating copy to clipboard operation
slimserver copied to clipboard

Error with MySQL: DBD::mysql::db do failed: BLOB/TEXT column 'url' used in key specification without a key length

Open hctom opened this issue 1 year ago • 4 comments

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

hctom avatar May 12 '23 12:05 hctom