[mythtv-users] Missing channel and freqid = NULL problem
Mark
mrote at hotmail.com
Wed Jul 12 22:16:40 UTC 2006
I am running latest SVN and had a few things that were messed in my
channel table so I thought I'd delete video source and start over.
Only problem is that when I download the data from zap2it, I am missing
one channel and am seeing a problem with freqid being set to NULL except
for the OTA channels. This may be correct but when trying to watch
LiveTV, I am getting a log file full of these for channels that are NULL
2006-07-12 16:57:16.863 DB Error (insert_program -- insert):
Query was:
INSERT INTO recorded (chanid, starttime, (removed rest)
Driver error was [2/1048]:
QMYSQL3: Unable to execute query
Database error was:
Column 'chanid' cannot be null
I am able to get around that by updating the table so that
freqid=channum but what is causing the problem in the first place?
Also, in regards to the missing channel depending on whether I use the
"Fetch channels from listings source" in mythtv-setup or
mythfilldatabase --do-channel-updates , I get two different results but
it's always the same channels getting crossed. 12 and 25.
If I use "Fetch channels..." I get the following results but there is
no entry for channum=25
chanid | channum | freqid | callsign | name
1012 12 25 KOKH KOKH
If I run mythfilldatabase, I get this but there is no entry for channum=12
chanid | channum | freqid | callsign | name
1012 25 0 LIFE Lifetime
Channel 12 on my cable is KOKH and channel 25 is Lifetime. Either way,
it doesn't work right.
I am able to get it working my making some manual changes to the
database but what could be causing this. Bad data from Zap2it maybe?
Here is the info on my setup
OK35543 Cox Communications - Oklahoma City (for 73099) Cable
mythbackend --version
Library API version: 0.19.20060708-1
Source code version: 10482
Was wondering if anybody else is seeing this and is there anything I
need to look in order to fix it.
Thanks for any assistance and sorry for being so long winded!
More information about the mythtv-users
mailing list