[mythtv-users] Mythfilldatabase not completing (only data for another day), SQL error

[Bobby Gill]

On Fri, Oct 9, 2009 at 10:19 PM, Bobby Gill <bobbygill at rogers.com> wrote:

> Saw that there's only data until 10/11 at 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:
> http://www.mythtv.org/wiki/Mythfilldatabase#2._INSERT_IGNORE_INTO_SQL_Errors
> here is the exact error as per output:
>
> http://pastebin.ca/1608738
>
> 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):
>
> http://pastebin.ca/1608742
>
>
> ^^ Even after this, no luck with mythfilldatabas, it gives the same output.
>
>
Okay, checking from this thread
http://www.gossamer-threads.com/lists/mythtv/users/207392#207392  I tried
the command:

 ALTER DATABASE mythconverg DEFAULT CHARACTER SET latin1;

Which allowed mythfilldatabase to work properly, however there are a bunch
of channels that it still has not retrieved data for.

Thanks
Bob
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mythtv.org/pipermail/mythtv-users/attachments/20091010/a5c8a668/attachment.htm>