ALTER TABLE `cmsPropertyTypeGroup` ADD COLUMN `uniqueID` GUID NOT NULL
Getting following error while upgrading Umbraco.
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').
Error message In UmbracoTraceLog.txt:
2017-11-08 09:57:04,649 [P9492/D2/T13] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 4: ALTER TABLE cmsPropertyTypeGroup ADD COLUMN uniqueID GUID NOT NULL
2017-11-08 09:57:04,655 [P9492/D2/T13] 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
Here I guess GUID in alter table query is not working for MySql. I've select MySql as database.
ALTER TABLE `cmsPropertyTypeGroup` ADD COLUMN `uniqueID` GUID NOT NULL
Getting following error while upgrading Umbraco.
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').
Error message In UmbracoTraceLog.txt:
2017-11-08 09:57:04,649 [P9492/D2/T13] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 4: ALTER TABLE
cmsPropertyTypeGroupADD COLUMNuniqueIDGUID NOT NULL2017-11-08 09:57:04,655 [P9492/D2/T13] 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
Here I guess GUID in alter table query is not working for MySql. I've select MySql as database.
Any idea/suggestion?
is working on a reply...