[mythtv-users] tv_grab_au 2.3

[Leo Kliger]

> 
> It seems I needed to update the configuration so that my TZ setting
> was at 'Australia/Brisbane'.  This now seems to have fixed some of the
> problems.  For examply, ABC and ABC2 seem to be perfect, but SBS, 7, 9
> and 10 are still showing Fridays schedule on Thursday, which means
> tonights line-up isn't down to be recorded.
> 
> Perhaps I need to run mythfilldatabase again and totally purge any
> existing schedule info.  I have tried the --ignore-cache option, but
> that didn't help.  Any other ideas?

Perhaps you should purge all program info from mythconverg and
repopulate mythfilldatabase with either --ignore-cache or by deleting
the cache file.

I'm sure some will frown at the following and I'd love to know a better
way if it exists (I'm not a DBA you see).....

run these commands:-
# mv /var/local/tv_grab_au/cached.pl /var/local/tv_grab_au/cached.pl_old
# mysql mythconverg
mysql> DELETE from program WHERE chanid;

It would look as follows:-
########################################################################
root at hostname:/mysqldbbac# mysql mythconverg
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1594 to server version:
4.0.24_Debian-10ubuntu2-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> DELETE from program WHERE chanid;
##########################################################################

Then run mythfilldatabase and see how everything looks.

Regards,

Leo