Datatype-Error in Schedule.cs

[ollis]

Hi.

There is an error in Schedule.cs, when i open the Manage.aspx:

(errormessage with german parts)

Code:

Serverfehler in der Anwendung /gbpvr.
--------------------------------------------------------------------------------

Datentypen in Kriterienausdruck unverträglich.
Beschreibung: Unbehandelte Ausnahme beim Ausführen der aktuellen Webanforderung. Überprüfen Sie die Stapelüberwachung, um weitere Informationen über diesen Fehler anzuzeigen und festzustellen, wo der Fehler im Code verursacht wurde.

Ausnahmedetails: [B]System.Data.OleDb.OleDbException: Datentypen in Kriterienausdruck unverträglich[/B].

Quellfehler:


[B]Zeile 126:                aCommand.Connection = aConnection;
Zeile 127:
Zeile 128:                DbDataReader aReader = aCommand.ExecuteReader();
Zeile 129:                if (aReader.Read())
Zeile 130:                {[/B]

Quelldatei: [B]c:\Programme\devnz\gbpvr\web\App_Code\classes\Schedule.cs    Zeile: 128[/B]

Stapelüberwachung:


[OleDbException (0x80040e07): Datentypen in Kriterienausdruck unverträglich.]
   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:\Programme\devnz\gbpvr\web\App_Code\classes\Schedule.cs:128
   GBPVRSchedule.Schedule.getSeasonDayString(ScheduledRecording scheduledRecording) in c:\Programme\devnz\gbpvr\web\App_Code\classes\Schedule.cs:149
   gbweb.Manage.Page_Load(Object sender, EventArgs e) in c:\Programme\devnz\gbpvr\web\Manage.aspx.cs:479
   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




--------------------------------------------------------------------------------
Versionsinformationen: Microsoft .NET Framework-Version:2.0.50727.1433; ASP.NET-Version:2.0.50727.1433

[ollis]

Research for the moment:

the affected code in Schedule.cs:

Code:

public int getSeasonDayMask(ScheduledRecording scheduledRecording)
        {
            int day_mask = -1;

            if ((RecType)scheduledRecording.getRecordingType() == RecType.Season)
            {

                // create the database connection
                DbConnection aConnection = Global.GetOpenGBPVRDbConnection();

                // create the command object and store the sql query
                DbCommand aCommand = aConnection.CreateCommand();

                //Create the command sql query string
                aCommand.CommandText = "select day_mask from REOCCURING_EXTRAS where recording_group='" +
                                       scheduledRecording.getRecordingGroup() + "'";
                aCommand.Connection = aConnection;

                DbDataReader aReader = aCommand.ExecuteReader();
                if (aReader.Read())
                {
                    day_mask = aReader.GetInt16(0);

                }

                // close the reader
                aReader.Close();
                aConnection.Close();
                aConnection.Dispose();
            }
                        return day_mask;
        }

this reflects the displayed days in Air Date column. (right?)

In Table REOCCURING_EXTRAS are 21 rows. Column day_mask has values from 0 to 127.

Why does the Reader says there ist a wrong datatype?

Greetz
Olli

[UncleJohnsBand]

Research for the moment:

the affected code in Schedule.cs:

Code:

public int getSeasonDayMask(ScheduledRecording scheduledRecording)
        {
            int day_mask = -1;

            if ((RecType)scheduledRecording.getRecordingType() == RecType.Season)
            {

                // create the database connection
                DbConnection aConnection = Global.GetOpenGBPVRDbConnection();

                // create the command object and store the sql query
                DbCommand aCommand = aConnection.CreateCommand();

                //Create the command sql query string
                aCommand.CommandText = "select day_mask from REOCCURING_EXTRAS where recording_group='" +
                                       scheduledRecording.getRecordingGroup() + "'";
                aCommand.Connection = aConnection;

                DbDataReader aReader = aCommand.ExecuteReader();
                if (aReader.Read())
                {
                    day_mask = aReader.GetInt16(0);

                }

                // close the reader
                aReader.Close();
                aConnection.Close();
                aConnection.Dispose();
            }
                        return day_mask;
        }

this reflects the displayed days in Air Date column. (right?)

In Table REOCCURING_EXTRAS are 21 rows. Column day_mask has values from 0 to 127.

Why does the Reader says there ist a wrong datatype?

Greetz
Olli

It appears you may be using Access as your database for gbpvr. I would run the changedatbase.exe file in the gbpvr directory and convert over to SQLite.

Let me know what happens.

[ollis]

Thanks UncleJohnsBand - this Workaround works.

But i can´t believe this error using MSACCESS.

for now - my PVR runs with SQLITE - i hope with the same stable as with MSACCESS in the past 4 Years.

Greets
Olli

[UncleJohnsBand]

When sub moved GBPVR to SQLite there was some growing pains but they were quickly put to the side with the speed increase gained using SQLite.

It is much faster than an Access database and does not suffer bloat.