[Koha-bugs] [Bug 5377] Database fields too small for multiple ISBN and ISSN

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

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

--- Comment #23 from Doug Dearden <dearden at 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.