http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5377
--- Comment #23 from Doug Dearden <[email protected]> --- 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. _______________________________________________ Koha-bugs mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
