Database Update LOCALE_NAMES error

markelachkar9 · January 18, 2018, 7:16am

Every time I try to update my database or even start the app it gives me the following error:

WARNING: Failed to execute: alter table SYS_CATEGORY_ATTR add LOCALE_NAMES varchar(1000) because: Duplicate column name ‘LOCALE_NAMES’
:app-core:updateDb FAILED

FAILURE: Build failed with an exception.

What went wrong:
Execution failed for task ‘:app-core:updateDb’.

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name ‘LOCALE_NAMES’

I’m not sure what’s causing this and I’m having to re-build my database every time i change anything on the system just to start up

Pinyazhin · January 18, 2018, 7:35am

Hi!

Can you clarify what version of Studio and platform do you use?
Did you migrate your project to another version of a platform?

markelachkar9 · January 18, 2018, 7:47am

Hello!

I’m using Studio 6.7.6 with platform 6.7.6 also.
I recently migrated but i’m not sure if this issue happened after the update or was happening beforehand

Pinyazhin · January 18, 2018, 7:57am

And from which version of the platform did you migrate?

markelachkar9 · January 18, 2018, 7:58am

6.7.4
I’m gonna try to revert back to check if this issue persists

Pinyazhin · January 18, 2018, 8:32am

Could you clarify if this issue appeared after migrating to platform 6.7.4? Does the issue appear during platform version migration or if you try to apply your update scripts?

markelachkar9 · January 18, 2018, 11:41am

Basically it happened after going from 6.7.4 to 6.7.6 when i was trying to update the database…
I went back to 6.7.4 and recreated the database. But I’m not really sure if this due to migration or something else might have caused it…

Pinyazhin · January 18, 2018, 2:42pm

Could you print the content of SYS_DB_CHANGELOG table and attach it.
Please, check that the LOCALE_NAMES column exists in your database.

markelachkar9 · February 12, 2018, 9:07am

HEllo!
Sorry for the late reply almost forgot about the issue.

Here’s the db change log, and yes LOCALE_NAMES does exist.

-- --------------------------------------------------------
-- Host:                         127.0.0.1
-- Server version:               5.7.19-log - MySQL Community Server (GPL)
-- Server OS:                    Win64
-- HeidiSQL Version:             9.3.0.4984
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

-- Dumping database structure for rpac2
CREATE DATABASE IF NOT EXISTS `rpac2` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `rpac2`;


