Opened 12 years ago

Closed 4 years ago

#10553 closed Bug Report - General (Fixed)

channelscanner can not added the found channels

Reported by: lars.schmohl@… Owned by: danielk
Priority: minor Milestone: 29.2
Component: MythTV - Channel Scanner Version: Master Head
Severity: medium Keywords:
Cc: Stuart Auchterlonie Ticket locked: no

Description

I am trying to use the new MythTV 0.25 for a new htpc.

I have installed mythbuntu 12.04, so far everything is running.

When I am scanning for channels, they are found but not insert in the table after the scan.

log file with the error messages are attached

myth

Attachments (1)

mythtv-setup.log (162.3 KB) - added by lars.schmohl@… 12 years ago.
mythtv setup channel scan

Download all attachments as: .zip

Change History (23)

Changed 12 years ago by lars.schmohl@…

Attachment: mythtv-setup.log added

mythtv setup channel scan

comment:1 Changed 12 years ago by danielk

Milestone: 0.25unknown

comment:2 Changed 12 years ago by dekarl@…

Lets see... Google hints that you might be in Switzerland.

Apr  6 11:28:15 HTPC-core mythtv-setup[11341]: E Scanner dvbchannel.cpp:797 (Tune) DVBChan(1:/dev/dvb/adapter0/frontend0): Tune(): Setting Frontend tuning parameters failed.#012#011#011#011eno: Invalid argument (22)
Apr  6 11:28:15  mythtv-setup[11341]: last message repeated 73 times

looks like your DVB card is unable to automatically guess one of the parameters and you have to manually scan one transport and learn the others from the network_information_section (NIT).

Looking further it appears that you might be on DVB-C with CableCom? and got a welcome letter with a network_id in it. The manual network_id setting is not yet hooked up to the GUI, see #7486, which enables MythTV to find the correct NIT and realize that your signal follows the DVB SI standard.

Apr  6 13:05:13 HTPC-core mythtv-setup[12526]: E CoreContext mythdbcon.cpp:648 (exec) Original query failed, but resend with empty strings in place of NULL strings worked. #012DB Error (MSqlQuery):#012Query was:#012INSERT INTO channelscan_dtv_multiplex  (  scanid,     mplexid,            frequency,       inversion,      symbolrate,         fec,             polarity,       hp_code_rate,       lp_code_rate,    modulation,     transmission_mode,  guard_interval,  hierarchy,      mod_sys,            rolloff,                         bandwidth,          sistandard,      tuner_type   ) VALUES  ( ?,    ?,           ?,      ?,     ?,        ?,            ?,      ?,      ?,   ?,    ?, ?, ?,     ?,           ?,                        ?,         ?,     ?   );#012Bindings were:#012:BANDWIDTH="a", :FEC="none", :FREQUENCY="538000000", :GUARD_INTERVAL="auto",#012:HIERARCHY="a", :HP_CODE_RATE="auto", :INVERSION="a", :LP_CODE_RATE="auto",#012:MODULATION="qam_64", :MOD_SYS="UNDEFINED", :MPLEXID=0, :POLARITY="v",#012:ROLLOFF="0.35", :SCANID=1, :SISTANDARD=NULL, :SYMBOLRATE="6900000",#012:TRANSMISSION_MODE="a", :TUNER_TYPE=1#012Driver error was [2/1048]:#012QMYSQL3: Unable to execute statement#012Database error was:#012Column 'sistandard' cannot be null

Ohh, and the channel.conf parser is known broken at the moment, see #7701

Apr  6 12:51:58 HTPC-core mythtv-setup[12448]: I CoreContext dtvconfparser.cpp:317 (AddChannel) Imported channel:  10001 -1  on 538000000 qam_64 a auto auto a a auto a v fec: none msys: UNDEFINED rolloff: 0.35

Looking further it appears that CableCom? is only providing CI+ cards, but no CI cards, which do not work with Linux at all. Knowing some details on country/provider would help alot as especially DVB-C providers often need special handling.

comment:3 Changed 12 years ago by lars.schmohl@…

I have a local provider, all channels are unencrypted, except for Teleclub (NDS). No transponder has a NIT (except for the Teleclub transponder, which is unusable).

I have got it to work by manually scanning every transponder.

The other thing is that the internal scanner of version 0.24.2 worked correctly and the internal scanner of version 0.25 does not.

comment:4 Changed 12 years ago by dekarl@…

