[Bug 8650] New: running misc/batchRebuildBiblioTables.pl messes up tables and creates duplicates
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8650 Priority: P5 - low Change sponsored?: --- Bug ID: 8650 Assignee: gmcharlt@gmail.com Summary: running misc/batchRebuildBiblioTables.pl messes up tables and creates duplicates Severity: normal Classification: Unclassified OS: All Reporter: gbarna@uttyler.edu Hardware: All Status: NEW Version: rel_3_8 Component: Command-line Utilities Product: Koha Created attachment 11632 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=11632&action=edit Screenshot of duplicate order The other day we added a new framework. Under MARC frameworks › CML framework structure › Tag 005 subfield structure › Edit subfields constraints, we changed the Koha link field in tag 005 to biblio.timestamp. There is a note that says this: NOTE: If you change this value you must ask your administrator to run misc/batchRebuildBiblioTables.pl. Therefore, last night we ran misc/batchRebuildBiblioTables.pl and this morning we noticed that all our tables are messed up. We noticed duplicate orders in Acquisitions, duplicate serials entries as well as duplicate biblios. We would appreciate any help with this issue. Thanks, Geanina -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8650 Chris Cormack <chris@bigballofwax.co.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |chris@bigballofwax.co.nz --- Comment #1 from Chris Cormack <chris@bigballofwax.co.nz> --- Hmmm (e.g., Title or Local-Number) NOTE: If you change this value you must ask your administrator to run misc/batchRebuildBiblioTables.pl. This note is next to the link field, not the Koha link field. The rebuild is for if you change the link, not the Koha link field. I'm not sure what it will have done in your case :( -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8650 --- Comment #2 from Chris Cormack <chris@bigballofwax.co.nz> --- Geanina When you look at that order, do both biblios have the same biblionumber? -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8650 Elliott Davis <elliott@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |elliott@bywatersolutions.co | |m --- Comment #3 from Elliott Davis <elliott@bywatersolutions.com> --- Geanina, I think probably the quickest solution would be to restore those tables from a backup if you have one. Depending on how long this has been a problem you may consider just restoring the whole database since it would be quicker than extracting the tables. -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8650 --- Comment #4 from gbarna@uttyler.edu --- (In reply to comment #1)
Hmmm
(e.g., Title or Local-Number) NOTE: If you change this value you must ask your administrator to run misc/batchRebuildBiblioTables.pl.
This note is next to the link field, not the Koha link field.
The rebuild is for if you change the link, not the Koha link field.
I'm not sure what it will have done in your case :(
Aaahhhhh! I see what you are saying. Thank you for bringing that to my attention. I guess I will close this bug. -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8650 gbarna@uttyler.edu changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution|--- |FIXED -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org