PayPal Express return url
12 views
Skip to first unread message
Marc Ackermann
Dec 10, 2020, 5:10:29 AM12/10/20
to Slatwall Commerce
Hi,
can someone please tell me what value I have to store in the paypal express api settings on the paypal site for the return url.
I tried it like this
But when making a test, this returns me to the "Step 1- Account Details" of the Checkout Example template with a url like this
Best regards,
Marc
Marc Ackermann
Dec 10, 2020, 5:34:15 AM12/10/20
to Slatwall Commerce
I meant the value for "Payment Return URL" on the "Integration Settings" tab in Slatwall.
Marc Ackermann
Dec 10, 2020, 7:49:00 AM12/10/20
to Slatwall Commerce
OK, I found out that the reason was, that I used a guest account for checkout.
SQL:select slatwallac0_.accountID as col_0_0_, count(distinct slatwallpe2_.permissionGroupID) as col_1_0_ from SwAccount slatwallac0_ left outer join SwAccountPermissionGroup permission1_ on slatwallac0_.accountID=permission1_.accountID left outer join SwPermissionGroup slatwallpe2_ on permission1_.permissionGroupID=slatwallpe2_.permissionGroupID where slatwallac0_.accountID=?
Now with a registered account I get this slatwall error:
500 Errorcould not execute query
SQL:select slatwallac0_.accountID as col_0_0_, count(distinct slatwallpe2_.permissionGroupID) as col_1_0_ from SwAccount slatwallac0_ left outer join SwAccountPermissionGroup permission1_ on slatwallac0_.accountID=permission1_.accountID left outer join SwPermissionGroup slatwallpe2_ on permission1_.permissionGroupID=slatwallpe2_.permissionGroupID where slatwallac0_.accountID=?
Column 'SwAccount.accountID' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause
Code:8120
Type:org.hibernate.exception.SQLGrammarException
lucee.runtime.exp.NativeException: could not execute query at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) at org.hibernate.loader.Loader.doList(Loader.java:2452) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2192) at org.hibernate.loader.Loader.list(Loader.java:2187) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:452) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1258) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102) at org.lucee.extension.orm.hibernate.HibernateORMSession.__executeQuery(HibernateORMSession.java:490) at org.lucee.extension.orm.hibernate.HibernateORMSession._executeQuery(HibernateORMSession.java:348) at org.lucee.extension.orm.hibernate.HibernateORMSession.executeQuery(HibernateORMSession.java:338) at lucee.runtime.functions.orm.ORMExecuteQuery._call(ORMExecuteQuery.java:71) at lucee.runtime.functions.orm.ORMExecuteQuery.call(ORMExecuteQuery.java:47) at model.dao.permissiongroupdao_cfc$cf.udfCall(/Slatwall/model/dao/PermissionGroupDAO.cfc:8) 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:680) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:568) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1898) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:785) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1710) at model.entity.account_cfc$cf$ag.udfCall3(/Slatwall/model/entity/Account.cfc:393) at model.entity.account_cfc$cf$ag.udfCall(/Slatwall/model/entity/Account.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:680) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:568) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1898) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:785) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1710) at org.hibachi.hibachiauthenticationservice_cfc$cf.udfCall2(/Slatwall/org/Hibachi/HibachiAuthenticationService.cfc:338) at org.hibachi.hibachiauthenticationservice_cfc$cf.udfCall(/Slatwall/org/Hibachi/HibachiAuthenticationService.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:681) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:568) at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1917) at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:864) at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1729) at org.hibachi.hibachiscope_cfc$cf.udfCall5(/Slatwall/org/Hibachi/HibachiScope.cfc:459) at org.hibachi.hibachiscope_cfc$cf.udfCall(/Slatwall/org/Hibachi/HibachiScope.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:681) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:568) at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1917) at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:864) at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1729) at org.hibachi.hibachitransient_cfc$cf.udfCall3(/Slatwall/org/Hibachi/HibachiTransient.cfc:204) at org.hibachi.hibachitransient_cfc$cf.udfCall(/Slatwall/org/Hibachi/HibachiTransient.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:681) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:576) at lucee.runtime.SuperComponent.callWithNamedValues(SuperComponent.java:93) at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:864) at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1729) at hibachientity_cfc$cf.udfCall1(/HibachiEntity.cfc:56) at hibachientity_cfc$cf.udfCall(/HibachiEntity.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:681) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:576) at lucee.runtime.SuperComponent.callWithNamedValues(SuperComponent.java:93) at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:864) at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1729) at model.entity.orderpayment_cfc$cf$cw.udfCall7(/Slatwall/model/entity/OrderPayment.cfc:850) at model.entity.orderpayment_cfc$cf$cw.udfCall(/Slatwall/model/entity/OrderPayment.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:680) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:568) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1898) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:785) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1710) at org.hibachi.hibachitransient_cfc$cf.udfCall3(/Slatwall/org/Hibachi/HibachiTransient.cfc:268) at org.hibachi.hibachitransient_cfc$cf.udfCall(/Slatwall/org/Hibachi/HibachiTransient.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:680) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:568) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1898) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:785) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1710) at org.hibachi.hibachiservice_cfc$cf.udfCall2(/Slatwall/org/Hibachi/HibachiService.cfc:161) at org.hibachi.hibachiservice_cfc$cf.udfCall(/Slatwall/org/Hibachi/HibachiService.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:792) at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:864) at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1729) at org.hibachi.hibachiservice_cfc$cf.udfCall4(/Slatwall/org/Hibachi/HibachiService.cfc:767) at org.hibachi.hibachiservice_cfc$cf.udfCall(/Slatwall/org/Hibachi/HibachiService.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:779) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:785) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1710) at org.hibachi.hibachiservice_cfc$cf.udfCall2(/Slatwall/org/Hibachi/HibachiService.cfc:440) at org.hibachi.hibachiservice_cfc$cf.udfCall(/Slatwall/org/Hibachi/HibachiService.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:680) at lucee.runtime.ComponentImpl.onMissingMethod(ComponentImpl.java:607) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:570) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1898) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:785) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1710) at integrationservices.paypalexpress.controllers.main_cfc$cf$1ar.udfCall(/Slatwall/integrationServices/paypalexpress/controllers/main.cfc:126) 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:681) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:568) at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1917) at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:898) at lucee.runtime.functions.dynamicEvaluation.Invoke.call(Invoke.java:49) at org.hibachi.framework.one_cfc$cf.udfCalla(/Slatwall/org/Hibachi/framework/one.cfc:1573) at org.hibachi.framework.one_cfc$cf.udfCall(/Slatwall/org/Hibachi/framework/one.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:779) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:785) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1710) at org.hibachi.framework.one_cfc$cf.udfCall6(/Slatwall/org/Hibachi/framework/one.cfc:888) at org.hibachi.framework.one_cfc$cf.udfCall(/Slatwall/org/Hibachi/framework/one.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:779) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:785) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1710) at org.hibachi.hibachi_cfc$cf.udfCall3(/Slatwall/org/Hibachi/Hibachi.cfc:1247) at org.hibachi.hibachi_cfc$cf.udfCall(/Slatwall/org/Hibachi/Hibachi.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:680) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:568) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1898) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:785) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1710) at org.hibachi.hibachiscope_cfc$cf.udfCall3(/Slatwall/org/Hibachi/HibachiScope.cfc:294) at org.hibachi.hibachiscope_cfc$cf.udfCall(/Slatwall/org/Hibachi/HibachiScope.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:680) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:568) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1898) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:785) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1710) at integrationservices.mura.model.handler.muraeventhandler_cfc$cf.udfCall1(/Slatwall/integrationServices/mura/model/handler/MuraEventHandler.cfc:106) at integrationservices.mura.model.handler.muraeventhandler_cfc$cf.udfCall(/Slatwall/integrationServices/mura/model/handler/MuraEventHandler.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:681) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:568) at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1912) at lucee.runtime.tag.Invoke.doComponent(Invoke.java:209) at lucee.runtime.tag.Invoke.doEndTag(Invoke.java:186) at plugin.pluginmanager_cfc$cf.udfCall3_000048_000052(/mura/plugin/pluginManager.cfc:1738) at plugin.pluginmanager_cfc$cf.udfCall3_000048(/mura/plugin/pluginManager.cfc:1728) at plugin.pluginmanager_cfc$cf.udfCall3(/mura/plugin/pluginManager.cfc:1583) at plugin.pluginmanager_cfc$cf.udfCall(/mura/plugin/pluginManager.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:792) at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:864) at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1729) at plugin.pluginmanager_cfc$cf.udfCall3(/mura/plugin/pluginManager.cfc:1275) at plugin.pluginmanager_cfc$cf.udfCall(/mura/plugin/pluginManager.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:680) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:568) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1898) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:785) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1710) at content.contentserver_cfc$cf.udfCall2(/mura/content/contentServer.cfc:788) at content.contentserver_cfc$cf.udfCall(/mura/content/contentServer.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:779) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:785) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1710) at content.contentserver_cfc$cf.udfCall1(/mura/content/contentServer.cfc:259) at content.contentserver_cfc$cf.udfCall(/mura/content/contentServer.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:779) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:785) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1710) at content.contentserver_cfc$cf.udfCall1(/mura/content/contentServer.cfc:345) at content.contentserver_cfc$cf.udfCall(/mura/content/contentServer.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:681) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:568) at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1917) at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:864) at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1729) at content.contentserver_cfc$cf.udfCall2(/mura/content/contentServer.cfc:716) at content.contentserver_cfc$cf.udfCall(/mura/content/contentServer.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:680) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:568) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1898) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:785) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1710) at index_cfm$cf$vv.call(/index.cfm:43) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:945) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:837) at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:216) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:42) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2416) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2406) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2381) at lucee.runtime.engine.Request.exe(Request.java:43) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1170) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1116) 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:741) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:415) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1639) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Unknown Source) Caused by: org.hibernate.exception.SQLGrammarException: could not execute query ... 267 more Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Column 'SwAccount.accountID' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. 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.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208) at org.hibernate.loader.Loader.getResultSet(Loader.java:1869) at org.hibernate.loader.Loader.doQuery(Loader.java:718) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:270) at org.hibernate.loader.Loader.doList(Loader.java:2449) ... 264 more
Column: 0
ID: ??
Line: 8
Raw Trace: model.dao.permissiongroupdao_cfc$cf.udfCall(/Slatwall/model/dao/PermissionGroupDAO.cfc:8)
Template: D:\inetpub\website06\httpdoc\Slatwall\model\dao\PermissionGroupDAO.cfc
Type: cfml
Column: 0
ID: ??
Line: 393
Raw Trace: model.entity.account_cfc$cf$ag.udfCall3(/Slatwall/model/entity/Account.cfc:393)
Template: D:\inetpub\website06\httpdoc\Slatwall\model\entity\Account.cfc
Type: cfml
Type:org.hibernate.exception.SQLGrammarException
lucee.runtime.exp.NativeException: could not execute query at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) at org.hibernate.loader.Loader.doList(Loader.java:2452) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2192) at org.hibernate.loader.Loader.list(Loader.java:2187) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:452) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1258) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102) at org.lucee.extension.orm.hibernate.HibernateORMSession.__executeQuery(HibernateORMSession.java:490) at org.lucee.extension.orm.hibernate.HibernateORMSession._executeQuery(HibernateORMSession.java:348) at org.lucee.extension.orm.hibernate.HibernateORMSession.executeQuery(HibernateORMSession.java:338) at lucee.runtime.functions.orm.ORMExecuteQuery._call(ORMExecuteQuery.java:71) at lucee.runtime.functions.orm.ORMExecuteQuery.call(ORMExecuteQuery.java:47) at model.dao.permissiongroupdao_cfc$cf.udfCall(/Slatwall/model/dao/PermissionGroupDAO.cfc:8) 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:680) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:568) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1898) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:785) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1710) at model.entity.account_cfc$cf$ag.udfCall3(/Slatwall/model/entity/Account.cfc:393) at model.entity.account_cfc$cf$ag.udfCall(/Slatwall/model/entity/Account.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:680) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:568) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1898) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:785) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1710) at org.hibachi.hibachiauthenticationservice_cfc$cf.udfCall2(/Slatwall/org/Hibachi/HibachiAuthenticationService.cfc:338) at org.hibachi.hibachiauthenticationservice_cfc$cf.udfCall(/Slatwall/org/Hibachi/HibachiAuthenticationService.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:681) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:568) at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1917) at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:864) at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1729) at org.hibachi.hibachiscope_cfc$cf.udfCall5(/Slatwall/org/Hibachi/HibachiScope.cfc:459) at org.hibachi.hibachiscope_cfc$cf.udfCall(/Slatwall/org/Hibachi/HibachiScope.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:681) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:568) at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1917) at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:864) at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1729) at org.hibachi.hibachitransient_cfc$cf.udfCall3(/Slatwall/org/Hibachi/HibachiTransient.cfc:204) at org.hibachi.hibachitransient_cfc$cf.udfCall(/Slatwall/org/Hibachi/HibachiTransient.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:681) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:576) at lucee.runtime.SuperComponent.callWithNamedValues(SuperComponent.java:93) at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:864) at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1729) at hibachientity_cfc$cf.udfCall1(/HibachiEntity.cfc:56) at hibachientity_cfc$cf.udfCall(/HibachiEntity.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:681) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:576) at lucee.runtime.SuperComponent.callWithNamedValues(SuperComponent.java:93) at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:864) at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1729) at model.entity.orderpayment_cfc$cf$cw.udfCall7(/Slatwall/model/entity/OrderPayment.cfc:850) at model.entity.orderpayment_cfc$cf$cw.udfCall(/Slatwall/model/entity/OrderPayment.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:680) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:568) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1898) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:785) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1710) at org.hibachi.hibachitransient_cfc$cf.udfCall3(/Slatwall/org/Hibachi/HibachiTransient.cfc:268) at org.hibachi.hibachitransient_cfc$cf.udfCall(/Slatwall/org/Hibachi/HibachiTransient.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:680) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:568) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1898) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:785) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1710) at org.hibachi.hibachiservice_cfc$cf.udfCall2(/Slatwall/org/Hibachi/HibachiService.cfc:161) at org.hibachi.hibachiservice_cfc$cf.udfCall(/Slatwall/org/Hibachi/HibachiService.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:792) at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:864) at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1729) at org.hibachi.hibachiservice_cfc$cf.udfCall4(/Slatwall/org/Hibachi/HibachiService.cfc:767) at org.hibachi.hibachiservice_cfc$cf.udfCall(/Slatwall/org/Hibachi/HibachiService.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:779) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:785) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1710) at org.hibachi.hibachiservice_cfc$cf.udfCall2(/Slatwall/org/Hibachi/HibachiService.cfc:440) at org.hibachi.hibachiservice_cfc$cf.udfCall(/Slatwall/org/Hibachi/HibachiService.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:680) at lucee.runtime.ComponentImpl.onMissingMethod(ComponentImpl.java:607) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:570) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1898) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:785) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1710) at integrationservices.paypalexpress.controllers.main_cfc$cf$1ar.udfCall(/Slatwall/integrationServices/paypalexpress/controllers/main.cfc:126) 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:681) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:568) at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1917) at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:898) at lucee.runtime.functions.dynamicEvaluation.Invoke.call(Invoke.java:49) at org.hibachi.framework.one_cfc$cf.udfCalla(/Slatwall/org/Hibachi/framework/one.cfc:1573) at org.hibachi.framework.one_cfc$cf.udfCall(/Slatwall/org/Hibachi/framework/one.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:779) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:785) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1710) at org.hibachi.framework.one_cfc$cf.udfCall6(/Slatwall/org/Hibachi/framework/one.cfc:888) at org.hibachi.framework.one_cfc$cf.udfCall(/Slatwall/org/Hibachi/framework/one.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:779) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:785) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1710) at org.hibachi.hibachi_cfc$cf.udfCall3(/Slatwall/org/Hibachi/Hibachi.cfc:1247) at org.hibachi.hibachi_cfc$cf.udfCall(/Slatwall/org/Hibachi/Hibachi.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:680) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:568) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1898) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:785) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1710) at org.hibachi.hibachiscope_cfc$cf.udfCall3(/Slatwall/org/Hibachi/HibachiScope.cfc:294) at org.hibachi.hibachiscope_cfc$cf.udfCall(/Slatwall/org/Hibachi/HibachiScope.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:680) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:568) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1898) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:785) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1710) at integrationservices.mura.model.handler.muraeventhandler_cfc$cf.udfCall1(/Slatwall/integrationServices/mura/model/handler/MuraEventHandler.cfc:106) at integrationservices.mura.model.handler.muraeventhandler_cfc$cf.udfCall(/Slatwall/integrationServices/mura/model/handler/MuraEventHandler.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:681) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:568) at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1912) at lucee.runtime.tag.Invoke.doComponent(Invoke.java:209) at lucee.runtime.tag.Invoke.doEndTag(Invoke.java:186) at plugin.pluginmanager_cfc$cf.udfCall3_000048_000052(/mura/plugin/pluginManager.cfc:1738) at plugin.pluginmanager_cfc$cf.udfCall3_000048(/mura/plugin/pluginManager.cfc:1728) at plugin.pluginmanager_cfc$cf.udfCall3(/mura/plugin/pluginManager.cfc:1583) at plugin.pluginmanager_cfc$cf.udfCall(/mura/plugin/pluginManager.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:792) at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:864) at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1729) at plugin.pluginmanager_cfc$cf.udfCall3(/mura/plugin/pluginManager.cfc:1275) at plugin.pluginmanager_cfc$cf.udfCall(/mura/plugin/pluginManager.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:680) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:568) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1898) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:785) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1710) at content.contentserver_cfc$cf.udfCall2(/mura/content/contentServer.cfc:788) at content.contentserver_cfc$cf.udfCall(/mura/content/contentServer.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:779) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:785) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1710) at content.contentserver_cfc$cf.udfCall1(/mura/content/contentServer.cfc:259) at content.contentserver_cfc$cf.udfCall(/mura/content/contentServer.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:779) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:785) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1710) at content.contentserver_cfc$cf.udfCall1(/mura/content/contentServer.cfc:345) at content.contentserver_cfc$cf.udfCall(/mura/content/contentServer.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:681) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:568) at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1917) at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:864) at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1729) at content.contentserver_cfc$cf.udfCall2(/mura/content/contentServer.cfc:716) at content.contentserver_cfc$cf.udfCall(/mura/content/contentServer.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:680) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:568) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1898) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:785) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1710) at index_cfm$cf$vv.call(/index.cfm:43) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:945) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:837) at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:216) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:42) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2416) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2406) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2381) at lucee.runtime.engine.Request.exe(Request.java:43) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1170) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1116) 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:741) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:415) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1639) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Unknown Source) Caused by: org.hibernate.exception.SQLGrammarException: could not execute query ... 267 more Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Column 'SwAccount.accountID' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. 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.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208) at org.hibernate.loader.Loader.getResultSet(Loader.java:1869) at org.hibernate.loader.Loader.doQuery(Loader.java:718) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:270) at org.hibernate.loader.Loader.doList(Loader.java:2449) ... 264 more
Column: 0
ID: ??
Line: 8
Raw Trace: model.dao.permissiongroupdao_cfc$cf.udfCall(/Slatwall/model/dao/PermissionGroupDAO.cfc:8)
Template: D:\inetpub\website06\httpdoc\Slatwall\model\dao\PermissionGroupDAO.cfc
Type: cfml
Column: 0
ID: ??
Line: 393
Raw Trace: model.entity.account_cfc$cf$ag.udfCall3(/Slatwall/model/entity/Account.cfc:393)
Template: D:\inetpub\website06\httpdoc\Slatwall\model\entity\Account.cfc
Type: cfml
Reply all
Reply to author
Forward
0 new messages