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 …