Ian Campbell
2016-05-23 08:55:39 UTC
My mythfilldatabase runs are complaining:
2016-05-23 06:35:03.532635 E DB Error (programrating insert):
Query was:
INSERT INTO programrating ( chanid, starttime, system, rating) VALUES (?, ?, ?, ?)
Bindings were:
:CHANID=8173, :RATING="TVG", :START=2016-05-26T15:30:00Z,
:SYS="USA Parental Rating"
Driver error was [2/1062]:
QMYSQL3: Unable to execute statement
Database error was:
Duplicate entry '8173-2016-05-26 15:30:00-USA Pare-TVG' for key 'chanid'
chaid=8173 is "BBC ONE East W" AKA xmltvid 24321 and indeed I see there
are two identical <rating> tags in the XML (and two identical
<presenter> FWIW):
<programme start="20160526153000 +0000" stop="20160526161500 +0000" channel="24321">
<title>Flog It!</title>
<sub-title>Sandon Hall 42</sub-title>
<desc>"Flog It!" [...].</desc>
<credits>
<presenter>Paul Martin</presenter>
<presenter>Paul Martin</presenter>
</credits>
<category>Collectibles</category>
<category>Auction</category>
<category>Arts/crafts</category>
<category>Series</category>
<category>series</category>
<episode-num system="xmltv_ns">13.44.</episode-num>
<episode-num system="dd_progid">EP012584290968</episode-num>
<audio>
<stereo>stereo</stereo>
</audio>
<previously-shown start="20160526000000 +0100" />
<new />
<subtitles type="teletext" />
<rating system="USA Parental Rating">
<value>TVG</value>
</rating>
<rating system="USA Parental Rating">
<value>TVG</value>
</rating>
</programme>
which is reflected in the JSON
[
{
"originalAirDate" : "2016-05-26",
"titles" : [
{
"title120" : "Flog It!"
}
],
"contentRating" : [
{
"code" : "TVG",
"body" : "USA Parental Rating"
},
{
"body" : "USA Parental Rating",
"code" : "TVG"
}
],
"programID" : "EP012584290968"
I'm unsure if this is expected/allowed at any level and therefore who
(mythtv, xmltv, sd) is expected to consolidate/tolerate them so I'll st
art by reporting here.
Ian.
2016-05-23 06:35:03.532635 E DB Error (programrating insert):
Query was:
INSERT INTO programrating ( chanid, starttime, system, rating) VALUES (?, ?, ?, ?)
Bindings were:
:CHANID=8173, :RATING="TVG", :START=2016-05-26T15:30:00Z,
:SYS="USA Parental Rating"
Driver error was [2/1062]:
QMYSQL3: Unable to execute statement
Database error was:
Duplicate entry '8173-2016-05-26 15:30:00-USA Pare-TVG' for key 'chanid'
chaid=8173 is "BBC ONE East W" AKA xmltvid 24321 and indeed I see there
are two identical <rating> tags in the XML (and two identical
<presenter> FWIW):
<programme start="20160526153000 +0000" stop="20160526161500 +0000" channel="24321">
<title>Flog It!</title>
<sub-title>Sandon Hall 42</sub-title>
<desc>"Flog It!" [...].</desc>
<credits>
<presenter>Paul Martin</presenter>
<presenter>Paul Martin</presenter>
</credits>
<category>Collectibles</category>
<category>Auction</category>
<category>Arts/crafts</category>
<category>Series</category>
<category>series</category>
<episode-num system="xmltv_ns">13.44.</episode-num>
<episode-num system="dd_progid">EP012584290968</episode-num>
<audio>
<stereo>stereo</stereo>
</audio>
<previously-shown start="20160526000000 +0100" />
<new />
<subtitles type="teletext" />
<rating system="USA Parental Rating">
<value>TVG</value>
</rating>
<rating system="USA Parental Rating">
<value>TVG</value>
</rating>
</programme>
which is reflected in the JSON
[
{
"originalAirDate" : "2016-05-26",
"titles" : [
{
"title120" : "Flog It!"
}
],
"contentRating" : [
{
"code" : "TVG",
"body" : "USA Parental Rating"
},
{
"body" : "USA Parental Rating",
"code" : "TVG"
}
],
"programID" : "EP012584290968"
I'm unsure if this is expected/allowed at any level and therefore who
(mythtv, xmltv, sd) is expected to consolidate/tolerate them so I'll st
art by reporting here.
Ian.