[mythtv-users] MythArchive missing table in database?

Lee McLaren lmclaren at lrm.com.au
Wed Aug 16 09:33:16 UTC 2006


Hi,
I am stuck on getting Mytharchive to work, If log the output of
Mythfrontend the error seems to suggest that my mythconverg database is
missing "archiveitems", when I check the database it is indeed missing.

I am running SVN ver 10728 for the frontend and backend and mytharchive.

Have I missed a step in the upgrade or should installing the Mythplugins
have upgraded the database?

Many thanks


Lee McLaren



Output of the Mythfrontend log when trying to take recordings to be
archived.



2006-08-16 19:20:07.481 Using runtime prefix = /usr
2006-08-16 19:20:07.494 DPMS is disabled.
2006-08-16 19:20:07.507 New DB connection, total: 1
2006-08-16 19:20:07.509 Connected to database 'mythconverg' at host:
localhost
2006-08-16 19:20:07.511 Total desktop dim: 848x480, with 1 screen[s].
2006-08-16 19:20:07.513 Using screen 0, 848x480 at 0,0
2006-08-16 19:20:07.517 Current Schema Version: 1155
2006-08-16 19:20:07.518 mythfrontend version: 0.19.20060708-1 www.mythtv.org
2006-08-16 19:20:07.518 Enabled verbose msgs:  important general
2006-08-16 19:20:07.839 Total desktop dim: 848x480, with 1 screen[s].
2006-08-16 19:20:07.840 Using screen 0, 848x480 at 0,0
2006-08-16 19:20:07.840 Switching to square mode (G.A.N.T.)
2006-08-16 19:20:07.852 Using the OpenGL painter
2006-08-16 19:20:08.008 New DB connection, total: 2
2006-08-16 19:20:08.009 Connected to database 'mythconverg' at host:
localhost
Could not initialize /dev/input/js0
open: Permission denied
ioctl JSIOCGAXES: Bad file descriptor
2006-08-16 19:20:08.196 Loading from:
/usr/share/mythtv/themes/G.A.N.T./base.xml
2006-08-16 19:20:08.205 Loading from:
/usr/share/mythtv/themes/default/base.xml
2006-08-16 19:20:08.251 Registering Internal as a media playback plugin.
2006-08-16 19:20:08.298 Registering MythDVD DVD Media Handler as a media
handler ext()
2006-08-16 19:20:08.299 Registering MythDVD VCD Media Handler as a media
handler ext()
2006-08-16 19:20:08.329 Registering MythGallery Media Handler 1/2 as a
media handler ext()
2006-08-16 19:20:08.330 Registering MythGallery Media Handler 2/2 as a
media handler ext(gif,jpg,png)
2006-08-16 19:20:08.427 Using NV NPOT texture extension
adding: 0,0,0 -- ST3250823AS
adding: 1,0,0 -- ST3250823AS
adding: ATA:0,1,0 -- DVD-RW  DVR-111D
Failed to run 'cdrecord --scanbus'
2006-08-16 19:20:10.635 Registering MythMusic Media Handler 1/2 as a
media handler ext()
2006-08-16 19:20:10.636 Registering MythMusic Media Handler 2/2 as a
media handler ext(ogg,mp3,aac,flac)
SIP listening on IP Address 10.1.1.150:5060 NAT address 10.1.1.150
2006-08-16 19:20:19.674 XMLParse::LoadTheme using
/usr/share/mythtv/themes/default/mytharchive-ui.xml
2006-08-16 19:20:19.906 Connecting to backend server: 10.1.1.150:6543
(try 1 of 5)
2006-08-16 19:20:19.907 Using protocol version 30
2006-08-16 19:20:25.331 DB Error (archive item insert):
Query was:
INSERT INTO archiveitems (type, title, subtitle,description, startdate,
starttime, size, filename, hascutlist) VALUES('Recording', 'Beyond
Tomorrow', '', 'T$
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.archiveitems' doesn't exist


More information about the mythtv-users mailing list