[mythtv-users] Re: SQL error when running mythfilldatabase

[Pascal Hos]

HI,

I'm experiencing the exact same problems. While going through the
mythfilldatabase --manual steps I see the following output when
entereing the required data for a channel:

###
### New channel found
###
### name     = Nickelodeon
### callsign =
### channum  =
### finetune =
### tvformat =
### icon     =
###
Choose a channel ID (positive integer)  [0]  23
Choose a channel name (any string, long version)  [Nickelodeon]
Choose a channel callsign (any string, short version) nick
Choose a channel number (just like xawtv) 67
Choose a channel fine tune offset (just like xawtv) 16
Choose a TV format (PAL/SECAM/NTSC/ATSC/Default)
Choose a channel icon image (any path name)
/home/mythtv/.mythtv/channels/nickelodeon.png
Query was:
SELECT chanid,name,callsign,channum,finetune,icon,freqid,tvformat FROM
channel WHERE xmltvid = "89" AND sourceid = 1;
No error type from QSqlError?  Strange...

After going through all the channels I see the same message as shown
in the post below. I end up with no program information in my DB.
I would love to hear what the problem is cause I'm getting tired of
entereing all the data over and over again to see if what I changed
made a difference or not.

-----------------------------
asciimonster at myrealbox wrote:
-----------------------------
 I have a strange database problem when I run mythfilldatabase on my 0.16
install

Just after tv_grab_nl completes it remarks:
"Query was:
SELECT channum FROM channel WHERE chanid = 1000;
No error type from QSqlError? Strange...
Query was:
SELECT channum FROM channel WHERE chanid = 1000;
No error type from QSqlError? Strange...
Query was:"

And this repeated a several dozen times.
Next,

"Updating icons for sourceid: 1
Unknown xmltv channel identifier: 1.tvgids.nl
Skipping channel."

And repeat this for every channel... Lastly:

"Adjusting program database end times...
0 replacements made."

Strangely all other programmes (mythback, mythfront and setup) report NO
database problems.
Could you guys (and gals) help me make sense of this?