[Koha-bugs] [Bug 36101] Deleting an item removes the itemnumber from old_reserves when it should not

2024-03-19 Thread bugzilla-daemon--- via Koha-bugs
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36101 --- Comment #18 from Lucas Gass --- > Dont you think that we should adhere to proven standards as to SQL, > normalization, etc ? :) We should keep the data that librarians want to keep. If the problem is a FK constraint then that

[Koha-bugs] [Bug 36101] Deleting an item removes the itemnumber from old_reserves when it should not

2024-03-19 Thread bugzilla-daemon--- via Koha-bugs
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36101 --- Comment #17 from Lari Strand --- > Dont you think that we should adhere to proven standards as to SQL, > normalization, etc ? :) I think we should adhere to the needs of the users who use the library system. We only gain more

[Koha-bugs] [Bug 36101] Deleting an item removes the itemnumber from old_reserves when it should not

2024-03-19 Thread bugzilla-daemon--- via Koha-bugs
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36101 --- Comment #16 from Katrin Fischer --- Hi, I agree with not removing the information about the linked item even if it was deleted, for the reasons given. But maybe we can find some middle ground here with the implementation. Have

[Koha-bugs] [Bug 36101] Deleting an item removes the itemnumber from old_reserves when it should not

2024-03-19 Thread bugzilla-daemon--- via Koha-bugs
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36101 paxed changed: What|Removed |Added CC||pasi.kalli...@koha-suomi.fi ---

[Koha-bugs] [Bug 36101] Deleting an item removes the itemnumber from old_reserves when it should not

2024-03-18 Thread bugzilla-daemon--- via Koha-bugs
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36101 Kyle M Hall changed: What|Removed |Added See Also||https://bugs.koha-community

[Koha-bugs] [Bug 36101] Deleting an item removes the itemnumber from old_reserves when it should not

2024-03-18 Thread bugzilla-daemon--- via Koha-bugs
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36101 Nick Clemens changed: What|Removed |Added CC||n...@bywatersolutions.com

[Koha-bugs] [Bug 36101] Deleting an item removes the itemnumber from old_reserves when it should not

2024-03-18 Thread bugzilla-daemon--- via Koha-bugs
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36101 Andrew Fuerste-Henry changed: What|Removed |Added See Also|

[Koha-bugs] [Bug 36101] Deleting an item removes the itemnumber from old_reserves when it should not

2024-03-18 Thread bugzilla-daemon--- via Koha-bugs
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36101 Andrew Fuerste-Henry changed: What|Removed |Added Status|Failed QA |In Discussion ---

[Koha-bugs] [Bug 36101] Deleting an item removes the itemnumber from old_reserves when it should not

2024-03-18 Thread bugzilla-daemon--- via Koha-bugs
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36101 --- Comment #13 from Marcel de Rooy --- (In reply to Lari Strand from comment #9) > "Keeping an itemnumber in this table that does no longer exist is bad > practice." > > We still have deleted-tables so I don't consider the data as

[Koha-bugs] [Bug 36101] Deleting an item removes the itemnumber from old_reserves when it should not

2024-03-15 Thread bugzilla-daemon--- via Koha-bugs
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36101 --- Comment #12 from Lari Strand --- We should also consider the impact this change makes when we join deleted-tables with "active" tables in the future, when nothing is really deleted and transferred to somewhere else, but tagged

[Koha-bugs] [Bug 36101] Deleting an item removes the itemnumber from old_reserves when it should not

2024-03-15 Thread bugzilla-daemon--- via Koha-bugs
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36101 --- Comment #11 from Lari Strand --- This ticket is just to make handling of these two old_ -tables' itemnumber data uniform. -- You are receiving this mail because: You are watching all bug changes.

[Koha-bugs] [Bug 36101] Deleting an item removes the itemnumber from old_reserves when it should not

2024-03-15 Thread bugzilla-daemon--- via Koha-bugs
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36101 --- Comment #10 from Lari Strand --- Sorry, I was supposed to comment this to https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32729, but the same logic applies here I assume. -- You are receiving this mail because: You

[Koha-bugs] [Bug 36101] Deleting an item removes the itemnumber from old_reserves when it should not

2024-03-15 Thread bugzilla-daemon--- via Koha-bugs
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36101 --- Comment #9 from Lari Strand --- In our case, we need to find out the biblio details for the deleted item so we can show these details for patrons in their lists of past loans/old issues. Without the itemnumber in the old_issues

[Koha-bugs] [Bug 36101] Deleting an item removes the itemnumber from old_reserves when it should not

