<br><br>
<div><span class="gmail_quote">On 12/5/07, <b class="gmail_sendername">R. G. Newbury</b> <<a href="mailto:newbury@mandamus.org">newbury@mandamus.org</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">I am stumped by this one.<br>Mythfilldatabase runs and produces temporary files in a<br>/tmp/mythtv_xxxxxx (ignoring the
my.cnf "tmp=/tmp/mysql" directive ??)<br><br>But mfdb cannot record the data as the "dd_xxxxx" tables do not exist.<br><br>The actual error is of the form:<br><br>2007-12-05 09:22:45.023 Grab complete. Actual data from Wed Dec 5
<br>05:00:00 2007 to Thu Dec 6 05:00:00 2007 (UTC)<br>2007-12-05 09:22:45.024 Main temp tables populated.<br>2007-12-05 09:22:45.024 Updating myth channels.<br>2007-12-05 09:22:45.025 DB Error (Truncating temporary table dd_v_station):
<br>Query was:<br>TRUNCATE TABLE dd_v_station;<br>Driver error was [2/1146]:<br>QMYSQL3: Unable to execute query<br>Database error was:<br>Table 'mythconverg.dd_v_station' doesn't exist<br><br><br>MySQL error 1146 is 'Table doesn't exist'....so that does not help.
<br><br>I cannot, with my limited programming knowledge of myth, see where mfdb<br>does/doesn't do this....<br><br>The system is running SVN 14882. I had a schema error and ended up doing<br>a mysqldump of the necessary tables (see the myth docs at chapter 23.
<br>Thanks Robert!), and a full install of this SVN, followed by a restore<br>of the record, recorded, etc. tables. It did a schema upgrade to 1201.<br><br>Help! I've fallen down to 5 days of listings and I can't get that up!
<br><br>Geoff<br>_______________________________________________<br>mythtv-users mailing list<br><a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br><a href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users">
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a><br></blockquote></div>
<div> </div>
<div>Weren't you having some other problems with temporary tables back a few weeks ago? Something tells me you need to do a reinstall of mysql after wiping away all configuration. Something is seriously hosed in your mysql setup.
</div>
<div><br> </div>