So if I understand correctly, the real issue is that the full scan can't tune any channels anymore due to

Tune(): Setting Frontend tuning parameters failed.
eno: Invalid argument (22)

which makes it similar to #8758...

comment:5 Changed 12 years ago by Jussi Lehtola <jussi.lehtola@…>

I am experiencing the very same issue on Fedora 17. I can scan for channels and that works properly, but the channels aren't added anywhere.

Running

$ mythtv-setup --loglevel debug

I see that the error is

2012-07-07 19:33:14.154926 E Original query failed, but resend with empty strings in place of NULL strings worked. DB Error (MSqlQuery): Query was: INSERT INTO channelscan_dtv_multiplex ( scanid, mplexid, frequency, inversion, symbolrate, fec, polarity, hp_code_rate, lp_code_rate, modulation, transmission_mode, guard_interval, hierarchy, mod_sys, rolloff, bandwidth, sistandard, tuner_type ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ); Bindings were: :BANDWIDTH="a", :FEC="none", :FREQUENCY="154000000", :GUARD_INTERVAL="auto", :HIERARCHY="a", :HP_CODE_RATE="auto", :INVERSION="a", :LP_CODE_RATE="auto", :MODULATION="qam_128", :MOD_SYS="UNDEFINED", :MPLEXID=0, :POLARITY="v", :ROLLOFF="0.35", :SCANID=2, :SISTANDARD=NULL, :SYMBOLRATE="6900000", :TRANSMISSION_MODE="a", :TUNER_TYPE=1 Driver error was [2/1048]: QMYSQL3: Unable to execute statement Database error was: Column 'sistandard' cannot be null

I have an 8-year old Terratec Cinergy dvb-c card.

comment:6 Changed 12 years ago by dekarl@…

Lets see...

Original query failed, but resend with empty strings in place of NULL strings worked.
...
Database error was: Column 'sistandard' cannot be null

While the error only means that somewhere NULL and "" are not properly handled it still hints at an issue, namely that the SDT could not be found, leading to sistandard being NULL instead of the correct "dvb".

Jussi, the OP has posted a version string that indicates his version is newer then [778d8111e]. Can you verify that you have 0.25 newer than March 23rd, too? (output of mythbackend --version)