2024-03-15 Thread bugzilla-daemon--- via Koha-bugs
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36101 --- Comment #8 from Jonathan Druart --- Also we have CONSTRAINT `old_issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL, -- You are receiving this mail because: You

[Koha-bugs] [Bug 36101] Deleting an item removes the itemnumber from old_reserves when it should not

2024-03-15 Thread bugzilla-daemon--- via Koha-bugs
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36101 Marcel de Rooy changed: What|Removed |Added QA Contact|testo...@bugs.koha-communit |m.de.r...@rijksmuseum.nl

[Koha-bugs] [Bug 36101] Deleting an item removes the itemnumber from old_reserves when it should not

2024-03-15 Thread bugzilla-daemon--- via Koha-bugs
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36101 Marcel de Rooy changed: What|Removed |Added Status|Signed Off |Failed QA --- Comment #7

[Koha-bugs] [Bug 36101] Deleting an item removes the itemnumber from old_reserves when it should not

2024-03-15 Thread bugzilla-daemon--- via Koha-bugs
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36101 Marcel de Rooy changed: What|Removed |Added CC||m.de.r...@rijksmuseum.nl

[Koha-bugs] [Bug 36101] Deleting an item removes the itemnumber from old_reserves when it should not

2024-03-14 Thread bugzilla-daemon--- via Koha-bugs
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36101 --- Comment #5 from Lari Strand --- Thank you Lucas. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes. ___ Koha-bugs mailing

[Koha-bugs] [Bug 36101] Deleting an item removes the itemnumber from old_reserves when it should not

2024-03-13 Thread bugzilla-daemon--- via Koha-bugs
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36101 Lucas Gass changed: What|Removed |Added CC||lu...@bywatersolutions.com

[Koha-bugs] [Bug 36101] Deleting an item removes the itemnumber from old_reserves when it should not

2024-03-13 Thread bugzilla-daemon--- via Koha-bugs
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36101 --- Comment #3 from Lucas Gass --- Created attachment 163120 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=163120=edit Bug 36101: (follow-up) Fix DBUpdate file permission and perltidy Signed-off-by: Lucas Gass

[Koha-bugs] [Bug 36101] Deleting an item removes the itemnumber from old_reserves when it should not

2024-03-13 Thread bugzilla-daemon--- via Koha-bugs
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36101 Lucas Gass changed: What|Removed |Added Attachment #163087|0 |1 is obsolete|

[Koha-bugs] [Bug 36101] Deleting an item removes the itemnumber from old_reserves when it should not

2024-03-13 Thread bugzilla-daemon--- via Koha-bugs
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36101 Lucas Gass changed: What|Removed |Added Status|Needs Signoff |Signed Off -- You are

[Koha-bugs] [Bug 36101] Deleting an item removes the itemnumber from old_reserves when it should not

2024-03-13 Thread bugzilla-daemon--- via Koha-bugs
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36101 Katie Bliss changed: What|Removed |Added CC||kebl...@dmpl.org -- You are

[Koha-bugs] [Bug 36101] Deleting an item removes the itemnumber from old_reserves when it should not

2024-03-12 Thread bugzilla-daemon--- via Koha-bugs
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36101 Victor Grousset/tuxayo changed: What|Removed |Added Severity|enhancement |normal -- You

[Koha-bugs] [Bug 36101] Deleting an item removes the itemnumber from old_reserves when it should not

2024-03-12 Thread bugzilla-daemon--- via Koha-bugs
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36101 --- Comment #1 from Lari Strand --- Created attachment 163087 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=163087=edit Bug 36101: Drop constraint to items.itemnumber from old_reserves-table This patch removes

[Koha-bugs] [Bug 36101] Deleting an item removes the itemnumber from old_reserves when it should not

2024-03-12 Thread bugzilla-daemon--- via Koha-bugs
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36101 Lari Strand changed: What|Removed |Added Status|NEW |Needs Signoff -- You are

[Koha-bugs] [Bug 36101] Deleting an item removes the itemnumber from old_reserves when it should not

2024-03-12 Thread bugzilla-daemon--- via Koha-bugs
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36101 Jonathan Druart changed: What|Removed |Added See Also|

[Koha-bugs] [Bug 36101] Deleting an item removes the itemnumber from old_reserves when it should not

2024-03-12 Thread bugzilla-daemon--- via Koha-bugs
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36101 Emmi Takkinen changed: What|Removed |Added CC||emmi.takki...@koha-suomi.fi

[Koha-bugs] [Bug 36101] Deleting an item removes the itemnumber from old_reserves when it should not

2024-03-11 Thread bugzilla-daemon--- via Koha-bugs
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36101 Andrew Fuerste-Henry changed: What|Removed |Added CC|