NextPVR Forums
  • ______
  • Home
  • New Posts
  • Wiki
  • Members
  • Help
  • Search
  • Register
  • Login
  • Home
  • Wiki
  • Members
  • Help
  • Search
NextPVR Forums Public NextPVR Other Clients Old Stuff (legacy) NextPVR Enhanced Web Admin (NEWA) v
« Previous 1 … 26 27 28 29 30 … 47 Next »
EWA throwing a data mismatch error

 
  • 0 Vote(s) - 0 Average
EWA throwing a data mismatch error
Guy
Offline

Junior Member

Posts: 25
Threads: 7
Joined: Mar 2005
#1
2008-04-19, 11:30 PM
Hi there,

I've just updated to latest version of gbpvr and EWA has stopped working...not sure what to do next...any help would be much appreciated.

The problem is that when i login on the local machine using

http://localhost:7647/gbpvr/Manage.aspx

I get the following error thrown:

Quote:Data type mismatch in criteria 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: Data type mismatch in criteria expression.

Source Error:


Line 126: aCommand.Connection = aConnection;
Line 127:
Line 128: DbDataReader aReader = aCommand.ExecuteReader();
Line 129: if (aReader.Read())
Line 130: {


Source File: c:\Program Files\devnz\gbpvr\web\App_Code\classes\Schedule.cs Line: 128

Stack Trace:


[OleDbException (0x80040e07): Data type mismatch in criteria 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
GBPVRSchedule.Schedule.getSeasonDayMask(ScheduledRecording scheduledRecording) in c:\Program Files\devnz\gbpvr\web\App_Code\classes\Schedule.cs:128
GBPVRSchedule.Schedule.getSeasonDayString(ScheduledRecording scheduledRecording) in c:\Program Files\devnz\gbpvr\web\App_Code\classes\Schedule.cs:149
gbweb.Manage.Page_Load(Object sender, EventArgs e) in c:\Program Files\devnz\gbpvr\web\Manage.aspx.cs:441
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +13
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +43
System.Web.UI.Control.OnLoad(EventArgs e) +80
System.Web.UI.Control.LoadRecursive() +49
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3750



When i try to login remotely (e.g. to login.aspx, then the login page appears but it tells me invalid username and password). Although it's worth noting, i haven't been able to remotely login to EWA for some time, as i always get a username / password invalid message - this hasn't bothered me as, up utnil now, I haven't needed remote login....but i did the upgrad in the hope that new version would fix my problem...

Anyway, any help much would be hugely appreciated,

thanks,

guy
UncleJohnsBand
Offline

Posting Freak

U.S.A.
Posts: 5,643
Threads: 258
Joined: Feb 2005
#2
2008-04-20, 12:54 PM
What version of EWA were you previously using?
Intel Core i7 @ 4.00GHz Skylake 14nm
ASUSTeK COMPUTER INC. Z170-DELUXE
Windows 10 Pro x64
PVR Software: NPVR 5.1.1
SiliconDust HDHomeRun HDHR5-4US Connect Quatro 4 Channel Tuner
Roku Ultra
2 PCH A-100's
UncleJohnsBand
Offline

Posting Freak

U.S.A.
Posts: 5,643
Threads: 258
Joined: Feb 2005
#3
2008-04-20, 01:04 PM
Actually.....I think the problem is you have not yet converted to SQLite....try converting you GBPVR database to SQLite and see if that fixes it. You just need to run the ChangeDatabase.exe that is in the GBPVR directory.
Intel Core i7 @ 4.00GHz Skylake 14nm
ASUSTeK COMPUTER INC. Z170-DELUXE
Windows 10 Pro x64
PVR Software: NPVR 5.1.1
SiliconDust HDHomeRun HDHR5-4US Connect Quatro 4 Channel Tuner
Roku Ultra
2 PCH A-100's
Guy
Offline

Junior Member

Posts: 25
Threads: 7
Joined: Mar 2005
#4
2008-04-20, 10:22 PM
Many thanks - this seems to have done the trick.

First time I ran it, it cleared out the database, so all settings lost, so I then ran it again but with "copy database" instead of convert and copied a backup .mdb file...I hope this was right thing to do - it seems to work now & all my data is back again.

Final problem....sorry....logging in still painful, but I've found a workaround. Basically, when I go to the EWA through my domain (http://www.mydomain.com), the login page comes up, but the login simply doesn't work.

Mydomain.com is actually forwarding to a dynamic DNS account. I have the full URL set on the dynamic domain (e.g. http://dynamicdomainname.com:7647/gbpvr/info2.aspx). The bizarre thing is, if I copy

http://dynamicdomainname.com:7647/gbpvr/info2.aspx

straight into URL bar, then I can login without problems - The problem only arises now when I'm trying via http://www.mydomain.com - ifuseewhatimean....this should be doing exactly the same thing..but doesn't seem to work.

FWIW here's the log created when I: logged in unsuccessfully via the forwarding domain; then immediately logged in successfully via the long URL.

Quote:2008-04-20 23:02:43.218 INFO [10] Pulled Credential from Config...
2008-04-20 23:02:43.218 INFO [10] User= tabitha
2008-04-20 23:02:43.218 INFO [10] Password = AD3B821CAF6C2B4A4368458AEE600255
2008-04-20 23:02:43.218 INFO [10]
2008-04-20 23:02:43.218 INFO [10] Postback not found....now pulling User Host Info...
2008-04-20 23:02:43.218 INFO [10] IP V4 Detected on Server
2008-04-20 23:02:43.218 INFO [10]
2008-04-20 23:02:43.218 INFO [10] Setting logo attribute to version info...
2008-04-20 23:02:43.218 INFO [10] Establishing login salt
2008-04-20 23:02:43.218 INFO [10] Login salt = 0ccf91b8-e853-428f-91f9-3559f2b14ab6
2008-04-20 23:02:43.218 INFO [10] Registering hidden field...LoginButton.UniqueID = LoginButton
2008-04-20 23:02:43.218 INFO [10]
2008-04-20 23:02:48.296 INFO [11] Loading Config...
2008-04-20 23:02:48.296 INFO [11]
2008-04-20 23:02:48.296 INFO [11] Pulled Credential from Config...
2008-04-20 23:02:48.296 INFO [11] User= tabitha
2008-04-20 23:02:48.296 INFO [11] Password = AD3B821CAF6C2B4A4368458AEE600255
2008-04-20 23:02:48.296 INFO [11]
2008-04-20 23:02:48.296 INFO [11]
2008-04-20 23:02:48.296 INFO [11] Setting logo attribute to version info...
2008-04-20 23:02:48.296 INFO [11] Establishing login salt
2008-04-20 23:02:48.296 INFO [11] Login salt = 0ccf91b8-e853-428f-91f9-3559f2b14ab6
2008-04-20 23:02:48.296 INFO [11] Registering hidden field...LoginButton.UniqueID = LoginButton
2008-04-20 23:02:48.296 INFO [11]
2008-04-20 23:02:48.296 INFO [11] Loginbutton click detected...
2008-04-20 23:02:48.296 INFO [11] Now pulling User Host Info...
2008-04-20 23:02:48.296 INFO [11] Using IP4 Address: 89.168.47.139
2008-04-20 23:02:48.296 INFO [11]
2008-04-20 23:02:48.296 INFO [11] Loading Global Settings....
2008-04-20 23:02:48.296 INFO [11]
2008-04-20 23:02:48.296 INFO [11]
2008-04-20 23:02:48.296 INFO [11] Checking to see if the username and password that were entered match what was pulled from config....
2008-04-20 23:02:48.296 INFO [11] User name and password matched for Administrative access...
2008-04-20 23:02:48.296 INFO [11]
2008-04-20 23:02:48.296 INFO [11] You have made it to the complete login method....this is a good thing....
2008-04-20 23:02:48.296 INFO [11] RedirectUri = /gbpvr/Admin2.aspx
2008-04-20 23:02:48.296 INFO [11] Checking username not blank, redirect uri = admin/admin2.aspx...
2008-04-20 23:02:48.296 INFO [11] User is going to css based admin2.aspx...setting theme session variable
2008-04-20 23:02:48.296 INFO [11]
2008-04-20 23:02:48.296 INFO [11] Checking to see if the redirec uri is equal to default.aspx or logout.aspx
2008-04-20 23:02:48.296 INFO [11] Redirect uri was not equal to default or logout....
2008-04-20 23:02:48.296 INFO [11]
2008-04-20 23:02:48.296 INFO [11]
2008-04-20 23:02:48.296 INFO [11] Successful login for tabitha from 89.168.47.139
2008-04-20 23:02:48.296 INFO [11]
2008-04-20 23:02:48.296 INFO [11] Initializing Forms Authentication....
2008-04-20 23:02:48.296 INFO [11]
2008-04-20 23:02:48.296 INFO [11] Setting Forms Authentication Cookie....
2008-04-20 23:02:48.296 INFO [11] Username = tabitha
2008-04-20 23:02:48.296 INFO [11] Cookie Path = /
2008-04-20 23:02:48.296 INFO [11]
2008-04-20 23:02:48.296 INFO [11] Checking for auto search execution....
2008-04-20 23:02:48.296 INFO [11] Auto Search is not set to run or it has aleady run today....
2008-04-20 23:02:48.296 INFO [11]
2008-04-20 23:02:48.296 INFO [11] Redirecting to the target page....
2008-04-20 23:02:48.296 INFO [11] Redirect URL = /gbpvr/Admin2.aspx
2008-04-20 23:02:48.312 INFO [4] Loading Config...
2008-04-20 23:02:48.312 INFO [4]
2008-04-20 23:02:48.312 INFO [4] Pulled Credential from Config...
2008-04-20 23:02:48.312 INFO [4] User= tabitha
2008-04-20 23:02:48.312 INFO [4] Password = AD3B821CAF6C2B4A4368458AEE600255
2008-04-20 23:02:48.312 INFO [4]
2008-04-20 23:02:48.312 INFO [4] Postback not found....now pulling User Host Info...
2008-04-20 23:02:48.312 INFO [4] IP V4 Detected on Server
2008-04-20 23:02:48.312 INFO [4]
2008-04-20 23:02:48.312 INFO [4] Setting logo attribute to version info...
2008-04-20 23:02:48.312 INFO [4] Establishing login salt
2008-04-20 23:02:48.312 INFO [4] Login salt = 0ccf91b8-e853-428f-91f9-3559f2b14ab6
2008-04-20 23:02:48.312 INFO [4] Registering hidden field...LoginButton.UniqueID = LoginButton
2008-04-20 23:02:48.312 INFO [4]
2008-04-20 23:03:01.671 INFO [11] Loading Config...
2008-04-20 23:03:01.671 INFO [11]
2008-04-20 23:03:01.671 INFO [11] Pulled Credential from Config...
2008-04-20 23:03:01.671 INFO [11] User= tabitha
2008-04-20 23:03:01.671 INFO [11] Password = AD3B821CAF6C2B4A4368458AEE600255
2008-04-20 23:03:01.671 INFO [11]
2008-04-20 23:03:01.671 INFO [11]
2008-04-20 23:03:01.671 INFO [11] Setting logo attribute to version info...
2008-04-20 23:03:01.671 INFO [11] Establishing login salt
2008-04-20 23:03:01.671 INFO [11] Login salt = 0ccf91b8-e853-428f-91f9-3559f2b14ab6
2008-04-20 23:03:01.671 INFO [11] Registering hidden field...LoginButton.UniqueID = LoginButton
2008-04-20 23:03:01.671 INFO [11]
2008-04-20 23:03:01.671 INFO [11] Loginbutton click detected...
2008-04-20 23:03:01.671 INFO [11] Now pulling User Host Info...
2008-04-20 23:03:01.671 INFO [11] Using IP4 Address: 89.168.47.139
2008-04-20 23:03:01.671 INFO [11]
2008-04-20 23:03:01.671 INFO [11] Loading Global Settings....
2008-04-20 23:03:01.671 INFO [11]
2008-04-20 23:03:01.671 INFO [11]
2008-04-20 23:03:01.671 INFO [11] Checking to see if the username and password that were entered match what was pulled from config....
2008-04-20 23:03:01.671 INFO [11] User name and password matched for Administrative access...
2008-04-20 23:03:01.671 INFO [11]
2008-04-20 23:03:01.671 INFO [11] You have made it to the complete login method....this is a good thing....
2008-04-20 23:03:01.671 INFO [11] RedirectUri = /gbpvr/Admin2.aspx
2008-04-20 23:03:01.671 INFO [11] Checking username not blank, redirect uri = admin/admin2.aspx...
2008-04-20 23:03:01.671 INFO [11] User is going to css based admin2.aspx...setting theme session variable
2008-04-20 23:03:01.671 INFO [11]
2008-04-20 23:03:01.671 INFO [11] Checking to see if the redirec uri is equal to default.aspx or logout.aspx
2008-04-20 23:03:01.671 INFO [11] Redirect uri was not equal to default or logout....
2008-04-20 23:03:01.671 INFO [11]
2008-04-20 23:03:01.671 INFO [11]
2008-04-20 23:03:01.671 INFO [11] Successful login for tabitha from 89.168.47.139
2008-04-20 23:03:01.671 INFO [11]
2008-04-20 23:03:01.671 INFO [11] Initializing Forms Authentication....
2008-04-20 23:03:01.671 INFO [11]
2008-04-20 23:03:01.671 INFO [11] Setting Forms Authentication Cookie....
2008-04-20 23:03:01.671 INFO [11] Username = tabitha
2008-04-20 23:03:01.671 INFO [11] Cookie Path = /
2008-04-20 23:03:01.671 INFO [11]
2008-04-20 23:03:01.671 INFO [11] Checking for auto search execution....
2008-04-20 23:03:01.671 INFO [11] Auto Search is not set to run or it has aleady run today....
2008-04-20 23:03:01.671 INFO [11]
2008-04-20 23:03:01.671 INFO [11] Redirecting to the target page....
2008-04-20 23:03:01.671 INFO [11] Redirect URL = /gbpvr/Admin2.aspx
2008-04-20 23:03:04.843 VERBOSE [4] RecordingFactory.loadSchedule()
2008-04-20 23:03:04.843 VERBOSE [4] getValue cached value: /settings/AutoRemoveMissingRecordings : true
2008-04-20 23:03:04.875 ERROR [4] System.IndexOutOfRangeException: Index was outside the bounds of the array.

Server stack trace:
at GBPVR.RecordingService.x93f60a55016d55c4.xbf7ba6ca72d62d77()
at GBPVR.RecordingService.RecordingRemote.getTunerStatus()
at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
at System.Runtime.Remoting.Messaging.StackBuilderSink.PrivateProcessMessage(RuntimeMethodHandle md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext)

Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at GBPVR.Backend.Common.IRecordingService.getTunerStatus()
at gbweb.Migrated_Info2.GetRecordingStatuses() in c:\Program Files\devnz\gbpvr\web\Info2.aspx.cs:line 279
at gbweb.Migrated_Info2.Page_Load(Object sender, EventArgs e) in c:\Program Files\devnz\gbpvr\web\Info2.aspx.cs:line 83
UncleJohnsBand
Offline

Posting Freak

U.S.A.
Posts: 5,643
Threads: 258
Joined: Feb 2005
#5
2008-04-21, 12:37 AM
Guy Wrote:Many thanks - this seems to have done the trick.

First time I ran it, it cleared out the database, so all settings lost, so I then ran it again but with "copy database" instead of convert and copied a backup .mdb file...I hope this was right thing to do - it seems to work now & all my data is back again.

Great to hear that this is resolved and you did not loose anything. Using SQLite you should actually get better performance as well.

Guy Wrote:Final problem....sorry....logging in still painful, but I've found a workaround. Basically, when I go to the EWA through my domain (www.mydomain.com), the login page comes up, but the login simply doesn't work.

Mydomain.com is actually forwarding to a dynamic DNS account. I have the full URL set on the dynamic domain (e.g. http://dynamicdomainname.com:7647/gbpvr/info2.aspx). The bizarre thing is, if I copy

http://dynamicdomainname.com:7647/gbpvr/info2.aspx

straight into URL bar, then I can login without problems - The problem only arises now when I'm trying via www.mydomain.com - ifuseewhatimean....this should be doing exactly the same thing..but doesn't seem to work.

I have never seen anyone try to code the port at the dynamic ip forwarding host.....I have only ever seen people just have the dynamic forward go straight to the PC and if you want a port you add it to the dynamic name....just like you are doing when it works. I am thinking that the problem may have something to do with the port when you try to set it in the dynamic forward rather than passing it in on the url you enter in the address bar.

If you want to use streaming then you won't be able to have the 7647 port hard coded in the dynamic forward address since streaming runs on a different port (7648) (another reason for not hard coding ports on a forward).
Intel Core i7 @ 4.00GHz Skylake 14nm
ASUSTeK COMPUTER INC. Z170-DELUXE
Windows 10 Pro x64
PVR Software: NPVR 5.1.1
SiliconDust HDHomeRun HDHR5-4US Connect Quatro 4 Channel Tuner
Roku Ultra
2 PCH A-100's
« Next Oldest | Next Newest »

Users browsing this thread: 1 Guest(s)



Possibly Related Threads…
Thread Author Replies Views Last Post
  Error with Web Admin? jksmurf 0 2,348 2019-06-20, 10:34 AM
Last Post: jksmurf
  Server Error in '/' Application smajor 19 16,871 2017-10-27, 12:57 PM
Last Post: mvallevand
  Error when trying to stream from NEWA on PC jksmurf 2 2,799 2017-02-27, 05:12 AM
Last Post: jksmurf
  Server Error in '/' Application [streaming failure] oldman 3 3,047 2017-02-04, 12:48 AM
Last Post: UncleJohnsBand
  Server Error when settign a manual recording in NEWA martinu 2 2,338 2017-01-23, 01:30 AM
Last Post: UncleJohnsBand
  Internal Server Error SilverTiger 5 3,201 2016-07-24, 04:03 PM
Last Post: UncleJohnsBand
  "Record selected" returns error web page ... softfoot 5 3,754 2016-03-26, 01:37 PM
Last Post: UncleJohnsBand
  Server Error in "/" Application ? Lone_Stranger 1 2,412 2016-02-19, 02:10 AM
Last Post: UncleJohnsBand
  Server Error in '/' Application mdenecke 1 2,916 2016-01-13, 03:33 AM
Last Post: UncleJohnsBand
  Server Error when trying to schedule with NEWA in 336? jksmurf 5 3,740 2015-12-12, 12:34 AM
Last Post: jksmurf

  • View a Printable Version
  • Subscribe to this thread
Forum Jump:

© Designed by D&D, modified by NextPVR - Powered by MyBB

Linear Mode
Threaded Mode