[Koha-bugs] [Bug 23289] Label Template - Creation not working with SQL strict mode enabled

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

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

Galen Charlton <gmcharlt at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |gmcharlt at gmail.com

--- Comment #6 from Galen Charlton <gmcharlt at gmail.com> ---
I'm not sure that the SQL mode is the problem per se; rather, as of 10.2.4,
"rows" is now a reserved word in MariaDB and cannot be used as a identifier
(e.g., a column name) without quoting it.

Using backticks to quote the word in the insert statement would make it work,
but of course that violates the SQL6 guideline (though given commit fd30cac85,
perhaps that guideline isn't being enforced?). It doesn't look like ANSI_QUOTES
or ANSI are being set either. Renaming label_templates.rows column is another
option, of course.

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