[Contentbox v4.3.0-snapshot][Contentbox v5.0.0] DB migration failes at Contentbox-Upgrade

[Christian]

Hi,
I have a Contentbox v4.3.0-snapshot setup that I would like to upgrade to the latest stable release.
I used the documentation as a guide.
At step 3 “Run the Updater” box task run Updater.cfc I am experiencing an issue where the updater tries to migrate the table IDs to UUIDs. However as the file “2020_08_24_150933_v5Upgrade.cfc” keeps beeing overwritten at the updater start, I am not able to debug which table actually throws the error. However as no success message for any table was printed it should be the first table.

What should be my next steps to upgrade my contentbox Installation to v5?

Output:

/Applications/box task run Updater.cfc
This task will update your ContentBox 4 installation to a ContentBox 5 installation.
Please make a backup of your source and your database now. 

Here are some files that will be overwritten by the updater. We will create .bak files for you.
Make sure you copy back your customizations to your new files:
- Application.cfc
- config/CacheBox.cfc
- config/Coldbox.cfc

Are you ready to continue (yes/no)?yes
Downloading ContentBox v5.0.0 assets to __temp folder...
 √ | Installing package [forgebox:contentbox-site@5.0.0]
   | √ | Installing package [forgebox:coldbox@^6.0.0]
   | √ | Installing package [forgebox:contentbox@~5.0.0]
   |   | √ | Installing package [forgebox:cborm@^3.0.0]
   |   |   | √ | Installing package [forgebox:cbvalidation@^3.0.0]
   |   |   |   | √ | Installing package [forgebox:cbi18n@^2.0.0]
   |   |   |   |   | √ | Installing package [forgebox:cbstorages@^2.4.0+64]
   |   |   | √ | Installing package [forgebox:mementifier@^2.0.0]
   |   |   | √ | Installing package [forgebox:cbstreams@^1.5.0]
   |   |   | √ | Installing package [forgebox:cbpaginator@^2.0.0]
   |   | √ | Installing package [forgebox:cbjavaloader@^2.0.0]
   |   | √ | Installing package [forgebox:cbmailservices@^1.5.0]
   |   | √ | Installing package [forgebox:cbsecurity@^2.0.0]
   |   |   | √ | Installing package [forgebox:jwt-cfml@^1.0.0]
   |   |   | √ | Installing package [forgebox:cbauth@^5.0.0]
   |   |   |   | √ | Installing package [forgebox:cbstorages@^2.0.0]
   |   |   | √ | Installing package [forgebox:cbcsrf@^2.0.0]
   |   |   |   | √ | Installing package [forgebox:cbstorages@^2.1.0]
   |   | √ | Installing package [forgebox:cbfeeds@^1.3.0]
   |   | √ | Installing package [forgebox:cbmessagebox@^4.0.0]
   |   | √ | Installing package [forgebox:cbantisamy@^1.3.1]
   |   |   | √ | Installing package [forgebox:cbjavaloader@^1.3.2]
   |   | √ | Installing package [forgebox:bcrypt@^3.0.0]
   |   |   | √ | Installing package [forgebox:cbjavaloader@^2.0.0]
   |   | √ | Installing package [forgebox:cbmarkdown@^3.4.0]
   |   |   | √ | Installing package [forgebox:cbjavaloader@^2.0.0]
   |   |   | √ | Installing package [forgebox:cbemoji@^1.0.1]
   |   | √ | Installing package [forgebox:cbSwagger@^2.3.0+131]
   |   |   | √ | Installing package [forgebox:swagger-sdk@^2.0.0]
   |   |   |   | √ | Installing package [forgebox:cbjavaloader@>0.0.9]
   |   | √ | Installing package [forgebox:jsonprettyprint@^1.4.0]
   | √ | Installing package [forgebox:commandbox-dotenv@*]
   | √ | Installing package [forgebox:commandbox-cfconfig@*]
   | √ | Installing package [forgebox:commandbox-migrations@*]
