Mailing List Archive

0.25 MythArchive 'Create Archive' progress.log not written
Updated from 0.24.2 to MythTV Version : v0.25pre from ATrpms on SL6.

mythtv-0.25-280_v0.25_beta_55_g814e880.el6.i686.rpm

All my usual things seem usable after a wiki-supported change to my
tarball-based Project-X installation that was needed to get DVD creation
working. I had been expecting a longer struggle here :-)

I've successfully used 'Create Archive' and rsync to transfer recordings
to my production box running 0.24-fixes, but the Log Viewer window that
is shown during the creation process remains blank throughout; the
'process.log' file remains at 0 bytes and I haven't found it anywhere
else. There is no indication on-screen that anything is happening, but
the disc is busy and the files are created.

The log viewer works as normal during DVD creation, and the mythburn.log
file in the same log folder isn't affected by 'Create Archive' task.

I tried an 'Import Archive' too (in 0.25*), but after the log viewer
appeared nothing happened; I had deleted the recording but had not
removed all traces of it from the DB using 'Previously Recorded'.

Finally I tried to optimise the DB and got this: I haven't yet tried
any of the suggestions. Maybe needs a different thread.

$ perl
/usr/share/doc/mythtv-docs-0.25/contrib/maintenance/optimize_mythdb.pl
Base class package "IO::Socket::INET6" is empty.
(Perhaps you need to 'use' the module which defines that package first,
or make that module available in @INC (@INC contains:
/usr/local/lib/perl5 /usr/local/share/perl5 /usr/lib/perl5/vendor_perl
/usr/share/perl5/vendor_perl /usr/local/lib/perl5 /usr/local/share/perl5
/usr/lib/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib/perl5
/usr/share/perl5 .).

Other points: Complains about locale settings, but that's before they
are read from XML.

And this is an extract from a mytharchivehelper log:

2.136095 I [19894/19894] CoreContext mythdbcon.cpp:179 (OpenDatabase) -
Connected to database 'mythconverg' at host: localhost
2012-03-23 12:19:22.138073 I [19894/19894] CoreContext
mythcorecontext.cpp:1272 (SaveLocaleDefaults) - Current locale en_GB
2012-03-23 12:19:22.138174 N [19894/19894] CoreContext
mythlocale.cpp:110 (LoadDefaultsFromXML) - Reading locale defaults from
/usr/share/mythtv//locales/en_gb.xml
2012-03-23 12:19:22.193138 E [19894/19894] CoreContext mythdbcon.cpp:823
(prepare) - Error preparing query: SELECT chanid, starttime, mark,
offset, type FROM recordedmarkup WHERE chanid = :CHANID and starttime =
:STARTTIME;
2012-03-23 12:19:22.193193 E [19894/19894] CoreContext mythdbcon.cpp:825
(prepare) - Driver error was [2/1054]:
QMYSQL3: Unable to prepare statement
Database error was:
Unknown column 'offset' in 'field list'

HTH

John P
_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://www.mythtv.org/mailman/listinfo/mythtv-users