Copied to clipboard

Flag this post as spam?

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


  • Graham Carr 277 posts 389 karma points
    Jul 20, 2015 @ 14:07
    Graham Carr
    0

    Scheduled publishing error showing in log file

    The publish at and unpublish at functionality is not currently working on my site which is running Umbraco 7.1.4 if I view the UmbracoTraceLog.txt file in the App_Data/Logs folder I see the following error showing up every minute.

    Any ideas what the cause might be??

    2015-07-20 15:01:55,679 [38] ERROR umbraco.presentation.publishingService - [Thread 7] Error executing scheduled publishing
    System.Data.SqlClient.SqlException (0x80131904): The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
       at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
       at System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows)
       at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
       at System.Data.SqlClient.SqlDataReader.Read()
       at Umbraco.Core.Persistence.Database.<Query>d__1c`1.MoveNext()
       at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
       at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
       at Umbraco.Core.Persistence.Repositories.ContentRepository.<PerformGetByQuery>d__24.MoveNext()
       at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()
       at System.Linq.Buffer`1..ctor(IEnumerable`1 source)
       at System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source)
       at umbraco.presentation.publishingService.CheckPublishing(Object sender)
    ClientConnectionId:5838da32-95d5-4103-9554-399f4775cdcc
    
  • Dennis Aaen 4500 posts 18255 karma points admin hq c-trib
    Jul 20, 2015 @ 14:18
    Dennis Aaen
    0

    Hi Graham,

    Try this issue from the issue tracker. http://issues.umbraco.org/issue/U4-5379

    Maybe it could be an idea for you to an upgrade. Then you should follow the general upgrade documentation.

    https://our.umbraco.org/documentation/installation/upgrading/general

    Hope this helps,

    /Dennis

  • 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