On Wed, May 4, 2011 at 12:19 PM, Steven Adeff <<a href="mailto:adeffs.mythtv@gmail.com">adeffs.mythtv@gmail.com</a>> wrote:<br>> On Wed, May 4, 2011 at 12:07 PM, Michael T. Dean<br>>> And do you see lines like:<br>
>><br>>> 2011-05-04 00:54:45.505 Marking repeats.<br>>> 2011-05-04 00:54:45.783 Found 11571<br>>><br>>> at the bottom of the log output for a mythfilldatabase run? (And do you<br>>> get a full run of mythfilldatabase, or does it crash sometime before<br>
>> this point?)<br>>><br>>> Mike<br>><br>> none of them say "repeat" even though they are. I'm running<br>> mythfilldatabase on the CLI to see what it says. I will get back when<br>
> it finishes running.<br>><br>> thanks to all!<br><br>ok, I think I figured it out... there was an errant source that was not connected to a recorder (from trying to setup a firewire recorder which was not able to capture anything outside of OTA so we removed the recorder but not the source).<br>
<br>what bothers me now though is I'm seeing lots of sql errors in the mythfilldatabase output...<br><br>2011-05-04 09:46:16.347 DB Error (Inserting into credits table):<br>Query was:<br>INSERT IGNORE INTO program ( chanid, starttime, endtime, title, subtitle, description, showtype, category, category_type, airdate, stars, previouslyshown, stereo, subtitled, subtitletypes, videoprop, audioprop, hdtv, closecaptioned, partnumber, parttotal, seriesid, originalairdate, colorcode, syndicatedepisodenumber, programid, listingsource) SELECT dd_v_program.chanid, DATE_ADD(starttime, INTERVAL channel.tmoffset MINUTE), DATE_ADD(endtime, INTERVAL channel.tmoffset MINUTE), title, subtitle, description, showtype, dd_genre.class, category_type, airdate, stars, previouslyshown, stereo, subtitled, (subtitled << 1 ) | closecaptioned, hdtv, (dolby << 3) | stereo, hdtv, closecaptioned, partnumber, parttotal, seriesid, originalairdate, colorcode, syndicatedepisodenumber, dd_v_program.programid, ? FROM (dd_v_program, channel) LEFT JOIN dd_genre ON ( dd_v_program.programid = dd_genre.programid AND dd_genre.relevance = '0' ) WHERE dd_v_program.chanid = channel.chanid<br>
Driver error was [2/1267]:<br>QMYSQL: Unable to execute query<br>Database error was:<br>Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='<br><br>considering this database was started by a 0.24-fixes install I don't know why this is occurring?<br>
<br><br>thanks!<br>-- <br>Steve<br><a href="http://www.mythtv.org/wiki/User:Steveadeff">http://www.mythtv.org/wiki/User:Steveadeff</a><br>Before you ask, read the FAQ! <a href="http://www.mythtv.org/wiki/index.php/Frequently_Asked_Questions">http://www.mythtv.org/wiki/index.php/Frequently_Asked_Questions</a><br>
then search the Wiki, and this list, <a href="http://www.gossamer-threads.com/lists/mythtv/">http://www.gossamer-threads.com/lists/mythtv/</a><br>Mailinglist etiquette - <a href="http://www.mythtv.org/wiki/index.php/Mailing_List_etiquette">http://www.mythtv.org/wiki/index.php/Mailing_List_etiquette</a><br>
<br>