<div class="gmail_quote">On Fri, Oct 9, 2009 at 10:19 PM, Bobby Gill <span dir="ltr"><<a href="mailto:bobbygill@rogers.com">bobbygill@rogers.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div class="im">Saw that there's only data until 10/11@03:00, certainly not right
(subscription expires 04/09/2010 just in case the obvious is inquired).
I ran mythfilldatabase manually, repeatedly got the error that is found
here: <a href="http://www.mythtv.org/wiki/Mythfilldatabase#2._INSERT_IGNORE_INTO_SQL_Errors" target="_blank">http://www.mythtv.org/wiki/Mythfilldatabase#2._INSERT_IGNORE_INTO_SQL_Errors</a> here is the exact error as per output:<br>
<br><font size="1"><span style="font-family: courier new,monospace;"></span></font></div><a href="http://pastebin.ca/1608738" target="_blank">http://pastebin.ca/1608738</a><div class="im"><br style="font-family: courier new,monospace;">
<br>Basically repeats the error throughout the output, completes
"successfully." Here is the output of the suggested command to
check/repair the database (mysqlcheck -r -u <username> -p
<password> mythconverg):<br>
<br></div><a href="http://pastebin.ca/1608742" target="_blank">http://pastebin.ca/1608742</a><div><div></div><div class="h5"><br>
<br>^^ Even after this, no luck with mythfilldatabas, it gives the same output.<br><br></div></div></blockquote><div><br>Okay, checking from this thread <a href="http://www.gossamer-threads.com/lists/mythtv/users/207392#207392">http://www.gossamer-threads.com/lists/mythtv/users/207392#207392</a> I tried the command:<br>
<br> <font face="Verdana,Arial,Helvetica" size="2" color="black"><font face="Verdana,Arial,Helvetica" size="2" color="black">ALTER DATABASE mythconverg DEFAULT CHARACTER SET latin1;<br><br>Which allowed mythfilldatabase to work properly, however there are a bunch of channels that it still has not retrieved data for.<br>
<br>Thanks<br>Bob<br> </font></font></div></div>