Copied to clipboard

Flag this post as spam?

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


  • Dennis Öhman 32 posts 177 karma points c-trib
    Feb 16, 2016 @ 14:47
    Dennis Öhman
    0

    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

  • Dennis Öhman 32 posts 177 karma points c-trib
    Feb 17, 2016 @ 07:41
    Dennis Öhman
    0

    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 ?

  • Dennis Öhman 32 posts 177 karma points c-trib
    Feb 17, 2016 @ 07:44
    Dennis Öhman
    0

    Ah, no, it will not work, I see that it wont run the rest.. damn

Please Sign in or register to post replies

Write your reply to:

Draft