Modify

Opened 6 years ago

Last modified 20 months ago

#10553 new Bug Report - General

channelscanner can not added the found channels

Reported by: lars.schmohl@… Owned by: danielk
Priority: minor Milestone: 29.0
Component: MythTV - Channel Scanner Version: Master Head
Severity: medium Keywords:
Cc: stuarta 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@… 6 years ago.
mythtv setup channel scan

Download all attachments as: .zip

Change History (19)

Changed 6 years ago by lars.schmohl@…

mythtv setup channel scan

comment:1 Changed 6 years ago by danielk

  • Milestone changed from 0.25 to unknown

comment:2 Changed 6 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 6 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 6 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 follow-up: Changed 5 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 5 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 4 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 4 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 4 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 4 years ago by stuarta

  • Cc stuarta added
  • Milestone changed from unknown to 0.28

comment:11 Changed 4 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 4 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 4 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 4 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 4 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 4 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 20 months ago by dekarl

  • Milestone changed from 0.28 to 0.29

comment:18 Changed 20 months ago by stuarta

  • Milestone changed from 0.29 to 29.0

Milestone renamed

Add Comment

Modify Ticket

Action
as new The owner will remain danielk.
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.