[Koha-bugs] [Bug 28207] New: Crash when seeing MARC structure of a new framework

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28207

            Bug ID: 28207
           Summary: Crash when seeing MARC structure of a new framework
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: normal
          Priority: P5 - low
         Component: System Administration
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: victor at tuxayo.net
        QA Contact: testopia at bugs.koha-community.org
                CC: gmcharlt at gmail.com

== Test plan ==
1. Administration › MARC frameworks => new framework
2. Marc structure
3. Internal server error
DBI Exception: DBD::mysql::st execute failed:
'koha_cover.biblio_framework.frameworktext' isn't in GROUP BY [for Statement
"select count(*),marc_tag_structure.frameworkcode,frameworktext from
marc_tag_structure,biblio_framework where
biblio_framework.frameworkcode=marc_tag_structure.frameworkcode group by
marc_tag_structure.frameworkcode"] at /usr/share/perl5/Plack/Component.pm line
50

Doesn't happen to everyone. But happens in PTFS-E's sandboxes for example.
(MariaDB 10.1)
On my koha also (MariaDB 10.5)

== sql strict mode ==
Tried toggling sql strict mode but still crashed.
sql_mode
STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

and

| Variable_name | Value |
+---------------+-------+
| sql_mode      |       |

Did a restart_all before retrying in case something weird kept the old mode for
Koha.

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.