Videos not deleted by cron, seems to be date formatting issue
I'm using the docker setup with the latest code from gitlab at rev 33019728.
Videos aren't getting delete after their max-days number. I enabled debug logging and it seems to be an issue with how the date is formatted in the sql query. I don't know mysql or javascript well enough to fix this on my own.
Here's the query I get from debugLog, and it produces zero results so no videos get deleted:
SELECT * FROM Videos WHERE ke='measifZUCD' AND status != 0 AND details NOT LIKE '%"archived":"1"%' AND (mid = 'QJW8E8hWCf' AND end < 'Wed Nov 14 2018 09:12:06 GMT-0800 (PST)') ORDER BY time
ASC;
If I instead format the date in ISO 8601 format, it produces the list of videos I'd expect:
SELECT * FROM Videos WHERE ke='measifZUCD' AND status != 0 AND details NOT LIKE '%"archived":"1"%' AND (mid = 'QJW8E8hWCf' AND end < '2018-11-14 09:12:06') ORDER BY time
ASC;