[Koha-bugs] [Bug 21682] Stock Rotation: Update DB is failing with strict_sql_modes ON

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21682 --- Comment #31 from Marcel de Rooy --- (In reply to Marcel de Rooy from comment #30) > (In reply to Jonathan Druart from comment #26) > > Created attachment 81815 [details] [review] [review] > > Bug 21682: Add update DB entry for

[Koha-bugs] [Bug 21682] Stock Rotation: Update DB is failing with strict_sql_modes ON

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21682 Marcel de Rooy changed: What|Removed |Added CC||m.de.r...@rijksmuseum.nl

[Koha-bugs] [Bug 21682] Stock Rotation: Update DB is failing with strict_sql_modes ON

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21682 Martin Renvoize changed: What|Removed |Added Resolution|--- |FIXED

[Koha-bugs] [Bug 21682] Stock Rotation: Update DB is failing with strict_sql_modes ON

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21682 Nick Clemens changed: What|Removed |Added Status|Passed QA |Pushed to Master

[Koha-bugs] [Bug 21682] Stock Rotation: Update DB is failing with strict_sql_modes ON

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21682 --- Comment #27 from Jonathan Druart --- I amended the last patch to move atomicupdate/bug_21620.perl to atomicupdate/bug_21682.perl -- You are receiving this mail because: You are watching all bug changes.

[Koha-bugs] [Bug 21682] Stock Rotation: Update DB is failing with strict_sql_modes ON

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21682 Jonathan Druart changed: What|Removed |Added Attachment #81788|0 |1 is obsolete|

[Koha-bugs] [Bug 21682] Stock Rotation: Update DB is failing with strict_sql_modes ON

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21682 Martin Renvoize changed: What|Removed |Added Status|Signed Off |Passed QA --- Comment

[Koha-bugs] [Bug 21682] Stock Rotation: Update DB is failing with strict_sql_modes ON

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21682 Martin Renvoize changed: What|Removed |Added Attachment #81770|0 |1 is obsolete|

[Koha-bugs] [Bug 21682] Stock Rotation: Update DB is failing with strict_sql_modes ON

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21682 Martin Renvoize changed: What|Removed |Added Attachment #81769|0 |1 is obsolete|

[Koha-bugs] [Bug 21682] Stock Rotation: Update DB is failing with strict_sql_modes ON

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21682 --- Comment #22 from Jonathan Druart --- I removed the need of the new subroutine, could you please test this version? -- You are receiving this mail because: You are watching all bug changes.

[Koha-bugs] [Bug 21682] Stock Rotation: Update DB is failing with strict_sql_modes ON

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21682 Jonathan Druart changed: What|Removed |Added Attachment #81526|0 |1 is obsolete|

[Koha-bugs] [Bug 21682] Stock Rotation: Update DB is failing with strict_sql_modes ON

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21682 --- Comment #21 from Jonathan Druart --- Created attachment 81770 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=81770=edit Bug 21682: Add update DB entry for existing installs -- You are receiving this mail

[Koha-bugs] [Bug 21682] Stock Rotation: Update DB is failing with strict_sql_modes ON

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21682 --- Comment #19 from Martin Renvoize --- I wasn't aware that was a statement 'we always use' -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs

[Koha-bugs] [Bug 21682] Stock Rotation: Update DB is failing with strict_sql_modes ON

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21682 --- Comment #18 from Jonathan Druart --- Why do not you use the same statement we always use? :) ALTER TABLE stockrotationrotas CHANGE COLUMN description description text; -- You are receiving this mail because: You are

[Koha-bugs] [Bug 21682] Stock Rotation: Update DB is failing with strict_sql_modes ON

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21682 --- Comment #17 from Martin Renvoize --- Wow.. thanks M.Tompsett -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list

[Koha-bugs] [Bug 21682] Stock Rotation: Update DB is failing with strict_sql_modes ON

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21682 --- Comment #14 from M. Tompsett --- Created attachment 81527 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=81527=edit Bug 21682: Corrections for strict sql in stockrotationrotas Test Plan: 1) Ensure you're

[Koha-bugs] [Bug 21682] Stock Rotation: Update DB is failing with strict_sql_modes ON

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21682 --- Comment #16 from M. Tompsett --- Created attachment 81529 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=81529=edit Bug 21682: Follow up to use the default_exists check This will make sure it is idempotent,

[Koha-bugs] [Bug 21682] Stock Rotation: Update DB is failing with strict_sql_modes ON

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21682 --- Comment #15 from M. Tompsett --- Created attachment 81528 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=81528=edit Bug 21682: (follow-up) - DBUpdate for Dev installs

