Opened 12 years ago
Closed 4 years ago
#10553 closed Bug Report - General (Fixed)
channelscanner can not added the found channels
Reported by: | 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)
Change History (23)
Changed 12 years ago by
Attachment: | mythtv-setup.log added |
---|
comment:1 Changed 12 years ago by
Milestone: | 0.25 → unknown |
---|
comment:2 Changed 12 years ago by
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
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
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: 7 Changed 12 years ago by
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
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 Changed 11 years ago by
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
comment:8 Changed 11 years ago by
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
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
Cc: | Stuart Auchterlonie added |
---|---|
Milestone: | unknown → 0.28 |
comment:11 Changed 10 years ago by
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
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
@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
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?
comment:15 Changed 10 years ago by
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
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
Milestone: | 0.28 → 0.29 |
---|
comment:19 Changed 6 years ago by
Milestone: | 29.0 → 29.1 |
---|
comment:20 Changed 6 years ago by
Milestone: | 29.1 → 0.28.2 |
---|
Moving remaining open tickets to 0.28.2 milestone
comment:21 Changed 6 years ago by
Milestone: | 0.28.2 → 29.2 |
---|
Moving remaining open tickets to 29.2 milestone
comment:22 Changed 4 years ago by
Resolution: | → Fixed |
---|---|
Status: | new → closed |
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.
mythtv setup channel scan