Copied to clipboard

Flag this post as spam?

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


  • Anton Oosthuizen 206 posts 486 karma points
    Jul 05, 2017 @ 15:31
    Anton Oosthuizen
    0

    Umbraco Forms: "6.0.2"  × Insufficient Permissions: You do not have permissions to create & manage forms

    Hi I get the following error Create a form Current installed version of Umbraco Forms: "6.0.2"  × Insufficient Permissions: You do not have permissions to create & manage forms

    I see there is a forms security section but I can not add edit or do anything with ir

    https://www.screencast.com/t/gw3CjSbStU4m

    Please advise

  • Anton Oosthuizen 206 posts 486 karma points
    Jul 07, 2017 @ 08:53
    Anton Oosthuizen
    0

    ?

  • Anton Oosthuizen 206 posts 486 karma points
    Jul 12, 2017 @ 09:42
    Anton Oosthuizen
    0

    enter image description here

  • Anton Oosthuizen 206 posts 486 karma points
    Jul 12, 2017 @ 09:43
    Anton Oosthuizen
    0

    Please can anyone assist

  • Anton Oosthuizen 206 posts 486 karma points
    Jul 12, 2017 @ 10:03
    Anton Oosthuizen
    0

    After further investigation, I see there is a formsecurity/getuserid error 500 Error

  • Warren Buckley 2106 posts 4836 karma points MVP 7x admin c-trib
    Jul 18, 2017 @ 07:16
    Warren Buckley
    0

    Hi Anton,
    Can you check clarify that there is not duplicate records in the UFUserSecurities and/or UFUserFormSecurities

    Thanks,
    Warren

  • Anton Oosthuizen 206 posts 486 karma points
    Jul 18, 2017 @ 07:36
    Anton Oosthuizen
    0

    Hi, Thanks for getting back.

    UFUserSecurities -> No duplicates under user field

    UFUserFormSecurities - >Empty

  • Warren Buckley 2106 posts 4836 karma points MVP 7x admin c-trib
    Jul 18, 2017 @ 08:03
    Warren Buckley
    0

    Hi Anton,
    Can you inspect in Chrome what the response comes back from those 500 HTTP errors?

    Sometimes the 500 error returns with more specific details like a stacktrace

    Additionally you may be able to see the exact error in the Umbraco logfile which could help see if we get some more details on what is going on.

    Thanks,
    Warren

  • Anton Oosthuizen 206 posts 486 karma points
    Jul 18, 2017 @ 08:13
    Anton Oosthuizen
    0

    Hi Warren,

    I get a 417 (Missing Token) error

    /umbraco/backoffice/UmbracoForms/FormSecurity/GetByUserId?userId=0 417 (Missing token)

  • Warren Buckley 2106 posts 4836 karma points MVP 7x admin c-trib
    Jul 18, 2017 @ 08:28
    Warren Buckley
    0

    Hi Anton,
    I would clear out your browser cahce & cookies or alternatively try a differtent browser to be sure.

    As the 417 Missing token errors can be caused by missing auth cookies.

    Warren

  • Anton Oosthuizen 206 posts 486 karma points
    Jul 18, 2017 @ 15:42
    Anton Oosthuizen
    0

    Same error all browsers

  • Warren Buckley 2106 posts 4836 karma points MVP 7x admin c-trib
    Jul 19, 2017 @ 07:32
  • Anton Oosthuizen 206 posts 486 karma points
    Jul 19, 2017 @ 08:10
    Anton Oosthuizen
    0

    Hi thanks for the links but the only place i see console errors is when I click on forms.

    I manage to get the 500 response error :

    )]}',
    {"Message":"An error has occurred.","ExceptionMessage":"Invalid column name 'Id'.","ExceptionType":"System.Data.SqlClient.SqlException","StackTrace":"   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)\r\n   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\r\n   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)\r\n   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()\r\n   at System.Data.SqlClient.SqlDataReader.get_MetaData()\r\n   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)\r\n   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest)\r\n   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)\r\n   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)\r\n   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)\r\n   at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClass4.<ExecuteReaderWithRetry>b__3()\r\n   at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)\r\n   at Umbraco.Core.Persistence.Database.<Query>d__7`1.MoveNext()\r\n   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)\r\n   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)\r\n   at Umbraco.Forms.Data.Storage.UserFormSecurityStorage.GetAllUserFormSecurity(String userId)\r\n   at Umbraco.Forms.Web.Editors.FormSecurityController.GetByUserId(Int32 userId)\r\n   at lambda_method(Closure , Object , Object[] )\r\n   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass10.<GetExecutor>b__9(Object instance, Object[] methodParameters)\r\n   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary`2 arguments, CancellationToken cancellationToken)\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__0.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__5.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__5.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Web.Http.Filters.ActionFilterAttribute.<ExecuteActionFilterAsyncCore>d__0.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__5.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__5.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Web.Http.Filters.ActionFilterAttribute.<ExecuteActionFilterAsyncCore>d__0.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__5.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__5.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Web.Http.Filters.ActionFilterAttribute.<ExecuteActionFilterAsyncCore>d__0.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__2.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Web.Http.Filters.AuthorizationFilterAttribute.<ExecuteAuthorizationFilterAsyncCore>d__2.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Web.Http.Filters.AuthorizationFilterAttribute.<ExecuteAuthorizationFilterAsyncCore>d__2.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Web.Http.Dispatcher.HttpControllerDispatcher.<SendAsync>d__1.MoveNext()"}
    
  • Warren Buckley 2106 posts 4836 karma points MVP 7x admin c-trib
    Jul 19, 2017 @ 13:54
    Warren Buckley
    1

    Hi Anton,
    Can you check those previously mentioned DB tables please. I am curious to see what DB columns are in those tables as it's complaining about the Id column

  • Anton Oosthuizen 206 posts 486 karma points
    Jul 19, 2017 @ 14:13
    Anton Oosthuizen
    0

    enter image description here

  • Anton Oosthuizen 206 posts 486 karma points
    Jul 19, 2017 @ 14:13
    Anton Oosthuizen
    0

    enter image description here

  • Anton Oosthuizen 206 posts 486 karma points
    Jul 19, 2017 @ 17:20
    Anton Oosthuizen
    100

    Hi

    Thanks for all your help

    For some reason UFUserFormSecurities was missing an Id field.

    Well, I created a new installation installed forms and copied the table so that fixed the problem.

    Thanks Again for your help owe you a beer when you come to South Africa

Please Sign in or register to post replies

Write your reply to:

Draft