10 Feb
2021
10 Feb
'21
5:44 p.m.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26997 --- Comment #10 from Martin Renvoize <martin.renvoize@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.