With "contentbox install-wizard", no dice on either MSSQL or MySQL

higgjose · February 29, 2024, 3:34am

I am having issues with install. I ready through this post and I can see the Ortus ORM engine installed by default using the .env file. The attached picture is what is showing when I try to go to the cbamdin page. The installer crashed when trying to populate the database. I can uninstall the ORM plugin and get the no ORM error instead of the above error. And I am assuming the version installed is what is needed. I upgraded through the various versions and it made no difference to the error. Obviously, ORM is not working and stalling at the DB steps of the wizard. I have tried different java versions and an open source JRE.

I have been trying for 2 days and keep running into same issue. Can’y find a work around.

CaptainPalapa · February 29, 2024, 4:25am

From my experience, I can tell you that I had this, and the ONLY way I was able to resolve it, if I remember correctly was to:

Remove Hibernate completely. The “regular hibernate”.
Remove any Ortus ORM installations.
Re-install the Ortus ORM.

The Ortus ORM comes bundled with Hibernate, but apparently you get a big 'ol conflict.

lmajano · February 29, 2024, 9:07am

First, can you post the entire stacktrace. The caused by is missing and we can’t tell what kicked that error.

Second. How did you install ContentBox? Did you use the cli? Did the migrations run correctly?
Can you post your server.json

higgjose · March 1, 2024, 3:29am

Thank you Luis for checking,.

I used the wizard cli in box to install. It crashes during the migrate (beginning). When I try the migrate by hand, it installs the migrate table in the SQL Server. So I know my db drivers are good and database connection works. I have tried both default and be versions, same issue. I can see your previous commit to load the “lucee-extensions”:“D062D72F-F8A2-46F0-8CBC91325B2F067B” in the server.json. When I open lucee server admin I see the Ortus ORM installed. As suggested above, I did not think to uninstall the hybernate, because it did not show it already installed. I did try upgrading to each version of ortus ORM including the snapshots without any luck.I also uninstalled, installed the old hybernate, then uninstalled and put the default Ortus one back in. Same error. Something is not connecting in the background.

When I uninstall Ortus ORM I get an error " No ORM Engine installed!" .

Stack trace below:

Lucee 5.4.4.38 Error (org.hibernate.exception.SQLGrammarException)
Message could not extract ResultSet
Error Code 208
Stacktrace The Error Occurred in
D:\MyApp\modules\contentbox\modules\contentbox-deps\modules\cborm\models\criterion\CriteriaBuilder.cfc: line 150
148:
149: // Get listing
150: var results = variables.nativeCriteria.list() ?: ;
151:
152: // process interception

