http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5377 --- Comment #23 from Doug Dearden <dearden@sarsf.org> --- Further investigation on this showed something interesting. I have three databases - main, image, and archive. The original DB is main, later I created image and still later archive - so archive was created on a newer version of Koha than the other two. The update to archive did not throw these errors. When I look at a pre-update version of the biblioitems table in the main and image DBs there are two indexes for issn - one called issn, the other issn_idx . Looking at a post-update version there is only issn_idx - no issn or isbn indexes, and the isbn and issn fields are still varchar(30) and varchar(9). I think adding $dbh->do("ALTER TABLE biblioitems DROP INDEX issn_idx"); to the right spot in updatedatabase.pl probably fixes this. I don't know why that old index was there on my main and image databases. -- You are receiving this mail because: You are the QA Contact for the bug. You are watching all bug changes.