Opened 10 years ago

Closed 9 years ago

#7479 closed defect (fixed)

Mythweb and Display of Favorites in Listings

Reported by: sgunther@… Owned by: stuartm
Priority: minor Milestone: 0.23
Component: Plugin - MythWeb Version: 0.22rc1
Severity: low Keywords:
Cc: Ticket locked: no

Description

In 0.22rc1 (Clean Install) the feature to toggle viewing only favorite channels "Only display favourite channels" on http://<host>/mythweb/settings/tv page causes the listings on http://<host>/mythweb/tv/list.

The database structure has changed. In precious versions favorite channels were stored in mythconverg.favorites where in 0.22 they are now stored in mythconverg.channelgroup (Associated to Favories from mythconverg.channelgroupnames)

Sample of the error;
 datetime:  2009-11-01 23:33:21 (CST)
    errornum:  256
  error type:  User Error
error string:  SQL Error: Table 'mythconverg.favorites' doesn't exist [#1146]
    filename:  /usr/share/mythtv/mythweb/classes/Database/Query/mysql.php
  error line:  83

==========================================================================

Backtrace: 

    file:  /usr/share/mythtv/mythweb/classes/Database/Query/mysql.php
    line:  83
   class:  
function:  trigger_error
    type:  
    args:  Array
(
    [0] => SQL Error: Table 'mythconverg.favorites' doesn't exist [#1146]
    [1] => 256
)

Attachments (1)

mythweb_favorites.diff (829 bytes) - added by Robin Hill <myth@…> 10 years ago.
Fix for favorites in mythweb

Download all attachments as: .zip

Change History (5)

Changed 10 years ago by Robin Hill <myth@…>

Attachment: mythweb_favorites.diff added

Fix for favorites in mythweb

comment:1 Changed 10 years ago by Robin Hill <myth@…>

Attached patch changes to use 'Favorites' channel group instead of favorites table.

comment:2 Changed 9 years ago by stuartm

Milestone: unknown0.23
Owner: changed from Rob Smith to stuartm
Status: newaccepted

comment:3 Changed 9 years ago by stuartm

(In [24302]) Fix display of favourite channels in mythweb. Patch from Robin Hill. Refs #7479

comment:4 Changed 9 years ago by stuartm

Resolution: fixed
Status: acceptedclosed

(In [24303]) Backport [24302] to 0.23-fixes. Fix display of favourite channels in mythweb. Patch from Robin Hill. Fixes #7479

Note: See TracTickets for help on using tickets.