[mythtv-users] mirobridge - bad table name mythconverg.deloldrecorded
Brian Ruth
brian at bigkitty.org
Sun Sep 5 16:22:24 UTC 2010
I upgraded to trunk revision 26128 this morning and mirobridge now hangs
when run trying to access a table that doesn't exist
'mythconverg.deloldrecorded'. I'm guessing it should be looking for
mythconverg.oldrecorded, however, my Python experience is non-existent
and nothing is jumping out as I scan through the code. Anyone else
experiencing this or is should I be looking at mysql instead?
Output as follows (-n to preclude the miro file download messages):
[mythtv at athena .mythtv]$ python
/usr/share/doc/mythtv-docs-0.24/contrib/imports/mirobridge/mirobridge.py
-c 9999:9999 -Vn
2010-09-05 08:13:54,345 - mirobridge - INFO - Using python library
'pyparsing' version 1.5.0
2010-09-05 08:13:55.367 Python Database Connection: Using connection
settings from /home/mythtv/.mythtv/config.xml
2010-09-05 08:13:56,825 - mirobridge - INFO - Miro Bridge version v0.6.3
with Miro version 3.0.2
2010-09-05 08:13:56,826 - mirobridge - INFO - Using
mirobridge_interpreter_3_0_0
2010-09-05 08:13:56,917 - mirobridge - INFO - Miro Version (3.0.2 r9d00ca9f)
2010-09-05 08:13:56,917 - mirobridge - INFO - Base Miro Video Directory
(/storage01/media/miro)
2010-09-05 08:13:56,917 - mirobridge - INFO -
==========================================================================================
Listed below are the types and base directories that will be use for
processing.
The list reflects your current configuration for the
'athena.bigkitty.org' back end
and whether a directory is a 'SG' (storage group) or not.
Note: All directories are from settings in the MythDB specific to
hostname (athena.bigkitty.org).
------------------------------------------------------------------------------------------
Type: Default - SG-YES - Directory: (/video2/)
Type: Cover art - SG-YES - Directory:
(/storage01/media/mythtv.metadata/coverart/)
Type: Fan art - SG-YES - Directory:
(/storage01/media/mythtv.metadata/fanart/)
Type: Banners - SG-YES - Directory:
(/storage01/media/mythtv.metadata/banners/)
Type: Screenshots - SG-YES - Directory:
(/storage01/media/mythtv.metadata/screenshots/)
Type: Video - SG-YES - Directory: (/storage01/media/movies/)
------------------------------------------------------------------------------------------
If a directory you set from a separate Front end is not displayed it means
that the directory is not accessible from this backend OR
you must add the missing directories using the Front end on this Back end.
Front end settings are host machine specific.
==========================================================================================
2010-09-05 08:13:57,465 - mirobridge - INFO - Starting Miro Frontend and
Backend
2010-09-05 08:13:57,496 INFO Starting up Miro
2010-09-05 08:13:57,497 INFO Version: 3.0.2
2010-09-05 08:13:57,504 INFO OS: Linux
2.6.34.6-47.fc13.x86_64 x86_64
2010-09-05 08:13:57,505 INFO Revision:
ssh://wguaraldi@pcf1.pculture.org/var/git/miro - 9d00ca9f
2010-09-05 08:13:57,506 INFO Builder:
mockbuild at x86-02.phx2.fedoraproject.org
2010-09-05 08:13:57,507 INFO Build Time: 1275591127.75
2010-09-05 08:13:57,507 INFO Starting event loop thread
2010-09-05 08:13:57,509 INFO Restoring database...
2010-09-05 08:13:57,510 INFO Sqlite3 version: 3.6.22
2010-09-05 08:13:57,511 INFO Pysqlite version: 2.4.1
2010-09-05 08:13:57,511 INFO opening database
/home/mythtv/.miro/sqlitedb
2010-09-05 08:13:57,652 TIMING Database upgrade time: 0.142
2010-09-05 08:13:57,661 DBLOG start database log entries
2010-09-05 08:13:57,662 DBLOG * Sat May 22 14:39:02 2010: Upgraded
database from version 105 to 110
2010-09-05 08:13:57,662 DBLOG end database log entries
2010-09-05 08:13:57,964 INFO setup tabs...
2010-09-05 08:13:57,973 INFO setup theme...
2010-09-05 08:13:58,015 INFO Checking movies directory
'/storage01/media/miro/'...
Startup success.
Traceback (most recent call last):
File
"/usr/share/doc/mythtv-docs-0.24/contrib/imports/mirobridge/mirobridge.py",
line 2640, in <module>
main()
File
"/usr/share/doc/mythtv-docs-0.24/contrib/imports/mirobridge/mirobridge.py",
line 2317, in main
videostodelete = getOldrecordedOrphans()
File
"/usr/share/doc/mythtv-docs-0.24/contrib/imports/mirobridge/mirobridge.py",
line 1113, in getOldrecordedOrphans
oldrecorded_array = list(mythdb.searchOldRecorded(chanid=channel_id, ))
File "/usr/lib/python2.6/site-packages/MythTV/utility.py", line 145,
in __call__
yield self.dbclass.fromRaw(row, self.inst)
File "/usr/lib/python2.6/site-packages/MythTV/database.py", line 107,
in fromRaw
cls._setClassDefs(db)
File "/usr/lib/python2.6/site-packages/MythTV/database.py", line 250,
in _setClassDefs
super(DBDataWrite, cls)._setClassDefs(db)
File "/usr/lib/python2.6/site-packages/MythTV/database.py", line 73,
in _setClassDefs
cls._field_order = db.tablefields[cls._table]
File "/usr/lib/python2.6/site-packages/MythTV/database.py", line 798,
in __getitem__
raise MythDBError(MythDBError.DB_RAW, e.args)
MythTV.exceptions.MythDBError: MySQL error: MySQL error 1146: Table
'mythconverg.deloldrecorded' doesn't exist
Brian
More information about the mythtv-users
mailing list