[Koha-bugs] [Bug 13766] biblioitems.ean field is too short

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13766

--- Comment #4 from Frédéric Demians <frederic at tamil.fr> ---
(In reply to Jonathan Druart from comment #3)
> Frédéric, I got an error on executing the updatedb entry:
> 
> DBD::mysql::db do failed: BLOB/TEXT column 'ean' used in key specification
> without a key length at installer/data/mysql/updatedatabase.pl line 9798.

Thanks testing. I also can get this error. I don't have it on recent DB. I get
it on older.

In updatedatebase.pl, line 5323:

$dbh->do("CREATE INDEX `ean` ON biblioitems (`ean`) ");

So a DB which was on Koha 3.8, and earlier, has an index on biblioitems.ean.

A fresh DB, hasn't such an index. kohastructre.sql, line 186 and after, there
are index defined for isbn but not for ean.

Do you think that an index is required on ean field?

-- 
You are receiving this mail because:
You are watching all bug changes.