Build 57 and white background

[rcrockett]

So I'm getting the "Server Error in '/gbpvr' Application." error (white background) every time I try to load up the web admin in my browser ever since I upgraded to build 57. I read in the Wiki that I sometimes have to wait 48 hours before I can use it, because of a problem in .NET. Is that my issue here?

[UncleJohnsBand]

So I'm getting the "Server Error in '/gbpvr' Application." error (white background) every time I try to load up the web admin in my browser ever since I upgraded to build 57. I read in the Wiki that I sometimes have to wait 48 hours before I can use it, because of a problem in .NET. Is that my issue here?

That can sometimes be an issue for some people......another cause can be a bad install......did you follow the instructions on the wiki....stopping the service, seleting everytghing except the DLL's listed, loading the upgrade and then restarting the service?

If this still doesn't work post the error you are getting here......make sure to access EWA from the machine hosting it so you can see the actual error and not the generic server error message you recieve when accessing EWA from a machine other than the host.

[rcrockett]

Here's the error message I'm getting:

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\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\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\gbpvr\web\App_Code\classes\ProgrammeDisplay.cs:251
gbweb.guide.Page_PreRender(Object sender, EventArgs e) in c:\Program Files\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




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

[UncleJohnsBand]

Here's the error message I'm getting:

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\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\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\gbpvr\web\App_Code\classes\ProgrammeDisplay.cs:251
gbweb.guide.Page_PreRender(Object sender, EventArgs e) in c:\Program Files\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




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

This is easy.....you are running ZapTools and you did not upgrade as the instructions indicate to do.......The HD column was added in build 55 so that build going forward need to have ZapTools upgraded so it has the new column.


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.

[rcrockett]

Thanks.

[kayak4ever]

Would it also be possible to delete the zaptools with the intent of adding the schedules direct tools? Or is there an advantage to having both? I was thiniking that I should only add the tools I need to avoid incompatibily problems.

At this point I have the SQlite error from not updating the zaptools. I am using 1.0.16 pvrx2 so I have only been adding plugins and utilities that are compatible with that version.

[UncleJohnsBand]

Would it also be possible to delete the zaptools with the intent of adding the schedules direct tools? Or is there an advantage to having both? I was thiniking that I should only add the tools I need to avoid incompatibily problems.

At this point I have the SQlite error from not updating the zaptools. I am using 1.0.16 pvrx2 so I have only been adding plugins and utilities that are compatible with that version.

Zaptools is now frozen in time.......SchedulesDirect Utilities has replaced it....same functioanlity but updated code that supports the new service.

I would just reomve the zaptools files and use the new utility after setting up the configuration.

[kayak4ever]

I am not sure if zaptools is still part of my program but I can access the website - ewa and I have uploaded the beta version of 66.
For anyone who has the same problem as me (trying to upgrade EWA when you missed upgrade 55 and get a sqlite error because it can't find column hd), you need to:
close down all of gbpvr (including the 0 process in the task manager: otherwise you may get the message that firefox\browser can't load the page possibly because of your firewall when really it is because the program isn't running)
download the latest version of zaptools (just to get rid of the error)
reboot (to get gbpvr restarted so you verify that it worked)
close down gbpvr again
download schedules direct utilities and the upgrade to EWA
restart gbpvr.

I didn't find a place to remove zaptools so I am assuming that installing schedules direct utilities must have done it
I am looking forward to trying out the guest login but I will need to wait for my family support group to help me.

Thank you