<blockquote style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;" class="gmail_quote">The only way to fix this is to edit the database directly. Make sure<br></blockquote><div class="gmail_quote">
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
you run a backup of the DB before touching it.<br>
<br>
To find the records that you need to fix, do something like this:<br>
<br>
$ mysql -u mythtv -pmythtv mythconverg<br>
mysql> select * from recorded where starttime IS NULL;<br>
<br>
The 'starttime' field is a datetime with a format of YYYY-MM-DD<br>
HH:MM:SS. More here: <a href="http://www.mythtv.org/wiki/Recorded" target="_blank">http://www.mythtv.org/wiki/Recorded</a><br>
<br>
You'll need to populate these fields with relavant data, as well as<br>
any other NULL field that should not be NULL.<br>
<br>
(Did I mention to do a backup before doing stuff like this?)<br>
<font color="#888888"></font><br></blockquote></div><br>Thanks Joe, yes I have mythconverg_backup running nightly, just ran it again as well. The field I need to change is chanid, so I tried:<br><br><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">└─> mysql -u mythtv -pmythtv mythconverg</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">Reading table information for completion of table and column names</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">You can turn off this feature to get a quicker startup with -A</span><br style="font-family: courier new,monospace;"><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">Welcome to the MySQL monitor. Commands end with ; or \g.</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">Your MySQL connection id is 1292</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">Server version: 5.1.38 Source distribution</span><br style="font-family: courier new,monospace;">
<br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.</span><br style="font-family: courier new,monospace;">
<br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">mysql> select * from recorded where chanid IS 44;</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '44' at line 1</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">mysql> select * from recorded where chanid IS NULL;</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">Empty set (0.00 sec)</span><br style="font-family: courier new,monospace;">
<br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">mysql> select * from recorded where chanid IS #44;</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"> -> </span><br>
<br>The recordings that I want to fix all have the chanid as 44 (I accidentally put it thinking it was asking for the channel number, before I realized it wanted the chanid which afterward I entered properly as 1042). Now I'm at the prompt here and unsure what it wants, is it asking me for the new chanid? I'd rather be sure than fudge up further. Thanks for the help.<br>
<br>Bob<br>