Copied to clipboard

Flag this post as spam?

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


  • Markus Rytterkull 29 posts 140 karma points
    Oct 18, 2022 @ 09:18
    Markus Rytterkull
    0

    Error when changing forms security for user after upgrade to 10

    Hi,

    upgraded a site from 8 to 10. Forms seem to work fine, but when I am trying to change rights for an existing user (adding rights to a form) a get an error:

    Conversion failed when converting the nvarchar value '−1' to data type int.

    Does anyone know why I am getting this error and what I can do to fix it?

    Thanks :-) / Markus

    Full error message:

    { "@t": "2022-10-18T09:00:00.5246980Z", "@mt": "Exception ({InstanceId}).", "@l": "Error", "@x": "Microsoft.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting the nvarchar value '−1' to data type int.\r\n at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)\r\n at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)\r\n at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\r\n at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)\r\n at Microsoft.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)\r\n at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean isAsync, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)\r\n at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry, String method)\r\n at Microsoft.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry, String methodName)\r\n at Microsoft.Data.SqlClient.SqlCommand.ExecuteNonQuery()\r\n at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteNonQuery() in C:\projects\dotnet\src\MiniProfiler.Shared\Data\ProfiledDbCommand.cs:line 281\r\n at Umbraco.Cms.Infrastructure.Persistence.FaultHandling.FaultHandlingDbCommand.

  • Markus Rytterkull 29 posts 140 karma points
    Oct 24, 2022 @ 09:23
    Markus Rytterkull
    0

    I created a new site with umbraco forms and ran a schema comparison to see if anything differed between an upgraded solution and a brand new one.

    There where some changes in indexes and contraints on some fields, otherwise the upgraded solution looked fine.

    So if the database is fine, I guess it must be something else in my solution that is not working (I am still getting the same error as before when changing form rights).

    In my new site that there are no files in App_plugins for umbraco forms - are they not required any more?

Please Sign in or register to post replies

Write your reply to:

Draft