You are here

MythTV mythfilldatabase Column 'channum' cannot be null

3 posts / 0 new
Last post
Symlink
Offline
Joined: 8 years
Last seen: 8 years
MythTV mythfilldatabase Column 'channum' cannot be null

WG++ version : latest (v1.1.1 / 55)

OS : Linux Ubuntu 14.04 (MythBuntu)

Mono version : Mono JIT compiler version 3.2.8 (Debian 3.2.8+dfsg-4ubuntu1.1)

I am using canada.com

 

First of all : thank you for taking the time to help me with this.

My problem : when running mythfilldatabse with the provided command from the configuration page : 

mythfilldatabase --refresh 14 --file --sourceid 1 --xmlfile ./guide.xml

It returns Column 'channum' cannot be null with every insert. 

It does however populate the database with information but since I have no channum I can't see the EPG unless I manually populate the channel numbers. But if I do populate those channel numbers the EPG works perfectly.

If I run the mythfilldatabase command again (which I need to in order to keep it updated without having to manually edit the channum everytime) it adds the channels as duplicates without the channum again. 

I went trough the guide.xml and noticed it was slightly different from my other xml file generated with zap2xml (which I put in the .zip alongside the guide.xml for you to review)

I searched in the forum and on google and didn't find anything as of now. 

 

Thank you again.

 

Attachments: 
francis
Offline
francis's picture
Has donated long time agoWG++ Team member
Joined: 11 years
Last seen: 1 month
Is the support helpful?
support us

Have you read/tested

https://www.mythtv.org/wiki/Updating_Channel_Lineup

XMLTV file seems correct. So that can't be the problem.

lkospa7
Offline
Joined: 9 years
Last seen: 2 months

Sorry to invoke this old thread, but the posted epg file is actually not complete. MythTV requires the channel number to be specified in the xmltv file using a separate display-name tag,

<display-name>13</display-name>

The posted EPG file is missing that information. This would work fine if the channel updates are not needed like

mythfilldatabase --only-update-guide --file --sourceid 1 --xmlfile guide.xml

but fail if channel updates are required.

Log in or register to post comments

Brought to you by Jan van Straaten

Program Development - Jan van Straaten ------- Web design - Francis De Paemeleere
Supported by: servercare.nl