√ ContentBox assets downloaded!
Installing new ContentBox resources folder...
Copying directory <Contentbox Root>/__temp/resources/database
Copying directory <Contentbox Root>/__temp/resources/seeder
Copying <Contentbox Root>/__temp/resources/Application.cfm
Copying directory <Contentbox Root>/__temp/resources/apidocs
√ ContentBox resources installed!
Migrating your database to version: 5.0.0...
> Starting to process migration of identifiers to uuid's...
Duplicate column name 'id'
lucee.runtime.exp.DatabaseException: Duplicate column name 'id'
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
	at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:764)
	at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:781)
	at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:320)
	at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:287)
	at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:235)
	at lucee.runtime.tag.Query.executeDatasoure(Query.java:1134)
	at lucee.runtime.tag.Query._doEndTag(Query.java:699)
	at lucee.runtime.tag.Query.doEndTag(Query.java:565)
	at lucee.runtime.functions.query.QueryExecute.call(QueryExecute.java:86)
	at models.grammars.basegrammar_cfc$cf.udfCall1(/qb/models/Grammars/BaseGrammar.cfc:106)
	at models.grammars.basegrammar_cfc$cf.udfCall(/qb/models/Grammars/BaseGrammar.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:207)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:685)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:572)
	at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1930)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:900)
	at lucee.runtime.functions.dynamicEvaluation.Invoke.call(Invoke.java:49)
	at models.grammars.autodiscover_cfc$cf.udfCall(/qb/models/Grammars/AutoDiscover.cfc:27)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344)
	at lucee.runtime.type.UDFImpl.call(UDFImpl.java:217)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:684)
	at lucee.runtime.ComponentImpl.onMissingMethod(ComponentImpl.java:611)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:574)
	at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1911)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)
	at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1747)
	at models.schema.schemabuilder_cfc$cf.udfCall2(/qb/models/Schema/SchemaBuilder.cfc:230)
	at models.schema.schemabuilder_cfc$cf.udfCall(/qb/models/Schema/SchemaBuilder.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344)
	at lucee.runtime.type.UDFImpl.call(UDFImpl.java:212)
	at lucee.runtime.type.EnvUDF.call(EnvUDF.java:109)
	at lucee.runtime.functions.closure.Each._call(Each.java:214)
	at lucee.runtime.functions.closure.Each.invoke(Each.java:170)
	at lucee.runtime.functions.closure.Each._call(Each.java:89)
	at lucee.runtime.functions.closure.Each.call(Each.java:66)
	at lucee.runtime.functions.arrays.ArrayEach._call(ArrayEach.java:51)
	at lucee.runtime.functions.arrays.ArrayEach.call(ArrayEach.java:38)
	at lucee.runtime.functions.arrays.ArrayEach.invoke(ArrayEach.java:67)
	at lucee.runtime.interpreter.ref.func.BIFCall.getValue(BIFCall.java:134)
	at lucee.runtime.type.util.MemberUtil.call(MemberUtil.java:126)
	at lucee.runtime.type.util.ArraySupport.call(ArraySupport.java:322)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)
	at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1747)
	at models.schema.schemabuilder_cfc$cf.udfCall2(/qb/models/Schema/SchemaBuilder.cfc:231)
	at models.schema.schemabuilder_cfc$cf.udfCall(/qb/models/Schema/SchemaBuilder.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344)
	at lucee.runtime.type.UDFImpl.call(UDFImpl.java:217)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:684)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:572)
	at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1911)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)
	at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1747)
	at <Contentbox Root>.resources.database.migrations._2020_08_24_150933_v5upgrade_cfc$cf.udfCall3(<Contentbox Root>/resources/database/migrations/2020_08_24_150933_v5Upgrade.cfc:388)
	at <Contentbox Root>.resources.database.migrations._2020_08_24_150933_v5upgrade_cfc$cf.udfCall(<Contentbox Root>/resources/database/migrations/2020_08_24_150933_v5Upgrade.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344)
	at lucee.runtime.type.UDFImpl.call(UDFImpl.java:212)
	at lucee.runtime.type.EnvUDF.call(EnvUDF.java:109)
	at lucee.runtime.functions.closure.Each._call(Each.java:214)
	at lucee.runtime.functions.closure.Each.invoke(Each.java:170)
	at lucee.runtime.functions.closure.Each._call(Each.java:89)
	at lucee.runtime.functions.closure.Each.call(Each.java:66)
	at lucee.runtime.functions.arrays.ArrayEach._call(ArrayEach.java:51)
	at lucee.runtime.functions.arrays.ArrayEach.call(ArrayEach.java:38)
	at lucee.runtime.functions.arrays.ArrayEach.invoke(ArrayEach.java:67)
	at lucee.runtime.interpreter.ref.func.BIFCall.getValue(BIFCall.java:134)
	at lucee.runtime.type.util.MemberUtil.call(MemberUtil.java:126)
	at lucee.runtime.type.util.ArraySupport.call(ArraySupport.java:322)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)
	at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1747)
	at <Contentbox Root>.resources.database.migrations._2020_08_24_150933_v5upgrade_cfc$cf.udfCall2(<Contentbox Root>/resources/database/migrations/2020_08_24_150933_v5Upgrade.cfc:396)
	at <Contentbox Root>.resources.database.migrations._2020_08_24_150933_v5upgrade_cfc$cf.udfCall(/<Contentbox Root>/resources/database/migrations/2020_08_24_150933_v5Upgrade.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:207)
	at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:797)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:866)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1766)
	at <Contentbox Root>.resources.database.migrations._2020_08_24_150933_v5upgrade_cfc$cf.udfCall1(<Contentbox Root>/resources/database/migrations/2020_08_24_150933_v5Upgrade.cfc:59)
	at <Contentbox Root>.resources.database.migrations._2020_08_24_150933_v5upgrade_cfc$cf.udfCall(<Contentbox Root>/resources/database/migrations/2020_08_24_150933_v5Upgrade.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344)
	at lucee.runtime.type.UDFImpl.call(UDFImpl.java:217)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:684)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:572)
	at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1911)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)
	at lucee.runtime.functions.dynamicEvaluation.Invoke.call(Invoke.java:59)
	at modules.commandbox_migrations495.modules.cfmigrations.models.migrationservice_cfc$cf.udfCall3(/commandbox/modules/commandbox-migrations/modules/cfmigrations/models/MigrationService.cfc:300)
	at modules.commandbox_migrations495.modules.cfmigrations.models.migrationservice_cfc$cf.udfCall(/commandbox/modules/commandbox-migrations/modules/cfmigrations/models/MigrationService.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344)
	at lucee.runtime.type.UDFImpl.call(UDFImpl.java:217)
	at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:784)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)
	at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1747)
	at modules.commandbox_migrations495.modules.cfmigrations.models.migrationservice_cfc$cf.udfCall2(/commandbox/modules/commandbox-migrations/modules/cfmigrations/models/MigrationService.cfc:124)
	at modules.commandbox_migrations495.modules.cfmigrations.models.migrationservice_cfc$cf.udfCall(/commandbox/modules/commandbox-migrations/modules/cfmigrations/models/MigrationService.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344)
	at lucee.runtime.type.UDFImpl.call(UDFImpl.java:212)
	at lucee.runtime.type.EnvUDF.call(EnvUDF.java:109)
	at lucee.runtime.functions.closure.Each._call(Each.java:214)
	at lucee.runtime.functions.closure.Each.invoke(Each.java:170)
	at lucee.runtime.functions.closure.Each._call(Each.java:89)
	at lucee.runtime.functions.closure.Each.call(Each.java:66)
	at lucee.runtime.functions.arrays.ArrayEach._call(ArrayEach.java:51)
	at lucee.runtime.functions.arrays.ArrayEach.call(ArrayEach.java:38)
	at modules.commandbox_migrations495.modules.cfmigrations.models.migrationservice_cfc$cf.udfCall1(/commandbox/modules/commandbox-migrations/modules/cfmigrations/models/MigrationService.cfc:125)
	at modules.commandbox_migrations495.modules.cfmigrations.models.migrationservice_cfc$cf.udfCall(/commandbox/modules/commandbox-migrations/modules/cfmigrations/models/MigrationService.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:207)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:685)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:572)
	at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1930)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:866)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1766)
	at modules.commandbox_migrations495.commands.migrate.up_cfc$cf.udfCall(/commandbox/modules/commandbox-migrations/commands/migrate/up.cfc:54)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:207)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:685)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:572)
	at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1930)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:866)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1766)
	at system.services.commandservice_cfc$cf.udfCall1(/commandbox/system/services/CommandService.cfc:345)
	at system.services.commandservice_cfc$cf.udfCall(/commandbox/system/services/CommandService.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:207)
	at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:797)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:866)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1766)
	at system.services.commandservice_cfc$cf.udfCall1(/commandbox/system/services/CommandService.cfc:158)
	at system.services.commandservice_cfc$cf.udfCall(/commandbox/system/services/CommandService.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:207)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:685)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:572)
	at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1930)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:866)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1766)
	at system.shell_cfc$cf.udfCall4(/commandbox/system/Shell.cfc:784)
	at system.shell_cfc$cf.udfCall(/commandbox/system/Shell.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344)
	at lucee.runtime.type.UDFImpl.call(UDFImpl.java:217)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:684)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:572)
	at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1911)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)
	at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1747)
	at system.util.commanddsl_cfc$cf.udfCall2(/commandbox/system/util/CommandDSL.cfc:251)
	at system.util.commanddsl_cfc$cf.udfCall(/commandbox/system/util/CommandDSL.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344)
	at lucee.runtime.type.UDFImpl.call(UDFImpl.java:217)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:684)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:572)
	at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1911)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)
	at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1747)
	at <Contentbox Root>.updater_cfc$cf.udfCall(<Contentbox Root>/Updater.cfc:70)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:207)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:685)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:572)
	at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1930)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:866)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1766)
	at models.taskservice_cfc$cf.udfCall1(/task-commands/models/TaskService.cfc:93)
	at models.taskservice_cfc$cf.udfCall(/task-commands/models/TaskService.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344)
	at lucee.runtime.type.UDFImpl.call(UDFImpl.java:217)
	at lucee.runtime.type.EnvUDF.call(EnvUDF.java:97)
	at lucee.runtime.type.util.StructSupport.call(StructSupport.java:274)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)
	at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1747)
	at models.taskservice_cfc$cf.udfCall2(/task-commands/models/TaskService.cfc:331)
	at models.taskservice_cfc$cf.udfCall(/task-commands/models/TaskService.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344)
	at lucee.runtime.type.UDFImpl.call(UDFImpl.java:217)
	at lucee.runtime.type.EnvUDF.call(EnvUDF.java:97)
	at lucee.runtime.type.util.StructSupport.call(StructSupport.java:274)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)
	at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1747)
	at models.taskservice_cfc$cf.udfCall2(/task-commands/models/TaskService.cfc:331)
	at models.taskservice_cfc$cf.udfCall(/task-commands/models/TaskService.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344)
	at lucee.runtime.type.UDFImpl.call(UDFImpl.java:217)
	at lucee.runtime.type.EnvUDF.call(EnvUDF.java:97)
	at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:784)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)
	at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1747)
	at models.taskservice_cfc$cf.udfCall1(/task-commands/models/TaskService.cfc:110)
	at models.taskservice_cfc$cf.udfCall(/task-commands/models/TaskService.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344)
	at lucee.runtime.type.UDFImpl.call(UDFImpl.java:217)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:684)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:572)
	at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1911)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)
	at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1747)
	at system.modules_app.task_commands225.commands.task.run_cfc$cf.udfCall(/commandbox/system/modules_app/task-commands/commands/task/run.cfc:68)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:207)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:685)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:572)
	at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1930)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:866)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1766)
	at system.services.commandservice_cfc$cf.udfCall1(/commandbox/system/services/CommandService.cfc:345)
	at system.services.commandservice_cfc$cf.udfCall(/commandbox/system/services/CommandService.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:207)
	at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:797)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:866)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1766)
	at system.services.commandservice_cfc$cf.udfCall1(/commandbox/system/services/CommandService.cfc:158)
	at system.services.commandservice_cfc$cf.udfCall(/commandbox/system/services/CommandService.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:207)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:685)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:572)
	at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1930)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:866)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1766)
	at system.shell_cfc$cf.udfCall4(/commandbox/system/Shell.cfc:784)
	at system.shell_cfc$cf.udfCall(/commandbox/system/Shell.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:207)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:685)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:572)
	at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1930)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:866)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1766)
	at christian._commandbox46.cfml.system.bootstrap_cfm$cf.call(/__commandbox_root/christian/.CommandBox/cfml/system/Bootstrap.cfm:119)
	at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1034)
	at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:926)
	at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:907)
	at 1hpf3i7wp6xx8.call(Unknown Source)
	at lucee.runtime.compiler.Renderer.tag(Renderer.java:107)
	at lucee.runtime.compiler.Renderer.script(Renderer.java:97)
	at lucee.runtime.jsr223.ScriptEngineImpl.eval(ScriptEngineImpl.java:63)
	at lucee.runtime.jsr223.ScriptEngineImpl.eval(ScriptEngineImpl.java:194)
	at cliloader.LoaderCLIMain.execute(LoaderCLIMain.java:330)
	at cliloader.LoaderCLIMain.execute(LoaderCLIMain.java:155)
	at cliloader.LoaderCLIMain.main(LoaderCLIMain.java:582)