Also knowing your country/provider would help lots to narrow down the possible issue. (maybe you need #7486)

Googling your name hints at Finland where the patch from #7486 should not be necessary based on specs. Unified Requirements of HDTV DVB-C and DVB-T2 digital receiver for Finnish market, 6.3.1:

When IRD locks to the first transmitting multiplex, the IRD shall read the NIT actual table and install the network and channels accordingly. The IRD should not scan the other remaining frequencies in the network.

The other issue is that the channels are not added after the scan. (even though they are scanned wrong they should still be added IMHO)

I suggest to make a ticket for "channel scan in <country> on DVB-C provider <provider> does not work" or similar so we can track the different networks in separate tickets.

comment:7 in reply to:  5 Changed 11 years ago by alexl@…

Replying to Jussi Lehtola <jussi.lehtola@…>:

I get the same problem on Fedora / RPM Fusion F18 with mythtv-0.26.0-8.fc18 trying to scan for ATSC channels with Hauppauge WinTV-HVR-2250 card. Here is the downstream bug I just filed:

https://bugzilla.rpmfusion.org/show_bug.cgi?id=2817

Jussi: did you have any luck with a workaround?

I am experiencing the very same issue on Fedora 17. I can scan for channels and that works properly, but the channels aren't added anywhere.

Running

$ mythtv-setup --loglevel debug

I see that the error is

2012-07-07 19:33:14.154926 E Original query failed, but resend with empty strings in place of NULL strings worked. DB Error (MSqlQuery): Query was: INSERT INTO channelscan_dtv_multiplex ( scanid, mplexid, frequency, inversion, symbolrate, fec, polarity, hp_code_rate, lp_code_rate, modulation, transmission_mode, guard_interval, hierarchy, mod_sys, rolloff, bandwidth, sistandard, tuner_type ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ); Bindings were: :BANDWIDTH="a", :FEC="none", :FREQUENCY="154000000", :GUARD_INTERVAL="auto", :HIERARCHY="a", :HP_CODE_RATE="auto", :INVERSION="a", :LP_CODE_RATE="auto", :MODULATION="qam_128", :MOD_SYS="UNDEFINED", :MPLEXID=0, :POLARITY="v", :ROLLOFF="0.35", :SCANID=2, :SISTANDARD=NULL, :SYMBOLRATE="6900000", :TRANSMISSION_MODE="a", :TUNER_TYPE=1 Driver error was [2/1048]: QMYSQL3: Unable to execute statement Database error was: Column 'sistandard' cannot be null

I have an 8-year old Terratec Cinergy dvb-c card.

I'm getting the same problem with mythtv

https://bugzilla.rpmfusion.org/show_bug.cgi?id=2817

comment:8 Changed 11 years ago by matti.laitala@…

I have mythtv-backend-0.26.0-8.fc18.x86_64 on Fedora 18 and I have to same problem as Jussi has. Country is Finland and Cable operator is DNA, 2x Terratec Cinergy dvb-c cards . Before this I have had mythtv running for years without problems, but just updated my hardware and did clean install for everything and now I am not able store scanned channels in mythtv-setup. Full scan does not work and when trying to import channels from scandvb I get the same insert problem with sistandard can not be null.

comment:9 Changed 10 years ago by jani.halinen@…

Same problem with 0.26 in Ubuntu, it'll log "Column 'sistandard' cannot be null". I tried to change the database column to not null: the error message went away but the channels don't get saved.

I also tried 0.27 and 0.28, either one will print out error messages about null columns but they also wont save the found channels.

I'm able to watch television with Kaffeine or VLC on this machine. MythTV used to work in this setup, before I had to rescan the channels. I'm located in Finland and the card is: "Twinhan Technology Co. Ltd Mantis DTV"

comment:10 Changed 10 years ago by Stuart Auchterlonie

Cc: Stuart Auchterlonie added
Milestone: unknown0.28

comment:11 Changed 10 years ago by Pfeffer.Code@…

I have the same problem on ubuntu 12.04, mythtv v0.25.2-15-g46cab93 (fixes/0.25) How to work-around this problem, until it is fixed?

Thanx!

comment:12 Changed 10 years ago by matti.laitala@…

I did multiple changes to my configuration to get it work. I tried to tune using both cards and end up removing one of the cards as it appeared to be malfunctioning (if I remember correctly SNR was significantly lower). Secondly I used old backup to restore my mythtv installation. Since that my installation has worked fine. I do not have time or nerves to try clean install again anytime soon...

comment:13 Changed 10 years ago by Pfeffer.Code@…

@matti: thank yiu for your quic reply.

It does not sound good. I moved (live now in a different city) so that my old dvb-t confiduration will not work. The error message I get is (after importig channels.conf which I generated by scan):

Jan  8 18:11:37 localhost mythtv-setup[5021]: I CoreContext dtvconfparser.cpp:308 (AddChannel) Imported channel:  16408 -1  on 746000000 qam_16 a 2/3 auto 8 8 1/4 n v fec: auto msys: UNDEFINED rolloff: 0.35
Jan  8 18:12:02 localhost mythtv-setup[5021]: E CoreContext mythdbcon.cpp:648 (exec) Original query failed, but resend with empty strings in place of NULL strings worked. #012DB Error (MSqlQuery):#012Query was:#012INSERT INTO channelscan_dtv_multiplex  (  scanid,     mplexid,            frequency,       inversion,      symbolrate,         fec,             polarity,       hp_code_rate,       lp_code_rate,    modulation,     transmission_mode,  guard_interval,  hierarchy,      mod_sys,            rolloff,                         bandwidth,          sistandard,      tuner_type   ) VALUES  ( ?,    ?,           ?,      ?,     ?,        ?,            ?,      ?,      ?,   ?,    ?, ?, ?,     ?,           ?,                        ?,         ?,     ?   );#012Bindings were:#012:BANDWIDTH="8", :FEC="auto", :FREQUENCY="586000000", :GUARD_INTERVAL="1/4",#012:HIERARCHY="n", :HP_CODE_RATE="2/3", :INVERSION="a", :LP_CODE_RATE="auto",#012:MODULATION="qam_16", :MOD_SYS="UNDEFINED", :MPLEXID=0, :POLARITY="v",#012:ROLLOFF="0.35", :SCANID=1, :SISTANDARD=NULL, :SYMBOLRATE="0",#012:TRANSMISSION_MODE="8", :TUNER_TYPE=2#012Driver error was [2/1048]:#012QMYSQL3: Unable to execute statement#012Database error was:#012Column 'sistandard' cannot be null
Jan  8 18:12:02 localhost mythtv-setup[5021]: E CoreContext mythdbcon.cpp:648 (exec) Original query failed, but resend with empty strings in place of NULL strings worked. #012DB Error (MSqlQuery):#012Query was:#012INSERT INTO channelscan_dtv_multiplex  (  scanid,     mplexid,            frequency,       inversion,      symbolrate,         fec,             polarity,       hp_code_rate,       lp_code_rate,    modulation,     transmission_mode,  guard_interval,  hierarchy,      mod_sys,            rolloff,                         bandwidth,          sistandard,      tuner_type   ) VALUES  ( ?,    ?,           ?,      ?,     ?,        ?,            ?,      ?,      ?,   ?,    ?, ?, ?,     ?,           ?,                        ?,         ?,     ?   );#012Bindings were:#012:BANDWIDTH="8", :FEC="auto", :FREQUENCY="674000000", :GUARD_INTERVAL="1/4",#012:HIERARCHY="n", :HP_CODE_RATE="1/2", :INVERSION="a", :LP_CODE_RATE="1/2",#012:MODULATION="qam_64", :MOD_SYS="UNDEFINED", :MPLEXID=0, :POLARITY="v",#012:ROLLOFF="0.35", :SCANID=1, :SISTANDARD=NULL, :SYMBOLRATE="0",#012:TRANSMISSION_MODE="8", :TUNER_TYPE=2#012Driver error was [2/1048]:#012QMYSQL3: Unable to execute statement#012Database error was:#012Column 'sistandard' cannot be null
Jan  8 18:12:02 localhost mythtv-setup[5021]: E CoreContext mythdbcon.cpp:648 (exec) Original query failed, but resend with empty strings in place of NULL strings worked. #012DB Error (MSqlQuery):#012Query was:#012INSERT INTO channelscan_dtv_multiplex  (  scanid,     mplexid,            frequency,       inversion,      symbolrate,         fec,             polarity,       hp_code_rate,       lp_code_rate,    modulation,     transmission_mode,  guard_interval,  hierarchy,      mod_sys,            rolloff,                         bandwidth,          sistandard,      tuner_type   ) VALUES  ( ?,    ?,           ?,      ?,     ?,        ?,            ?,      ?,      ?,   ?,    ?, ?, ?,     ?,           ?,                        ?,         ?,     ?   );#012Bindings were:#012:BANDWIDTH="8", :FEC="auto", :FREQUENCY="690000000", :GUARD_INTERVAL="1/4",#012:HIERARCHY="n", :HP_CODE_RATE="2/3", :INVERSION="a", :LP_CODE_RATE="auto",#012:MODULATION="qam_16", :MOD_SYS="UNDEFINED", :MPLEXID=0, :POLARITY="v",#012:ROLLOFF="0.35", :SCANID=1, :SISTANDARD=NULL, :SYMBOLRATE="0",#012:TRANSMISSION_MODE="8", :TUNER_TYPE=2#012Driver error was [2/1048]:#012QMYSQL3: Unable to execute statement#012Database error was:#012Column 'sistandard' cannot be null
Jan  8 18:12:02 localhost mythtv-setup[5021]: E CoreContext mythdbcon.cpp:648 (exec) Original query failed, but resend with empty strings in place of NULL strings worked. #012DB Error (MSqlQuery):#012Query was:#012INSERT INTO channelscan_dtv_multiplex  (  scanid,     mplexid,            frequency,       inversion,      symbolrate,         fec,             polarity,       hp_code_rate,       lp_code_rate,    modulation,     transmission_mode,  guard_interval,  hierarchy,      mod_sys,            rolloff,                         bandwidth,          sistandard,      tuner_type   ) VALUES  ( ?,    ?,           ?,      ?,     ?,        ?,            ?,      ?,      ?,   ?,    ?, ?, ?,     ?,           ?,                        ?,         ?,     ?   );#012Bindings were:#012:BANDWIDTH="8", :FEC="auto", :FREQUENCY="722000000", :GUARD_INTERVAL="1/4",#012:HIERARCHY="n", :HP_CODE_RATE="2/3", :INVERSION="a", :LP_CODE_RATE="auto",#012:MODULATION="qam_16", :MOD_SYS="UNDEFINED", :MPLEXID=0, :POLARITY="v",#012:ROLLOFF="0.35", :SCANID=1, :SISTANDARD=NULL, :SYMBOLRATE="0",#012:TRANSMISSION_MODE="8", :TUNER_TYPE=2#012Driver error was [2/1048]:#012QMYSQL3: Unable to execute statement#012Database error was:#012Column 'sistandard' cannot be null
Jan  8 18:12:02 localhost mythtv-setup[5021]: E CoreContext mythdbcon.cpp:648 (exec) Original query failed, but resend with empty strings in place of NULL strings worked. #012DB Error (MSqlQuery):#012Query was:#012INSERT INTO channelscan_dtv_multiplex  (  scanid,     mplexid,            frequency,       inversion,      symbolrate,         fec,             polarity,       hp_code_rate,       lp_code_rate,    modulation,     transmission_mode,  guard_interval,  hierarchy,      mod_sys,            rolloff,                         bandwidth,          sistandard,      tuner_type   ) VALUES  ( ?,    ?,           ?,      ?,     ?,        ?,            ?,      ?,      ?,   ?,    ?, ?, ?,     ?,           ?,                        ?,         ?,     ?   );#012Bindings were:#012:BANDWIDTH="8", :FEC="auto", :FREQUENCY="746000000", :GUARD_INTERVAL="1/4",#012:HIERARCHY="n", :HP_CODE_RATE="2/3", :INVERSION="a", :LP_CODE_RATE="auto",#012:MODULATION="qam_16", :MOD_SYS="UNDEFINED", :MPLEXID=0, :POLARITY="v",#012:ROLLOFF="0.35", :SCANID=1, :SISTANDARD=NULL, :SYMBOLRATE="0",#012:TRANSMISSION_MODE="8", :TUNER_TYPE=2#012Driver error was [2/1048]:#012QMYSQL3: Unable to execute statement#012Database error was:#012Column 'sistandard' cannot be null
Jan  8 18:12:06 localhost mythtv-setup[5021]: I CoreContext mythdbcon.cpp:422 (getStaticCon) New static DB connectionDataDirectCon
Jan  8 18:12:06 localhost mythtv-setup[5021]: I CoreContext channelscan/channelimporter.cpp:246 (DeleteUnusedTransports) ChanImport: Found 33 unused transports

Is this already fixed in the developer version? Is there any work-around?

Thanx!

Pfeffer

comment:14 Changed 10 years ago by J.Pilk@…

Your scan has identified several multiplex frequencies. What happens if you enter one or more of those with the Transport Editor and try the procedure here?

http://code.mythtv.org/trac/ticket/10217#comment:15

comment:15 Changed 10 years ago by Pfeffer.Code@…

great - that worked! I manually added a new transport (mythbackend-setup -> Channel Editor -> Edit Transports). The data for that I took from channels.conf which I generated before with scan. Most items to enter are intuitively machted to the entries in the channels.conf. Only two items I had to tryout: LP Coderate = 2nd FEC item in the channels.conf HP Coderate = 1st FEC item in the channels.conf That means they are entered in mythbacken-setup in the reverse order than they are found in channels.conf. After entering a new transport, I clicked on "Channel Scan" and selected "Full Scan (Tuned)". There I entered the same data again - and the tv channels are finnaly added. I repeated this procedure for each frequency an now I have all tv channels available in mythtv :-)

