System.Data.SqlClient.SqlException (0x80131904): La conversione di un tipo di dati varchar in datetime ha generato un valore non compreso nell'intervallo dei valori consentiti.
in System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
in System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
6.2.2: publish at error caused by a conversion from varchar to datetime. Maybe the cause date field in publish at?
My server has italian datetime settings. Do I need setting it in English?
2014-09-18 17:11:51,039 [5] ERROR Umbraco.Web.WebServices.ScheduledPublishController - [Thread 20] Error executing scheduled task
System.Data.SqlClient.SqlException (0x80131904): La conversione di un tipo di dati varchar in datetime ha generato un valore non compreso nell'intervallo dei valori consentiti.
in System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
in System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
in System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
in System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows)
in System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
in System.Data.SqlClient.SqlDataReader.Read()
in Umbraco.Core.Persistence.Database.<Query>d__1c`1.MoveNext()
in System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
in System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
in Umbraco.Core.Persistence.Repositories.ContentRepository.<PerformGetByQuery>d__22.MoveNext()
in System.Linq.Enumerable.WhereEnumerableIterator`1.MoveNext()
in Umbraco.Core.Publishing.ScheduledPublisher.CheckPendingAndProcess()
in Umbraco.Web.WebServices.ScheduledPublishController.Index()
ClientConnectionId:c48fc8c8-dcd6-4592-acbe-cae0d7049121
2014-09-18 17:11:51,039 [5] ERROR Umbraco.Web.Scheduling.ScheduledPublishing - [Thread 11] An error occurred with the scheduled publishing
System.Net.WebException: Errore del server remoto: (400) Richiesta non valida.
in System.Net.WebClient.UploadDataInternal(Uri address, String method, Byte[] data, WebRequest& request)
in System.Net.WebClient.UploadString(Uri address, String method, String data)
in Umbraco.Web.Scheduling.ScheduledPublishing.Start(ApplicationContext appContext)
Which tables are involved into the query to publish at?
?
Solved with upgrade to to 6.2.4 version and last UBlogsy version. You need only change something in your code, but all works now.
-:)
is working on a reply...