[mythtv-users] Mythfilldatabase temporary tables do not exist.

[David Shay]

On 12/5/07, R. G. Newbury <newbury at mandamus.org> wrote:
>
> I am stumped by this one.
> Mythfilldatabase runs and produces temporary files in a
> /tmp/mythtv_xxxxxx  (ignoring the my.cnf "tmp=/tmp/mysql" directive ??)
>
> But mfdb cannot record the data as the "dd_xxxxx" tables do not exist.
>
> The actual error is of the form:
>
> 2007-12-05 09:22:45.023 Grab complete.  Actual data from Wed Dec 5
> 05:00:00 2007 to Thu Dec 6 05:00:00 2007 (UTC)
> 2007-12-05 09:22:45.024 Main temp tables populated.
> 2007-12-05 09:22:45.024 Updating myth channels.
> 2007-12-05 09:22:45.025 DB Error (Truncating temporary table
> dd_v_station):
> Query was:
> TRUNCATE TABLE dd_v_station;
> Driver error was [2/1146]:
> QMYSQL3: Unable to execute query
> Database error was:
> Table 'mythconverg.dd_v_station' doesn't exist
>
>
> MySQL error 1146 is 'Table doesn't exist'....so that does not help.
>
> I cannot, with my limited programming knowledge of myth, see where mfdb
> does/doesn't do this....
>
> The system is running SVN 14882. I had a schema error and ended up doing
> a mysqldump of the necessary tables (see the myth docs at chapter 23.
> Thanks Robert!), and a full install of this SVN, followed by a restore
> of the record, recorded, etc. tables. It did a schema upgrade to 1201.
>
> Help! I've fallen down to 5 days of listings and I can't get that up!
>
> Geoff
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20071205/f7a5717f/attachment.htm