[mythtv-users] Guide data until 2038
ian.hodgson at dsl.pipex.com
Tue Oct 16 08:49:19 UTC 2007
Earlier this year, there was a post asking about a way to solve Myth
reporting that it had TV guide data until 2038. The solution posted was to
tidy the database with the following SQL script...
delete from program where starttime < date_sub(curdate(), interval 1 day)
or starttime > date_add(curdate(), interval 14 day);
I also have the '2038 problem' but have no idea of how to execute the script
supplied to the previous poster. Can anyone help with the full sequence of
commands so that I can correct the error in my database.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the mythtv-users