On Tue, Aug 03, 2021 at 01:41:16PM +0200, mj wrote:
> Yes you are right. But the question remains: where does this faulty date in
> the system come from, and how to get it out.
Scrub the database?
mysqldump sogo | grep 'Sat Jul 10 11:56:18 UTC 2021' and see from what
table it comes? Hopefully, a PRODID property will tell you what client
did it.
Then you could fix it with something like this:
update table_xxx
set c_content = replace(
c_content,
'Sat Jul 10 11:56:18 UTC 2021',
'Sat, Jul 10 11:56:18 2021 +0000')
where c_content like '%Sat Jul 10 11:56:18 UTC 2021%';
If you have many of them, you will need something more complex.
Backup advised, as usual.
--
Emmanuel Dreyfus
[email protected]
--
[email protected]
https://inverse.ca/sogo/lists
