Copied to clipboard

Flag this post as spam?

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


  • Nils Frank 19 posts 89 karma points
    Jan 04, 2017 @ 15:48
    Nils Frank
    0

    DB Error

    Hey Rolf,

    i tried using your package on 7.5.6 and 7.4.3. On both Versions it doesnt work.

    My best guess is that there is a problem with the database structure of newer umbraco versions.

    Do you have any idea?

    Umbraco Log File says:

    017-01-04 16:05:26,411 [P10332/D14/T26] ERROR
    Chalmers.MediaContentUsage - There was an error parsing the query. [ Token line number = 1,Token line offset = 193,Token in error = max ]
    System.Data.SqlServerCe.SqlCeException (0x80004005): There was an error parsing the query. [ Token line number = 1,Token line offset = 193,Token in error = max ]
       bei System.Data.SqlServerCe.SqlCeCommand.ProcessResults(Int32 hr)
       bei System.Data.SqlServerCe.SqlCeCommand.CompileQueryPlan()
       bei System.Data.SqlServerCe.SqlCeCommand.ExecuteCommand(CommandBehavior behavior, String method, ResultSetOptions options)
       bei System.Data.SqlServerCe.SqlCeCommand.ExecuteDbDataReader(CommandBehavior behavior)
       bei System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
       bei StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteDbDataReader(CommandBehavior behavior) in c:\Code\github\SamSaffron\MiniProfiler\StackExchange.Profiling\Data\ProfiledDbCommand.cs:Zeile 235.
       bei System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
       bei Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClass4.<ExecuteReaderWithRetry>b__3()
       bei Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)
       bei Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteReaderWithRetry(IDbCommand command, RetryPolicy cmdRetryPolicy, RetryPolicy conRetryPolicy)
       bei Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteReaderWithRetry(IDbCommand command, RetryPolicy retryPolicy)
       bei Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteReaderWithRetry(IDbCommand command)
       bei Umbraco.Core.Persistence.Database.<Query>d__7`1.MoveNext()
       bei Chalmers.MediaContentUsage.FindMedia(Int32 contentNodeId)
    
  • Rolf Johansson 53 posts 315 karma points
    Dec 09, 2021 @ 12:21
    Rolf Johansson
    0

    I'm very sorry for missing this question for so long, but for future reference I think it's a problem with SQL CE, it's not supported. It looks like it's trying to do a query with nvarchar(max). Perhaps it can be fixed with ntext instead.

    All the best, Rolf

Please Sign in or register to post replies

Write your reply to:

Draft