Mythweb and Display of Favorites in Listings

[sgunther@…]

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
)

[Robin Hill <myth@…>]

Fix for favorites in mythweb

[Robin Hill <myth@…>]

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

[stuartm]

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

[stuartm]

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