Enhanced Web Admin (EWA) Build 72 Released

[UncleJohnsBand]

Build 72 of EWA has been released. You can download it here or on the wiki.

This upgrade requires GBPVR 99.12 or higher to work.

Date: 2008-01-20 Build Number: 72 Changes:

• UncleJohnsBand: Correct issue with theme not always displaying when accessing the login screen.
  
• UncleJohnsBand: Added select All and None options to Manage Recordings filter.
  
• UncleJohnsBand: Search processing has been totally re-written to improve performance and handle large EPG's.
  
• UncleJohnsBand: Changes only in CSS based pages:
  • Add MP3 and WMA music tags as hover text in Music Library.
  • Updated Guide grid lines for the Blue and Default themes so they are visible.
  • Updated Guide to correctly place programmes when the first programme for the time period starts later that the startime of the time period.
  • Updated Manage Recordings and Search Result so that the programme description area scrolls if necessary.
  • Correct treeview display issue that was causing a display offset in entries that had more than one recording under them.
  • Correct treeview problem that caused shows to not be grouped together when sorting by title.
  • Correct treeview not displaying the correct channel name for programmes.
  
  
• UncleJohnsBand: CSS General Notes:
  • CSS Note: To access CSS based screens use guide2.aspx as your start page.
  • CSS Note: CSS screens are coded in strict standards mode. This will make future updates easier and provides the best cross-browser (Firefox / IE) compatibility. However, this also means that the CSS sceens will only be fully supported by IE 7 and FireFox. Some screens will not work correctly in IE6. Sorry.
  • CSS Note: CSS screens are optimized for screens with 1024x768 resolution or higher. Lower resolution will just cause more scrolling on some screens.
  • CSS Note: Please post feedback/bugs in the EWA CSS Guide sticky thread located in the EWA support forum.

[ecorbin]

As always, thanks, UJB, for the new version of EWA. And I know it's a few versions old by now, but I LOVE the auto-record functionality. It's great for finding shows on various topics. Thanks!

I'm getting an error message in v72. When I choose one of my saved searches, and click Submit, I get the following error. The other saved searches work fine.

Code:

SQLite error
ambiguous column name: CHANNEL.oid
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SQLite.SQLiteException: SQLite error
ambiguous column name: CHANNEL.oid

Source Error:


Line 636:            aCommand.Connection = aConnection;
Line 637:            // create the datareader object to connect to table and execute the query
Line 638:            aReader = aCommand.ExecuteReader();
Line 639:            return aConnection;
Line 640:        }


Source File: c:\Program Files\devnz\gbpvr\web\App_Code\classes\SearchEngine.cs    Line: 638


Stack Trace:

[SQLiteException (0x80004005): SQLite error
ambiguous column name: CHANNEL.oid]
   System.Data.SQLite.SQLite3.Prepare(String strSql, SQLiteStatement previous, String& strRemain) +316
   System.Data.SQLite.SQLiteCommand.BuildNextCommand() +231
   System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index) +14
   System.Data.SQLite.SQLiteDataReader.NextResult() +209
   System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave) +69
   System.Data.SQLite.SQLiteCommand.ExecuteDbDataReader(CommandBehavior behavior) +35
   System.Data.Common.DbCommand.ExecuteReader() +9
   gbweb.classes.SearchEngine.executeQuery(String pgm_cmd, String where_cmd) in c:\Program Files\devnz\gbpvr\web\App_Code\classes\SearchEngine.cs:638
   gbweb.classes.SearchEngine.SelectProgrammes(Array channels, Array selectedGenre, Boolean checkTitle, Boolean checkDesc, Boolean checkSubtitle, Boolean matchTitle, Boolean matchDesc, Boolean matchSubtitle, Boolean matchUniqueID, String searchFor, Boolean caseSensitive, Schedule scheduleHelper, Int32 programmeMinLength, Int32 programmeMaxLength) in c:\Program Files\devnz\gbpvr\web\App_Code\classes\SearchEngine.cs:346
   gbweb.SearchResults.SearchForEpisode(Boolean checkTitle, Boolean checkDesc, Boolean checkSubtitle, Boolean matchTitle, Boolean matchDesc, Boolean matchSubtitle, Boolean matchUniqueID, String searchFor, Boolean caseSensitive, Int32 minLength, Int32 maxLength, String[] channels, String[] selectedGenre, String startdate, String starttime, String enddate, String endtime) in c:\Program Files\devnz\gbpvr\web\SearchResults.aspx.cs:628
   gbweb.SearchResults.SearchResults_PreRender(Object sender, EventArgs e) in c:\Program Files\devnz\gbpvr\web\SearchResults.aspx.cs:187
   System.EventHandler.Invoke(Object sender, EventArgs e) +0
   System.Web.UI.Control.OnPreRender(EventArgs e) +80
   System.Web.UI.Control.PreRenderRecursiveInternal() +88
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5731

