Error upgradering 7.3.5 to 7.4.0 with MySQL 5.6.15 = ALTER TABLE `cmsPropertyTypeGroup` ADD COLUMN `uniqueID` GUID NOT NULL
Any ideas?
Log
2016-02-16 15:24:08,667 [P9712/D6/T16] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Initializing database migrations
2016-02-16 15:24:08,685 [P9712/D6/T16] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddDataDecimalColumn' to context
2016-02-16 15:24:08,700 [P9712/D6/T16] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddUniqueIdPropertyTypeGroupColumn' to context
2016-02-16 15:24:08,704 [P9712/D6/T16] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'EnsureContentTypeUniqueIdsAreConsistent' to context
2016-02-16 15:24:08,708 [P9712/D6/T16] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'FixListViewMediaSortOrder' to context
2016-02-16 15:24:08,720 [P9712/D6/T16] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'RemoveParentIdPropertyTypeGroupColumn' to context
2016-02-16 15:24:08,726 [P9712/D6/T16] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddUmbracoDeployTables' to context
2016-02-16 15:24:08,728 [P9712/D6/T16] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 1: ALTER TABLE cmsPropertyTypeGroup ADD COLUMN uniqueID GUID NOT NULL
2016-02-16 15:24:08,729 [P9712/D6/T16] ERROR Umbraco.Core.Persistence.UmbracoDatabase - Database exception occurred
MySql.Data.MySqlClient.MySqlException (0x80004005): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GUID NOT NULL' at line 1
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteNonQuery() in c:\Code\github\SamSaffron\MiniProfiler\StackExchange.Profiling\Data\ProfiledDbCommand.cs:line 279
at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>cDisplayClass1.0() in c:\projects\umbraco-cms-xtjqd\src\Umbraco.Core\Persistence\PetaPocoCommandExtensions.cs:line 56
at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func1 func) in c:\projects\umbraco-cms-xtjqd\src\Umbraco.Core\Persistence\FaultHandling\RetryPolicy.cs:line 172
at Umbraco.Core.Persistence.Database.Execute(String sql, Object[] args) in c:\projects\umbraco-cms-xtjqd\src\Umbraco.Core\Persistence\PetaPoco.cs:line 591
2016-02-16 15:24:08,730 [P9712/D6/T16] ERROR Umbraco.Core.DatabaseContext - Database configuration failed
Umbraco.Core.Persistence.Migrations.DataLossException: An error occurred running a schema migration but the changes could not be rolled back. Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GUID NOT NULL' at line 1. In some cases, it may be required that the database be restored to it's original state before running this upgrade process again. ---> MySql.Data.MySqlClient.MySqlException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GUID NOT NULL' at line 1
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteNonQuery() in c:\Code\github\SamSaffron\MiniProfiler\StackExchange.Profiling\Data\ProfiledDbCommand.cs:line 279
at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClass1.<ExecuteNonQueryWithRetry>b__0() in c:\projects\umbraco-cms-xtjqd\src\Umbraco.Core\Persistence\PetaPocoCommandExtensions.cs:line 56
at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func1 func) in c:\projects\umbraco-cms-xtjqd\src\Umbraco.Core\Persistence\FaultHandling\RetryPolicy.cs:line 172
at Umbraco.Core.Persistence.Database.Execute(String sql, Object[] args) in c:\projects\umbraco-cms-xtjqd\src\Umbraco.Core\Persistence\PetaPoco.cs:line 606
at Umbraco.Core.Persistence.Migrations.MigrationRunner.ExecuteMigrations(IMigrationContext context, Database database) in c:\projects\umbraco-cms-xtjqd\src\Umbraco.Core\Persistence\Migrations\MigrationRunner.cs:line 278
at Umbraco.Core.Persistence.Migrations.MigrationRunner.Execute(Database database, DatabaseProviders databaseProvider, Boolean isUpgrade) in c:\projects\umbraco-cms-xtjqd\src\Umbraco.Core\Persistence\Migrations\MigrationRunner.cs:line 106
--- End of inner exception stack trace ---
at Umbraco.Core.Persistence.Migrations.MigrationRunner.Execute(Database database, DatabaseProviders databaseProvider, Boolean isUpgrade) in c:\projects\umbraco-cms-xtjqd\src\Umbraco.Core\Persistence\Migrations\MigrationRunner.cs:line 121
at Umbraco.Core.DatabaseContext.UpgradeSchemaAndData(IMigrationEntryService migrationEntryService) in c:\projects\umbraco-cms-xtjqd\src\Umbraco.Core\DatabaseContext.cs:line 668
2016-02-16 15:24:08,730 [P9712/D6/T16] INFO Umbraco.Core.DatabaseContext - The database schema validation produced the following summary:
The following tables were found in the database, but are not in the current schema:
ufrecorddatabit,ufrecorddatadatetime,ufrecorddatainteger,ufrecorddatalongstring,ufrecorddatastring,ufrecordfields,ufrecords,ufuserformsecurity,ufusersecurity,umbracoDeployChecksum,umbracoDeployDependency
The following columns were found in the database, but are not in the current schema:
cmspropertytypegroup,parentGroupId,ufrecorddatabit,Id,ufrecorddatabit,Key,ufrecorddatabit,Value,ufrecorddatadatetime,Id,ufrecorddatadatetime,Key,ufrecorddatadatetime,Value,ufrecorddatainteger,Id,ufrecorddatainteger,Key,ufrecorddatainteger,Value,ufrecorddatalongstring,Id,ufrecorddatalongstring,Key,ufrecorddatalongstring,Value,ufrecorddatastring,Id,ufrecorddatastring,Key,ufrecorddatastring,Value,ufrecordfields,Key,ufrecordfields,FieldId,ufrecordfields,Record,ufrecordfields,Alias,ufrecordfields,DataType,ufrecords,Id,ufrecords,Form,ufrecords,Created,ufrecords,Updated,ufrecords,CurrentPage,ufrecords,UmbracoPageId,ufrecords,IP,ufrecords,MemberKey,ufrecords,UniqueId,ufrecords,State,ufrecords,RecordData,ufuserformsecurity,Id,ufuserformsecurity,User,ufuserformsecurity,Form,ufuserformsecurity,HasAccess,ufuserformsecurity,AllowInEditor,ufuserformsecurity,SecurityType,ufusersecurity,User,ufusersecurity,ManageDataSources,ufusersecurity,ManagePreValueSources,ufusersecurity,ManageWorkflows,ufusersecurity,ManageForms,cmsPropertyTypeGroup,uniqueID,cmsPropertyData,dataDecimal,umbracoDeployChecksum,id,umbracoDeployChecksum,entityType,umbracoDeployChecksum,entityGuid,umbracoDeployChecksum,entityPath,umbracoDeployChecksum,localChecksum,umbracoDeployChecksum,compositeChecksum,umbracoDeployDependency,sourceId,umbracoDeployDependency,targetId,umbracoDeployDependency,mode
The following indexes were found in the database, but are not in the current schema:
IXdatabitrecordfield,IXdatadatetimerecordfield,IXdataintegerrecordfield,IXdatalongstringrecordfield,IXdatastringrecordfield,IXcmsPropertyTypeGroupUniqueID,IXumbracoDeployChecksum
Please note that the constraints could not be validated because the current dataprovider is MySql.
2016-02-16 15:24:08,731 [P9712/D6/T16] ERROR Umbraco.Web.Install.Controllers.InstallApiController - Installation step DatabaseUpgrade failed.
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Umbraco.Web.Install.InstallException: The database failed to upgrade. ERROR: The database configuration failed with the following message: An error occurred running a schema migration but the changes could not be rolled back. Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GUID NOT NULL' at line 1. In some cases, it may be required that the database be restored to it's original state before running this upgrade process again.
Please check log file for additional information (can be found in '/App_Data/Logs/UmbracoTraceLog.txt')
at Umbraco.Web.Install.InstallSteps.DatabaseUpgradeStep.Execute(Object model) in c:\projects\umbraco-cms-xtjqd\src\Umbraco.Web\Install\InstallSteps\DatabaseUpgradeStep.cs:line 37
--- End of inner exception stack trace ---
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at Umbraco.Web.Install.Controllers.InstallApiController.ExecuteStep(InstallSetupStep step, JToken instruction) in c:\projects\umbraco-cms-xtjqd\src\Umbraco.Web\Install\Controllers\InstallApiController.cs:line 269
2016-02-16 15:24:08,731 [P9712/D6/T16] INFO Umbraco.Web.Install.Controllers.InstallApiController - Step completed (took 75ms)
2016-02-16 15:24:08,731 [P9712/D6/T16] ERROR Umbraco.Web.Install.Controllers.InstallApiController - An error occurred during installation step DatabaseUpgrade
Error upgradering 7.3.5 to 7.4.0 with MySQL 5.6.15 = ALTER TABLE `cmsPropertyTypeGroup` ADD COLUMN `uniqueID` GUID NOT NULL
Any ideas?
Log
2016-02-16 15:24:08,667 [P9712/D6/T16] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Initializing database migrations 2016-02-16 15:24:08,685 [P9712/D6/T16] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddDataDecimalColumn' to context 2016-02-16 15:24:08,700 [P9712/D6/T16] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddUniqueIdPropertyTypeGroupColumn' to context 2016-02-16 15:24:08,704 [P9712/D6/T16] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'EnsureContentTypeUniqueIdsAreConsistent' to context 2016-02-16 15:24:08,708 [P9712/D6/T16] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'FixListViewMediaSortOrder' to context 2016-02-16 15:24:08,720 [P9712/D6/T16] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'RemoveParentIdPropertyTypeGroupColumn' to context 2016-02-16 15:24:08,726 [P9712/D6/T16] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddUmbracoDeployTables' to context 2016-02-16 15:24:08,728 [P9712/D6/T16] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 1: ALTER TABLE
cmsPropertyTypeGroup
ADD COLUMNuniqueID
GUID NOT NULL2016-02-16 15:24:08,729 [P9712/D6/T16] ERROR Umbraco.Core.Persistence.UmbracoDatabase - Database exception occurred MySql.Data.MySqlClient.MySqlException (0x80004005): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GUID NOT NULL' at line 1 at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId) at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force) at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery() at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteNonQuery() in c:\Code\github\SamSaffron\MiniProfiler\StackExchange.Profiling\Data\ProfiledDbCommand.cs:line 279 at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>cDisplayClass1.0() in c:\projects\umbraco-cms-xtjqd\src\Umbraco.Core\Persistence\PetaPocoCommandExtensions.cs:line 56 at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func
1 func) in c:\projects\umbraco-cms-xtjqd\src\Umbraco.Core\Persistence\FaultHandling\RetryPolicy.cs:line 172 at Umbraco.Core.Persistence.Database.Execute(String sql, Object[] args) in c:\projects\umbraco-cms-xtjqd\src\Umbraco.Core\Persistence\PetaPoco.cs:line 591 2016-02-16 15:24:08,730 [P9712/D6/T16] ERROR Umbraco.Core.DatabaseContext - Database configuration failed Umbraco.Core.Persistence.Migrations.DataLossException: An error occurred running a schema migration but the changes could not be rolled back. Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GUID NOT NULL' at line 1. In some cases, it may be required that the database be restored to it's original state before running this upgrade process again. ---> MySql.Data.MySqlClient.MySqlException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GUID NOT NULL' at line 1 at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId) at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force) at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery() at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteNonQuery() in c:\Code\github\SamSaffron\MiniProfiler\StackExchange.Profiling\Data\ProfiledDbCommand.cs:line 279 at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClass1.<ExecuteNonQueryWithRetry>b__0() in c:\projects\umbraco-cms-xtjqd\src\Umbraco.Core\Persistence\PetaPocoCommandExtensions.cs:line 56 at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func
1 func) in c:\projects\umbraco-cms-xtjqd\src\Umbraco.Core\Persistence\FaultHandling\RetryPolicy.cs:line 172 at Umbraco.Core.Persistence.Database.Execute(String sql, Object[] args) in c:\projects\umbraco-cms-xtjqd\src\Umbraco.Core\Persistence\PetaPoco.cs:line 606 at Umbraco.Core.Persistence.Migrations.MigrationRunner.ExecuteMigrations(IMigrationContext context, Database database) in c:\projects\umbraco-cms-xtjqd\src\Umbraco.Core\Persistence\Migrations\MigrationRunner.cs:line 278 at Umbraco.Core.Persistence.Migrations.MigrationRunner.Execute(Database database, DatabaseProviders databaseProvider, Boolean isUpgrade) in c:\projects\umbraco-cms-xtjqd\src\Umbraco.Core\Persistence\Migrations\MigrationRunner.cs:line 106 --- End of inner exception stack trace --- at Umbraco.Core.Persistence.Migrations.MigrationRunner.Execute(Database database, DatabaseProviders databaseProvider, Boolean isUpgrade) in c:\projects\umbraco-cms-xtjqd\src\Umbraco.Core\Persistence\Migrations\MigrationRunner.cs:line 121 at Umbraco.Core.DatabaseContext.UpgradeSchemaAndData(IMigrationEntryService migrationEntryService) in c:\projects\umbraco-cms-xtjqd\src\Umbraco.Core\DatabaseContext.cs:line 668 2016-02-16 15:24:08,730 [P9712/D6/T16] INFO Umbraco.Core.DatabaseContext - The database schema validation produced the following summary: The following tables were found in the database, but are not in the current schema: ufrecorddatabit,ufrecorddatadatetime,ufrecorddatainteger,ufrecorddatalongstring,ufrecorddatastring,ufrecordfields,ufrecords,ufuserformsecurity,ufusersecurity,umbracoDeployChecksum,umbracoDeployDependencyThe following columns were found in the database, but are not in the current schema: cmspropertytypegroup,parentGroupId,ufrecorddatabit,Id,ufrecorddatabit,Key,ufrecorddatabit,Value,ufrecorddatadatetime,Id,ufrecorddatadatetime,Key,ufrecorddatadatetime,Value,ufrecorddatainteger,Id,ufrecorddatainteger,Key,ufrecorddatainteger,Value,ufrecorddatalongstring,Id,ufrecorddatalongstring,Key,ufrecorddatalongstring,Value,ufrecorddatastring,Id,ufrecorddatastring,Key,ufrecorddatastring,Value,ufrecordfields,Key,ufrecordfields,FieldId,ufrecordfields,Record,ufrecordfields,Alias,ufrecordfields,DataType,ufrecords,Id,ufrecords,Form,ufrecords,Created,ufrecords,Updated,ufrecords,CurrentPage,ufrecords,UmbracoPageId,ufrecords,IP,ufrecords,MemberKey,ufrecords,UniqueId,ufrecords,State,ufrecords,RecordData,ufuserformsecurity,Id,ufuserformsecurity,User,ufuserformsecurity,Form,ufuserformsecurity,HasAccess,ufuserformsecurity,AllowInEditor,ufuserformsecurity,SecurityType,ufusersecurity,User,ufusersecurity,ManageDataSources,ufusersecurity,ManagePreValueSources,ufusersecurity,ManageWorkflows,ufusersecurity,ManageForms,cmsPropertyTypeGroup,uniqueID,cmsPropertyData,dataDecimal,umbracoDeployChecksum,id,umbracoDeployChecksum,entityType,umbracoDeployChecksum,entityGuid,umbracoDeployChecksum,entityPath,umbracoDeployChecksum,localChecksum,umbracoDeployChecksum,compositeChecksum,umbracoDeployDependency,sourceId,umbracoDeployDependency,targetId,umbracoDeployDependency,mode
The following indexes were found in the database, but are not in the current schema: IXdatabitrecordfield,IXdatadatetimerecordfield,IXdataintegerrecordfield,IXdatalongstringrecordfield,IXdatastringrecordfield,IXcmsPropertyTypeGroupUniqueID,IXumbracoDeployChecksum
Please note that the constraints could not be validated because the current dataprovider is MySql.
2016-02-16 15:24:08,731 [P9712/D6/T16] ERROR Umbraco.Web.Install.Controllers.InstallApiController - Installation step DatabaseUpgrade failed. System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Umbraco.Web.Install.InstallException: The database failed to upgrade. ERROR: The database configuration failed with the following message: An error occurred running a schema migration but the changes could not be rolled back. Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GUID NOT NULL' at line 1. In some cases, it may be required that the database be restored to it's original state before running this upgrade process again. Please check log file for additional information (can be found in '/App_Data/Logs/UmbracoTraceLog.txt') at Umbraco.Web.Install.InstallSteps.DatabaseUpgradeStep.Execute(Object model) in c:\projects\umbraco-cms-xtjqd\src\Umbraco.Web\Install\InstallSteps\DatabaseUpgradeStep.cs:line 37 --- End of inner exception stack trace --- at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at Umbraco.Web.Install.Controllers.InstallApiController.ExecuteStep(InstallSetupStep step, JToken instruction) in c:\projects\umbraco-cms-xtjqd\src\Umbraco.Web\Install\Controllers\InstallApiController.cs:line 269 2016-02-16 15:24:08,731 [P9712/D6/T16] INFO Umbraco.Web.Install.Controllers.InstallApiController - Step completed (took 75ms) 2016-02-16 15:24:08,731 [P9712/D6/T16] ERROR Umbraco.Web.Install.Controllers.InstallApiController - An error occurred during installation step DatabaseUpgrade
I see that the 7.4 migration adds "uniqueID" to "cmsPropertyTypeGroup"
https://github.com/umbraco/Umbraco-CMS/blob/7.4.0/src/Umbraco.Core/Persistence/Migrations/Upgrades/TargetVersionSevenFourZero/AddUniqueIdPropertyTypeGroupColumn.cs
Can I add the column manually to the table, non-nullable, char(36) , default empty?
or will this ?
Ah, no, it will not work, I see that it wont run the rest.. damn
is working on a reply...