Migrating: 2020_08_24_150933_v5Upgrade


ERROR (5.4.2+00453)

Migration from identifiers to GUIDs failed due to the following: Duplicate column name 'id'.  Your database is now in an unusable state.  Please restore your database.


<Contentbox Root>/resources/database/migrations/2020_08_24_150933_v5Upgrade.cfc: line 65
63: 			transactionRollback();
64: 			throw(
65: 				"Migration from identifiers to GUIDs failed due to the following: #e.message#.  Your database is now in an unusable state.  Please restore your database."
66: 			);
67: 		}
called from /modules/commandbox-migrations/modules/cfmigrations/models/MigrationService.cfc: line 300
called from /modules/commandbox-migrations/modules/cfmigrations/models/MigrationService.cfc: line 124
called from /modules/commandbox-migrations/modules/cfmigrations/models/MigrationService.cfc: line 125
called from /modules/commandbox-migrations/commands/migrate/up.cfc: line 54
called from /system/services/CommandService.cfc: line 345
called from /system/services/CommandService.cfc: line 158
called from /system/Shell.cfc: line 784
called from /system/util/CommandDSL.cfc: line 251
called from <Contentbox Root>/Updater.cfc: line 70
called from /system/modules_app/task-commands/models/TaskService.cfc: line 93
called from /system/modules_app/task-commands/models/TaskService.cfc: line 331
called from /system/modules_app/task-commands/models/TaskService.cfc: line 110
called from /system/modules_app/task-commands/commands/task/run.cfc: line 68
called from /system/services/CommandService.cfc: line 345
called from /system/services/CommandService.cfc: line 158
called from /system/Shell.cfc: line 784
called from /system/Bootstrap.cfm: line 119

To enable full stack trace, run config set verboseErrors=true

[Christian]

Database DDL

create table <database>.cb_category
(
    categoryID   int unsigned auto_increment
        primary key,
    createdDate  datetime         not null,
    modifiedDate datetime         not null,
    isDeleted    bit default b'0' not null,
    category     varchar(200)     not null,
    slug         varchar(200)     not null,
    constraint slug
        unique (slug)
)
    collate = utf8_bin;

create index idx_categoryName
    on <database>.cb_category (category);

create index idx_categorySlug
    on <database>.cb_category (slug);

create index idx_createDate
    on <database>.cb_category (createdDate);

create index idx_deleted
    on <database>.cb_category (isDeleted);

create index idx_modifiedDate
    on <database>.cb_category (modifiedDate);

create table <database>.cb_loginAttempts
(
    loginAttemptsID    int unsigned auto_increment
        primary key,
    createdDate        datetime         not null,
    modifiedDate       datetime         not null,
    isDeleted          bit default b'0' not null,
    value              varchar(255)     not null,
    attempts           int              not null,
    lastLoginSuccessIP varchar(100)     null
)
    collate = utf8_bin;

create index idx_createDate
    on <database>.cb_loginAttempts (createdDate);

create index idx_deleted
    on <database>.cb_loginAttempts (isDeleted);

create index idx_modifiedDate
    on <database>.cb_loginAttempts (modifiedDate);

create index idx_values
    on <database>.cb_loginAttempts (value);

create table <database>.cb_menu
(
    menuID       int unsigned auto_increment
        primary key,
    createdDate  datetime         not null,
    modifiedDate datetime         not null,
    isDeleted    bit default b'0' not null,
    title        varchar(200)     not null,
    slug         varchar(200)     not null,
    menuClass    varchar(160)     null,
    listClass    varchar(160)     null,
    listType     varchar(20)      null,
    constraint slug
        unique (slug)
)
    collate = utf8_bin;

create index idx_createDate
    on <database>.cb_menu (createdDate);

create index idx_deleted
    on <database>.cb_menu (isDeleted);

create index idx_menuslug
    on <database>.cb_menu (slug);

create index idx_menutitle
    on <database>.cb_menu (title);

create index idx_modifiedDate
    on <database>.cb_menu (modifiedDate);

create table <database>.cb_menuItem
(
    menuItemID   int unsigned auto_increment
        primary key,
    menuType     varchar(255)     not null,
    createdDate  datetime         not null,
    modifiedDate datetime         not null,
    isDeleted    bit default b'0' not null,
    title        varchar(200)     not null,
    label        varchar(200)     null,
    itemClass    varchar(200)     null,
    data         varchar(255)     null,
    active       bit default b'1' null,
    FK_menuID    int unsigned     not null,
    FK_parentID  int unsigned     null,
    mediaPath    varchar(255)     null,
    target       varchar(255)     null,
    urlClass     varchar(255)     null,
    menuSlug     varchar(255)     null,
    contentSlug  varchar(255)     null,
    js           varchar(255)     null,
    url          varchar(255)     null,
    constraint FKF9F1DCF28E0E8DD2
        foreign key (FK_menuID) references <database>.cb_menu (menuID),
    constraint FKF9F1DCF2D3B42410
        foreign key (FK_parentID) references <database>.cb_menuItem (menuItemID)
)
    collate = utf8_bin;

create index idx_createDate
    on <database>.cb_menuItem (createdDate);

create index idx_deleted
    on <database>.cb_menuItem (isDeleted);

create index idx_menuitemtitle
    on <database>.cb_menuItem (title);

create index idx_modifiedDate
    on <database>.cb_menuItem (modifiedDate);

create table <database>.cb_module
(
    moduleID     int unsigned auto_increment
        primary key,
    createdDate  datetime                           not null,
    modifiedDate datetime                           not null,
    isDeleted    bit          default b'0'          not null,
    name         varchar(255)                       not null,
    title        varchar(255)                       null,
    version      varchar(255)                       null,
    entryPoint   varchar(255)                       null,
    author       varchar(255)                       null,
    webURL       longtext                           null,
    forgeBoxSlug varchar(255)                       null,
    description  longtext                           null,
    isActive     bit                                not null,
    moduleType   varchar(255) default '''unknown''' null
)
    collate = utf8_bin;

create index idx_activeModule
    on <database>.cb_module (isActive);

create index idx_createDate
    on <database>.cb_module (createdDate);

create index idx_deleted
    on <database>.cb_module (isDeleted);

create index idx_entryPoint
    on <database>.cb_module (entryPoint);

create index idx_modifiedDate
    on <database>.cb_module (modifiedDate);

create index idx_moduleName
    on <database>.cb_module (name);

create index idx_moduleType
    on <database>.cb_module (moduleType);

create table <database>.cb_permission
(
    permissionID int unsigned auto_increment
        primary key,
    createdDate  datetime         not null,
    modifiedDate datetime         not null,
    isDeleted    bit default b'0' not null,
    permission   varchar(255)     not null,
    description  longtext         null,
    constraint permission
        unique (permission)
)
    collate = utf8_bin;

create index idx_createDate
    on <database>.cb_permission (createdDate);

create index idx_deleted
    on <database>.cb_permission (isDeleted);

create index idx_modifiedDate
    on <database>.cb_permission (modifiedDate);

create index idx_permissionName
    on <database>.cb_permission (permission);

create table <database>.cb_permissionGroup
(
    permissionGroupID int unsigned auto_increment
        primary key,
    createdDate       datetime         not null,
    modifiedDate      datetime         not null,
    isDeleted         bit default b'0' not null,
    name              varchar(255)     not null,
    description       longtext         null,
    constraint name
        unique (name)
)
    collate = utf8_bin;

create table <database>.cb_groupPermissions
(
    FK_permissionGroupID int unsigned not null,
    FK_permissionID      int unsigned not null,
    constraint FK72ECB06537C1A3F2
        foreign key (FK_permissionID) references <database>.cb_permission (permissionID),
    constraint FK72ECB065F4497DC2
        foreign key (FK_permissionGroupID) references <database>.cb_permissionGroup (permissionGroupID)
)
    collate = utf8_bin;

