<br><br><div><span class="gmail_quote">On 18/09/06, <b class="gmail_sendername">Dave</b> <<a href="mailto:dbadia@gmail.com">dbadia@gmail.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div><br><br><div></div><div><span class="e" id="q_10dbe4ac6c735009_1"><span class="gmail_quote">On 9/16/06, <b class="gmail_sendername">Paul Harrison</b> <<a href="mailto:mythtv@dsl.pipex.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
mythtv@dsl.pipex.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Dave wrote:<br>> Upgraded to myth .20-fixes rev 11193 last night, works great except<br>> for MythArchive.<br>> trying to archive a few recording to an ISO and getting:<br>><br>> mythburn.py (0.1.20060910-1
) starting up...<br>> Process priority -2<br>> script path:/usr/local/share/mythtv/mytharchive/scripts<br>> myth share path:/usr/local/share/mythtv<br>> passed job file: /var/local/media/tmp/config/mydata.xml
<br>
> passed progress log file: /var/local/media/tmp/logs/progress.log<br>> mythburn.py (0.1.20060910-1) starting up...<br>> Obtaining MythTV settings from MySQL database for hostname dawkins<br>> Obtaining date and time settings from MySQL database for hostname dawkins
<br>> ************************************************************<br>> ERROR: Failed to get time formats from the DB<br>> ************************************************************<br>><br>><br>> Searched the forums, but couldn't find anything on this one. Any
<br>> thoughts?<br>><br>> Thanks!<br>> Dave<br>><br><br>If you run this query in mysql what is the result?<br><br>SELECT value,data FROM settings WHERE (hostname='dawkins' AND value IN<br>('DateFormat', 'ShortDateFormat', 'TimeFormat')) ORDER BY value;
<br><br>Paul H.<br><br><br>_______________________________________________<br>mythtv-users mailing list<br><a href="mailto:mythtv-users@mythtv.org" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">mythtv-users@mythtv.org
</a><br><a href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a></blockquote></span></div><div><div><br><br>mysql> SELECT value,data FROM settings WHERE (hostname='dawkins' AND value IN</div><div><span class="q"><br> -> ('DateFormat', 'ShortDateFormat', 'TimeFormat')) ORDER BY value;
<br></span></div><div>+-----------------+-----------+<br>| value | data |<br>+-----------------+-----------+<br>| DateFormat | ddd MMM d |<br>| DateFormat | ddd MMM d |<br>| ShortDateFormat | M/d |
<br>| ShortDateFormat | M/d |
<br>| TimeFormat | h:mm AP |<br>| TimeFormat | h:mm AP |<br>+-----------------+-----------+<br>6 rows in set (0.03 sec)<br> </div><br></div></div></blockquote></div>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.
<br><br>mysql> SELECT value,data FROM settings WHERE (hostname='mythtv' AND value IN<br> -> ('DateFormat', 'ShortDateFormat', 'TimeFormat')) ORDER BY value;<br>+-----------------+-----------+<br>| value | data |
<br>+-----------------+-----------+<br>| DateFormat | ddd MMM d |<br>| DateFormat | ddd MMM d |<br>| ShortDateFormat | dd/MM |<br>| TimeFormat | h:mm AP |<br>| TimeFormat | h:mm AP |<br>+-----------------+-----------+
<br>5 rows in set (0.03 sec)<br><br>regards<br><br>Gary<br>