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

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

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

--- Comment #9 from Martin Renvoize <martin.renvoize at ptfs-europe.com> ---
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
value [for Statement "ALTER TABLE `stockrotationrotas` ALTER COLUMN
`description` DROP DEFAULT"] at (eval 1403) line 3.

I think we need to check for sql strict mode before attempting to apply the
update or not.. :(

This was meant to be a simple fix :(

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