Uploaded image for project: 'MediaPortal 1'
  1. MediaPortal 1
  2. MP1-3039

TV MiniGuide dosen't load prgrams when the channel set is very large

    XMLWordPrintable

Details

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Major Major
    • 1.3.0 Alpha
    • 1.2.0 Beta
    • None
    • None
    • Operating System: Windows XP
      Platform: Intel

    Description

      The Tv MiniGuide loads programs (now and next) from the tv database with a query constructed in TvBusinessLayer. The query is a series of select statements in a union to form the result set. On Windows there are several limitations that may prevent the opening of a number of large table simultaneously (see http://dev.mysql.com/doc/refman/5.0/en/limits-windows.html). In the case of the select/union statement for TvMiniGuide each select statement opens the program table; the number of select statements in my tests exceeded 750 (All Channels program group, US directv). A SQL error is presented as the result of the query execution and the result set returned to the Tv MiniGuide is empty resulting in the Tv MiniGuide being filled with "No available information" messages.

      h4. Steps to Reproduce
      Set up MP with more than 700 channels and bring up the Tv MiniGuide. No data is displayed.

      Attachments

        Activity

          People

            ajp8164 Andy (Inactive)
            ajp8164 Andy (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: