Copied to clipboard

Flag this post as spam?

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


  • Simone Chiaretta 134 posts 541 karma points c-trib
    Mar 02, 2016 @ 09:50
    Simone Chiaretta
    0

    Cannot post "long" titles (on our.umbraco)

    I was trying to post a question with title

    Should Source and Object return the same value when building property value converters for custom data types that have their value in JSON?

    And the "post topic" buttons stays with the 3 dots... doesn't give any errors, but when looking at the response of the web api request I get the following error.

    {"Message":"An error has occurred.","ExceptionMessage":"String or binary data would be truncated.
    The statement has been terminated.","ExceptionType":"System.Data.SqlClient.SqlException","StackTrace":"   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.TryConsumeMetaData()
    at System.Data.SqlClient.SqlDataReader.get_MetaData()
    at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
    at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
    at System.Data.SqlClient.SqlCommand.ExecuteScalar()
    at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteScalar() in c:\\Code\\github\\SamSaffron\\MiniProfiler\\StackExchange.Profiling\\Data\\ProfiledDbCommand.cs:line 299
    at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClassa.<ExecuteScalarWithRetry>b__9()
    at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)
    at Umbraco.Core.Persistence.Database.Insert(String tableName, String primaryKeyName, Boolean autoIncrement, Object poco)
    at Umbraco.Core.Persistence.Database.Save(String tableName, String primaryKeyName, Object poco)
    at OurUmbraco.Forum.Services.TopicService.Save(Topic topic)
       at OurUmbraco.Forum.Api.ForumController.Topic(TopicSaveModel model)
          at lambda_method(Closure , Object , Object[] )
             at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass10.<GetExecutor>b__9(Object instance, Object[] methodParameters)
                at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary`2 arguments, CancellationToken cancellationToken)
                --- End of stack trace from previous location where exception was thrown ---
                   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
                      at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
                         at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()
                            at System.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__0.MoveNext()
                            --- End of stack trace from previous location where exception was thrown ---
                               at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
                                  at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
                                     at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()
                                        at System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__2.MoveNext()
                                        --- End of stack trace from previous location where exception was thrown ---
                                           at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
                                              at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
                                                 at System.Web.Http.Filters.AuthorizationFilterAttribute.<ExecuteAuthorizationFilterAsyncCore>d__2.MoveNext()
                                                 --- End of stack trace from previous location where exception was thrown ---
                                                    at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
                                                       at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
                                                          at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()
                                                             at System.Web.Http.Dispatcher.HttpControllerDispatcher.<SendAsync>d__1.MoveNext()"}
    

    I guess somewhere something is too long.

  • Ronak Panchal 71 posts 230 karma points
    Mar 02, 2016 @ 11:34
    Ronak Panchal
    1

    Hello Simone,

    Are you using SSMS for CMS database.

    if yes then go to the Database table definition, they have limited "nvarchar" field in table "CMSPropertyData" to only 500 characters which is very very small size.

    Set "Nvarchar(500)" of type "Nvarchar(MAX)".

    Hope it works for long title.

    Best Regards,

    Ronak Panchal.

  • Simone Chiaretta 134 posts 541 karma points c-trib
    Mar 02, 2016 @ 11:48
    Simone Chiaretta
    0

    Well... this question was posted in the our.umb dev forum bugs category. Not much I can do as I'm not working on our.umbraco forum :)

  • Simone Chiaretta 134 posts 541 karma points c-trib
    Mar 07, 2016 @ 21:07
    Simone Chiaretta
    101

    Added as bug in issue tracker: http://issues.umbraco.org/issue/OUR-382

Please Sign in or register to post replies

Write your reply to:

Draft