LinHES Forums
http://forums.linhes.org/

mythfilldatabase SQL erros
http://forums.linhes.org/viewtopic.php?f=5&t=5149
Page 1 of 1

Author:  infield [ Fri Jul 01, 2005 8:01 am ]
Post subject:  mythfilldatabase SQL erros

Hi,

I turned off my myth box when I went away for a two weeks. When I tried to run mythfilldatabase the first time it turned out my datadirect subscription need to be renewed. I renewed it and now I am getting a SQL error when I run mythfilldatabase.

Code:
Your subscription expires on 10/01/05 08:24:49
Grab complete.  Actual data from Sat Jul 2 07:00:00 2005 to Sun Jul 3 07:00:00 2005 (UTC)
Clearing data for source...
Clearing from Sat Jul 2 00:00:00 2005 to Sun Jul 3 00:00:00 2005 (localtime)
2005-07-01 06:54:09.897 New DB connection, total: 3
2005-07-01 06:54:09.898 New DB connection, total: 4
Data for source cleared...
Main temp tables populated.  Updating myth channels...
Updating icons for sourceid: 1
DB Error (Looking for icons to fetch):
Query was:
SELECT ch.chanid, nim.url FROM channel ch, callsignnetworkmap csm RIGHT JOIN networkiconmap nim ON csm.network = nim.network WHERE ch.callsign = csm.callsign AND (icon = 'none' OR icon = '') AND ch.sourceid = 1
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.callsignnetworkmap' doesn't exist



It looks like it's missing the callsignnetworkmap table. Any tips?

Thanks,
-marc

Page 1 of 1 All times are UTC - 6 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/