| Summary: | Use of an authorised value in a marc subfield causes strict mode SQL error | ||
|---|---|---|---|
| Product: | Koha | Reporter: | Andrew Fuerste-Henry <andrew> |
| Component: | Cataloging | Assignee: | Andrew Fuerste-Henry <andrew> |
| Status: | CLOSED FIXED | QA Contact: | Testopia <testopia> |
| Severity: | major | ||
| Priority: | P5 - low | CC: | 1joynelson, lucas, m.de.rooy |
| Version: | Main | ||
| Hardware: | All | ||
| OS: | All | ||
| GIT URL: | Initiative type: | --- | |
| Sponsorship status: | --- | Comma delimited list of Sponsors: | |
| Crowdfunding goal: | 0 | Patch complexity: | Trivial patch |
| Documentation contact: | Documentation submission: | ||
| Text to go in the release notes: | Version(s) released in: |
20.05.00, 19.11.06, 19.05.11
|
|
| Circulation function: | |||
| Bug Depends on: | |||
| Bug Blocks: | 17258 | ||
| Attachments: |
Bug 25335: group by authorised_value in addbiblio.pl
Bug 25335: group by authorised_value in addbiblio.pl Bug 25335: group by authorised_value in addbiblio.pl |
||
|
Description
Andrew Fuerste-Henry
2020-04-30 19:33:25 UTC
Created attachment 104051 [details] [review] Bug 25335: group by authorised_value in addbiblio.pl To Test: 1- Edit your default framework, connect any subfield outside of the 952 to an authorised value (for example, connect the 942$n to the Yes_No auth value) 2 - Find a record in that framework 3 - Edit the record and find your subfield 4 - The subfield shows a dropdown with no contents 5 - check plack log, see "DBD::mysql::st execute failed: 'koha_kohadev.authorised_values.authorised_value' isn't in GROUP BY " 6 - apply patch, restart all 7 - reload edit record page, see your auth value dropdown has contents Created attachment 104077 [details] [review] Bug 25335: group by authorised_value in addbiblio.pl To Test: 1- Edit your default framework, connect any subfield outside of the 952 to an authorised value (for example, connect the 942$n to the Yes_No auth value) 2 - Find a record in that framework 3 - Edit the record and find your subfield 4 - The subfield shows a dropdown with no contents 5 - check plack error log, see "DBD::mysql::st execute failed: 'koha_kohadev.authorised_values.authorised_value' isn't in GROUP BY " 6 - apply patch, restart all 7 - reload edit record page, see your auth value dropdown has contents Signed-off-by: David Nind <david@davidnind.com> Created attachment 104231 [details] [review] Bug 25335: group by authorised_value in addbiblio.pl To Test: 1- Edit your default framework, connect any subfield outside of the 952 to an authorised value (for example, connect the 942$n to the Yes_No auth value) 2 - Find a record in that framework 3 - Edit the record and find your subfield 4 - The subfield shows a dropdown with no contents 5 - check plack log, see "DBD::mysql::st execute failed: 'koha_kohadev.authorised_values.authorised_value' isn't in GROUP BY " 6 - apply patch, restart all 7 - reload edit record page, see your auth value dropdown has contents Signed-off-by: David Nind <david@davidnind.com> Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de> Good catch! Nice work everyone! Pushed to master for 20.05 Backported to 19.11.x for 19.11.06 backported to 19.05.x for 19.05.11 |