create index idx_createDate
    on <database>.cb_permissionGroup (createdDate);

create index idx_deleted
    on <database>.cb_permissionGroup (isDeleted);

create index idx_modifiedDate
    on <database>.cb_permissionGroup (modifiedDate);

create index idx_permissionGroupName
    on <database>.cb_permissionGroup (name);

create table <database>.cb_role
(
    roleID       int unsigned auto_increment
        primary key,
    createdDate  datetime         not null,
    modifiedDate datetime         not null,
    isDeleted    bit default b'0' not null,
    role         varchar(255)     not null,
    description  longtext         null,
    constraint role
        unique (role)
)
    collate = utf8_bin;

create table <database>.cb_author
(
    authorID        int unsigned auto_increment
        primary key,
    createdDate     datetime         not null,
    modifiedDate    datetime         not null,
    isDeleted       bit default b'0' not null,
    firstName       varchar(100)     not null,
    lastName        varchar(100)     not null,
    email           varchar(255)     not null,
    username        varchar(100)     not null,
    password        varchar(100)     not null,
    isActive        bit              not null,
    lastLogin       datetime         null,
    biography       longtext         null,
    preferences     longtext         null,
    isPasswordReset bit default b'0' not null,
    is2FactorAuth   bit default b'0' not null,
    APIToken        varchar(255)     null,
    FK_roleID       int unsigned     not null,
    constraint APIToken
        unique (APIToken),
    constraint username
        unique (username),
    constraint FK6847396B9724FA40
        foreign key (FK_roleID) references <database>.cb_role (roleID)
)
    collate = utf8_bin;

create index idx_2factorauth
    on <database>.cb_author (is2FactorAuth);

create index idx_activeAuthor
    on <database>.cb_author (isActive);

create index idx_apitoken
    on <database>.cb_author (APIToken);

create index idx_createDate
    on <database>.cb_author (createdDate);

create index idx_deleted
    on <database>.cb_author (isDeleted);

create index idx_email
    on <database>.cb_author (email);

create index idx_login
    on <database>.cb_author (username, password, isActive);

create index idx_modifiedDate
    on <database>.cb_author (modifiedDate);

create index idx_passwordReset
    on <database>.cb_author (isPasswordReset);

create table <database>.cb_authorPermissionGroups
(
    FK_permissionGroupID int unsigned not null,
    FK_authorID          int unsigned not null,
    constraint FK7443FC0EAA6AC0EA
        foreign key (FK_authorID) references <database>.cb_author (authorID),
    constraint FK7443FC0EF4497DC2
        foreign key (FK_permissionGroupID) references <database>.cb_permissionGroup (permissionGroupID)
)
    collate = utf8_bin;

create table <database>.cb_authorPermissions
(
    FK_authorID     int unsigned not null,
    FK_permissionID int unsigned not null,
    constraint FKE167E21937C1A3F2
        foreign key (FK_permissionID) references <database>.cb_permission (permissionID),
    constraint FKE167E219AA6AC0EA
        foreign key (FK_authorID) references <database>.cb_author (authorID)
)
    collate = utf8_bin;

create table <database>.cb_content
(
    contentID              int unsigned auto_increment
        primary key,
    contentType            varchar(255)     not null,
    createdDate            datetime         not null,
    modifiedDate           datetime         not null,
    isDeleted              bit default b'0' not null,
    title                  varchar(200)     not null,
    slug                   varchar(200)     not null,
    publishedDate          datetime         null,
    expireDate             datetime         null,
    isPublished            bit              not null,
    allowComments          bit              not null,
    passwordProtection     varchar(100)     null,
    HTMLKeywords           varchar(160)     null,
    HTMLDescription        varchar(160)     null,
    HTMLTitle              varchar(255)     null,
    cache                  bit              not null,
    cacheLayout            bit              not null,
    cacheTimeout           int              null,
    cacheLastAccessTimeout int              null,
    markup                 varchar(100)     not null,
    showInSearch           bit              not null,
    featuredImage          varchar(255)     null,
    featuredImageURL       varchar(255)     null,
    FK_authorID            int unsigned     not null,
    FK_parentID            int unsigned     null,
    constraint slug
        unique (slug),
    constraint FKFFE018996FDC2C99
        foreign key (FK_parentID) references <database>.cb_content (contentID)
            on update cascade on delete set null,
    constraint FKFFE01899AA6AC0EA
        foreign key (FK_authorID) references <database>.cb_author (authorID)
            on update cascade
)
    collate = utf8_bin;

create table <database>.cb_comment
(
    commentID    int unsigned auto_increment
        primary key,
    createdDate  datetime         not null,
    modifiedDate datetime         not null,
    isDeleted    bit default b'0' not null,
    content      longtext         not null,
    author       varchar(100)     not null,
    authorIP     varchar(100)     not null,
    authorEmail  varchar(255)     not null,
    authorURL    varchar(255)     null,
    isApproved   bit              not null,
    FK_contentID int unsigned     not null,
    constraint FKFFCED27F91F58374
        foreign key (FK_contentID) references <database>.cb_content (contentID)
            on update cascade on delete cascade
)
    collate = utf8_bin;

create index idx_approved
    on <database>.cb_comment (isApproved);

create index idx_contentComment
    on <database>.cb_comment (isApproved, FK_contentID);

create index idx_createDate
    on <database>.cb_comment (createdDate);

create index idx_deleted
    on <database>.cb_comment (isDeleted);

create index idx_modifiedDate
    on <database>.cb_comment (modifiedDate);

create index idx_cache
    on <database>.cb_content (cache);

create index idx_cachelastaccesstimeout
    on <database>.cb_content (cacheLastAccessTimeout);

create index idx_cachelayout
    on <database>.cb_content (cacheLayout);

create index idx_cachetimeout
    on <database>.cb_content (cacheTimeout);

create index idx_createDate
    on <database>.cb_content (createdDate);

create index idx_deleted
    on <database>.cb_content (isDeleted);

create index idx_discriminator
    on <database>.cb_content (contentType);

create index idx_expireDate
    on <database>.cb_content (expireDate);

create index idx_modifiedDate
    on <database>.cb_content (modifiedDate);

create index idx_published
    on <database>.cb_content (contentType, isPublished, passwordProtection);

create index idx_publishedDate
    on <database>.cb_content (publishedDate);

create index idx_publishedSlug
    on <database>.cb_content (slug, isPublished);

create index idx_search
    on <database>.cb_content (title, isPublished);

create index idx_showInSearch
    on <database>.cb_content (showInSearch);

create index idx_slug
    on <database>.cb_content (slug);

create table <database>.cb_contentCategories
(
    FK_contentID  int unsigned not null,
    FK_categoryID int unsigned not null,
    constraint FKD96A0F9591F58374
        foreign key (FK_contentID) references <database>.cb_content (contentID)
            on update cascade on delete cascade,
    constraint FKD96A0F95F10ECD0
        foreign key (FK_categoryID) references <database>.cb_category (categoryID)
            on update cascade on delete cascade
)
    collate = utf8_bin;

create table <database>.cb_contentStore
(
    contentID   int unsigned  not null
        primary key,
    description longtext      null,
    `order`     int default 0 null,
    constraint FKEA4C67C8C960893B
        foreign key (contentID) references <database>.cb_content (contentID)
)
    collate = utf8_bin;

create table <database>.cb_contentVersion
(
    contentVersionID int unsigned auto_increment
        primary key,
    createdDate      datetime         not null,
    modifiedDate     datetime         not null,
    isDeleted        bit default b'0' not null,
    content          longtext         not null,
    changelog        longtext         null,
    version          int              not null,
    isActive         bit              not null,
    FK_authorID      int unsigned     not null,
    FK_contentID     int unsigned     not null,
    constraint cb_contentVersion_ibfk_1
        foreign key (FK_authorID) references <database>.cb_author (authorID)
            on update cascade,
    constraint cb_contentVersion_ibfk_2
        foreign key (FK_contentID) references <database>.cb_content (contentID)
            on update cascade on delete cascade
)
    collate = utf8_bin;

create index FKE166DFF91F58374
    on <database>.cb_contentVersion (FK_contentID);

create index FKE166DFFAA6AC0EA
    on <database>.cb_contentVersion (FK_authorID);

create index idx_activeContentVersion
    on <database>.cb_contentVersion (isActive);

