[Server] SQL Statements datetime problems (1 Viewer)

[Dado]

MediaPortal Version: 0.2.0.4
Windows Version: Windows XP MCE RU2
CPU Type: P4 3.0 GHz
HDD: IBM 250 Gb 7200 Rpm 16 Mb Cache
Memory: 512 Mb
Motherboard: ASUS P5P800
Motherboard Chipset: Intel
Motherboard Bios: -
Video Card: NVidia GeForce 5200
Video Card Driver: -
Sound Card: On Board
Sound Card AC3: -
Sound Card Driver: -
1. TV Card: Hauppauge PVR-350
1. TV Card Type: ATSC
1. TV Card Driver: 2.2
2. TV Card: Pinnacle 310i
2. TV Card Type: DVB-T
2. TV Card Driver:
3. TV Card:
3. TV Card Type:
3. TV Card Driver:
4. TV Card:
4. TV Card Type:
4. TV Card Driver:
MPEG2 Video Codec: MPV Video Decoder
MPEG2 Audio Codec: MPA Audio Decoder
Satelite/CableTV Provider:
HTPC Case: Mid Tower
Cooling:
Power Supply: 400W
Remote: MCE Remote
TV: 42" 16:9 Plasma
TV - HTPC Connection: DVI

Hi all,
I'm testing this new engine, but I have encountered a problem regardings datetime conversion in SQL Server:

From error.log:

2006-10-24 14.30.13.656250 [ERROR][MPMain]: Exception   :System.NullReferenceException: Object reference not set to an instance of an object.
   at MediaPortal.Player.TStreamBufferPlayer9.GetInterfaces(String filename)
2006-10-24 14.30.13.656250 [ERROR][MPMain]: Exception   :Object reference not set to an instance of an object.
2006-10-24 14.30.13.656250 [ERROR][MPMain]:   site      :Boolean GetInterfaces(System.String)
2006-10-24 14.30.13.656250 [ERROR][MPMain]:   source    :Core
2006-10-24 14.30.13.656250 [ERROR][MPMain]:   stacktrace:   at MediaPortal.Player.TStreamBufferPlayer9.GetInterfaces(String filename)
2006-10-24 14.30.30.281250 [ERROR][MPMain]: OnMessage exception:Error: StatementErrorUnclassified
Gentle.Common.GentleException: select top 2 idProgram, idChannel, startTime, endTime, title, description, genre, notify from Program where idChannel = @idChannel and endTime >= '10/24/2006 14.30.30' order by startTime asc; ---> System.Data.SqlClient.SqlException: La conversione del tipo di dati da char a datetime ha generato un valore di tipo datetime non compreso nell'intervallo dei valori consentiti.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlDataReader.HasMoreRows()
   at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout)
   at System.Data.SqlClient.SqlDataReader.Read()
   at Gentle.Framework.SqlResult..ctor(PersistenceBroker broker, IDataReader dr, SqlStatement stmt)
   at Gentle.Framework.SqlStatement.Execute(IDbConnection conn, IDbTransaction tr)
   --- End of inner exception stack trace ---
   at Gentle.Framework.SqlStatement.Execute(IDbConnection conn, IDbTransaction tr)
   at Gentle.Framework.PersistenceBroker.Execute(SqlStatement stmt, IDbConnection dbConnection, IDbTransaction dbTransaction)
   at Gentle.Framework.SqlStatement.Execute()
   at TvDatabase.Channel.UpdateNowAndNext()
   at TvDatabase.Channel.get_CurrentProgram()
   at TvPlugin.TVHome.OnRecord()
   at TvPlugin.TVHome.OnClicked(Int32 controlId, GUIControl control, ActionType actionType)
   at MediaPortal.GUI.Library.GUIWindow.OnMessage(GUIMessage message)System.Data.SqlClient.SqlException: La conversione del tipo di dati da char a datetime ha generato un valore di tipo datetime non compreso nell'intervallo dei valori consentiti.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlDataReader.HasMoreRows()
   at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout)
   at System.Data.SqlClient.SqlDataReader.Read()
   at Gentle.Framework.SqlResult..ctor(PersistenceBroker broker, IDataReader dr, SqlStatement stmt)
   at Gentle.Framework.SqlStatement.Execute(IDbConnection conn, IDbTransaction tr)

Perhaps there may be a problem only in some countries with inversion of dates into sql statements; in my country date format is dd/mm/yyyy hh.mm.ss but MP uses mm/dd/yyyy hh.mm.ss and this cause datetime conversion errors.

Can someone solve this?

New tv engine seems to be GREAT! I have tried to record from TV Server Management Console and the native MPG is GREAT! Unfortunately when I click on Record Now from MP nothing happen..... and when I try to change channels nothing happen too, perhaps for datetime exception too.

Thanks a lot in advance,
Dado

 

[Frodo]

Indeed a problem
I uploaded a new version for you at http://tvengine3.team-mediaportal.com/
Perhaps you can try that one and see if its fixed?
The problem exists in both server & plugin so please install both after downloading the the new version

Frodo

 

[Dado]

Ok, now It's better: problems with date are ok, and TV works (record now, channel changing, etc) but after restart I have encountered problem: when starting TV a message appear: "unable to start timeshifting - no free card available".

After this I was going into the manual control section of Mgmt and I had seen that it is recording and timeshifting is on.....

If I try to restart the service at restart it starts to timeshift and record!! This is very strange!

Thanks,
Dado

 

[Frodo]

In mediaportal, cancel the schedule in tv->schedule
Frodo

 

[Dado]

Hi,
I have deleted schedule and restart PC, but at the boot > TV > some message. If I close MP and go to Mgmt of tvserver boards is all Idle, but if I try to start timeshift or recoring a message appear: "All cards are busy"...If now I restart the service finally I can start manual timeshifting and record... Now I try to open MP.....and a message appea: "Unable to start timeshifting" "no audio/video detected". I have tried some channels...

If I try again with Mgmt ad manual control it's the same: "No Audio/video detected".
.
Thanks,
Dado

 

[Frodo]

Check the log files, maybe it tells something
If the problem remains then please post the log files on
http://pastebin.team-mediaportal.com

 

[j1nx]

I solved this problem by deleting the database before installing the new tvserver. I still have no clue why, but when you remove the tvserver software (you have to otherwise you can not install a new version) first delete the database and again install the new tvserver again.

 

[Dado]

Ok, I attach all logs (there are errors) I have retried all entire operation and I have seen that when I stop the manual recording on MP, the TV starts an old TS file on another channel and video is at low fps (with oles, etc)...

Help! I love this engine!

Thanks,
Dado

 

[Dado]

Hi frodo,
there are news for me?

Thanks,
Dado