Enhanced Web Admin (EWA) Build 74 Released

[ACTCMS]

I use EWA on local machine and over LAN. I have two systems - Live and Test. Both had the same versions of everything on them (including EWA 1.74).

I installed 1.2.9 on the test system and EWA was fine.

When I installed 1.2.9 on the live system I got similar problems to pbb - I checked the firewall and stuff but nothing wrong there - at one point I got an info screen which seemed to suggest a problem with the Ajax lib - so I reinstalled ver 1.74 from my original download, following the install instructions and that fixed it.

Unfortunately, I wasn't able to extract any useful debug info...

[UncleJohnsBand]

I use EWA on local machine and over LAN. I have two systems - Live and Test. Both had the same versions of everything on them (including EWA 1.74).

I installed 1.2.9 on the test system and EWA was fine.

When I installed 1.2.9 on the live system I got similar problems to pbb - I checked the firewall and stuff but nothing wrong there - at one point I got an info screen which seemed to suggest a problem with the Ajax lib - so I reinstalled ver 1.74 from my original download, following the install instructions and that fixed it.

Unfortunately, I wasn't able to extract any useful debug info...

It could be an installer issue....but I am not sure...there were a few (non-ewa) issues with the installer that sub was restling with. I normally advise anyone having a problem with ewa to download the latest release and follow the install instructions on the wiki.

To utilize a class for Ajax calls you have to use a web service that calls the class containing the functions you want Ajax to use.

You can see the web service and the methods currently used by going to the following url:

http://localhost:7647/gbpvr/ajaxservice2.asmx (this is for the CSS based screens. ajaxservice.asmx is for the table based screens)

You should get a page that show 3 methods at the top of the page. If you are running on the server itself you can click on the method name and actually see the XML that is returned by the web service....otherwise you will get a page telling you that you need to be on the local machine to execute the method.

However....you should not be seeing any errors.

[trevparks]

Access it on the gbpvr machine that it is running on and post a screen shot of the resulting error. My gut is that you either have an older version of EWA or a bad install of it.

I installed 1.2.9 with no problems but got the attached screenshot. I then went back to 1.1.5 and everything worked fine. I then installed EWA, build 74, and it didn't work. Reinstalled the files from 1.1.5 EWA and all works again.

[ACTCMS]

It could be an installer issue....but I am not sure...there were a few (non-ewa) issues with the installer that sub was restling with. I normally advise anyone having a problem with ewa to download the latest release and follow the install instructions on the wiki.

To utilize a class for Ajax calls you have to use a web service that calls the class containing the functions you want Ajax to use.

You can see the web service and the methods currently used by going to the following url:

http://localhost:7647/gbpvr/ajaxservice2.asmx (this is for the CSS based screens. ajaxservice.asmx is for the table based screens)

You should get a page that show 3 methods at the top of the page. If you are running on the server itself you can click on the method name and actually see the XML that is returned by the web service....otherwise you will get a page telling you that you need to be on the local machine to execute the method.

However....you should not be seeing any errors.

Having noticed that there were a few MSI related issues with 1.2.9, I assumed that was the source of my problem (especially as it worked on the test system) - so I just wanted to share what was a very easy solution for me in the hope that it might work for others...

However I had a look at ...ajaxservice2.asmx (but I know very little about the detail of web services) - maybe it's time I did... Thanks for that

[pbb]

Have you upgraded to the new 1.2.9 release of GBPVR?

Yeah, that's actually the only reason I upgraded to build 74 of EWA.

[trevparks]

I installed 1.2.9 with no problems but got the attached screenshot. I then went back to 1.1.5 and everything worked fine. I then installed EWA, build 74, and it didn't work. Reinstalled the files from 1.1.5 EWA and all works again.

I uninstalled first, and then deleted the gbpvr directory (which was lowercase), then installed 1.2.9 (now it is uppercase GBPVR) and it works now.

[UncleJohnsBand]

I installed 1.2.9 with no problems but got the attached screenshot. I then went back to 1.1.5 and everything worked fine. I then installed EWA, build 74, and it didn't work. Reinstalled the files from 1.1.5 EWA and all works again.

You need to log on the local machine and run EWA....you will get an actual error screen that will provide info on what is occuring.

[UncleJohnsBand]

I uninstalled first, and then deleted the gbpvr directory (which was lowercase), then installed 1.2.9 (now it is uppercase GBPVR) and it works now.

Ok...I figured it was some sort of install thing. Glad it is working....

[DrDDT]

Since 1.2.9 search is no longer working for me.
I re-installed build 74, but the error is still there:

Code:

Server Error in '/gbpvr' Application.
Undefined function 'datetime' in expression.
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.OleDb.OleDbException: Undefined function 'datetime' in expression.

Source Error:

Line 632:            aCommand.Connection = aConnection;
Line 633:            // create the datareader object to connect to table and execute the query
Line 634:            aReader = aCommand.ExecuteReader();
Line 635:            return aConnection;
Line 636:        }


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

Stack Trace:

[OleDbException (0x80040e14): Undefined function 'datetime' in expression.]
   System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) +177
   System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) +194
   System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) +56
   System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +105
   System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior) +91
   System.Data.OleDb.OleDbCommand.ExecuteDbDataReader(CommandBehavior behavior) +4
   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:634
   gbweb.classes.SearchEngine.processQuery(String chnl_cmd, String chnl_join, String genre_cmd, String genre_join, String& pgm_cmd, String& where_cmd) in c:\Program Files\devnz\gbpvr\web\App_Code\classes\SearchEngine.cs:493
   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:223
   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:627
   gbweb.SearchResults.SearchResults_PreRender(Object sender, EventArgs e) in c:\Program Files\devnz\gbpvr\web\SearchResults.aspx.cs:186
   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) +5676


Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433

[UncleJohnsBand]

Since 1.2.9 search is no longer working for me.
I re-installed build 74, but the error is still there:

Code:

Server Error in '/gbpvr' Application.
Undefined function 'datetime' in expression.
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.OleDb.OleDbException: Undefined function 'datetime' in expression.

Source Error:

Line 632:            aCommand.Connection = aConnection;
Line 633:            // create the datareader object to connect to table and execute the query
Line 634:            aReader = aCommand.ExecuteReader();
Line 635:            return aConnection;
Line 636:        }


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

Stack Trace:

[OleDbException (0x80040e14): Undefined function 'datetime' in expression.]
   System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) +177
   System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) +194
   System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) +56
   System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +105
   System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior) +91
   System.Data.OleDb.OleDbCommand.ExecuteDbDataReader(CommandBehavior behavior) +4
   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:634
   gbweb.classes.SearchEngine.processQuery(String chnl_cmd, String chnl_join, String genre_cmd, String genre_join, String& pgm_cmd, String& where_cmd) in c:\Program Files\devnz\gbpvr\web\App_Code\classes\SearchEngine.cs:493
   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:223
   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:627
   gbweb.SearchResults.SearchResults_PreRender(Object sender, EventArgs e) in c:\Program Files\devnz\gbpvr\web\SearchResults.aspx.cs:186
   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) +5676


Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433

This is because the new/improved search only works with the SQLite DB. You will need to run the upgrade to convert your current Access based database to use the newer (18 months at least) SQLite database.

Upgrade is easy....just run the ChangeDatbase.exe file in the gbvr directory.