create index idx_contentVersions
    on <database>.cb_contentVersion (isActive, FK_contentID);

create index idx_createDate
    on <database>.cb_contentVersion (createdDate);

create index idx_deleted
    on <database>.cb_contentVersion (isDeleted);

create index idx_modifiedDate
    on <database>.cb_contentVersion (modifiedDate);

create index idx_version
    on <database>.cb_contentVersion (version);

create table <database>.cb_customfield
(
    customFieldID int unsigned auto_increment
        primary key,
    createdDate   datetime         not null,
    modifiedDate  datetime         not null,
    isDeleted     bit default b'0' not null,
    `key`         varchar(255)     not null,
    value         longtext         not null,
    FK_contentID  int unsigned     null,
    constraint FK1844684991F58374
        foreign key (FK_contentID) references <database>.cb_content (contentID)
            on update cascade on delete cascade
)
    collate = utf8_bin;

create index idx_contentCustomFields
    on <database>.cb_customfield (FK_contentID);

create index idx_createDate
    on <database>.cb_customfield (createdDate);

create index idx_deleted
    on <database>.cb_customfield (isDeleted);

create index idx_modifiedDate
    on <database>.cb_customfield (modifiedDate);

create table <database>.cb_entry
(
    contentID int unsigned not null
        primary key,
    excerpt   longtext     null,
    constraint FK141674927FFF6A7
        foreign key (contentID) references <database>.cb_content (contentID)
            on update cascade on delete cascade
)
    collate = utf8_bin;

create table <database>.cb_page
(
    contentID    int unsigned not null
        primary key,
    layout       varchar(200) null,
    mobileLayout varchar(200) null,
    `order`      int          null,
    showInMenu   bit          not null,
    excerpt      longtext     null,
    SSLOnly      bit          not null,
    constraint FK21B2F26F9636A2E2
        foreign key (contentID) references <database>.cb_content (contentID)
            on update cascade on delete cascade
)
    collate = utf8_bin;

create index idx_showInMenu
    on <database>.cb_page (showInMenu);

create index idx_ssl
    on <database>.cb_page (SSLOnly);

create table <database>.cb_relatedContent
(
    FK_contentID        int unsigned not null,
    FK_relatedContentID int unsigned not null,
    constraint FK9C2F71AE91F58374
        foreign key (FK_contentID) references <database>.cb_content (contentID)
            on update cascade on delete cascade,
    constraint FK9C2F71AEDF61AADD
        foreign key (FK_relatedContentID) references <database>.cb_content (contentID)
            on update cascade on delete cascade
)
    collate = utf8_bin;

create index idx_createDate
    on <database>.cb_role (createdDate);

create index idx_deleted
    on <database>.cb_role (isDeleted);

create index idx_modifiedDate
    on <database>.cb_role (modifiedDate);

create index idx_roleName
    on <database>.cb_role (role);

create table <database>.cb_rolePermissions
(
    FK_roleID       int unsigned not null,
    FK_permissionID int unsigned not null,
    constraint FKDCCC1A4E37C1A3F2
        foreign key (FK_permissionID) references <database>.cb_permission (permissionID),
    constraint FKDCCC1A4E9724FA40
        foreign key (FK_roleID) references <database>.cb_role (roleID)
)
    collate = utf8_bin;

create table <database>.cb_securityRule
(
    ruleID       int unsigned auto_increment
        primary key,
    createdDate  datetime                       not null,
    modifiedDate datetime                       not null,
    isDeleted    bit         default b'0'       not null,
    whitelist    varchar(255)                   null,
    securelist   varchar(255)                   not null,
    roles        varchar(255)                   null,
    permissions  longtext                       null,
    redirect     longtext                       not null,
    useSSL       bit                            null,
    `order`      int unsigned                   not null,
    `match`      varchar(50)                    null,
    message      varchar(255)                   null,
    messageType  varchar(50) default '''info''' null
)
    collate = utf8_bin;

create index idx_createDate
    on <database>.cb_securityRule (createdDate);

create index idx_deleted
    on <database>.cb_securityRule (isDeleted);

create index idx_modifiedDate
    on <database>.cb_securityRule (modifiedDate);

create table <database>.cb_setting
(
    settingID    int unsigned auto_increment
        primary key,
    createdDate  datetime         not null,
    modifiedDate datetime         not null,
    isDeleted    bit default b'0' not null,
    name         varchar(100)     not null,
    value        longtext         not null,
    isCore       bit default b'0' not null,
    constraint name
        unique (name)
)
    collate = utf8_bin;

create index idx_core
    on <database>.cb_setting (isCore);

create index idx_createDate
    on <database>.cb_setting (createdDate);

create index idx_deleted
    on <database>.cb_setting (isDeleted);

create index idx_modifiedDate
    on <database>.cb_setting (modifiedDate);

create table <database>.cb_stats
(
    statsID      int unsigned auto_increment
        primary key,
    createdDate  datetime         not null,
    modifiedDate datetime         not null,
    isDeleted    bit default b'0' not null,
    hits         bigint           null,
    FK_contentID int unsigned     not null,
    constraint FK_contentID
        unique (FK_contentID),
    constraint FK14DE30BF91F58374
        foreign key (FK_contentID) references <database>.cb_content (contentID)
            on update cascade on delete cascade
)
    collate = utf8_bin;

create index idx_createDate
    on <database>.cb_stats (createdDate);

create index idx_deleted
    on <database>.cb_stats (isDeleted);

create index idx_modifiedDate
    on <database>.cb_stats (modifiedDate);

create table <database>.cb_subscribers
(
    subscriberID    int unsigned auto_increment
        primary key,
    createdDate     datetime         not null,
    modifiedDate    datetime         not null,
    isDeleted       bit default b'0' not null,
    subscriberEmail varchar(255)     not null,
    subscriberToken varchar(255)     not null
)
    collate = utf8_bin;

create index idx_createDate
    on <database>.cb_subscribers (createdDate);

create index idx_deleted
    on <database>.cb_subscribers (isDeleted);

create index idx_modifiedDate
    on <database>.cb_subscribers (modifiedDate);

create index idx_subscriberEmail
    on <database>.cb_subscribers (subscriberEmail);

create table <database>.cb_subscriptions
(
    subscriptionID    int unsigned auto_increment
        primary key,
    createdDate       datetime         not null,
    modifiedDate      datetime         not null,
    isDeleted         bit default b'0' not null,
    subscriptionToken varchar(255)     not null,
    type              varchar(255)     not null,
    FK_subscriberID   int unsigned     not null,
    constraint FKE92A1716F2A66EE4
        foreign key (FK_subscriberID) references <database>.cb_subscribers (subscriberID)
)
    collate = utf8_bin;

create table <database>.cb_commentSubscriptions
(
    subscriptionID int unsigned not null
        primary key,
    FK_contentID   int unsigned not null,
    constraint FK41716EB71D33B614
        foreign key (subscriptionID) references <database>.cb_subscriptions (subscriptionID)
            on update cascade on delete cascade,
    constraint FK41716EB791F58374
        foreign key (FK_contentID) references <database>.cb_content (contentID)
            on update cascade on delete cascade
)
    collate = utf8_bin;

create index idx_contentCommentSubscription
    on <database>.cb_commentSubscriptions (FK_contentID);

create index idx_createDate
    on <database>.cb_subscriptions (createdDate);

create index idx_deleted
    on <database>.cb_subscriptions (isDeleted);

create index idx_modifiedDate
    on <database>.cb_subscriptions (modifiedDate);

create index idx_subscriber
    on <database>.cb_subscriptions (FK_subscriberID);

These are only the cb_* tables. There are more tables used bymy modules which are designed like:

create table example1
(
    id        int unsigned auto_increment primary key,
    ...
)
    collate = utf8_bin;

create table example3
(
    fkTable1 int unsigned not null,
    fkTable2 int unsigned not null,
    primary key (fkTable1, fkTable2),
    constraint exampleFKTable1
        foreign key (fkTable1) references example1 (id)
            on update cascade on delete cascade,
    constraint exampleFKTable2
        foreign key (fkTable2) references example2 (id)
            on update cascade
)
    collate = utf8_bin;

[lmajano]

Hi @Christian few questions

• Are you running this on the root of the contentbox 4 site?
• Is this Adobe or Lucee, and which version?
• What database are you using?
• Did you follow the pre-requisites?

