Sign in Register
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Biagio Paruolo 1621 posts 1914 karma points c-trib
    Sep 18, 2014 @ 17:25
    Biagio Paruolo
    0

    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)

    Copy Link
  • Biagio Paruolo 1621 posts 1914 karma points c-trib
    Sep 19, 2014 @ 15:53
    Biagio Paruolo
    0

    Which tables are involved into the query to publish at?

    ?

    Copy Link
  • Biagio Paruolo 1621 posts 1914 karma points c-trib
    Jan 06, 2015 @ 13:50
    Biagio Paruolo
    100

    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.

    -:)

    Copy Link

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies