Enhanced Web Admin (EWA) Build 57 Released

[UncleJohnsBand]

Build 57 of EWA has been released. You can download it in the EWA Support Forum build 57 Release Thread.

ZapTools Users if you have not yet upgraded to latest Version of ZapTools you will need to do so to use any version of EWA higher than build 54.
You can download from wiki....read the upgrade instructions.

Date: 2007-02-17 Build Number: 57 Changes:

• UncleJohnsBand: Update RSS.aspx page to support FireFox and IE RSS feed detection.
  • Accessing http://yourlocation:yourport/gbpvr/public/rss.aspx will provide links to acesss the feeds as well as auto detection of the feed URL's for Firefox and IE.
  
  
• UncleJohnsBand: Add support for empty RSS feeds so that RSS Readers do not have an issue.

Build 56 RSS Notes:
[*]UncleJohnsBand: Added RSS Feed functionality.

• GenRss.exe in web\bin directory can be run as a batch program. This will create RSS feeds for the different recorded/scheduled programmes. Feed xml files are stored in web\public folder.
  
• GenRss.exe has a config file with parameters for setting link location (LAN/WAN) as well as a filter and specify RSS feed file location.
  
• On-demand RSS feed is available from
  Code:

  http://yourmachine:yourport/gbpvr/public/rss.aspx?filter=

• Filter param options for above URL include:

• completed
  
• pending
  
• in-progress
  
• conflict
  
• failed
  
• season
  
• deleted

[dljones8053]

I installed Build 57 and got this screen when I tried to open the Web Interface any ideas?? Looks to me it is looking for a column in SQL but cannot find it.

SQLite error
no such column: hd
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
no such column: hd

Source Error:


Line 122: aCommand.CommandText = "select hd from Schedule where scheduleid='" + UniqueProgrammeIdentifier + "'";
Line 123: aCommand.Connection = zapConnection;
Line 124: DbDataReader aReader = aCommand.ExecuteReader();
Line 125:
Line 126: // read from the database


Source File: c:\Program Files (x86)\devnz\gbpvr\web\App_Code\classes\ZapTools.cs Line: 124

Stack Trace:


[SQLiteException (0x80004005): SQLite error
no such column: hd]
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.ZapTools.IsHD(String UniqueProgrammeIdentifier) in c:\Program Files (x86)\devnz\gbpvr\web\App_Code\classes\ZapTools.cs:124
gbweb.classes.ProgrammeDisplay.FillProgrammeDisplay(HttpServerUtility Server, TableCell colShow, Programme programme, ScheduledRecording scheduledRecording, Boolean highlightRecordedShows) in c:\Program Files (x86)\devnz\gbpvr\web\App_Code\classes\ProgrammeDisplay.cs:251
gbweb.guide.Page_PreRender(Object sender, EventArgs e) in c:\Program Files (x86)\devnz\gbpvr\web\Guide.aspx.cs:365
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +13
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +45
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

[dljones8053]

Forget my last post I figured it out I had ZAPTool installed and once I ran the ZAPUpgrade all is working now.. Sorry for the extra post that is not needed maybe it will help others never know.

Thanks
Daryl