Here is what I can see from the updater log. The updater starts off by creating an id column to migrate the current primary keys to UUIDs. The stack is reporting that the tables already have an id column. Did you create this yourself? Because if you did, the updater won’t work with tables already having an id column.

[Christian]

Hi @lmajano:
regarding your questions:

• Yes the Updater.cfc is located in the contentbox root (webroot) and is also executed there
• I am running Lucee 5.3.8.201
• My Database is a local Docker Container containing mariadb:10.3.27
• I did run the following prerequisites:
  Install CommandBox Dependencies (dotenv & migrations)
  Create .env File
  Create .cfconfig.json
  Update box.json
  Run the migration table installation (box migrate install)

As far as I know the cb_tables were not altered. As you can see in the DDL above my cb_author table does not contain a column named “id”

[lmajano]

This is perplexing then, because the exception is claiming that the tables have an id field already. Could this be a maria db reserved column or something?

[Christian]

I did some more testing:
I am able to execute the following in the DB:

alter table cb_author
	add id varchar(35) null;

create unique index cb_author_id_uindex
	on cb_author (id);

However I did another rollback of the Contentbox installation and the DB. Apparently I didn’t do a full reset of the whole folder on previous attempts which could have resulted in the error. However I am getting another error: lucee.runtime.exp.DatabaseException: Table '<DB>.cb_securityrule' doesn't exist in engine.
I therefor renamed the table cb_securityRule to the lowercase name.
In the next run I got a similar error: Table '<DB>.cb_authorpermissions' doesn't exist in engine however when I try to rename the affected table it gets renamed during the update process.

/Applications/box task run Updater.cfc
This task will update your ContentBox 4 installation to a ContentBox 5 installation.
Please make a backup of your source and your database now. 

Here are some files that will be overwritten by the updater. We will create .bak files for you.
Make sure you copy back your customizations to your new files:
- Application.cfc
- config/CacheBox.cfc
- config/Coldbox.cfc

Are you ready to continue (yes/no)?yes
Downloading ContentBox v5.0.0 assets to __temp folder...
 √ | Installing package [forgebox:contentbox-site@5.0.0]
   | √ | Installing package [forgebox:coldbox@^6.0.0]
   | √ | Installing package [forgebox:contentbox@~5.0.0]
   |   | √ | Installing package [forgebox:cborm@^3.0.0]
   |   |   | √ | Installing package [forgebox:cbvalidation@^3.0.0]
   |   |   |   | √ | Installing package [forgebox:cbi18n@^2.0.0]
   |   |   |   |   | √ | Installing package [forgebox:cbstorages@^2.4.0+64]
   |   |   | √ | Installing package [forgebox:mementifier@^2.0.0]
   |   |   | √ | Installing package [forgebox:cbstreams@^1.5.0]
   |   |   | √ | Installing package [forgebox:cbpaginator@^2.0.0]
   |   | √ | Installing package [forgebox:cbjavaloader@^2.0.0]
   |   | √ | Installing package [forgebox:cbmailservices@^1.5.0]
   |   | √ | Installing package [forgebox:cbsecurity@^2.0.0]
   |   |   | √ | Installing package [forgebox:jwt-cfml@^1.0.0]
   |   |   | √ | Installing package [forgebox:cbauth@^5.0.0]
   |   |   |   | √ | Installing package [forgebox:cbstorages@^2.0.0]
   |   |   | √ | Installing package [forgebox:cbcsrf@^2.0.0]
   |   |   |   | √ | Installing package [forgebox:cbstorages@^2.1.0]
   |   | √ | Installing package [forgebox:cbfeeds@^1.3.0]
   |   | √ | Installing package [forgebox:cbmessagebox@^4.0.0]
   |   | √ | Installing package [forgebox:cbantisamy@^1.3.1]
   |   |   | √ | Installing package [forgebox:cbjavaloader@^1.3.2]
   |   | √ | Installing package [forgebox:bcrypt@^3.0.0]
   |   |   | √ | Installing package [forgebox:cbjavaloader@^2.0.0]
   |   | √ | Installing package [forgebox:cbmarkdown@^3.4.0]
   |   |   | √ | Installing package [forgebox:cbjavaloader@^2.0.0]
   |   |   | √ | Installing package [forgebox:cbemoji@^1.0.1]
   |   | √ | Installing package [forgebox:cbSwagger@^2.3.0+131]
   |   |   | √ | Installing package [forgebox:swagger-sdk@^2.0.0]
   |   |   |   | √ | Installing package [forgebox:cbjavaloader@>0.0.9]
   |   | √ | Installing package [forgebox:jsonprettyprint@^1.4.0]
   | √ | Installing package [forgebox:commandbox-dotenv@*]
   | √ | Installing package [forgebox:commandbox-cfconfig@*]
   | √ | Installing package [forgebox:commandbox-migrations@*]
√ ContentBox assets downloaded!
Installing new ContentBox resources folder...
Copying directory <Contentbox Root>/__temp/resources/database
Copying directory <Contentbox Root>/__temp/resources/seeder
Copying <Contentbox Root>/__temp/resources/Application.cfm
Copying directory <Contentbox Root>/__temp/resources/apidocs
√ ContentBox resources installed!
Migrating your database to version: 5.0.0...
> Starting to process migration of identifiers to uuid's...
	√ - cb_content new uuid pk created and populated
	√ - cb_author new uuid pk created and populated
	√ - cb_module new uuid pk created and populated
	√ - cb_role new uuid pk created and populated
	√ - cb_menu new uuid pk created and populated
	√ - cb_comment new uuid pk created and populated
	√ - cb_subscriptions new uuid pk created and populated
	√ - cb_securityRule new uuid pk created and populated
	√ - cb_menuItem new uuid pk created and populated
	√ - cb_contentVersion new uuid pk created and populated
	√ - cb_loginAttempts new uuid pk created and populated
	√ - cb_subscribers new uuid pk created and populated
	√ - cb_setting new uuid pk created and populated
	√ - cb_customfield new uuid pk created and populated
	√ - cb_stats new uuid pk created and populated
	√ - cb_permissionGroup new uuid pk created and populated
	√ - cb_permission new uuid pk created and populated
	√ - cb_category new uuid pk created and populated
√√ - Finalized adding new primary keys to all tables

> Beginning to process child tables...

> Starting to process child table: cb_entry
	√ - (cb_entry) Dropped foreign key and constraints
	√ - (cb_entry) rekeyed to new parent uuid
> Starting to process child table: cb_page
	√ - (cb_page) Dropped foreign key and constraints
	√ - (cb_page) rekeyed to new parent uuid
> Starting to process child table: cb_contentStore
	√ - (cb_contentStore) Dropped foreign key and constraints
	√ - (cb_contentStore) rekeyed to new parent uuid
> Starting to process child table: cb_commentSubscriptions
	√ - (cb_commentSubscriptions) Dropped foreign key and constraints
	√ - (cb_commentSubscriptions) rekeyed to new parent uuid
√√ - Finalized rekeying all child tables

> Beginning to process foreign keys...

> Starting to process (cb_content) foreign keys...
	√ - (cb_content) Dropped foreign key and constraints (FK_authorID)
	√ - (cb_content) foreign key (FK_authorID) rekeyed as a uuid into (tmp_FK_authorID)
	√ - (cb_content) Dropped foreign key and constraints (FK_parentID)
	√ - (cb_content) foreign key (FK_parentID) rekeyed as a uuid into (tmp_FK_parentID)
> Starting to process (cb_author) foreign keys...
	√ - (cb_author) Dropped foreign key and constraints (FK_roleID)
	√ - (cb_author) foreign key (FK_roleID) rekeyed as a uuid into (tmp_FK_roleID)
> Starting to process (cb_authorPermissions) foreign keys...
	√ - (cb_authorPermissions) Dropped foreign key and constraints (FK_permissionID)
