[Koha-bugs] [Bug 33375] Advanced editor crashes when using MySQL 8 due to reserved rank keyword
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33375 Katrin Fischer changed: What|Removed |Added CC||dhodgins@coloradovirtuallib ||rary.org --- Comment #11 from Katrin Fischer --- *** Bug 29973 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 33375] Advanced editor crashes when using MySQL 8 due to reserved rank keyword
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33375 Arthur Suzuki changed: What|Removed |Added Version(s)|23.05.00,22.11.05,22.05.13 |23.05.00,22.11.05,22.05.13, released in||21.11.21 CC||arthur.suz...@biblibre.com --- Comment #10 from Arthur Suzuki --- applied to 21.11 for 21.11.21 -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 33375] Advanced editor crashes when using MySQL 8 due to reserved rank keyword
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33375 Katrin Fischer changed: What|Removed |Added CC||jcautomatizac...@gmail.com --- Comment #9 from Katrin Fischer --- *** Bug 31859 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 33375] Advanced editor crashes when using MySQL 8 due to reserved rank keyword
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33375 Katrin Fischer changed: What|Removed |Added Keywords||rel_21_11_candidate -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 33375] Advanced editor crashes when using MySQL 8 due to reserved rank keyword
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33375 Katrin Fischer changed: What|Removed |Added CC||kohasupp...@nlj.gov.jm --- Comment #8 from Katrin Fischer --- *** Bug 33714 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 33375] Advanced editor crashes when using MySQL 8 due to reserved rank keyword
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33375 Lucas Gass changed: What|Removed |Added Status|Pushed to stable|Pushed to oldstable Version(s)|23.05.00,22.11.05 |23.05.00,22.11.05,22.05.13 released in|| CC||lu...@bywatersolutions.com --- Comment #7 from Lucas Gass --- Backported to 22.05.x for upcoming 22.05.13. -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 33375] Advanced editor crashes when using MySQL 8 due to reserved rank keyword
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33375 --- Comment #6 from Matt Blenkinsop --- Nice work everyone! Pushed to stable for 22.11.x -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 33375] Advanced editor crashes when using MySQL 8 due to reserved rank keyword
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33375 Matt Blenkinsop changed: What|Removed |Added Version(s)|23.05.00|23.05.00,22.11.05 released in|| Status|Pushed to master|Pushed to stable -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 33375] Advanced editor crashes when using MySQL 8 due to reserved rank keyword
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33375 --- Comment #5 from Tomás Cohen Arazi --- Pushed to master for 23.05. Nice work everyone, thanks! -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 33375] Advanced editor crashes when using MySQL 8 due to reserved rank keyword
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33375 Tomás Cohen Arazi changed: What|Removed |Added Status|Passed QA |Pushed to master Version(s)||23.05.00 released in|| -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 33375] Advanced editor crashes when using MySQL 8 due to reserved rank keyword
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33375 Marcel de Rooy changed: What|Removed |Added QA Contact|testo...@bugs.koha-communit |m.de.r...@rijksmuseum.nl |y.org | -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 33375] Advanced editor crashes when using MySQL 8 due to reserved rank keyword
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33375 Marcel de Rooy changed: What|Removed |Added Attachment #149056|0 |1 is obsolete|| --- Comment #4 from Marcel de Rooy --- Created attachment 149633 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=149633=edit Bug 33375: Quote reserved keyword 'rank' in advanced editor This change quotes the 'rank' keyword in the advanced editor, so that it doesn't cause fatal crashes when using MySQL 8 Test plan: 0. Apply patch and koha-plack --restart kohadev 1. Enable advanced editor http://localhost:8081/cgi-bin/koha/admin/preferences.pl?op=search=EnableAdvancedCatalogingEditor 2. Go to http://localhost:8081/cgi-bin/koha/cataloguing/editor.pl#new/ 3. Click on "Advanced" on the left nav 4. Note that "LIBRARY OF CONGRESS" is ordered before "NATIONAL LIBRARY OF FRANCE" 5. Rejoice! Signed-off-by: David Nind Signed-off-by: Marcel de Rooy -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 33375] Advanced editor crashes when using MySQL 8 due to reserved rank keyword
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33375 Marcel de Rooy changed: What|Removed |Added Patch complexity|Small patch |Trivial patch Status|Signed Off |Passed QA -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 33375] Advanced editor crashes when using MySQL 8 due to reserved rank keyword
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33375 Jonathan Druart changed: What|Removed |Added Blocks||23996 CC||jonathan.druart+koha@gmail. ||com Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23996 [Bug 23996] MySQL 8 support [Omnibus] -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 33375] Advanced editor crashes when using MySQL 8 due to reserved rank keyword
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33375 David Nind changed: What|Removed |Added CC||da...@davidnind.com --- Comment #3 from David Nind --- Testing notes using KTD: 1. To start KTD with MySQL instead of MariaDB: before starting KTD, change .env so that DB_IMAGE=mysql:8.0 2. Replicated the issue. 3. Applied the patch and followed the test plan. -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 33375] Advanced editor crashes when using MySQL 8 due to reserved rank keyword
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33375 David Nind changed: What|Removed |Added Attachment #149008|0 |1 is obsolete|| --- Comment #2 from David Nind --- Created attachment 149056 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=149056=edit Bug 33375: Quote reserved keyword 'rank' in advanced editor This change quotes the 'rank' keyword in the advanced editor, so that it doesn't cause fatal crashes when using MySQL 8 Test plan: 0. Apply patch and koha-plack --restart kohadev 1. Enable advanced editor http://localhost:8081/cgi-bin/koha/admin/preferences.pl?op=search=EnableAdvancedCatalogingEditor 2. Go to http://localhost:8081/cgi-bin/koha/cataloguing/editor.pl#new/ 3. Click on "Advanced" on the left nav 4. Note that "LIBRARY OF CONGRESS" is ordered before "NATIONAL LIBRARY OF FRANCE" 5. Rejoice! Signed-off-by: David Nind -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 33375] Advanced editor crashes when using MySQL 8 due to reserved rank keyword
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33375 David Nind changed: What|Removed |Added Status|Needs Signoff |Signed Off -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 33375] Advanced editor crashes when using MySQL 8 due to reserved rank keyword
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33375 David Cook changed: What|Removed |Added Assignee|koha-b...@lists.koha-commun |dc...@prosentient.com.au |ity.org | -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 33375] Advanced editor crashes when using MySQL 8 due to reserved rank keyword
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33375 --- Comment #1 from David Cook --- Created attachment 149008 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=149008=edit Bug 33375: Quote reserved keyword 'rank' in advanced editor This change quotes the 'rank' keyword in the advanced editor, so that it doesn't cause fatal crashes when using MySQL 8 Test plan: 0. Apply patch and koha-plack --restart kohadev 1. Enable advanced editor http://localhost:8081/cgi-bin/koha/admin/preferences.pl?op=search=EnableAdvancedCatalogingEditor 2. Go to http://localhost:8081/cgi-bin/koha/cataloguing/editor.pl#new/ 3. Click on "Advanced" on the left nav 4. Note that "LIBRARY OF CONGRESS" is ordered before "NATIONAL LIBRARY OF FRANCE" 5. Rejoice! -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 33375] Advanced editor crashes when using MySQL 8 due to reserved rank keyword
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33375 David Cook changed: What|Removed |Added Patch complexity|--- |Small patch Status|NEW |Needs Signoff -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 33375] Advanced editor crashes when using MySQL 8 due to reserved rank keyword
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33375 David Cook changed: What|Removed |Added Depends on||17515 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17515 [Bug 17515] Advanced Editor - Rancor - Z39 sources not sorted properly -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
