Mailing List Archive: MythTV: Commits

Ticket #7467: Watch recordings screen will not load if bookmark column contains "invalid" value

Index | Next | Previous | View Threaded

mythtv at cvs

Oct 31, 2009, 12:44 PM

Post #1 of 5 (158 views)
Permalink

Ticket #7467: Watch recordings screen will not load if bookmark column contains "invalid" value

#7467: Watch recordings screen will not load if bookmark column contains "invalid"
value
-------------------------------------------+--------------------------------
Reporter: skd5aner <skd5aner@…> | Owner: ijr
Type: defect | Status: new
Priority: minor | Milestone: unknown
Component: MythTV - General | Version: 0.22rc1
Severity: medium | Mlocked: 0
-------------------------------------------+--------------------------------
Recently upgraded to .22-fixes (r22670) from .21-fixes. It may also be of
value to let you know that I've been using myth since ~.13 or .14 and the
database has been updated from every version since then.

When I launched watched recordings for the first time, I saw no videos.
However, the filters list showed 341 videos. In the console, I received a
message that said: "sortedlist is empty".

After searching the archives, I came across this: http://www.gossamer-
threads.com/lists/mythtv/dev/366940?search_string=sortedlist%20is%20empty;#366940
- it appears they had the same problem.

Going into the database, I had 1 recording (the oldest and first record)
from 2005 where the bookmark value was set to 127. I manually changed it
to 1, and then my watched recording screen loaded as expected.

This can be easily replicated, and wagnerrp in IRC was able to replicate
it as well by just changing one recording to have a bookmark value of 127.

First off, no clue how/why that would have received a value of 127. I do
not have any custom patches or 3'rd party components. I guess there are
really 2 problems, 1) How/Why did it set the value to 127 and 2) if there
is an "invalid" entry, that probably shouldn't prevent the loading of the
watch recordings list.

If there's any other data I can provide to help diagnose/troubleshoot let
me know.

--
Ticket URL: <http://svn.mythtv.org/trac/ticket/7467>
MythTV <http://www.mythtv.org/>
MythTV
_______________________________________________
mythtv-commits mailing list
mythtv-commits[at]mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-commits

mythtv at cvs

Oct 31, 2009, 12:49 PM

Post #2 of 5 (153 views)
Permalink

Re: Ticket #7467: Watch recordings screen will not load if bookmark column contains "invalid" value [In reply to]

mythtv at cvs

Nov 2, 2009, 10:19 PM

Post #3 of 5 (128 views)
Permalink

Re: Ticket #7467: Watch recordings screen will not load if bookmark column contains "invalid" value [In reply to]

#7467: Watch recordings screen will not load if bookmark column contains "invalid"
value
-------------------------------------------+--------------------------------
Reporter: skd5aner <skd5aner@…> | Owner: ijr
Type: defect | Status: closed
Priority: minor | Milestone: unknown
Component: MythTV - General | Version: 0.22rc1
Severity: medium | Resolution: wontfix
Mlocked: 0 |
-------------------------------------------+--------------------------------
Changes (by mdean):

* status: new => closed
* resolution: => wontfix

Comment:

This issue is due to a bug in Qt4 that causes QSqlQuery::next() to fail on
a record containing a TINYINT(1) field where the column value is less than
-9 or greater than 99.

After discussion in IRC, we have decided not to work around the Qt bug in
MythTV at this time. If a lot more users than we expect experience this
issue, we will consider adding a workaround.

The only users who could possibly be affected by this issue (ignoring the
possibility of users manually editing DB data) are users who upgraded to
trunk MythTV between [9270] (Mar 6, 2006 05:30:05 AM) and [11016] (Sep 2,
2006 08:59:13 AM) and who still have recordings more than 3 years and 2
months old. Further, most of those users no longer have the invalid data
in their databases. The invalid data will only exist for users who:

* Upgraded to trunk between [9270] and [11016] (both changes during the
0.19 to 0.20 development cycle
* Had one or more recordings with bookmarks set at the time
* Still have one or more of those recordings that had bookmarks
* Have never changed the bookmark on the recording(s)

Any users who experience the issue may fix their data by running:
{{{
mysql -umythtv -p mythconverg -e "UPDATE recorded SET bookmark = 1 WHERE
bookmark != 0;"
}}}
Please feel free to mention to me in IRC (sphery) or send a message to the
list if you are affected by this issue.

Thanks to Matt S., Brad Templeton, and Kevin Khupal for the identifying
the invalid data that tripped the Qt bug, and to Matt S. for reporting the
issue so we could fully understand what's happening.

(Note for me: Likely workaround would be to modify all queries in
0.22-fixes that access the bookmark field to use "bookmark + 0" rather
than "bookmark" to retrieve the field contents and add an appropriate
comment explaining the hack; then add a DB update to trunk to "UPDATE
recorded SET bookmark = 1 WHERE bookmark != 0;" so that the
workaround/hack is not necessary in trunk going forward.)

--
Ticket URL: <http://svn.mythtv.org/trac/ticket/7467#comment:2>
MythTV <http://www.mythtv.org/>
MythTV
_______________________________________________
mythtv-commits mailing list
mythtv-commits[at]mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-commits

mythtv at cvs

Nov 7, 2009, 3:39 PM

Post #4 of 5 (96 views)
Permalink

Re: Ticket #7467: Watch recordings screen will not load if bookmark column contains "invalid" value [In reply to]

mythtv at cvs

Nov 12, 2009, 9:15 PM

Post #5 of 5 (71 views)
Permalink

Re: Ticket #7467: Watch recordings screen will not load if bookmark column contains "invalid" value [In reply to]

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact lists@gossamer-threads.com