called from D:\MyApp\modules\contentbox\models\system\SettingService.cfc: line 260
called from D:\MyApp\modules\contentbox\ModuleConfig.cfc: line 149
called from D:\MyApp\coldbox\system\web\services\ModuleService.cfc: line 836
called from D:\MyApp\coldbox\system\web\services\ModuleService.cfc: line 546
called from D:\MyApp\coldbox\system\web\services\LoaderService.cfc: line 88
called from D:\MyApp\coldbox\system\Bootstrap.cfc: line 110
called from D:\MyApp\Application.cfc: line 144
Java Stacktrace lucee.runtime.exp.NativeException: could not extract ResultSet
at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:103)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:37)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:67)
at org.hibernate.loader.Loader.getResultSet(Loader.java:2322)
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2075)
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2037)
at org.hibernate.loader.Loader.doQuery(Loader.java:956)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:357)
at org.hibernate.loader.Loader.doList(Loader.java:2868)
at org.hibernate.loader.Loader.doList(Loader.java:2850)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2682)
at org.hibernate.loader.Loader.list(Loader.java:2677)
at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:109)
at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1922)
at org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:370)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.base/java.lang.reflect.Method.invoke(Unknown Source)
at lucee.runtime.reflection.pairs.MethodInstance.invoke(MethodInstance.java:56)
at lucee.runtime.reflection.Reflector.callMethod(Reflector.java:877)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:831)
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1775)
at models.criterion.criteriabuilder_cfc$cf.udfCall1(/cborm/models/criterion/CriteriaBuilder.cfc:150)
at models.criterion.criteriabuilder_cfc$cf.udfCall(/cborm/models/criterion/CriteriaBuilder.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:1794)
at models.system.settingservice_cfc$cf.udfCall1(/contentbox/models/system/SettingService.cfc:260)
at models.system.settingservice_cfc$cf.udfCall(/contentbox/models/system/SettingService.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:1775)
at modules.contentbox.moduleconfig_cfc$cf.udfCall(/modules/contentbox/ModuleConfig.cfc:149)
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:1775)
at system.web.services.moduleservice_cfc$cf.udfCall2(/coldbox/system/web/services/ModuleService.cfc:836)
at system.web.services.moduleservice_cfc$cf.udfCall(/coldbox/system/web/services/ModuleService.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:1775)
at system.web.services.moduleservice_cfc$cf.udfCall2(/coldbox/system/web/services/ModuleService.cfc:546)
at system.web.services.moduleservice_cfc$cf.udfCall(/coldbox/system/web/services/ModuleService.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:1775)
at system.web.services.loaderservice_cfc$cf.udfCall1(/coldbox/system/web/services/LoaderService.cfc:88)
at system.web.services.loaderservice_cfc$cf.udfCall(/coldbox/system/web/services/LoaderService.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:1775)
at coldbox.system.bootstrap_cfc$cf.udfCall1(/coldbox/system/Bootstrap.cfc:110)
at coldbox.system.bootstrap_cfc$cf.udfCall(/coldbox/system/Bootstrap.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:1775)
at application_cfc$cf.udfCall(/Application.cfc:144)
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.listener.ModernAppListener.call(ModernAppListener.java:444)
at lucee.runtime.listener.ModernAppListener.onApplicationStart(ModernAppListener.java:306)
at lucee.runtime.PageContextImpl.initApplicationContext(PageContextImpl.java:3168)
at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:122)
at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:44)
at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2493)
at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2478)
at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2449)
at lucee.runtime.engine.Request.exe(Request.java:45)
at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1215)
at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1161)
at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97)
at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:51)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:590)
at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
at org.cfmlprojects.regexpathinfofilter.RegexPathInfoFilter.doFilter(RegexPathInfoFilter.java:54)
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
at runwar.undertow.SSLCertHeaderHandler.handleRequest(SSLCertHeaderHandler.java:161)
at io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:257)
at io.undertow.servlet.handlers.ServletInitialHandler.dispatchToPath(ServletInitialHandler.java:182)
at io.undertow.servlet.spec.RequestDispatcherImpl.forwardImpl(RequestDispatcherImpl.java:188)
at io.undertow.servlet.spec.RequestDispatcherImpl.forwardImplSetup(RequestDispatcherImpl.java:136)
at io.undertow.servlet.spec.RequestDispatcherImpl.forward(RequestDispatcherImpl.java:99)
at org.cfmlprojects.regexpathinfofilter.RegexPathInfoFilter.doFilter(RegexPathInfoFilter.java:52)
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
at runwar.undertow.SSLCertHeaderHandler.handleRequest(SSLCertHeaderHandler.java:161)
at io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:117)
at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
at io.undertow.servlet.handlers.SendErrorPageHandler.handleRequest(SendErrorPageHandler.java:52)
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:275)
at io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:79)
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:134)
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:131)
at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:255)
at io.undertow.servlet.handlers.ServletInitialHandler.handleRequest(ServletInitialHandler.java:175)
at io.undertow.server.handlers.HttpContinueReadHandler.handleRequest(HttpContinueReadHandler.java:69)
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
at runwar.undertow.WelcomeFileHandler.handleRequest(WelcomeFileHandler.java:39)
at io.undertow.server.handlers.PathHandler.handleRequest(PathHandler.java:104)
at runwar.undertow.SiteDeployment$1.handleRequest(SiteDeployment.java:162)
at io.undertow.predicate.PredicatesHandler.handleRequest(PredicatesHandler.java:141)
at io.undertow.predicate.PredicatesHandler.handleRequest(PredicatesHandler.java:141)
at io.undertow.server.handlers.SetAttributeHandler.handleRequest(SetAttributeHandler.java:119)
at io.undertow.server.handlers.builder.RewriteHandlerBuilder$2$1.handleRequest(RewriteHandlerBuilder.java:92)
at io.undertow.predicate.PredicatesHandler.handleRequest(PredicatesHandler.java:113)
at io.undertow.predicate.PredicatesHandler.handleRequest(PredicatesHandler.java:113)
at io.undertow.server.handlers.DisallowedMethodsHandler.handleRequest(DisallowedMethodsHandler.java:62)
at io.undertow.predicate.PredicatesHandler.handleRequest(PredicatesHandler.java:113)
at io.undertow.server.handlers.encoding.EncodingHandler.handleRequest(EncodingHandler.java:72)
at runwar.undertow.LifecyleHandler.handleRequest(LifecyleHandler.java:143)
at runwar.undertow.SiteDeployment$4.handleRequest(SiteDeployment.java:345)
at io.undertow.server.Connectors.executeRootHandler(Connectors.java:393)
at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:852)
at org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)
at org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:2019)
at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1558)
at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1423)
at org.xnio.XnioWorker$WorkerThreadFactory$1$1.run(XnioWorker.java:1282)
at java.base/java.lang.Thread.run(Unknown Source)
Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
… 183 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name ‘cb_setting’.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:285)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:57)
… 178 more

Timestamp 3/1/24 3:18:57 AM UTC

higgjose · March 1, 2024, 3:35am

I tried this and, no joy. I did not see the regular hibernate as installed by default. So I removed, ortus ORM, installed old one, uninstalled it, and reinstalled Ortus ORM. Still no joy. Tried several versions of Ortus, no joy.

higgjose · March 1, 2024, 3:37am

Server .json
{
“name”:“MyApp2”,
“web”:{
“directoryBrowsing”:false,
“rewrites”:{
“enable”:“true”
}
},
“JVM”:{
“heapSize”:“768”,
“args”:“-Dfile.encoding=UTF8 -Dcom.sun.net.ssl.enableECC=false”
},
“openBrowserURL”:“/”,
“trayicon”:“modules_app/contentbox-custom/_content/ContentBoxIcon300.png”,
“trayOptions”:[
{
“label”:“Open ContentBox Admin”,
“action”:“openbrowser”,
“url”:“/cbadmin”,
“disabled”:false,
“image”:“modules_app/contentbox-custom/_content/ContentBoxIcon300.png”
}
],
“cfconfig”:{
“file”:“.cfconfig.json”
},
“env”:{
“lucee-extensions”:“D062D72F-F8A2-46F0-8CBC91325B2F067B”
},
“openBrowser”:“true”,
“app”:{
“cfengine”:“lucee@5”
}
}

MichaelBorn · March 1, 2024, 3:42am

Assuming you’re talking about the ContentBox CLI, what version are you using? This very thread describes fixes that are only available in the latest version, 1.5.2, so you need to be on version 1.5.2 of the ContentBox CLI.

What does “it crashes” mean here? Can you paste the full stack trace?

Well that depends - what does “by hand” mean? Do you mean running migrate up from the CommandBox shell? That would definitely be a solid test of the CFML datasource and your CFMigrations configuration. Anything other than that would be a confusing “red herring”.

Both default and be versions of what?

What version?

What was suggested above was specific to @CaptainPalapa 's set up and installation process, which was subpar before the Ortus ORM extension installation command was corrected in the ContentBox CLI v 1.5.2. Your experience is likely different, which is why tagging on to this thread is more confusing than anything.

Which prior described issue is this stack trace from? Is this what you see when you log in to the cbadmin?

MichaelBorn · March 1, 2024, 3:45am

@higgjose You’re seeing issues in the CB admin because the installation process failed. You need to run the ContentBox migrations during the installation process, whether via the CLI wizard or by manually executing migrate up from commandbox in the root of your contentbox app directory.

Until those migrations are run, you’re going to see errors about non-existing tables, because of course those tables haven’t been created yet. So it’s pointless to debug issues in the /cbadmin if you haven’t finished the installation process.

