[Koha-bugs] [Bug 26997] Database Mysql Version 8.0.22 failed to Update During Upgrade

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

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

--- Comment #10 from Martin Renvoize <martin.renvoize at ptfs-europe.com> ---
(In reply to Manos PETRIDIS from comment #9)
> I wonder if 
> UPDATE suggestions SET suggesteddate = '1970-01-01' WHERE NOT suggesteddate
> > '1970-01-01';
> might succeed in performing the intended update. Values '0000-00-00' would
> be interpeted as FALSE, and NOT FALSE would allow the update to proceed.

I just tried this locally and it works well.. 

I think however, it may be worth putting into a generic 'fix all dates'
script..

I'll take a look at doing that.

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