This saved search is set as an auto-record, and I think that part is working. I just get the error above when trying to view it. Under previous versions, it did work, but I'm not sure exactly when I last tried it. I did some trial-and-error, and I'm not finding an exact pattern as to when it occurs. The error message seems to point to channels, so I've played with selecting a channel or not, but the results don't seem consistent.

This is not urgent for me; just thought you'd want to check it out when you are able.

I'll send you a PM with the URL, username, and password for my EWA, if that'll help.

THANKS!

[UncleJohnsBand]

As always, thanks, UJB, for the new version of EWA. And I know it's a few versions old by now, but I LOVE the auto-record functionality. It's great for finding shows on various topics. Thanks!

I'm getting an error message in v72. When I choose one of my saved searches, and click Submit, I get the following error. The other saved searches work fine.

Code:

SQLite error
ambiguous column name: CHANNEL.oid
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SQLite.SQLiteException: SQLite error
ambiguous column name: CHANNEL.oid

Source Error:


Line 636:            aCommand.Connection = aConnection;
Line 637:            // create the datareader object to connect to table and execute the query
Line 638:            aReader = aCommand.ExecuteReader();
Line 639:            return aConnection;
Line 640:        }


Source File: c:\Program Files\devnz\gbpvr\web\App_Code\classes\SearchEngine.cs    Line: 638


Stack Trace:

[SQLiteException (0x80004005): SQLite error
ambiguous column name: CHANNEL.oid]
   System.Data.SQLite.SQLite3.Prepare(String strSql, SQLiteStatement previous, String& strRemain) +316
   System.Data.SQLite.SQLiteCommand.BuildNextCommand() +231
   System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index) +14
   System.Data.SQLite.SQLiteDataReader.NextResult() +209
   System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave) +69
   System.Data.SQLite.SQLiteCommand.ExecuteDbDataReader(CommandBehavior behavior) +35
   System.Data.Common.DbCommand.ExecuteReader() +9
   gbweb.classes.SearchEngine.executeQuery(String pgm_cmd, String where_cmd) in c:\Program Files\devnz\gbpvr\web\App_Code\classes\SearchEngine.cs:638
   gbweb.classes.SearchEngine.SelectProgrammes(Array channels, Array selectedGenre, Boolean checkTitle, Boolean checkDesc, Boolean checkSubtitle, Boolean matchTitle, Boolean matchDesc, Boolean matchSubtitle, Boolean matchUniqueID, String searchFor, Boolean caseSensitive, Schedule scheduleHelper, Int32 programmeMinLength, Int32 programmeMaxLength) in c:\Program Files\devnz\gbpvr\web\App_Code\classes\SearchEngine.cs:346
   gbweb.SearchResults.SearchForEpisode(Boolean checkTitle, Boolean checkDesc, Boolean checkSubtitle, Boolean matchTitle, Boolean matchDesc, Boolean matchSubtitle, Boolean matchUniqueID, String searchFor, Boolean caseSensitive, Int32 minLength, Int32 maxLength, String[] channels, String[] selectedGenre, String startdate, String starttime, String enddate, String endtime) in c:\Program Files\devnz\gbpvr\web\SearchResults.aspx.cs:628
   gbweb.SearchResults.SearchResults_PreRender(Object sender, EventArgs e) in c:\Program Files\devnz\gbpvr\web\SearchResults.aspx.cs:187
   System.EventHandler.Invoke(Object sender, EventArgs e) +0
   System.Web.UI.Control.OnPreRender(EventArgs e) +80
   System.Web.UI.Control.PreRenderRecursiveInternal() +88
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5731

This saved search is set as an auto-record, and I think that part is working. I just get the error above when trying to view it. Under previous versions, it did work, but I'm not sure exactly when I last tried it. I did some trial-and-error, and I'm not finding an exact pattern as to when it occurs. The error message seems to point to channels, so I've played with selecting a channel or not, but the results don't seem consistent.

This is not urgent for me; just thought you'd want to check it out when you are able.

I'll send you a PM with the URL, username, and password for my EWA, if that'll help.

THANKS!

This is a bug. :eek:

If you opt to search more than just one option for a search string (Title, Sub-Title, Description) the error occurs.

Attached is a single file patch that corrects the issue.

Thanks for reporting the bug!