[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