[mythtv-users] tv_grab_au 2.3
Leo Kliger
lkliger at bigpond.net.au
Thu Jun 29 04:03:40 UTC 2006
>
> 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
More information about the mythtv-users
mailing list