[mythtv-users] MythArchive error: Failed to get time formats from the DB

[Gary Dawes]

On 18/09/06, Dave <dbadia at gmail.com> wrote:
>
>
>
> On 9/16/06, Paul Harrison <mythtv at dsl.pipex.com> wrote:
> >
> > Dave wrote:
> > > Upgraded to myth .20-fixes rev 11193 last night, works great except
> > > for MythArchive.
> > > trying to archive a few recording to an ISO and getting:
> > >
> > > mythburn.py (0.1.20060910-1 ) starting up...
> > > Process priority -2
> > > script path:/usr/local/share/mythtv/mytharchive/scripts
> > > myth share path:/usr/local/share/mythtv
> > > passed job file: /var/local/media/tmp/config/mydata.xml
> > > passed progress log file: /var/local/media/tmp/logs/progress.log
> > > mythburn.py (0.1.20060910-1) starting up...
> > > Obtaining MythTV settings from MySQL database for hostname dawkins
> > > Obtaining date and time settings from MySQL database for hostname
> > dawkins
> > > ************************************************************
> > > ERROR: Failed to get time formats from the DB
> > > ************************************************************
> > >
> > >
> > > Searched the forums, but couldn't find anything on this one.  Any
> > > thoughts?
> > >
> > > Thanks!
> > > Dave
> > >
> >
> > If you run this query in mysql what is the result?
> >
> > SELECT value,data FROM settings WHERE (hostname='dawkins' AND value IN
> > ('DateFormat', 'ShortDateFormat', 'TimeFormat')) ORDER BY value;
> >
> > Paul H.
> >
> >
> > _______________________________________________
> > mythtv-users mailing list
> > mythtv-users at mythtv.org
> > http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
>
>
> mysql> SELECT value,data FROM settings WHERE (hostname='dawkins' AND value
> IN
>
>     -> ('DateFormat', 'ShortDateFormat', 'TimeFormat')) ORDER BY value;
> +-----------------+-----------+
> | value           | data      |
> +-----------------+-----------+
> | DateFormat      | ddd MMM d |
> | DateFormat      | ddd MMM d |
> | ShortDateFormat | M/d       |
> | ShortDateFormat | M/d       |
> | TimeFormat      | h:mm AP   |
> | TimeFormat      | h:mm AP   |
> +-----------------+-----------+
> 6 rows in set (0.03 sec)
>
>
> Just to add, I get the same error. running that mysql query for me gives
the following result. I'm running the latest knoppmyth in the UK.

mysql> SELECT value,data FROM settings WHERE (hostname='mythtv' AND value IN
    -> ('DateFormat', 'ShortDateFormat', 'TimeFormat')) ORDER BY value;
+-----------------+-----------+
| value           | data      |
+-----------------+-----------+
| DateFormat      | ddd MMM d |
| DateFormat      | ddd MMM d |
| ShortDateFormat | dd/MM     |
| TimeFormat      | h:mm AP   |
| TimeFormat      | h:mm AP   |
+-----------------+-----------+
5 rows in set (0.03 sec)

regards

Gary
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20060918/9cde2ea4/attachment.htm