Hi
We're currently using Matrix 3.4 and want to use rollback but it isn't functioning properly. While investigating the problem I noticed that every asset seems to have 3 current versions when you look at the history screen. Each version has a different start time but they all show "present" as the end time. Is there an easy way to fix this? I'm hoping some kind of SQL query to set the end time for 2 out of 3 assets followed purging old versions.
Thanks,
Richard
PS: We can't upgrade Matrix until the end of the year because we don't have a recent enough version of PostgreSQL. Any fix needs to involve us staying with Matrix 3.4 for the moment.
That sounds like all your end dates are missing. To be honest, I've never seen that before in a rollback enabled system so we've never had to fix it.
The start date of the newer entry needs to be used as the end date of the older entry, but I don't know how you would write a query to do that. Sounds like something a script would have to do.