Table '<DB>.cb_authorpermissions' doesn't exist in engine
lucee.runtime.exp.DatabaseException: Table '<DB>.cb_authorpermissions' doesn't exist in engine
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
	at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:764)
	at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:781)
	at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:320)
	at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:287)
	at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:235)
	at lucee.runtime.tag.Query.executeDatasoure(Query.java:1134)
	at lucee.runtime.tag.Query._doEndTag(Query.java:699)
	at lucee.runtime.tag.Query.doEndTag(Query.java:565)
	at lucee.runtime.functions.query.QueryExecute.call(QueryExecute.java:86)
	at models.grammars.basegrammar_cfc$cf.udfCall1(/qb/models/Grammars/BaseGrammar.cfc:106)
	at models.grammars.basegrammar_cfc$cf.udfCall(/qb/models/Grammars/BaseGrammar.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:207)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:685)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:572)
	at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1930)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:900)
	at lucee.runtime.functions.dynamicEvaluation.Invoke.call(Invoke.java:49)
	at models.grammars.autodiscover_cfc$cf.udfCall(/qb/models/Grammars/AutoDiscover.cfc:27)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344)
	at lucee.runtime.type.UDFImpl.call(UDFImpl.java:217)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:684)
	at lucee.runtime.ComponentImpl.onMissingMethod(ComponentImpl.java:611)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:574)
	at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1911)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)
	at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1747)
	at models.schema.schemabuilder_cfc$cf.udfCall2(/qb/models/Schema/SchemaBuilder.cfc:230)
	at models.schema.schemabuilder_cfc$cf.udfCall(/qb/models/Schema/SchemaBuilder.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344)
	at lucee.runtime.type.UDFImpl.call(UDFImpl.java:212)
	at lucee.runtime.type.EnvUDF.call(EnvUDF.java:109)
	at lucee.runtime.functions.closure.Each._call(Each.java:214)
	at lucee.runtime.functions.closure.Each.invoke(Each.java:170)
	at lucee.runtime.functions.closure.Each._call(Each.java:89)
	at lucee.runtime.functions.closure.Each.call(Each.java:66)
	at lucee.runtime.functions.arrays.ArrayEach._call(ArrayEach.java:51)
	at lucee.runtime.functions.arrays.ArrayEach.call(ArrayEach.java:38)
	at lucee.runtime.functions.arrays.ArrayEach.invoke(ArrayEach.java:67)
	at lucee.runtime.interpreter.ref.func.BIFCall.getValue(BIFCall.java:134)
	at lucee.runtime.type.util.MemberUtil.call(MemberUtil.java:126)
	at lucee.runtime.type.util.ArraySupport.call(ArraySupport.java:322)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)
	at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1747)
	at models.schema.schemabuilder_cfc$cf.udfCall2(/qb/models/Schema/SchemaBuilder.cfc:231)
	at models.schema.schemabuilder_cfc$cf.udfCall(/qb/models/Schema/SchemaBuilder.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344)
	at lucee.runtime.type.UDFImpl.call(UDFImpl.java:217)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:684)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:572)
	at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1911)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)
	at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1747)
	at <Contentbox Root>.resources.database.migrations._2020_08_24_150933_v5upgrade_cfc$cf.udfCall3(<Contentbox Root>/resources/database/migrations/2020_08_24_150933_v5Upgrade.cfc:443)
	at <Contentbox Root>.resources.database.migrations._2020_08_24_150933_v5upgrade_cfc$cf.udfCall(<Contentbox Root>/resources/database/migrations/2020_08_24_150933_v5Upgrade.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344)
	at lucee.runtime.type.UDFImpl.call(UDFImpl.java:212)
	at lucee.runtime.type.EnvUDF.call(EnvUDF.java:109)
	at lucee.runtime.functions.closure.Each._call(Each.java:214)
	at lucee.runtime.functions.closure.Each.invoke(Each.java:170)
	at lucee.runtime.functions.closure.Each._call(Each.java:89)
	at lucee.runtime.functions.closure.Each.call(Each.java:66)
	at lucee.runtime.functions.arrays.ArrayEach._call(ArrayEach.java:51)
	at lucee.runtime.functions.arrays.ArrayEach.call(ArrayEach.java:38)
	at lucee.runtime.functions.arrays.ArrayEach.invoke(ArrayEach.java:67)
	at lucee.runtime.interpreter.ref.func.BIFCall.getValue(BIFCall.java:134)
	at lucee.runtime.type.util.MemberUtil.call(MemberUtil.java:126)
	at lucee.runtime.type.util.ArraySupport.call(ArraySupport.java:322)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)
	at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1747)
	at <Contentbox Root>.resources.database.migrations._2020_08_24_150933_v5upgrade_cfc$cf.udfCall3(<Contentbox Root>/resources/database/migrations/2020_08_24_150933_v5Upgrade.cfc:445)
	at <Contentbox Root>.resources.database.migrations._2020_08_24_150933_v5upgrade_cfc$cf.udfCall(<Contentbox Root>/resources/database/migrations/2020_08_24_150933_v5Upgrade.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344)
	at lucee.runtime.type.UDFImpl.call(UDFImpl.java:212)
	at lucee.runtime.type.EnvUDF.call(EnvUDF.java:109)
	at lucee.runtime.functions.closure.Each._call(Each.java:214)
	at lucee.runtime.functions.closure.Each.invoke(Each.java:170)
	at lucee.runtime.functions.closure.Each._call(Each.java:89)
	at lucee.runtime.functions.closure.Each.call(Each.java:66)
	at lucee.runtime.functions.arrays.ArrayEach._call(ArrayEach.java:51)
	at lucee.runtime.functions.arrays.ArrayEach.call(ArrayEach.java:38)
	at lucee.runtime.functions.arrays.ArrayEach.invoke(ArrayEach.java:67)
	at lucee.runtime.interpreter.ref.func.BIFCall.getValue(BIFCall.java:134)
	at lucee.runtime.type.util.MemberUtil.call(MemberUtil.java:126)
	at lucee.runtime.type.util.ArraySupport.call(ArraySupport.java:322)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)
	at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1747)
	at <Contentbox Root>.resources.database.migrations._2020_08_24_150933_v5upgrade_cfc$cf.udfCall2(<Contentbox Root>/resources/database/migrations/2020_08_24_150933_v5Upgrade.cfc:447)
	at <Contentbox Root>.resources.database.migrations._2020_08_24_150933_v5upgrade_cfc$cf.udfCall(<Contentbox Root>/resources/database/migrations/2020_08_24_150933_v5Upgrade.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:207)
	at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:797)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:866)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1766)
	at <Contentbox Root>.resources.database.migrations._2020_08_24_150933_v5upgrade_cfc$cf.udfCall1(<Contentbox Root>/resources/database/migrations/2020_08_24_150933_v5Upgrade.cfc:59)
	at <Contentbox Root>.resources.database.migrations._2020_08_24_150933_v5upgrade_cfc$cf.udfCall(<Contentbox Root>/resources/database/migrations/2020_08_24_150933_v5Upgrade.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344)
	at lucee.runtime.type.UDFImpl.call(UDFImpl.java:217)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:684)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:572)
	at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1911)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)
	at lucee.runtime.functions.dynamicEvaluation.Invoke.call(Invoke.java:59)
	at modules.commandbox_migrations495.modules.cfmigrations.models.migrationservice_cfc$cf.udfCall3(/commandbox/modules/commandbox-migrations/modules/cfmigrations/models/MigrationService.cfc:300)
	at modules.commandbox_migrations495.modules.cfmigrations.models.migrationservice_cfc$cf.udfCall(/commandbox/modules/commandbox-migrations/modules/cfmigrations/models/MigrationService.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344)
	at lucee.runtime.type.UDFImpl.call(UDFImpl.java:217)
	at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:784)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)
	at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1747)
	at modules.commandbox_migrations495.modules.cfmigrations.models.migrationservice_cfc$cf.udfCall2(/commandbox/modules/commandbox-migrations/modules/cfmigrations/models/MigrationService.cfc:124)
	at modules.commandbox_migrations495.modules.cfmigrations.models.migrationservice_cfc$cf.udfCall(/commandbox/modules/commandbox-migrations/modules/cfmigrations/models/MigrationService.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344)
	at lucee.runtime.type.UDFImpl.call(UDFImpl.java:212)
	at lucee.runtime.type.EnvUDF.call(EnvUDF.java:109)
	at lucee.runtime.functions.closure.Each._call(Each.java:214)
	at lucee.runtime.functions.closure.Each.invoke(Each.java:170)
	at lucee.runtime.functions.closure.Each._call(Each.java:89)
	at lucee.runtime.functions.closure.Each.call(Each.java:66)
	at lucee.runtime.functions.arrays.ArrayEach._call(ArrayEach.java:51)
	at lucee.runtime.functions.arrays.ArrayEach.call(ArrayEach.java:38)
	at modules.commandbox_migrations495.modules.cfmigrations.models.migrationservice_cfc$cf.udfCall1(/commandbox/modules/commandbox-migrations/modules/cfmigrations/models/MigrationService.cfc:125)
	at modules.commandbox_migrations495.modules.cfmigrations.models.migrationservice_cfc$cf.udfCall(/commandbox/modules/commandbox-migrations/modules/cfmigrations/models/MigrationService.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:207)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:685)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:572)
	at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1930)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:866)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1766)
	at modules.commandbox_migrations495.commands.migrate.up_cfc$cf.udfCall(/commandbox/modules/commandbox-migrations/commands/migrate/up.cfc:54)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:207)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:685)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:572)
	at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1930)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:866)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1766)
	at system.services.commandservice_cfc$cf.udfCall1(/commandbox/system/services/CommandService.cfc:345)
	at system.services.commandservice_cfc$cf.udfCall(/commandbox/system/services/CommandService.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:207)
	at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:797)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:866)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1766)
	at system.services.commandservice_cfc$cf.udfCall1(/commandbox/system/services/CommandService.cfc:158)
	at system.services.commandservice_cfc$cf.udfCall(/commandbox/system/services/CommandService.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:207)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:685)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:572)
	at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1930)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:866)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1766)
	at system.shell_cfc$cf.udfCall4(/commandbox/system/Shell.cfc:784)
	at system.shell_cfc$cf.udfCall(/commandbox/system/Shell.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344)
	at lucee.runtime.type.UDFImpl.call(UDFImpl.java:217)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:684)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:572)
	at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1911)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)
	at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1747)
	at system.util.commanddsl_cfc$cf.udfCall2(/commandbox/system/util/CommandDSL.cfc:251)
	at system.util.commanddsl_cfc$cf.udfCall(/commandbox/system/util/CommandDSL.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344)
	at lucee.runtime.type.UDFImpl.call(UDFImpl.java:217)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:684)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:572)
	at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1911)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)
	at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1747)
	at <Contentbox Root>.updater_cfc$cf.udfCall(<Contentbox Root>/Updater.cfc:70)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:207)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:685)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:572)
	at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1930)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:866)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1766)
	at models.taskservice_cfc$cf.udfCall1(/task-commands/models/TaskService.cfc:93)
	at models.taskservice_cfc$cf.udfCall(/task-commands/models/TaskService.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344)
	at lucee.runtime.type.UDFImpl.call(UDFImpl.java:217)
	at lucee.runtime.type.EnvUDF.call(EnvUDF.java:97)
	at lucee.runtime.type.util.StructSupport.call(StructSupport.java:274)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)
	at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1747)
	at models.taskservice_cfc$cf.udfCall2(/task-commands/models/TaskService.cfc:331)
	at models.taskservice_cfc$cf.udfCall(/task-commands/models/TaskService.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344)
	at lucee.runtime.type.UDFImpl.call(UDFImpl.java:217)
	at lucee.runtime.type.EnvUDF.call(EnvUDF.java:97)
	at lucee.runtime.type.util.StructSupport.call(StructSupport.java:274)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)
	at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1747)
	at models.taskservice_cfc$cf.udfCall2(/task-commands/models/TaskService.cfc:331)
	at models.taskservice_cfc$cf.udfCall(/task-commands/models/TaskService.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344)
	at lucee.runtime.type.UDFImpl.call(UDFImpl.java:217)
	at lucee.runtime.type.EnvUDF.call(EnvUDF.java:97)
	at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:784)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)
	at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1747)
	at models.taskservice_cfc$cf.udfCall1(/task-commands/models/TaskService.cfc:110)
	at models.taskservice_cfc$cf.udfCall(/task-commands/models/TaskService.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344)
	at lucee.runtime.type.UDFImpl.call(UDFImpl.java:217)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:684)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:572)
	at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1911)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)
	at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1747)
	at system.modules_app.task_commands225.commands.task.run_cfc$cf.udfCall(/commandbox/system/modules_app/task-commands/commands/task/run.cfc:68)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:207)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:685)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:572)
	at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1930)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:866)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1766)
	at system.services.commandservice_cfc$cf.udfCall1(/commandbox/system/services/CommandService.cfc:345)
	at system.services.commandservice_cfc$cf.udfCall(/commandbox/system/services/CommandService.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:207)
	at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:797)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:866)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1766)
	at system.services.commandservice_cfc$cf.udfCall1(/commandbox/system/services/CommandService.cfc:158)
	at system.services.commandservice_cfc$cf.udfCall(/commandbox/system/services/CommandService.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:207)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:685)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:572)
	at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1930)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:866)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1766)
	at system.shell_cfc$cf.udfCall4(/commandbox/system/Shell.cfc:784)
	at system.shell_cfc$cf.udfCall(/commandbox/system/Shell.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:207)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:685)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:572)
	at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1930)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:866)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1766)
	at christian._commandbox46.cfml.system.bootstrap_cfm$cf.call(/__commandbox_root/christian/.CommandBox/cfml/system/Bootstrap.cfm:119)
	at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1034)
	at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:926)
	at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:907)
	at 1hpf3i7wp6xx8.call(Unknown Source)
	at lucee.runtime.compiler.Renderer.tag(Renderer.java:107)
	at lucee.runtime.compiler.Renderer.script(Renderer.java:97)
	at lucee.runtime.jsr223.ScriptEngineImpl.eval(ScriptEngineImpl.java:63)
	at lucee.runtime.jsr223.ScriptEngineImpl.eval(ScriptEngineImpl.java:194)
	at cliloader.LoaderCLIMain.execute(LoaderCLIMain.java:330)
	at cliloader.LoaderCLIMain.execute(LoaderCLIMain.java:155)
	at cliloader.LoaderCLIMain.main(LoaderCLIMain.java:582)

