[Bug 8835] New: Two indexes on biblioitems.issn
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8835 Priority: P5 - low Change sponsored?: --- Bug ID: 8835 Assignee: gmcharlt@gmail.com Summary: Two indexes on biblioitems.issn Severity: minor Classification: Unclassified OS: All Reporter: fridolyn.somers@biblibre.com Hardware: All Status: NEW Version: master Component: Database Product: Koha In update database script : 3.01.00.006 adds an index called 'issn' on biblioitems.issn. 3.01.00.093 also adds an index on biblioitems.issn, called 'issn_idx'. In kohastructure, only 'issn' index exists for biblioitems. So udpate 3.01.00.093 is useless. Can it be removed ? -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8835 Jonathan Druart <jonathan.druart@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |jonathan.druart@biblibre.co | |m --- Comment #1 from Jonathan Druart <jonathan.druart@biblibre.com> --- Since 3.01 is a quite old version, I think this bug report could be closed. Fridolin, do you agree? -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8835 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |katrin.fischer@bsz-bw.de --- Comment #2 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- We have fixed some occurrences of this is our recent update to 3.18 - I believe no harm is done by the differently named indexes, but it shows up as an error in the web installer output. -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8835 Tomás Cohen Arazi <tomascohen@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |tomascohen@gmail.com --- Comment #3 from Tomás Cohen Arazi <tomascohen@gmail.com> --- I think we should (at this point) have an update action that removes the issn_idx index if present. -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8835 --- Comment #4 from Jonathan Druart <jonathan.druart@biblibre.com> --- Actually, there is also 3.15.00.049 - Bug 5377 - Biblioitems isbn and issn fields too small for multiple ISBN and ISSN which remove the index named "issn" and modify the datatype for the issn field. If an index existed at this point, the change would have failed. -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org