-- Dumping structure for table rpac2.sys_db_changelog
CREATE TABLE IF NOT EXISTS `sys_db_changelog` (
  `SCRIPT_NAME` varchar(190) NOT NULL,
  `CREATE_TS` datetime DEFAULT CURRENT_TIMESTAMP,
  `IS_INIT` int(11) DEFAULT '0',
  PRIMARY KEY (`SCRIPT_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Dumping data for table rpac2.sys_db_changelog: ~169 rows (approximately)
/*!40000 ALTER TABLE `sys_db_changelog` DISABLE KEYS */;
INSERT IGNORE INTO `sys_db_changelog` (`SCRIPT_NAME`, `CREATE_TS`, `IS_INIT`) VALUES
	('10-cuba/init/mysql/create-db.sql', '2017-12-05 13:48:15', 1),
	('10-cuba/update/mysql/16/160405-createUniqSysCategory.sql', '2017-12-05 13:50:16', 1),
	('10-cuba/update/mysql/16/160420-createUpdateTsIndexOnSysSendingMessage.sql', '2017-12-05 13:50:16', 1),
	('10-cuba/update/mysql/16/160616-addSizeCategoryAttribute.sql', '2017-12-05 13:50:16', 1),
	('10-cuba/update/mysql/16/160626-createIndexOnFinishTimeScheduledExecution.sql', '2017-12-05 13:50:16', 1),
	('10-cuba/update/mysql/16/160725-anonymousLogin.sql', '2017-12-05 13:50:16', 1),
	('10-cuba/update/mysql/16/160916-addEntityIdToFtsQueue.sql', '2017-12-05 13:50:16', 1),
	('10-cuba/update/mysql/16/161024-collectionDynamicAttributes.sql', '2017-12-05 13:50:16', 1),
	('10-cuba/update/mysql/16/161025-sysAttrValueParentConstraint.sql', '2017-12-05 13:50:16', 1),
	('10-cuba/update/mysql/16/161102-setIsCollectionForExistingCategoryAttrs.sql', '2017-12-05 13:50:16', 1),
	('10-cuba/update/mysql/16/161124-FilterXmlInCategoryAttr.sql', '2017-12-05 13:50:16', 1),
	('10-cuba/update/mysql/16/161124-joinAndWhereInCategoryAttr.sql', '2017-12-05 13:50:16', 1),
	('10-cuba/update/mysql/16/270916-addEntityIdToQueryResult.sql', '2017-12-05 13:50:16', 1),
	('10-cuba/update/mysql/17/170214-addEntityIdToSnapshot.sql', '2017-12-05 13:50:16', 1),
	('10-cuba/update/mysql/17/170215-addEntityIdToEntityLog.sql', '2017-12-05 13:50:16', 1),
	('10-cuba/update/mysql/17/170221-addEntityIdToAttributeValue.sql', '2017-12-05 13:50:16', 1),
	('10-cuba/update/mysql/17/170228-createRestApiTokenTable.sql', '2018-02-12 11:05:10', 0),
	('10-cuba/update/mysql/17/170502-createSessionHistoryTable.sql', '2017-12-05 13:50:16', 1),
	('10-cuba/update/mysql/17/170620-alterConstraints.sql', '2017-12-05 13:50:17', 1),
	('10-cuba/update/mysql/17/170712-createLocalizedConstraintMessageTable.sql', '2017-12-05 13:50:17', 1),
	('10-cuba/update/mysql/17/280217-createRestApiTokenTable.sql', '2017-12-05 13:50:17', 1),
	('20-reports/init/mysql/create-db.sql', '2017-12-12 08:07:45', 1),
	('20-reports/update/mysql/17/170131-addFieldsForAvailableReports.sql', '2017-12-12 08:07:45', 1),
	('20-reports/update/mysql/17/170201-migrateSecurityIndex.upgrade.groovy', '2017-12-12 08:07:45', 1),
	('50-r-pac/init/mysql/10.create-db.sql', '2017-12-05 13:48:29', 1),
	('50-r-pac/init/mysql/20.create-db.sql', '2017-12-05 13:50:15', 1),
	('50-r-pac/init/mysql/30.create-db.sql', '2017-12-05 13:50:15', 1),
	('50-r-pac/update/mysql/17/171002-1-updateItem.sql', '2017-12-05 13:50:17', 1),
	('50-r-pac/update/mysql/17/171002-2-updateItem.sql', '2017-12-05 13:50:17', 1),
	('50-r-pac/update/mysql/17/171002-2-updateItem01.sql', '2017-12-05 13:50:17', 1),
	('50-r-pac/update/mysql/17/171002-2-updateItem02.sql', '2017-12-05 13:50:17', 1),
	('50-r-pac/update/mysql/17/171003-1-updateUserFeature.sql', '2017-12-05 13:50:17', 1),
	('50-r-pac/update/mysql/17/171003-2-updateUserFeature.sql', '2017-12-05 13:50:17', 1),
	('50-r-pac/update/mysql/17/171003-2-updateUserFeature01.sql', '2017-12-05 13:50:17', 1),
	('50-r-pac/update/mysql/17/171006-1-updateFeature.sql', '2017-12-05 13:50:17', 1),
	('50-r-pac/update/mysql/17/171006-2-updateFeature.sql', '2017-12-05 13:50:17', 1),
	('50-r-pac/update/mysql/17/171006-2-updateFeature01.sql', '2017-12-05 13:50:17', 1),
	('50-r-pac/update/mysql/17/171006-2-updateUserFeature.sql', '2017-12-05 13:50:17', 1),
	('50-r-pac/update/mysql/17/171012-1-createOperation.sql', '2017-12-05 13:50:17', 1),
	('50-r-pac/update/mysql/17/171012-2-updateOperation.sql', '2017-12-05 13:50:17', 1),
	('50-r-pac/update/mysql/17/171012-2-updateOrderContainer.sql', '2017-12-05 13:50:17', 1),
	('50-r-pac/update/mysql/17/171012-2-updateOrderContainer01.sql', '2017-12-05 13:50:17', 1),
	('50-r-pac/update/mysql/17/171013-1-createPackingOperation.sql', '2017-12-05 13:50:17', 1),
	('50-r-pac/update/mysql/17/171013-1-createReceivingOperation.sql', '2017-12-05 13:50:17', 1),
	('50-r-pac/update/mysql/17/171013-1-createShippingOperation.sql', '2017-12-05 13:50:17', 1),
	('50-r-pac/update/mysql/17/171013-1-updateOperation.sql', '2017-12-05 13:50:17', 1),
	('50-r-pac/update/mysql/17/171013-1-updateOperation01.sql', '2017-12-05 13:50:17', 1),
	('50-r-pac/update/mysql/17/171013-1-updateOperation02.sql', '2017-12-05 13:50:17', 1),
	('50-r-pac/update/mysql/17/171013-1-updateOrderContainer.sql', '2017-12-05 13:50:18', 1),
	('50-r-pac/update/mysql/17/171013-1-updateOrderContainer01.sql', '2017-12-05 13:50:18', 1),
	('50-r-pac/update/mysql/17/171013-1-updateReceivingOperation.sql', '2017-12-05 13:50:18', 1),
	('50-r-pac/update/mysql/17/171013-1-updateReceivingOperation01.sql', '2017-12-05 13:50:18', 1),
	('50-r-pac/update/mysql/17/171013-1-updateReceivingOperation02.sql', '2017-12-05 13:50:18', 1),
	('50-r-pac/update/mysql/17/171013-2-createPackingOperation.sql', '2017-12-05 13:50:18', 1),
	('50-r-pac/update/mysql/17/171013-2-createReceivingOperation.sql', '2017-12-05 13:50:18', 1),
	('50-r-pac/update/mysql/17/171013-2-createShippingOperation.sql', '2017-12-05 13:50:18', 1),
	('50-r-pac/update/mysql/17/171013-2-updateOperation.sql', '2017-12-05 13:50:18', 1),
	('50-r-pac/update/mysql/17/171013-2-updateOperation01.sql', '2017-12-05 13:50:18', 1),
	('50-r-pac/update/mysql/17/171013-2-updateOperation02.sql', '2017-12-05 13:50:18', 1),
	('50-r-pac/update/mysql/17/171013-2-updateOperation03.sql', '2017-12-05 13:50:18', 1),
	('50-r-pac/update/mysql/17/171013-2-updateOperation04.sql', '2017-12-05 13:50:18', 1),
	('50-r-pac/update/mysql/17/171013-2-updateOperation05.sql', '2017-12-05 13:50:18', 1),
	('50-r-pac/update/mysql/17/171013-2-updateOperation06.sql', '2017-12-05 13:50:18', 1),
	('50-r-pac/update/mysql/17/171013-2-updateOperation07.sql', '2017-12-05 13:50:18', 1),
	('50-r-pac/update/mysql/17/171013-2-updateOperation08.sql', '2017-12-05 13:50:18', 1),
	('50-r-pac/update/mysql/17/171013-2-updateOperation09.sql', '2017-12-05 13:50:18', 1),
	('50-r-pac/update/mysql/17/171013-2-updateOperation10.sql', '2017-12-05 13:50:18', 1),
	('50-r-pac/update/mysql/17/171013-2-updateOperation11.sql', '2017-12-05 13:50:18', 1),
	('50-r-pac/update/mysql/17/171013-2-updateOperation12.sql', '2017-12-05 13:50:18', 1),
	('50-r-pac/update/mysql/17/171013-2-updateOperation13.sql', '2017-12-05 13:50:18', 1),
	('50-r-pac/update/mysql/17/171013-2-updateOperation14.sql', '2017-12-05 13:50:18', 1),
	('50-r-pac/update/mysql/17/171013-2-updateOperation15.sql', '2017-12-05 13:50:19', 1),
	('50-r-pac/update/mysql/17/171013-2-updateOperation16.sql', '2017-12-05 13:50:19', 1),
	('50-r-pac/update/mysql/17/171013-2-updateOperation17.sql', '2017-12-05 13:50:19', 1),
	('50-r-pac/update/mysql/17/171013-2-updateOrderContainer.sql', '2017-12-05 13:50:19', 1),
	('50-r-pac/update/mysql/17/171013-2-updateOrderContainer01.sql', '2017-12-05 13:50:19', 1),
	('50-r-pac/update/mysql/17/171013-2-updatePackingOperation.sql', '2017-12-05 13:50:19', 1),
	('50-r-pac/update/mysql/17/171013-2-updateReceivingOperation.sql', '2017-12-05 13:50:19', 1),
	('50-r-pac/update/mysql/17/171016-2-updateOperation.sql', '2017-12-05 13:50:19', 1),
	('50-r-pac/update/mysql/17/171016-2-updateOperation01.sql', '2017-12-05 13:50:19', 1),
	('50-r-pac/update/mysql/17/171023-0-dropCycleCountOrder.sql', '2017-12-05 13:50:19', 1),
	('50-r-pac/update/mysql/17/171023-0-dropOcItemStatus.sql', '2017-12-05 13:50:19', 1),
	('50-r-pac/update/mysql/17/171023-0-dropOcsItemStatus.sql', '2017-12-05 13:50:19', 1),
	('50-r-pac/update/mysql/17/171023-0-dropOrderContainer.sql', '2017-12-05 13:50:19', 1),
	('50-r-pac/update/mysql/17/171023-0-dropPackingOrder.sql', '2017-12-05 13:50:19', 1),
	('50-r-pac/update/mysql/17/171023-0-dropReceivingOrder.sql', '2017-12-05 13:50:19', 1),
	('50-r-pac/update/mysql/17/171023-0-dropShippingOrder.sql', '2017-12-05 13:50:19', 1),
	('50-r-pac/update/mysql/17/171023-1-createAddedSerializedItem.sql', '2017-12-05 13:50:19', 1),
	('50-r-pac/update/mysql/17/171023-1-createCycleCountOperation.sql', '2017-12-05 13:50:19', 1),
	('50-r-pac/update/mysql/17/171023-1-createSerializedItemResult.sql', '2017-12-05 13:50:19', 1),
	('50-r-pac/update/mysql/17/171023-1-updateCycleCountOperation.sql', '2017-12-05 13:50:19', 1),
	('50-r-pac/update/mysql/17/171023-1-updateOcItemStatus.sql', '2017-12-05 13:50:19', 1),
	('50-r-pac/update/mysql/17/171023-1-updateOcItemStatus01.sql', '2017-12-05 13:50:20', 1),
	('50-r-pac/update/mysql/17/171023-1-updateOrderContainer.sql', '2017-12-05 13:50:20', 1),
	('50-r-pac/update/mysql/17/171023-1-updateOrderContainer01.sql', '2017-12-05 13:50:20', 1),
	('50-r-pac/update/mysql/17/171023-2-createAddedSerializedItem.sql', '2017-12-05 13:50:20', 1),
	('50-r-pac/update/mysql/17/171023-2-createCycleCountOperation.sql', '2017-12-05 13:50:20', 1),
	('50-r-pac/update/mysql/17/171023-2-createSerializedItemResult.sql', '2017-12-05 13:50:20', 1),
	('50-r-pac/update/mysql/17/171023-2-updateContainer.sql', '2017-12-05 13:50:20', 1),
	('50-r-pac/update/mysql/17/171023-2-updateContainer01.sql', '2017-12-05 13:50:20', 1),
	('50-r-pac/update/mysql/17/171023-2-updateCycleCountOperation.sql', '2017-12-05 13:50:20', 1),
	('50-r-pac/update/mysql/17/171023-2-updateOcItemStatus.sql', '2017-12-05 13:50:20', 1),
	('50-r-pac/update/mysql/17/171023-2-updateOcItemStatus01.sql', '2017-12-05 13:50:20', 1),
	('50-r-pac/update/mysql/17/171023-2-updateOperation01.sql', '2017-12-05 13:50:20', 1),
	('50-r-pac/update/mysql/17/171023-2-updateOrderContainer.sql', '2017-12-05 13:50:20', 1),
	('50-r-pac/update/mysql/17/171023-2-updatePackingOperation.sql', '2017-12-05 13:50:20', 1),
	('50-r-pac/update/mysql/17/171023-2-updatePackingOperation01.sql', '2017-12-05 13:50:20', 1),
	('50-r-pac/update/mysql/17/171023-2-updatePackingOperation02.sql', '2017-12-05 13:50:20', 1),
	('50-r-pac/update/mysql/17/171023-2-updateReceivingOperation.sql', '2017-12-05 13:50:20', 1),
	('50-r-pac/update/mysql/17/171023-2-updateReceivingOperation01.sql', '2017-12-05 13:50:20', 1),
	('50-r-pac/update/mysql/17/171023-2-updateSerializedItemResult.sql', '2017-12-05 13:50:20', 1),
	('50-r-pac/update/mysql/17/171023-2-updateShippingOperation.sql', '2017-12-05 13:50:20', 1),
	('50-r-pac/update/mysql/17/171023-2-updateShippingOperation01.sql', '2017-12-05 13:50:20', 1),
	('50-r-pac/update/mysql/17/171024-1-updateOperation.sql', '2017-12-05 13:50:20', 1),
	('50-r-pac/update/mysql/17/171024-1-updateSerializedItemResult.sql', '2017-12-05 13:50:21', 1),
	('50-r-pac/update/mysql/17/171024-2-updateOperation.sql', '2017-12-05 13:50:21', 1),
	('50-r-pac/update/mysql/17/171024-2-updateOperation01.sql', '2017-12-05 13:50:21', 1),
	('50-r-pac/update/mysql/17/171024-2-updateOperation02.sql', '2017-12-05 13:50:21', 1),
	('50-r-pac/update/mysql/17/171024-2-updateOperation03.sql', '2017-12-05 13:50:21', 1),
	('50-r-pac/update/mysql/17/171024-2-updateSerializedItemResult.sql', '2017-12-05 13:50:21', 1),
	('50-r-pac/update/mysql/17/171024-2-updateSerializedItemResult01.sql', '2017-12-05 13:50:21', 1),
	('50-r-pac/update/mysql/17/171024-2-updateShippingOperation.sql', '2017-12-05 13:50:21', 1),
	('50-r-pac/update/mysql/17/171026-0-dropCycleCountSerializedItemResult.sql', '2017-12-05 13:50:21', 1),
	('50-r-pac/update/mysql/17/171026-1-createCcItemResult.sql', '2017-12-05 13:50:21', 1),
	('50-r-pac/update/mysql/17/171026-1-createCycleCountSerializedItemResult.sql', '2017-12-05 13:50:21', 1),
	('50-r-pac/update/mysql/17/171026-2-createCcItemResult.sql', '2017-12-05 13:50:21', 1),
	('50-r-pac/update/mysql/17/171026-2-createCycleCountSerializedItemResult.sql', '2017-12-05 13:50:21', 1),
	('50-r-pac/update/mysql/17/171026-2-updateCycleCountOperation.sql', '2017-12-05 13:50:21', 1),
	('50-r-pac/update/mysql/17/171026-2-updateCycleCountOperation01.sql', '2017-12-05 13:50:21', 1),
	('50-r-pac/update/mysql/17/171026-2-updateCycleCountOperation02.sql', '2017-12-05 13:50:21', 1),
	('50-r-pac/update/mysql/17/171026-2-updateCycleCountSerializedItemResult.sql', '2017-12-05 13:50:21', 1),
	('50-r-pac/update/mysql/17/171026-2-updateOperation.sql', '2017-12-05 13:50:21', 1),
	('50-r-pac/update/mysql/17/171031-2-updateSerializedItemResult.sql', '2017-12-05 13:50:21', 1),
	('50-r-pac/update/mysql/17/171031-2-updateSerializedItemResult01.sql', '2017-12-05 13:50:21', 1),
	('50-r-pac/update/mysql/17/171106-1-updateContainer.sql', '2017-12-05 13:50:22', 1),
	('50-r-pac/update/mysql/17/171106-2-updateContainer.sql', '2017-12-05 13:50:22', 1),
	('50-r-pac/update/mysql/17/171106-2-updateContainer01.sql', '2017-12-05 13:50:22', 1),
	('50-r-pac/update/mysql/17/171106-2-updateContainer02.sql', '2017-12-05 13:50:22', 1),
	('50-r-pac/update/mysql/17/171107-2-updateContainer.sql', '2017-12-05 13:50:22', 1),
	('50-r-pac/update/mysql/17/171107-2-updateSerializedItemResult.sql', '2017-12-05 13:50:22', 1),
	('50-r-pac/update/mysql/17/171107-2-updateSerializedItemResult01.sql', '2017-12-05 13:50:22', 1),
	('50-r-pac/update/mysql/17/171108-0-dropSerialItemResultsCount.sql', '2017-12-05 13:50:22', 1),
	('50-r-pac/update/mysql/17/171108-1-createSerialItemResultsCount.sql', '2017-12-05 13:50:22', 1),
	('50-r-pac/update/mysql/17/171108-1-createSerialResultCount.sql', '2017-12-05 13:50:22', 1),
	('50-r-pac/update/mysql/17/171108-1-updateSerialItemResultsCount.sql', '2017-12-05 13:50:22', 1),
	('50-r-pac/update/mysql/17/171108-1-updateSerialResultCount.sql', '2017-12-05 13:50:22', 1),
	('50-r-pac/update/mysql/17/171108-1-updateSerialResultCount01.sql', '2017-12-05 13:50:22', 1),
	('50-r-pac/update/mysql/17/171108-2-updateSerialItemResultsCount.sql', '2017-12-05 13:50:22', 1),
	('50-r-pac/update/mysql/17/171108-2-updateSerialItemResultsCount01.sql', '2017-12-05 13:50:22', 1),
	('50-r-pac/update/mysql/17/171108-2-updateSerialItemResultsCount02.sql', '2017-12-05 13:50:22', 1),
	('50-r-pac/update/mysql/17/171108-2-updateSerialItemResultsCount03.sql', '2017-12-05 13:50:22', 1),
	('50-r-pac/update/mysql/17/171108-2-updateSerialResultCount.sql', '2017-12-05 13:50:22', 1),
	('50-r-pac/update/mysql/17/171108-2-updateSerialResultCount01.sql', '2017-12-05 13:50:22', 1),
	('50-r-pac/update/mysql/17/171108-2-updateSerialResultCount02.sql', '2017-12-05 13:50:22', 1),
	('50-r-pac/update/mysql/17/171108-2-updateSerialResultCount03.sql', '2017-12-05 13:50:22', 1),
	('50-r-pac/update/mysql/17/171108-2-updateSerialResultCount04.sql', '2017-12-05 13:50:23', 1),
	('50-r-pac/update/mysql/17/171110-2-updateSerialResultCount.sql', '2017-12-05 13:50:23', 1),
	('50-r-pac/update/mysql/17/171110-2-updateSerialResultCount01.sql', '2017-12-05 13:50:23', 1),
	('50-r-pac/update/mysql/17/171205-1-createImportSettings.sql', '2017-12-05 16:19:39', 0),
	('50-r-pac/update/mysql/17/171205-2-updateImportSettings.sql', '2017-12-05 16:27:59', 0),
	('50-r-pac/update/mysql/17/171206-2-updateContainer.sql', '2017-12-06 12:20:51', 0),
	('50-r-pac/update/mysql/17/171208-0-dropSerialOperationResultCount.sql', '2017-12-08 15:04:35', 0),
	('50-r-pac/update/mysql/17/171208-1-createSerialOperationResultCount.sql', '2017-12-08 14:44:21', 0),
	('50-r-pac/update/mysql/17/171208-2-updateSerialOperationResultCount.sql', '2017-12-08 14:46:18', 0),
	('50-r-pac/update/mysql/17/171211-0-dropOperationResult.sql', '2017-12-11 14:23:42', 0),
	('50-r-pac/update/mysql/17/171211-1-createOperationResult.sql', '2017-12-11 14:01:18', 0),
	('50-r-pac/update/mysql/17/171211-2-createOperationResult.sql', '2017-12-11 14:01:23', 0),
	('50-r-pac/update/mysql/17/171212-1-createOperationResult.sql', '2017-12-12 16:24:00', 0),
	('50-r-pac/update/mysql/17/171212-2-updateOperationResult.sql', '2017-12-12 16:27:15', 0),
	('50-r-pac/update/mysql/17/171218-2-updateOperation.sql', '2017-12-18 11:54:30', 0);
/*!40000 ALTER TABLE `sys_db_changelog` ENABLE KEYS */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

iskandarov · February 14, 2018, 10:02am

Hi,
By some reason, no upgrade-scripts appeared in 6.7 were registered in your sys_db_changelog but the LOCALE_NAMES column was created indeed. How did you create the table: using Studio or executing the create_db gradle-task in terminal?

Could you please say one more time, which version of the platform you were using before migration? And which encoding has the database?
We had an issue with MySQL update when the database was created in 6.4. Probably you are facing a similar problem.

markelachkar9 · February 14, 2018, 10:33am

I created the whole database using Studio, but the issue persisted independent of platform version. Currently using platform-6.7.10 I even recreated the database on this version and it seems to persist. I’m unable to update the database due to this error, which is probably why no scripts were registered.
Anytime i want to change anything i’m having to recreate the database from scratch. Could it be that I created the database in 6.4 and ever since the issue is persisting?