Hi,

So i'm running into a problem when trying to mirgrate my database over to v13 from v10.

The following is the error: Syntax error parsing SQL identifier ' '

The problem is most likely happening because im upgrading all the way from v7. I took the following path: v7 -> v8 -> v10 -> v13

I've gone through most documentation and forum threads regarding this, but with no luck.

I assume its a wrong name in a column or something similar.

This is the log, if that clould give some insight:

{"@t":"2024-11-13T12:03:52.8538616Z","@mt":"Starting '{MigrationName}'...","MigrationName":"Umbraco.Core","SourceContext":"Umbraco.Cms.Infrastructure.Migrations.MigrationPlanExecutor","ProcessId":87472,"ProcessName":"iisexpress","ThreadId":1,"ApplicationId":"9f425384764fca69c4465f376613a233484c63ee","MachineName":"JMA","Log4NetLevel":"INFO "} {"@t":"2024-11-13T12:03:52.8539631Z","@mt":"At {OrigState}","OrigState":"{6158F3A3-4902-4201-835E-1ED7F810B2D8}","SourceContext":"Umbraco.Cms.Infrastructure.Migrations.MigrationPlanExecutor","ProcessId":87472,"ProcessName":"iisexpress","ThreadId":1,"ApplicationId":"9f425384764fca69c4465f376613a233484c63ee","MachineName":"JMA","Log4NetLevel":"INFO "} {"@t":"2024-11-13T12:03:52.8541069Z","@mt":"Execute {MigrationType}","MigrationType":"AlignUpgradedDatabase","SourceContext":"Umbraco.Cms.Infrastructure.Migrations.MigrationPlanExecutor","ProcessId":87472,"ProcessName":"iisexpress","ThreadId":1,"ApplicationId":"9f425384764fca69c4465f376613a233484c63ee","MachineName":"JMA","Log4NetLevel":"INFO "} {"@t":"2024-11-13T12:03:52.9759317Z","@mt":"Exception ({InstanceId}).","@l":"Error","@x":"Microsoft.Data.SqlClient.SqlException (0x80131904): Syntax error parsing SQL identifier ''.\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.RunExecuteNonQueryTds(String methodName, Boolean isAsync, Int32 timeout, Boolean asyncWrite)\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 268\r\n at Umbraco.Cms.Infrastructure.Persistence.FaultHandling.FaultHandlingDbCommand.<ExecuteNonQuery>b__32_0()\r\n at Umbraco.Cms.Infrastructure.Persistence.FaultHandling.FaultHandlingDbCommand.<>c__DisplayClass38_01.