To help others, i have just found a ticket where this issues was discussed
MM-39351: fixes LastRootPostAt being null by koox00 · Pull Request #19574 · mattermost/mattermost-server · GitHub and the following fixed my channels
UPDATE Channels SET LastRootPostAt=0 WHERE LastRootPostAt is NULL;