cant use install wizard
Sorry about this dodgy first message - I couldn’t create the real message without it erroring - please see it in the reply
Hi there
I am trying to install contentbox but I am getting an error using the install-wizard…
(Additionally - when asked what engine you are using - both Lucee 5 & 6 are selected, doesn’t seem like that would be correct)
Anyway - the error I am getting is that the sqlformatter class cannot be found.
I retried the install-wizard after manually installing sqlformatter - but they made no difference at all.
Here is the stacktrace
lucee.runtime.exp.ExpressionException: invalid component definition, can't find component [sqlformatter.models.Formatter]
at lucee.runtime.component.ComponentLoader._search(ComponentLoader.java:196)
at lucee.runtime.component.ComponentLoader.searchComponent(ComponentLoader.java:82)
at lucee.runtime.PageContextImpl.loadComponent(PageContextImpl.java:3281)
at lucee.runtime.functions.other.CreateObject.doComponent(CreateObject.java:148)
at lucee.runtime.functions.other.CreateObject.call(CreateObject.java:70)
at lucee.runtime.functions.other.CreateObject.call(CreateObject.java:49)
at system.ioc.builder_cfc$cf.udfCall1(/wirebox/system/ioc/Builder.cfc:151)
at system.ioc.builder_cfc$cf.udfCall(/wirebox/system/ioc/Builder.cfc)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:358)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:698)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586)
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1933)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1776)
at users.gavin._commandbox46.cfml.system.wirebox.system.ioc.injector_cfc$cf.udfCall1(/Users/gavin/.CommandBox/cfml/system/wirebox/system/ioc/Injector.cfc:463)
at users.gavin._commandbox46.cfml.system.wirebox.system.ioc.injector_cfc$cf.udfCall(/Users/gavin/.CommandBox/cfml/system/wirebox/system/ioc/Injector.cfc)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:358)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:698)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586)
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1933)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1776)
at system.ioc.scopes.noscope_cfc$cf.udfCall(/wirebox/system/ioc/scopes/NoScope.cfc:44)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:358)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:698)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586)
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1933)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1776)
at users.gavin._commandbox46.cfml.system.wirebox.system.ioc.injector_cfc$cf.udfCall1(/Users/gavin/.CommandBox/cfml/system/wirebox/system/ioc/Injector.cfc:432)
at users.gavin._commandbox46.cfml.system.wirebox.system.ioc.injector_cfc$cf.udfCall(/Users/gavin/.CommandBox/cfml/system/wirebox/system/ioc/Injector.cfc)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:358)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:698)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586)
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1933)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1776)
at system.ioc.builder_cfc$cf.udfCall3(/wirebox/system/ioc/Builder.cfc:800)
at system.ioc.builder_cfc$cf.udfCall(/wirebox/system/ioc/Builder.cfc)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:358)
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:213)
at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:804)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:866)
at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1795)
at system.ioc.builder_cfc$cf.udfCall2(/wirebox/system/ioc/Builder.cfc:581)
at system.ioc.builder_cfc$cf.udfCall(/wirebox/system/ioc/Builder.cfc)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:358)
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:213)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:699)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586)
at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1952)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:866)
at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1795)
at users.gavin._commandbox46.cfml.system.wirebox.system.ioc.injector_cfc$cf.udfCall3(/Users/gavin/.CommandBox/cfml/system/wirebox/system/ioc/Injector.cfc:994)
at users.gavin._commandbox46.cfml.system.wirebox.system.ioc.injector_cfc$cf.udfCall(/Users/gavin/.CommandBox/cfml/system/wirebox/system/ioc/Injector.cfc)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:358)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223)
at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:786)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1776)
at users.gavin._commandbox46.cfml.system.wirebox.system.ioc.injector_cfc$cf.udfCall1(/Users/gavin/.CommandBox/cfml/system/wirebox/system/ioc/Injector.cfc:738)
at users.gavin._commandbox46.cfml.system.wirebox.system.ioc.injector_cfc$cf.udfCall(/Users/gavin/.CommandBox/cfml/system/wirebox/system/ioc/Injector.cfc)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:358)
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:213)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:699)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586)
at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1952)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:866)
at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1795)
at system.ioc.scopes.singleton_cfc$cf.udfCall(/wirebox/system/ioc/scopes/Singleton.cfc:77)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:358)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:698)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586)
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1933)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1776)
at users.gavin._commandbox46.cfml.system.wirebox.system.ioc.injector_cfc$cf.udfCall1(/Users/gavin/.CommandBox/cfml/system/wirebox/system/ioc/Injector.cfc:432)
at users.gavin._commandbox46.cfml.system.wirebox.system.ioc.injector_cfc$cf.udfCall(/Users/gavin/.CommandBox/cfml/system/wirebox/system/ioc/Injector.cfc)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:358)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:698)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586)
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1933)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1776)
at system.services.commandservice_cfc$cf.udfCall3(/commandbox/system/services/CommandService.cfc:1008)
at system.services.commandservice_cfc$cf.udfCall(/commandbox/system/services/CommandService.cfc)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:358)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223)
at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:786)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1776)
at system.services.commandservice_cfc$cf.udfCall2(/commandbox/system/services/CommandService.cfc:844)
at system.services.commandservice_cfc$cf.udfCall(/commandbox/system/services/CommandService.cfc)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:358)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223)
at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:786)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1776)
at system.services.commandservice_cfc$cf.udfCall1(/commandbox/system/services/CommandService.cfc:238)
at system.services.commandservice_cfc$cf.udfCall(/commandbox/system/services/CommandService.cfc)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:358)
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:213)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:699)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586)
at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1952)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:866)
at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1795)
at system.shell_cfc$cf.udfCall4(/commandbox/system/Shell.cfc:862)
at system.shell_cfc$cf.udfCall(/commandbox/system/Shell.cfc)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:358)
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:213)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:699)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586)
at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1952)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:866)
at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1795)
at system.util.commanddsl_cfc$cf.udfCall2(/commandbox/system/util/CommandDSL.cfc:267)
at system.util.commanddsl_cfc$cf.udfCall(/commandbox/system/util/CommandDSL.cfc)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:358)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:698)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586)
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1933)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1776)
at modules.contentbox_cli495.commands.contentbox.install_cfc$cf.udfCall(/commandbox/modules/contentbox-cli/commands/contentbox/install.cfc:168)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:358)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223)
at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:786)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1776)
at modules.contentbox_cli495.commands.contentbox.install_cfc$cf.udfCall(/commandbox/modules/contentbox-cli/commands/contentbox/install.cfc:145)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:358)
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:213)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:699)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:594)
at lucee.runtime.SuperComponent.callWithNamedValues(SuperComponent.java:93)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:866)
at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1795)
at modules.contentbox_cli495.commands.contentbox.install_wizard_cfc360$cf.udfCall(/commandbox/modules/contentbox-cli/commands/contentbox/install-wizard.cfc:178)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:358)
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:213)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:699)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586)
at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1952)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:866)
at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1795)
at system.services.commandservice_cfc$cf.udfCall1(/commandbox/system/services/CommandService.cfc:443)
at system.services.commandservice_cfc$cf.udfCall(/commandbox/system/services/CommandService.cfc)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:358)
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:213)
at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:804)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:866)
at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1795)
at system.services.commandservice_cfc$cf.udfCall1(/commandbox/system/services/CommandService.cfc:225)
at system.services.commandservice_cfc$cf.udfCall(/commandbox/system/services/CommandService.cfc)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:358)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:698)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586)
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1933)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1776)
at system.shell_cfc$cf.udfCall4(/commandbox/system/Shell.cfc:865)
at system.shell_cfc$cf.udfCall(/commandbox/system/Shell.cfc)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:358)
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:213)
at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:804)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:866)
at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1795)
at system.shell_cfc$cf.udfCall3(/commandbox/system/Shell.cfc:680)
at system.shell_cfc$cf.udfCall(/commandbox/system/Shell.cfc)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:358)
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:213)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:699)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586)
at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1952)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:866)
at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1795)
at users.gavin._commandbox46.cfml.system.bootstrap_cfm$cf.call(/Users/gavin/.CommandBox/cfml/system/Bootstrap.cfm:165)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1057)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:949)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:930)
at j3lh5ynvlgtz.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:65)
at lucee.runtime.jsr223.ScriptEngineImpl.eval(ScriptEngineImpl.java:220)
at cliloader.LoaderCLIMain.execute(LoaderCLIMain.java:339)
at cliloader.LoaderCLIMain.execute(LoaderCLIMain.java:158)
at cliloader.LoaderCLIMain.main(LoaderCLIMain.java:595)
Investigating Gavin. Not sure what the error is.
Hi @lmajano,
Here is what I am doing.
I have installed the contentbox-cli.
I create a new DB
I create a new directory
I CD to the new directory
run box
if the very first thing I do is contentbox install-wizard - I get the error message from the original thread.
if I do
I create a new DB
I create a new directory
I CD to the new directory
run box
install sqlformatter
exit box
start box
server start
I get the following error:
Module [commandbox-migrations] failed to load! Check the logs for more info ( system-log | open ).
Cannot activate module: sqlFormatter
The module has not been registered, register the module first and then activate it.
C:\Users\gavin.CommandBox\cfml\system\services\ModuleService.cfc:414
if I do
I create a new DB
I create a new directory
I CD to the new directory
run box
install commandbox-migrations
contentbox install-wizard
server start
I get a different error…
Message Error building: Restrictions@cborm → the value from key [OBJECT] is NULL, which is the same as not existing in CFML .
Detail DSL: none; Path: cborm.models.criterion.Restrictions; Error Location: C:\Users\gavin\Workspace\cbsecurity\test2\modules\contentbox\modules\contentbox-deps\modules\cborm\models\util\JavaProxyBuilder.cfc:33
C:\Users\gavin\Workspace\cbsecurity\test2\modules\contentbox\modules\contentbox-deps\modules\cborm\models\criterion\Restrictions.cfc:55
I did get it working eventually - by mixing and matching the order of installing things and starting/stopping… but unfortunately I can’t remember which combination worked…
Trying to replicate it now - I can’t get it to work at all…
I’ll delete my .Commandbox folder and start totally fresh and give another update…`
I made a few tweaks, try installed the be: install contentbox-cli@be --force and report back. I am attaching my log.
- WIndows 11
- PostgreSQL
- CommandBox 6.1
I deleted the .CommandBox directory
Box told me there was an update available to 6.1 - which I installed.
I created a brand new database and ran the wizard, and got this error message;
Please wait while we install your migrations table...
Created seeds directory
Migration table installed!
Migrating: 2020_01_01_150933_init
Starting to initialize the ContentBox Database, this will take a while...
Migrating [sites]...
- Table doesn't exist (cb_site) creating it...
Migrating [settings]...
- Table doesn't exist (cb_setting) creating it...
ERROR (6.1.0+00813)
ERROR: relation "idx_deleted" already exists
C:\Users\gavin\.CommandBox\cfml\modules\contentbox-cli\modules\commandbox-migrations\modules\cfmigrations\modules\qb\models\Schema\SchemaBuilder.cfc
CREATE INDEX "idx_deleted" ON "cb_setting" ("isDeleted")
OK
Tried again.
- Deleted .CommandBox
- Dropped / created database
- Windows 11
- CommandBox 6.0.0 (did NOT update to 6.1 when prompted)
update --systeminstall contentbox-cli@be --force- PostgreSQL v14 (Yes it is old - we are STUCK using this version)
contentbox install-wizard
(I Chose Lucee 6 in the installer but - CommandBox complained that Lucee@6 was not a valid choice.)
And got the following error:
ERROR (6.0.0+00787)
No manager found named [contentbox]. Available managers are: default
I seem to be getting a different issue, every time…
No idea what is going on - which is why I thought I would try again with a completely CLEAN start : but that seems to be an issue for me, too!
I think I might have to swap PHP and Laravel at this stage!
And just for the hell of it - let’s try with the same config except - lets use the be version of ContentBox : 6.1.0-Snapshot
I get the following error, now:
Error creating command [/C__Users_gavin__CommandBox/cfml/modules/commandbox-migrations/commands.migrate.install]
invalid component definition, can't find component [sqlformatter.models.Formatter]
Which is similar to the errors I was getting originally when I first started trying to install.
Ok, I think the issue is PostgreSQL. I know @gunnar.lieb reported issues in our migrations for PostgreSQL which is fixed in be for ContentBox.
Just to reiterate so I can test accordingly:
OS: Windows
CFML Engine: Lucee 5 or 6
I would not recommend 6 as we have still tons of regressions on many box libraries and who knows when they will fix them.
CommandBox 6.1
DB: PostgreSQL 14
Can you confirm, and then I can build a lab on this.
The issue has been reported and it’s been looked at.
Hi @lmajano,
Awesome thanks very much for your help!
@elpete
If you would like me to do any testing.
If you would like any help, in any way at all.
Please feel free to bother me any time.
@GavinBaumanis I want to keep you informed.
I have made progress on this. Here are some things I have found.
- PostgreSQL is very strict
and is being a pain so I can have consistency. However, I am almost there with all migrations. If you want to start now, you can use MySQL and then migrate over. - Lucee 6 is broken. Lucee 6 has several regressions and ContentBox just doesn’t even work. This is going to take time as I need to report them to the Lucee team, and well, I’ll leave it at that. At this point, I would say use Lucee 5 as 6 won’t work right now.
Once I finalize the migrations portions, I will report back. The commandbox migrations issue has been fixed and released via ContentBox 6.1
1 Like
Hi @lmajano
Thanks very much for the update.
I am happy to help with a PR…
If you’d like to let me know what is needed - IK can do the leg-work for you.
Eg. PostgreSQL requires insert to be like this instead of that
update like …
Hi @GavinBaumanis sorry for the long pause, but we are getting ready to launch BoxLang here. So this has taken a back burner. I would love help on this. I have closed all the bugs with the CLI and migrations. Right now, the issue I have is making sure the migrations are updated so they work with PostgreSQL. It would be super helpful!
I have made the necessary changes in the migration files.
Altering the numeric 0/1 → true/false.
But the migration still fails.
I THINK it is a QB problem - but it is a guess.
The problem is that my boolean values are being stringified when run.
For example, one my changes is:
from
"isDeleted": 0
to
"isDeleted": false
but when the migration is being run - my false value is getting changed to "false"
Here is the output of the error I get when I use my changed code:
ERROR (6.2.0+00826)
ERROR: column "isDeleted" is of type boolean but expression is of type character varyingHint: You will need to rewrite or cast the expression.Position: 135
C:\Users\gavin\.CommandBox\cfml\modules\commandbox-migrations\modules\cfmigrations\modules\qb\models\Query\QueryBuilder.cfc
INSERT INTO
"cb_permission" (
"createdDate",
"description",
"isDeleted",
"modifiedDate",
"permission",
"permissionID"
)
VALUES
(
{ ts '2025-04-05 20:52:07' },
'Ability to manage authors, default is view only',
'false',
{ ts '2025-04-05 20:52:07' },
'AUTHOR_ADMIN',
'F6EE4223-C159-4208-AFCF1D2164B5DF2A'
),
I have submitted the 0|1 → false|true changes PR - but I cannot test it locally - and have mentioned this in the PR.
As always please let me know if I can do anything else.
Do we know of a cfm server/database combo that can be installed via Commandbox? I’ve tried SQL Server in both Lucee 5 and 6 and it fails. I thought I’d try PostgreSQL using same and it fails as well with the above error mentioned by Gavin. Thank you.
Tried using ChatGTP for a little help getting either SQL Server or PostgreSQL running. After quite a number of tries to no avail this was its suggestion. - 
If you want my honest advice:
Forget ContentBox installs unless you’re married to it.
Start clean ColdBox app (coldbox create app)
Manually manage your DB schema — skip ORM hell for now.
Use SQL Server — it’s way more reliable under CFML than PostgreSQL (in your stack).
Hi @irvirv
Apologies in advance if I am telling you something that you already know…
The choice of DB engine - isn’t the issue as such - it is the DB Migrations that are tied to ContentBox.
I have submitted a PR that will correct the migrations - and they SHOULD work with all engines.
There is a sticking point, however, that another Ortus library (“Query Builder”) that uses the migration scripts (that I submitted the PR for) - also needs a correction as it is treating Boolean types as Strings. This is stopping me from actually being able to use the scripts I just changed and also stops the PR from being accepted and merged in - because they can’t be tested.
The Ortus guys are flat-out at the moment polishing off the initial release of BoxLang - but have said they will get to it as soon as they can.
Along the way, as time permits, they are helping me - but again- they just don’t have the time in the “now” - to help out.
As for ChatGPT suggestions…
I don’t know if MS-SQL server works.
I can state that MySQL - wholly works, though.
(I am assuming) - they do “their” initial work in MySQL - then do “porting/fix-ups” - for the other engines.
As with all people… the secondary work - doesn’t always get done at the same time - because you just don’t have endless amounts of time.
And the secondary list of tasks - falls down the queue in importance - as more work comes in.
I will take a look at the Query Builder (QB) repo and see if I can work it out for myself…
But I haven’t ever looked at the code before - so it might take a while.
Yes, my reply was kind of snarkey but there are a couple of other threads here with VERY similar issues that are now approaching a year old with no fix. Meanwhile their product homepage makes a statement as to install that is laughable at best. I really love Coldbox and the people I’ve met at Ortus over the years are super smart but at bare minimum they should just scale this app’s description back to what it really is and quit making some of these claims. Again, probably I should just leave it alone. That said, one of their team members made a statement on another thread here that kind of makes me feel they don’t care to EVER really fix this product. Thanks. -Irv