[Koha-bugs] [Bug 28328] Editing a record can cause an ISE if data too long for column
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28328 Katrin Fischer changed: What|Removed |Added CC||da...@davidnind.com --- Comment #17 from Katrin Fischer --- *** Bug 30896 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 28328] Editing a record can cause an ISE if data too long for column
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28328 --- Comment #16 from Katrin Fischer --- (In reply to Jan Kissig from comment #3) > The same problem for columns publishercode or place obtained from MARC 264$b > and $a or 260$a and $b > > > to reproduce > 1 - edit or add new biblio > 2 - in 264$a enter f.e. > "1averylongtextaverylongtextaverylongtext42averylongtextaverylongtextaverylon > gtext84 | > 2averylongtextaverylongtextaverylongtext42averylongtextaverylongtextaverylong > text84 | > 3averylongtextaverylongtextaverylongtext42averylongtextaverylongtextaverylong > text847" > 3 - fill in other mandatory fields > 4 - save > > > /var/log/koha/kohadev/plack-intranet-error.log says > [2023/04/12 08:27:52] [WARN] DBIx::Class::Storage::DBI::_dbh_execute(): DBI > Exception: DBD::mysql::st execute failed: Data too long for column 'place' > at row 1 at /kohadevbox/koha/Koha/Object.pm line 176 > > As 260/264 $a and $c are repeatable fields, which get joined, it is not > uncommon that they exceed the maximal length of 256 in some of my records Hi Jan, please see bug 34029. Trying to get rid of those problems for good. -- 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 28328] Editing a record can cause an ISE if data too long for column
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28328 Katrin Fischer changed: What|Removed |Added See Also||https://bugs.koha-community ||.org/bugzilla3/show_bug.cgi ||?id=34029 -- 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 28328] Editing a record can cause an ISE if data too long for column
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28328 --- Comment #15 from Martin Renvoize --- Many hands makes light work, thankyou everyone! Pushed to 22.11.x for the next release -- 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 28328] Editing a record can cause an ISE if data too long for column
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28328 Martin Renvoize changed: What|Removed |Added Status|Pushed to master|Pushed to stable Version(s)|23.05.00|23.05.00,22.11.06 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 28328] Editing a record can cause an ISE if data too long for column
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28328 --- Comment #14 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 28328] Editing a record can cause an ISE if data too long for column
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28328 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 28328] Editing a record can cause an ISE if data too long for column
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28328 Martin Renvoize changed: What|Removed |Added Status|Signed Off |Passed QA CC||martin.renvoize@ptfs-europe ||.com --- Comment #13 from Martin Renvoize --- All working as described and fixes the issue. Passing 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 28328] Editing a record can cause an ISE if data too long for column
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28328 Martin Renvoize changed: What|Removed |Added Attachment #150588|0 |1 is obsolete|| --- Comment #12 from Martin Renvoize --- Created attachment 151022 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=151022&action=edit Bug 28328: Adjust tests Signed-off-by: Nick Clemens Signed-off-by: Martin Renvoize -- 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 28328] Editing a record can cause an ISE if data too long for column
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28328 Martin Renvoize changed: What|Removed |Added Attachment #150587|0 |1 is obsolete|| --- Comment #11 from Martin Renvoize --- Created attachment 151021 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=151021&action=edit Bug 28328: DBIC schema changes Signed-off-by: Nick Clemens Signed-off-by: Martin Renvoize -- 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 28328] Editing a record can cause an ISE if data too long for column
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28328 Martin Renvoize changed: What|Removed |Added Attachment #150586|0 |1 is obsolete|| --- Comment #10 from Martin Renvoize --- Created attachment 151020 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=151020&action=edit Bug 28328: Extend biblioitems.lccn to longtext Same sa issn and isbn, we want lccn to allow longer values. Test plan: Run the updatedatabase script to modify the DB structure restart_all Edit a bibliographic record and enter a long (more than 25 chars) lccn Save Signed-off-by: Nick Clemens Signed-off-by: Martin Renvoize -- 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 28328] Editing a record can cause an ISE if data too long for column
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28328 Nick Clemens changed: What|Removed |Added Attachment #150585|0 |1 is obsolete|| --- Comment #9 from Nick Clemens --- Created attachment 150588 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=150588&action=edit Bug 28328: Adjust tests Signed-off-by: Nick Clemens -- 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 28328] Editing a record can cause an ISE if data too long for column
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28328 Nick Clemens changed: What|Removed |Added Attachment #150584|0 |1 is obsolete|| --- Comment #8 from Nick Clemens --- Created attachment 150587 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=150587&action=edit Bug 28328: DBIC schema changes Signed-off-by: Nick Clemens -- 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 28328] Editing a record can cause an ISE if data too long for column
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28328 Nick Clemens changed: What|Removed |Added Attachment #150583|0 |1 is obsolete|| --- Comment #7 from Nick Clemens --- Created attachment 150586 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=150586&action=edit Bug 28328: Extend biblioitems.lccn to longtext Same sa issn and isbn, we want lccn to allow longer values. Test plan: Run the updatedatabase script to modify the DB structure restart_all Edit a bibliographic record and enter a long (more than 25 chars) lccn Save Signed-off-by: Nick Clemens -- 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 28328] Editing a record can cause an ISE if data too long for column
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28328 Nick Clemens 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 28328] Editing a record can cause an ISE if data too long for column
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28328 Jonathan Druart changed: What|Removed |Added Assignee|koha-b...@lists.koha-commun |jonathan.druart+koha@gmail. |ity.org |com CC||jonathan.druart+koha@gmail. ||com -- 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 28328] Editing a record can cause an ISE if data too long for column
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28328 --- Comment #6 from Jonathan Druart --- Created attachment 150585 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=150585&action=edit Bug 28328: Adjust tests -- 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 28328] Editing a record can cause an ISE if data too long for column
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28328 --- Comment #5 from Jonathan Druart --- Created attachment 150584 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=150584&action=edit Bug 28328: DBIC schema changes -- 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 28328] Editing a record can cause an ISE if data too long for column
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28328 --- Comment #4 from Jonathan Druart --- Created attachment 150583 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=150583&action=edit Bug 28328: Extend biblioitems.lccn to longtext Same sa issn and isbn, we want lccn to allow longer values. Test plan: Run the updatedatabase script to modify the DB structure restart_all Edit a bibliographic record and enter a long (more than 25 chars) lccn Save -- 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 28328] Editing a record can cause an ISE if data too long for column
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28328 Jonathan Druart changed: What|Removed |Added Status|NEW |Needs Signoff -- 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 28328] Editing a record can cause an ISE if data too long for column
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28328 --- Comment #3 from Jan Kissig --- The same problem for columns publishercode or place obtained from MARC 264$b and $a or 260$a and $b to reproduce 1 - edit or add new biblio 2 - in 264$a enter f.e. "1averylongtextaverylongtextaverylongtext42averylongtextaverylongtextaverylongtext84 | 2averylongtextaverylongtextaverylongtext42averylongtextaverylongtextaverylongtext84 | 3averylongtextaverylongtextaverylongtext42averylongtextaverylongtextaverylongtext847" 3 - fill in other mandatory fields 4 - save /var/log/koha/kohadev/plack-intranet-error.log says [2023/04/12 08:27:52] [WARN] DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st execute failed: Data too long for column 'place' at row 1 at /kohadevbox/koha/Koha/Object.pm line 176 As 260/264 $a and $c are repeatable fields, which get joined, it is not uncommon that they exceed the maximal length of 256 in some of my records -- 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 28328] Editing a record can cause an ISE if data too long for column
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28328 Jan Kissig changed: What|Removed |Added CC||bibliot...@th-wildau.de -- 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 28328] Editing a record can cause an ISE if data too long for column
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28328 Philip Orr changed: What|Removed |Added CC||philip@lmscloud.de --- Comment #2 from Philip Orr --- I got the same error in the OPAC when adding a purchase suggestion from an already existing title. To reproduce: 1 - Open a record in the OPAC that has too many characters in the ISBN field, e.g. "Ruby cookbook" 2 - Click on "Suggest for purchase" 3 - Click on "Submit your suggestion" 4 - ISE: DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st execute failed: Data too long for column 'isbn' at row 1 at /kohadevbox/koha/Koha/Object.pm line 170 at /usr/share/perl5/DBIx/Class/Exception.pm line 77 -- 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 28328] Editing a record can cause an ISE if data too long for column
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28328 Jonathan Druart changed: What|Removed |Added See Also||https://bugs.koha-community ||.org/bugzilla3/show_bug.cgi ||?id=30896 -- 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 28328] Editing a record can cause an ISE if data too long for column
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28328 --- Comment #1 from Katrin Fischer --- What would be the best solution here? I think we could limit the max size of 010a via the frameworks. But if the LCCN really can be longer than we give them space for now, we should probably change the data type of the column? -- 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 28328] Editing a record can cause an ISE if data too long for column
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28328 Nick Clemens changed: What|Removed |Added See Also||https://bugs.koha-community ||.org/bugzilla3/show_bug.cgi ||?id=26518 -- 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/