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

[Dave]

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)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20060917/691e072b/attachment.html