Migrating: 2020_08_24_150933_v5Upgrade


ERROR (5.4.2+00453)

Migration from identifiers to GUIDs failed due to the following: Table '<DB>.cb_authorpermissions' doesn't exist in engine.  Your database is now in an unusable state.  Please restore your database.


<Contentbox Root>/resources/database/migrations/2020_08_24_150933_v5Upgrade.cfc: line 65
63: 			transactionRollback();
64: 			throw(
65: 				"Migration from identifiers to GUIDs failed due to the following: #e.message#.  Your database is now in an unusable state.  Please restore your database."
66: 			);
67: 		}
called from /modules/commandbox-migrations/modules/cfmigrations/models/MigrationService.cfc: line 300
called from /modules/commandbox-migrations/modules/cfmigrations/models/MigrationService.cfc: line 124
called from /modules/commandbox-migrations/modules/cfmigrations/models/MigrationService.cfc: line 125
called from /modules/commandbox-migrations/commands/migrate/up.cfc: line 54
called from /system/services/CommandService.cfc: line 345
called from /system/services/CommandService.cfc: line 158
called from /system/Shell.cfc: line 784
called from /system/util/CommandDSL.cfc: line 251
called from <Contentbox Root>/Updater.cfc: line 70
called from /system/modules_app/task-commands/models/TaskService.cfc: line 93
called from /system/modules_app/task-commands/models/TaskService.cfc: line 331
called from /system/modules_app/task-commands/models/TaskService.cfc: line 110
called from /system/modules_app/task-commands/commands/task/run.cfc: line 68
called from /system/services/CommandService.cfc: line 345
called from /system/services/CommandService.cfc: line 158
called from /system/Shell.cfc: line 784
called from /system/Bootstrap.cfm: line 119

To enable full stack trace, run config set verboseErrors=true

[lmajano]

Ok we have a case error.

This happens on some databases due to casing issues. Let me revise the casing internally in our upgrader

[lmajano]

Ok here is our migrations

Ortus-Solutions/ContentBox/blob/development/resources/database/migrations/2020_08_24_150933_v5Upgrade.cfc#L516

There you can see the casing that’s supposed to be created. I have some database ignore our casing like postgresql. Which makes our job incredibly hard.

Thus. To make the upgrader work for you I suggest the following

1. Copy this migration to the root/resources/database/migrations folder
2. Open it and review all table names so they match your database
3. Run ‘migrate up’ manually

Once successful you can run updater again. It will see the database has been migrated already and skip it.

[Christian]

Seems like my database is the problem here…
I executed the migration manually and experienced the same problem.
After a some debugging and testing I got the same error message from my database even when executing direct sql-statements.
Unfortunately a complete reset of the db-container was also not successful.
I will try to fix my Database issues tomorrow.