@J.Pilk: Than you very much!

Pfeffer

comment:16 Changed 10 years ago by J.Pilk@…

Great. I'm glad it worked, although I suspect that you entered more values than were actually needed. In future, if you need to rescan, try deleting all channels, but not the transports, and rescanning 'all known transports' with the 'look for linked transports' option enabled. It might work.

comment:17 Changed 8 years ago by Karl Egly

Milestone: 0.280.29

comment:18 Changed 8 years ago by Stuart Auchterlonie

Milestone: 0.2929.0

Milestone renamed

comment:19 Changed 6 years ago by Stuart Auchterlonie

Milestone: 29.029.1

comment:20 Changed 6 years ago by Stuart Auchterlonie

Milestone: 29.10.28.2

Moving remaining open tickets to 0.28.2 milestone

comment:21 Changed 6 years ago by Stuart Auchterlonie

Milestone: 0.28.229.2

Moving remaining open tickets to 29.2 milestone

comment:22 Changed 4 years ago by Klaas de Waal

Resolution: Fixed
Status: newclosed

Channel scanning has been improved a lot in the last few years so the problem mentioned in this ticket is most likely resolved and therefore this ticket is now closed. If the problem reappears then please re-open this ticket or create a new ticket.

Note: See TracTickets for help on using tickets.