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)
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.
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:
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
is working on a reply...