Hence, let’s focus on why the migrations are failing on your end.

higgjose · March 1, 2024, 3:55am

I get this error when trying to run migrate up.

Yes, the install errored at this point, and not able to recover. The stacktrace above is from navigating to the cbadmin page. I was just trying to troubleshoot where the issue could be. It was odd that it could create the migrations table, but nothing else. I wonder if the migrations table creation does not use any ORM??? Just a guess.
Any suggested next step?

MichaelBorn · March 1, 2024, 4:14am

Is this a brand new database? I would try dropping the table(s) and re-trying the migrate up command.

The “Migration table not installed.” error is pretty odd, since the error indicates it does exist. That seems like it may need some tweaking in ContentBox, but I’d have to go poke at it.

I don’t know what ContentBox’s migrations are written like, but I would bet they don’t use ORM or Hibernate at all, but instead plain SQL or QB queries. Just another reason we don’t need to worry about your installed ORM extension version right now.

higgjose · March 1, 2024, 4:15am

MichaelBorn:

higgjose:

I used the wizard cli in box to install.

Assuming you’re talking about the ContentBox CLI, what version are you using? This very thread describes fixes that are only available in the latest version, 1.5.2, so you need to be on version 1.5.2 of the ContentBox CLI.
I can’t find a place that the version is located. Suffice it to say, I ran update contentbox-cli, so it should have the latest one. There are no outstanding dependencies.

higgjose:

It crashes during the migrate (beginning)

What does “it crashes” mean here? Can you paste the full stack trace?
The contentbox-cli install crashes when it starts the database table creation activities. There is no crash log other than the error on the screen that I can see.

higgjose:

When I try the migrate by hand, it installs the migrate table in the SQL Server. So I know my db drivers are good and database connection works.

Well that depends - what does “by hand” mean? Do you mean running migrate up from the CommandBox shell? That would definitely be a solid test of the CFML datasource and your CFMigrations configuration. Anything other than that would be a confusing “red herring”.

Correct, I am running migrate up.

higgjose:

I have tried both default and be versions, same issue.

Both default and be versions of what? contentbox. When you follow the wizard, if you leave the option for version blank, it installs the latest stable version, or if you put ‘be’ you get the bleeding edge. I have tried both.

higgjose:

When I open lucee server admin I see the Ortus ORM installed.

What version?
Ortus ORM Extension 6.4.0 (I tried several verions, and of course, it reverts back to 6.4.0 upon server restart because of the entry in the .env file, which is expected).

higgjose:

As suggested above, I did not think to uninstall the hybernate, because it did not show it already installed.

What was suggested above was specific to @CaptainPalapa 's set up and installation process, which was subpar before the Ortus ORM extension installation command was corrected in the ContentBox CLI v 1.5.2. Your experience is likely different, which is why tagging on to this thread is more confusing than anything.

higgjose:

Stack trace below:

Apologies for tagging onto the thread.

Which prior described issue is this stack trace from? Is this what you see when you log in to the cbadmin?

Yes, it is from cbadmin. I was just trying to get default app up and going, and looking for places to troubleshoot.

higgjose · March 1, 2024, 4:17am

MichaelBorn:

higgjose:

Any suggested next step?

Is this a brand new database? I would try dropping the table(s) and re-trying the migrate up command.
Yes, brand new MSSQL database. It is running on Unraid Docker image, but that should not make a difference.

The “Migration table not installed.” error is pretty odd, since the error indicates it does exist. That seems like it may need some tweaking in ContentBox, but I’d have to go poke at it.

higgjose:

I wonder if the migrations table creation does not use any ORM??? Just a guess.

I don’t know what ContentBox’s migrations are written like, but I would bet they don’t use ORM or Hibernate at all, but instead plain SQL or QB queries. Just another reason we don’t need to worry about your installed ORM extension version right now.

I am a newb, but trying to learn, please be patient with me. I dropped the migrations table and reran and it still errors.

higgjose · March 1, 2024, 4:22am

