Summary: | Crash when seeing MARC structure of a new framework | ||
---|---|---|---|
Product: | Koha | Reporter: | Victor Grousset/tuxayo <victor> |
Component: | System Administration | Assignee: | Jonathan Druart <jonathan.druart> |
Status: | CLOSED FIXED | QA Contact: | Testopia <testopia> |
Severity: | normal | ||
Priority: | P5 - low | CC: | andrew, fridolin.somers, gmcharlt, jonathan.druart, julian.maurice, phil |
Version: | Main | ||
Hardware: | All | ||
OS: | All | ||
GIT URL: | Change sponsored?: | --- | |
Patch complexity: | --- | Documentation contact: | |
Documentation submission: | Text to go in the release notes: | ||
Version(s) released in: |
21.05.00,20.11.06,20.05.12
|
Circulation function: | |
Bug Depends on: | |||
Bug Blocks: | 17258 | ||
Attachments: |
Bug 28207: Fix biblio_framework.frameworktext isn't in GROUP BY
Bug 28207: Fix biblio_framework.frameworktext isn't in GROUP BY Bug 28207: Fix biblio_framework.frameworktext isn't in GROUP BY Bug 28207: Fix biblio_framework.frameworktext isn't in GROUP BY |
Description
Victor Grousset/tuxayo
2021-04-23 15:21:38 UTC
To switch off strict sql modes you need to turn strict_sql_modes off in the koha config. Created attachment 120167 [details] [review] Bug 28207: Fix biblio_framework.frameworktext isn't in GROUP BY When a new framework is created and "Marc structure" is opened, a SQL error happened if sql_strict_mode is on. Test plan: Create a 2 new biblio frameworks Click "Marc structure" for one of them => You see the list of all frameworks with an existing structure Created attachment 120185 [details] [review] Bug 28207: Fix biblio_framework.frameworktext isn't in GROUP BY When a new framework is created and "Marc structure" is opened, a SQL error happened if sql_strict_mode is on. Test plan: Create a 2 new biblio frameworks Click "Marc structure" for one of them => You see the list of all frameworks with an existing structure Signed-off-by: David Nind <david@davidnind.com> Created attachment 120186 [details] [review] Bug 28207: Fix biblio_framework.frameworktext isn't in GROUP BY When a new framework is created and "Marc structure" is opened, a SQL error happened if sql_strict_mode is on. Test plan: Create a 2 new biblio frameworks Click "Marc structure" for one of them => You see the list of all frameworks with an existing structure Signed-off-by: David Nind <david@davidnind.com> Signed-off-by: Victor Grousset/tuxayo <victor@tuxayo.net> Thanks for the fix :D Created attachment 120327 [details] [review] Bug 28207: Fix biblio_framework.frameworktext isn't in GROUP BY When a new framework is created and "Marc structure" is opened, a SQL error happened if sql_strict_mode is on. Test plan: Create a 2 new biblio frameworks Click "Marc structure" for one of them => You see the list of all frameworks with an existing structure Signed-off-by: David Nind <david@davidnind.com> Signed-off-by: Victor Grousset/tuxayo <victor@tuxayo.net> Signed-off-by: Julian Maurice <julian.maurice@biblibre.com> Pushed to master for 21.05, thanks to everybody involved! Pushed to 20.11.x for 20.11.06 Pushed to 20.05.x for 20.05.12 Not backported to oldoldstable (19.11.x). Feel free to ask if it's needed. |