Copied to clipboard

Flag this post as spam?

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


  • Marcel 18 posts 67 karma points
    Jan 26, 2015 @ 14:26
    Marcel
    0

    Database Schema

    Hi.

    We wanted to mirgrate from "Contour" to "Umbraco Forms". We use the Umbraco Forms Migration tool to install Forms. The tool displayed a thank you page and everything was fine.

    When we accessed our old data from the new umbraco forms interface - we don't see any entry. On the console we see following error message:

    {"Message":"An error has occurred.","ExceptionMessage":"Conversion failed when converting the nvarchar value 'Submitted' to data type int.","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.SqlInternalConnection.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.TryHasMoreRows(Boolean& moreRows)\r\n   at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)\r\n   at System.Data.SqlClient.SqlDataReader.Read()\r\n   at System.Data.SqlClient.SqlCommand.CompleteExecuteScalar(SqlDataReader ds, Boolean returnSqlValue)\r\n   at System.Data.SqlClient.SqlCommand.ExecuteScalar()\r\n   at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteScalar() in c:\\Code\\github\\SamSaffron\\MiniProfiler\\StackExchange.Profiling\\Data\\ProfiledDbCommand.cs:line 311\r\n   at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClassa.<ExecuteScalarWithRetry>b__9()\r\n   at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)\r\n   at Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteScalarWithRetry(IDbCommand command, RetryPolicy cmdRetryPolicy, RetryPolicy conRetryPolicy)\r\n   at Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteScalarWithRetry(IDbCommand command, RetryPolicy retryPolicy)\r\n   at Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteScalarWithRetry(IDbCommand command)\r\n   at Umbraco.Core.Persistence.Database.ExecuteScalar[T](String sql, Object[] args)\r\n   at Umbraco.Core.Persistence.Database.Page[T](Int64 page, Int64 itemsPerPage, String sql, Object[] args)\r\n   at Umbraco.Core.Persistence.Database.Page[T](Int64 page, Int64 itemsPerPage, Sql sql)\r\n   at Umbraco.Forms.Web.BusinessLogic.FormRecordSearcher.QueryDataBase(RecordFilter model, DatabaseContext databaseContext) in f:\\TeamCity\\buildAgent\\work\\133677a4e37ceece\\Umbraco.Forms.Mvc\\BusinessLogic\\FormRecordSearcher.cs:line 37\r\n   at Umbraco.Forms.Web.Editors.RecordController.PostRetriveRecords(RecordFilter model) in f:\\TeamCity\\buildAgent\\work\\133677a4e37ceece\\Umbraco.Forms.Mvc\\Editors\\RecordController.cs:line 51\r\n   at lambda_method(Closure , Object , Object[] )\r\n   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass13.<GetExecutor>b__c(Object instance, Object[] methodParameters)\r\n   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.Execute(Object instance, Object[] arguments)\r\n   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.<>c__DisplayClass5.<ExecuteAsync>b__4()\r\n   at System.Threading.Tasks.TaskHelpers.RunSynchronously[TResult](Func`1 func, CancellationToken cancellationToken)"}
    

    After doing some investigation I think the migration didn't work. Nothing changed on the DB-Schema.

    So I ask you, can you send me the target DB-Schema, so I can migrate my data by myself. It would cost me half a day to install a new Umbraco Instance, install Forms, only to get the DB-Schema.

    Best regards, Marcel

  • Craig Mayers 164 posts 507 karma points
    Aug 06, 2016 @ 15:15
    Craig Mayers
    0

    Experiencing the same issue on a upgraded site (6.2.5 to 7.3.8).

    Struggling to find a fix for this issue.

    Anybody?

  • Heather Floyd 531 posts 787 karma points MVP 2x c-trib
    Nov 28, 2018 @ 19:19
    Heather Floyd
    0

    Sorry, Craig, for hijacking this thread, but there didn't seem to be any other way to get your attention... Can you take a look at this post?

    https://our.umbraco.com/forum/extending-umbraco-and-using-the-api//94803-question-about-sleepymediadatefolders

    Thanks!

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies