SQLServer Problems with latest releases. (1 Viewer)

[joboehl]

I'll post a complete bug report later, have to reinstall SQL Server first, but would like to know if anybody else is having this problem:

In the latest SVNs, TVClient almost stopped working since it can't communicate properly with the database. This SQL error message appears in the logs, reported by the Gentle.Framework:


The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.


A sample SQL that's causing the problem is:


select idProgram, idChannel, startTime, endTime, title, description, genre, notify from Program where idChannel = 5 and ((EndTime > '2007-01-26 01:00:00' and EndTime < '2007-01-26 02:59:00') or (StartTime >= '2007-01-26 01:00:00' and StartTime <= '2007-01-26 02:59:00') or (StartTime <= '2007-01-26 01:00:00' and EndTime >= '2007-01-26 02:59:00')) order by startTime asc


Changing it to something like this solves the problem:

select idProgram, idChannel, startTime, endTime, title, description, genre, notify from Program where idChannel = 5 and ((EndTime > '2007-26-01 01:00:00' and EndTime < '2007-26-01 02:59:00') or (StartTime >= '2007-26-01 01:00:00' and StartTime <= '2007-26-01 02:59:00') or (StartTime <= '2007-26-01 01:00:00' and EndTime >= '2007-26-01 02:59:00')) order by startTime asc


All machines (client and Server) are configured with regional settings of United States. Haven't had this problems with builds up to 12646, no matter which region setting I had. Tested now with 12736 and 12752.

anybody else seeing this?

 

[Peter Pan]

I can confirm this problem.

 

[Chelle]

Yes I also got this yesterday. Reinstalled and configured for mysql instead and now everything is working again.

//Chelle

 

[rtv]

As of ISO 8601 the International Standard for the representation of dates and times has to be year-month-day.
Would be nice if you find out what sqlserver setting has been changed for you.

 

[joboehl]

rtv,

Nothing has changed in SQLServer config. It was just a simple SVN update. Looked at the Gentle.Config and the only thing that is different is Pooling=false, which I removed.

As for the machines, they are all set to date format year-month-day. Can't understand why SQLServer is rejecting it now and why it was not doing it before.

I'll try with some older SVNs and see what happens. Do you know if there's anyway to make gentle log all SQL statements? This way it would be possible to see if the actual SQL Statement is changing between SVNs.

Thanks.