[Koha-bugs] [Bug 21682] Stock Rotation: Update DB is failing with strict_sql_modes ON

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21682 M. Tompsett changed: What|Removed |Added Attachment #81280|0 |1 is obsolete|

[Koha-bugs] [Bug 21682] Stock Rotation: Update DB is failing with strict_sql_modes ON

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21682 M. Tompsett changed: What|Removed |Added Status|Needs Signoff |Signed Off -- You are

[Koha-bugs] [Bug 21682] Stock Rotation: Update DB is failing with strict_sql_modes ON

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21682 --- Comment #12 from M. Tompsett --- Created attachment 81525 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=81525=edit Bug 21682: Prequel addition of default_exists prove t/db_dependent/Installer.t perldoc

[Koha-bugs] [Bug 21682] Stock Rotation: Update DB is failing with strict_sql_modes ON

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21682 Tomás Cohen Arazi changed: What|Removed |Added CC||tomasco...@gmail.com

[Koha-bugs] [Bug 21682] Stock Rotation: Update DB is failing with strict_sql_modes ON

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21682 --- Comment #10 from Martin Renvoize --- Actually.. I get that error whether I enable strict modes or not.. I have no idea. -- You are receiving this mail because: You are watching all bug changes.

[Koha-bugs] [Bug 21682] Stock Rotation: Update DB is failing with strict_sql_modes ON

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21682 --- Comment #9 from Martin Renvoize --- Actually.. I do need help here.. When running in SQL strict mode I get the following for the atomic update. DBD::mysql::db do failed: BLOB/TEXT column 'description' can't have a default

[Koha-bugs] [Bug 21682] Stock Rotation: Update DB is failing with strict_sql_modes ON

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21682 Martin Renvoize changed: What|Removed |Added Attachment #81347|0 |1 is obsolete|

[Koha-bugs] [Bug 21682] Stock Rotation: Update DB is failing with strict_sql_modes ON

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21682 --- Comment #7 from Martin Renvoize --- I'm not 100% sure on the idempotency of the atomicupdate.. I believe 'DROP DEFAULT' is idempotent in itself, but couldn't find any documentation either way and it's not trivial to check that a

[Koha-bugs] [Bug 21682] Stock Rotation: Update DB is failing with strict_sql_modes ON

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21682 --- Comment #6 from Martin Renvoize --- Created attachment 81347 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=81347=edit Bug 21683: (follow-up) - DBUpdate for Dev installs -- You are receiving this mail

[Koha-bugs] [Bug 21682] Stock Rotation: Update DB is failing with strict_sql_modes ON

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21682 --- Comment #5 from Jonathan Druart --- (In reply to Katrin Fischer from comment #4) > As the devs refresh the dbs quite frequently, shoudl this be blocker? Either we need it or we write that somewhere in the guidelines :) --

[Koha-bugs] [Bug 21682] Stock Rotation: Update DB is failing with strict_sql_modes ON

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21682 Katrin Fischer changed: What|Removed |Added CC||katrin.fisc...@bsz-bw.de

[Koha-bugs] [Bug 21682] Stock Rotation: Update DB is failing with strict_sql_modes ON

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21682 Jonathan Druart changed: What|Removed |Added Severity|critical|major -- You are

[Koha-bugs] [Bug 21682] Stock Rotation: Update DB is failing with strict_sql_modes ON

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

[Koha-bugs] [Bug 21682] Stock Rotation: Update DB is failing with strict_sql_modes ON

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21682 Martin Renvoize changed: What|Removed |Added Blocks||21656 Referenced Bugs:

[Koha-bugs] [Bug 21682] Stock Rotation: Update DB is failing with strict_sql_modes ON

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21682 Martin Renvoize changed: What|Removed |Added Status|NEW |Needs Signoff ---

[Koha-bugs] [Bug 21682] Stock Rotation: Update DB is failing with strict_sql_modes ON

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21682 Martin Renvoize changed: What|Removed |Added Depends on||11897 Referenced Bugs:

[Koha-bugs] [Bug 21682] Stock Rotation: Update DB is failing with strict_sql_modes ON

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21682 Martin Renvoize changed: What|Removed |Added Assignee|koha-b...@lists.koha-commun

[Koha-bugs] [Bug 21682] Stock Rotation: Update DB is failing with strict_sql_modes ON

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21682 --- Comment #1 from Martin Renvoize --- Created attachment 81280 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=81280=edit Bug 21682: Corrections for strict sql in stockrotationrotas Test Plan: 1) Ensure you're

[Koha-bugs] [Bug 21682] Stock Rotation: Update DB is failing with strict_sql_modes ON

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21682 Martin Renvoize changed: What|Removed |Added Severity|enhancement |critical -- You are