[Koha-bugs] [Bug 19016] Add a script to fix corrupted data

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19016 Jonathan Druart changed: What|Removed |Added Status|In Discussion |RESOLVED

[Koha-bugs] [Bug 19016] Add a script to fix corrupted data

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19016 --- Comment #22 from Benjamin Rokseth --- Only an attempt to push focus to the core problem, and a proposed fix to that ;) The problem is worse than shifted autoincrements, as we discovered to our dismay. -- You are receiving this

[Koha-bugs] [Bug 19016] Add a script to fix corrupted data

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19016 --- Comment #21 from Jonathan Druart --- (In reply to Benjamin Rokseth from comment #20) > The fix is in Bug 20271. Please push it forward Hum, what do you mean? -- You are receiving this mail because: You are watching all bug

[Koha-bugs] [Bug 19016] Add a script to fix corrupted data

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19016 Benjamin Rokseth changed: What|Removed |Added CC|

[Koha-bugs] [Bug 19016] Add a script to fix corrupted data

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19016 matthew.charleswo...@hekima.ac.ke changed: What|Removed |Added CC|

[Koha-bugs] [Bug 19016] Add a script to fix corrupted data

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19016 --- Comment #19 from Katrin Fischer --- The script is not finished and not recommended for production use. -- You are receiving this mail because: You are watching all bug changes.

[Koha-bugs] [Bug 19016] Add a script to fix corrupted data

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19016 sokunrotanak changed: What|Removed |Added CC|

[Koha-bugs] [Bug 19016] Add a script to fix corrupted data

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19016 Dobrica Pavlinusic changed: What|Removed |Added CC|

[Koha-bugs] [Bug 19016] Add a script to fix corrupted data

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19016 Oliver Bock changed: What|Removed |Added CC|

[Koha-bugs] [Bug 19016] Add a script to fix corrupted data

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19016 --- Comment #15 from Tomás Cohen Arazi --- Created attachment 68015 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=68015=edit Bug 19016: Trigger reindex on fixing biblios Signed-off-by:

[Koha-bugs] [Bug 19016] Add a script to fix corrupted data

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19016 Michael Kuhn changed: What|Removed |Added CC|

[Koha-bugs] [Bug 19016] Add a script to fix corrupted data

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19016 --- Comment #14 from Fridolin SOMERS --- We prefer to correct id in old_issues and old_reserves tables. For deleted_xxx tables, we may just delete since it is too difficult to fix. For example

[Koha-bugs] [Bug 19016] Add a script to fix corrupted data

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19016 --- Comment #13 from Jonathan Druart --- (In reply to dguidry from comment #12) > (In reply to Christian McDonald from comment #11) > > When can expect a fix to be available via the stable

[Koha-bugs] [Bug 19016] Add a script to fix corrupted data

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19016 dgui...@lcg.org changed: What|Removed |Added CC||dgui...@lcg.org ---

[Koha-bugs] [Bug 19016] Add a script to fix corrupted data

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19016 Christian McDonald changed: What|Removed |Added CC|

[Koha-bugs] [Bug 19016] Add a script to fix corrupted data

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19016 Krishna K changed: What|Removed |Added CC|

[Koha-bugs] [Bug 19016] Add a script to fix corrupted data

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19016 --- Comment #10 from Katrin Fischer --- I wonder if it would be good to separate the different types of data. I feel pretty sure about the fix for issues, but borrowers and biblio* tables appear more

[Koha-bugs] [Bug 19016] Add a script to fix corrupted data

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19016 --- Comment #9 from Marcel de Rooy --- (In reply to Marcel de Rooy from comment #8) > Would it be safer to change id's in the old/deleted tables, and push the > autoincrement on the original table ?

[Koha-bugs] [Bug 19016] Add a script to fix corrupted data

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19016 --- Comment #8 from Marcel de Rooy --- Created a problem in two tables: * Tables biblioitems/deletedbiblioitems: 2580, 2632 * Tables reserves/old_reserves: 831, 833 Now fixing it with the script: *

[Koha-bugs] [Bug 19016] Add a script to fix corrupted data

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19016 --- Comment #7 from Tomás Cohen Arazi --- Created attachment 65710 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=65710=edit Bug 19016: Check and fix 'biblioitems' This patch adds

[Koha-bugs] [Bug 19016] Add a script to fix corrupted data

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19016 --- Comment #6 from Jonathan Druart --- (In reply to Kyle M Hall from comment #4) > What about the biblioitems table? I have no idea what to do with biblioitems. What do you think about

[Koha-bugs] [Bug 19016] Add a script to fix corrupted data

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19016 --- Comment #5 from Kyle M Hall --- Created attachment 65456 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=65456=edit Bug 19016 [Followup] - Fix bad column name -- You are receiving

[Koha-bugs] [Bug 19016] Add a script to fix corrupted data

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19016 Kyle M Hall changed: What|Removed |Added CC|

[Koha-bugs] [Bug 19016] Add a script to fix corrupted data

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19016 Mason James changed: What|Removed |Added CC|

[Koha-bugs] [Bug 19016] Add a script to fix corrupted data

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19016 Jonathan Druart changed: What|Removed |Added Status|NEW

[Koha-bugs] [Bug 19016] Add a script to fix corrupted data

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19016 --- Comment #2 from Jonathan Druart --- Created attachment 65402 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=65402=edit Bug 19016: Add a script to fix corrupted data

[Koha-bugs] [Bug 19016] Add a script to fix corrupted data

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19016 --- Comment #3 from Jonathan Druart --- Created attachment 65403 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=65403=edit Bug 19016: Update other values Here we have a

[Koha-bugs] [Bug 19016] Add a script to fix corrupted data

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19016 Marcel de Rooy changed: What|Removed |Added CC|