These are the 3 tables that are created during the install process, prior to the crash. I have dropped them and tried reinstall. Still no joy. Dropped and tried migrate up after failed install as well.

after a drop of the tables, and migrate up command I get

Then I get stuck in the loop of, the table is already installed.

MichaelBorn · March 1, 2024, 4:23am

Totally understand! I’ve been a noob for a long, long time now. And you’re asking good questions and doing a good job of getting to the root of the issue.

With that said, the more details you can share the easier it is to help. Especially details we specifically ask for, like what version of the ContentBox CLI you are using.

higgjose · March 1, 2024, 4:24am

How do I find the version?

MichaelBorn · March 1, 2024, 4:28am

I’m sure there’s better ways to do it, but this CommandBox command will show you the installed version and the most recent version:

outdated --system | grep contentbox

MichaelBorn · March 1, 2024, 4:39am

I went and dug through the ContentBox CLI source and found this:

github.com

Ortus-Solutions/contentbox-cli/blob/development/commands/contentbox/install.cfc#L129-L141


      
          		variables.print
          			.greenLine(
          				"ContentBox has been installed and configured on disk. We will now verify your database credentials, and install the database migrations."
          			)
          			.redBoldLine( "Make sure your database (#arguments.databaseName#) has been created!" )
          			.redBoldLine(
          				"If this process fails, then your database credentials are not correct.  Verify them and make sure they match the ones in the (.env) file we created."
          			)
          			.redBoldLine(
          				"You don't have to run the installer again if it fails. You can run the following commands to finish your installation:"
          			)
          			.redBoldLine( "- migrate install" )
          			.redBoldLine( "- run-script contentbox:migrate" );

I’m guessing the migrations failed due to some initially-misconfigured connection details, then the instructions on what to do if migrations failed were missed.

So the command I told you to run , migrate up, was not correct. (Sorry! I don’t use ContentBox myself.) Instead, you should run:

migrate install
run-script contentbox:migrate

This is because ContentBox uses a custom CFMigrations manager to do special stuff with its migrations. Here’s where that contentbox:migrate script is defined:

github.com

Ortus-Solutions/ContentBox/blob/807784b57e4540232abb9803ac1acef4ae10cb9d/box.json#L68


      
              "start:lucee":"server start serverConfigFile='server-lucee@5.json' --force",
              "start:2018":"server start serverConfigFile='server-adobe@2018.json' --force",
              "start:2021":"server start serverConfigFile='server-adobe@2021.json' --force",
              "start:2023":"server start serverConfigFile='server-adobe@2023.json' --force",
              "log:lucee":"server log serverConfigFile=server-lucee@5.json --follow",
              "log:2018":"server log serverConfigFile=server-adobe@2018.json --follow",
              "log:2021":"server log serverConfigFile=server-adobe@2021.json --follow",
              "log:2023":"server log serverConfigFile=server-adobe@2023.json --follow",
              "contentbox:install":"install --force && cd modules/contentbox && install --force",
              "contentbox:migrate:create":"migrate create name=${1} manager=contentbox",
              "contentbox:migrate":"migrate up manager=contentbox",
              "contentbox:migrate:up":"run-script contentbox:migrate",
              "contentbox:migrate:down":"migrate down manager=contentbox",
              "contentbox:migrate:fresh":"migrate fresh manager=contentbox"
          },
          "testbox":{
              "runner":[
                  {
                      "default":"http://127.0.0.1:8589/tests/runner.cfm"
                  },
                  {

higgjose · March 1, 2024, 5:32am

I did not miss them when it stopped during install the first time. I did not mention that I had done this. This is what happened when I ran those 2 steps (again).

MichaelBorn · March 1, 2024, 2:31pm

Yep, so you have a partially constructed database so the migration will fail. From here, I think all you have to do is

Drop all tables from that database
Run migrate install
Run run-script contentbox:migrate

higgjose · March 1, 2024, 2:50pm

Have done that several times. The ascension i posted last night is the outcome of this operation.

With "contentbox install-wizard", no dice on either MSSQL or MySQL

Latest Ortus News

GIVING BACK

HARVESTING IN SPANISH

WOODSEDGE