/library/img//_Prof._Vincenzo_Pallota.png By Olga Bulankina Sun, February 07,2021 1972 views

IIG welcomes new professor of Innovations and Entrepreneurship - Dr. Pallotta Vincenzo

We are proud to announce the appointment of Vincenzo Pallota our new professor!

PhD in Computer Science, Swiss Federal Institute of Technology Lausanne (EPFL), Switzerland, MSc in Information Science, University of Pisa, Italy. PMI-PMP, ITIL v.3 and PRINCE2 certified.

 Professor Vincenzo is the founder and former CTO of interAnalytics Sàrl. He has over 30 years of experience in ICT, has worked as a software engineer at IBM and Apple Italy, and as a researcher at EPFL, University of Fribourg and University of Geneva.

He is the author of more than 100 publications in international journals and conferences. He is the member of several advisory boards of Swiss
startups and a jury member and mentor in several startup acceleration programs such as MassChallenge, Seedstars World, Venture and Impact Hub.

Warm Welcome Professor Vincenzo!

struct
Cause
struct
ErrorCode 1055
Message Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'cms_iun.cms_post_s.POST_DATE' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQLState 42000
StackTrace java.sql.SQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'cms_iun.cms_post_s.POST_DATE' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:764) at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:781) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1567) at coldfusion.sql.Executive.executeQuery(Executive.java:1317) at coldfusion.sql.Executive.executeQuery(Executive.java:1247) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:427) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1211) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:841) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:794) at cfget2ecfm434816839._factor4(D:\vhosts\www.wideagency.ch\netvertisCMS\cms\handlers\default\get.cfm:228) at cfget2ecfm434816839._factor7(D:\vhosts\www.wideagency.ch\netvertisCMS\cms\handlers\default\get.cfm:171) at cfget2ecfm434816839._factor8(D:\vhosts\www.wideagency.ch\netvertisCMS\cms\handlers\default\get.cfm:1) at cfget2ecfm434816839.runPage(D:\vhosts\www.wideagency.ch\netvertisCMS\cms\handlers\default\get.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:330) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cfsidebar2ecfm1544399287.runPage(D:\vhosts\www.iig.ch\handlers\v2_blog\sidebar.cfm:10) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cfdetail2ecfm1945358417.runPage(D:\vhosts\www.iig.ch\handlers\v2_blog\detail.cfm:177) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:330) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cfinvoker2ecfm1304907224.runPage(D:\vhosts\www.wideagency.ch\netvertisCMS\cms\customtags\invoker.cfm:55) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:330) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cfdetail2ecfm2002289900.runPage(D:\vhosts\www.iig.ch\pages\detail.cfm:18) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cfindex2ecfm1591340439.runPage(D:\vhosts\www.wideagency.ch\netvertisCMS\cms\customtags\htdocs\index.cfm:57) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cfindex2ecfm184466660.runPage(D:\vhosts\www.iig.ch\html\index.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:555) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:96) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:226) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:377) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:463) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:844)
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 228
RAW_TRACE at cfget2ecfm434816839._factor4(D:\vhosts\www.wideagency.ch\netvertisCMS\cms\handlers\default\get.cfm:228)
TEMPLATE D:\vhosts\www.wideagency.ch\netvertisCMS\cms\handlers\default\get.cfm
TYPE CFML
2
struct
COLUMN 0
ID CF_GET
LINE 171
RAW_TRACE at cfget2ecfm434816839._factor7(D:\vhosts\www.wideagency.ch\netvertisCMS\cms\handlers\default\get.cfm:171)
TEMPLATE D:\vhosts\www.wideagency.ch\netvertisCMS\cms\handlers\default\get.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_GET
LINE 1
RAW_TRACE at cfget2ecfm434816839._factor8(D:\vhosts\www.wideagency.ch\netvertisCMS\cms\handlers\default\get.cfm:1)
TEMPLATE D:\vhosts\www.wideagency.ch\netvertisCMS\cms\handlers\default\get.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_GET
LINE 1
RAW_TRACE at cfget2ecfm434816839.runPage(D:\vhosts\www.wideagency.ch\netvertisCMS\cms\handlers\default\get.cfm:1)
TEMPLATE D:\vhosts\www.wideagency.ch\netvertisCMS\cms\handlers\default\get.cfm
TYPE CFML
5
struct
COLUMN 0
ID CFMODULE
LINE 10
RAW_TRACE at cfsidebar2ecfm1544399287.runPage(D:\vhosts\www.iig.ch\handlers\v2_blog\sidebar.cfm:10)
TEMPLATE D:\vhosts\www.iig.ch\handlers\v2_blog\sidebar.cfm
TYPE CFML
6
struct
COLUMN 0
ID CFINCLUDE
LINE 177
RAW_TRACE at cfdetail2ecfm1945358417.runPage(D:\vhosts\www.iig.ch\handlers\v2_blog\detail.cfm:177)
TEMPLATE D:\vhosts\www.iig.ch\handlers\v2_blog\detail.cfm
TYPE CFML
7
struct
COLUMN 0
ID CFMODULE
LINE 55
RAW_TRACE at cfinvoker2ecfm1304907224.runPage(D:\vhosts\www.wideagency.ch\netvertisCMS\cms\customtags\invoker.cfm:55)
TEMPLATE D:\vhosts\www.wideagency.ch\netvertisCMS\cms\customtags\invoker.cfm
TYPE CFML
8
struct
COLUMN 0
ID CFMODULE
LINE 18
RAW_TRACE at cfdetail2ecfm2002289900.runPage(D:\vhosts\www.iig.ch\pages\detail.cfm:18)
TEMPLATE D:\vhosts\www.iig.ch\pages\detail.cfm
TYPE CFML
9
struct
COLUMN 0
ID CFINCLUDE
LINE 57
RAW_TRACE at cfindex2ecfm1591340439.runPage(D:\vhosts\www.wideagency.ch\netvertisCMS\cms\customtags\htdocs\index.cfm:57)
TEMPLATE D:\vhosts\www.wideagency.ch\netvertisCMS\cms\customtags\htdocs\index.cfm
TYPE CFML
10
struct
COLUMN 0
ID CFINCLUDE
LINE 1
RAW_TRACE at cfindex2ecfm184466660.runPage(D:\vhosts\www.iig.ch\html\index.cfm:1)
TEMPLATE D:\vhosts\www.iig.ch\html\index.cfm
TYPE CFML
Type java.sql.SQLSyntaxErrorException
DataSource cms_iun
Detail Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'cms_iun.cms_post_s.POST_DATE' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
ErrorCode 42000
Exceptions
array
1
struct
class java.sql.SQLSyntaxErrorException
message Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'cms_iun.cms_post_s.POST_DATE' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Message Error Executing Database Query.
NativeErrorCode 1055
RootCause
struct
ErrorCode 1055
Message Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'cms_iun.cms_post_s.POST_DATE' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQLState 42000
StackTrace java.sql.SQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'cms_iun.cms_post_s.POST_DATE' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:764) at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:781) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1567) at coldfusion.sql.Executive.executeQuery(Executive.java:1317) at coldfusion.sql.Executive.executeQuery(Executive.java:1247) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:427) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1211) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:841) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:794) at cfget2ecfm434816839._factor4(D:\vhosts\www.wideagency.ch\netvertisCMS\cms\handlers\default\get.cfm:228) at cfget2ecfm434816839._factor7(D:\vhosts\www.wideagency.ch\netvertisCMS\cms\handlers\default\get.cfm:171) at cfget2ecfm434816839._factor8(D:\vhosts\www.wideagency.ch\netvertisCMS\cms\handlers\default\get.cfm:1) at cfget2ecfm434816839.runPage(D:\vhosts\www.wideagency.ch\netvertisCMS\cms\handlers\default\get.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:330) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cfsidebar2ecfm1544399287.runPage(D:\vhosts\www.iig.ch\handlers\v2_blog\sidebar.cfm:10) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cfdetail2ecfm1945358417.runPage(D:\vhosts\www.iig.ch\handlers\v2_blog\detail.cfm:177) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:330) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cfinvoker2ecfm1304907224.runPage(D:\vhosts\www.wideagency.ch\netvertisCMS\cms\customtags\invoker.cfm:55) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:330) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cfdetail2ecfm2002289900.runPage(D:\vhosts\www.iig.ch\pages\detail.cfm:18) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cfindex2ecfm1591340439.runPage(D:\vhosts\www.wideagency.ch\netvertisCMS\cms\customtags\htdocs\index.cfm:57) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cfindex2ecfm184466660.runPage(D:\vhosts\www.iig.ch\html\index.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:555) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:96) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:226) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:377) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:463) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:844)
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 228
RAW_TRACE at cfget2ecfm434816839._factor4(D:\vhosts\www.wideagency.ch\netvertisCMS\cms\handlers\default\get.cfm:228)
TEMPLATE D:\vhosts\www.wideagency.ch\netvertisCMS\cms\handlers\default\get.cfm
TYPE CFML
2
struct
COLUMN 0
ID CF_GET
LINE 171
RAW_TRACE at cfget2ecfm434816839._factor7(D:\vhosts\www.wideagency.ch\netvertisCMS\cms\handlers\default\get.cfm:171)
TEMPLATE D:\vhosts\www.wideagency.ch\netvertisCMS\cms\handlers\default\get.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_GET
LINE 1
RAW_TRACE at cfget2ecfm434816839._factor8(D:\vhosts\www.wideagency.ch\netvertisCMS\cms\handlers\default\get.cfm:1)
TEMPLATE D:\vhosts\www.wideagency.ch\netvertisCMS\cms\handlers\default\get.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_GET
LINE 1
RAW_TRACE at cfget2ecfm434816839.runPage(D:\vhosts\www.wideagency.ch\netvertisCMS\cms\handlers\default\get.cfm:1)
TEMPLATE D:\vhosts\www.wideagency.ch\netvertisCMS\cms\handlers\default\get.cfm
TYPE CFML
5
struct
COLUMN 0
ID CFMODULE
LINE 10
RAW_TRACE at cfsidebar2ecfm1544399287.runPage(D:\vhosts\www.iig.ch\handlers\v2_blog\sidebar.cfm:10)
TEMPLATE D:\vhosts\www.iig.ch\handlers\v2_blog\sidebar.cfm
TYPE CFML
6
struct
COLUMN 0
ID CFINCLUDE
LINE 177
RAW_TRACE at cfdetail2ecfm1945358417.runPage(D:\vhosts\www.iig.ch\handlers\v2_blog\detail.cfm:177)
TEMPLATE D:\vhosts\www.iig.ch\handlers\v2_blog\detail.cfm
TYPE CFML
7
struct
COLUMN 0
ID CFMODULE
LINE 55
RAW_TRACE at cfinvoker2ecfm1304907224.runPage(D:\vhosts\www.wideagency.ch\netvertisCMS\cms\customtags\invoker.cfm:55)
TEMPLATE D:\vhosts\www.wideagency.ch\netvertisCMS\cms\customtags\invoker.cfm
TYPE CFML
8
struct
COLUMN 0
ID CFMODULE
LINE 18
RAW_TRACE at cfdetail2ecfm2002289900.runPage(D:\vhosts\www.iig.ch\pages\detail.cfm:18)
TEMPLATE D:\vhosts\www.iig.ch\pages\detail.cfm
TYPE CFML
9
struct
COLUMN 0
ID CFINCLUDE
LINE 57
RAW_TRACE at cfindex2ecfm1591340439.runPage(D:\vhosts\www.wideagency.ch\netvertisCMS\cms\customtags\htdocs\index.cfm:57)
TEMPLATE D:\vhosts\www.wideagency.ch\netvertisCMS\cms\customtags\htdocs\index.cfm
TYPE CFML
10
struct
COLUMN 0
ID CFINCLUDE
LINE 1
RAW_TRACE at cfindex2ecfm184466660.runPage(D:\vhosts\www.iig.ch\html\index.cfm:1)
TEMPLATE D:\vhosts\www.iig.ch\html\index.cfm
TYPE CFML
Type java.sql.SQLSyntaxErrorException
SQLState 42000
Sql select post_date, year(post_date) as y, month(post_date) as m, count(*) as counter, concat(year(post_date),"-",if(MONTH(post_date) < 10,"0",''),MONTH(post_date)) as k from cms_objects_s,cms_post_s where 0=0 and isdeleted = 0 and status < 5 and cms_post_s.objectid = cms_objects_s.objectid and parentobjectid='CA06CC6B-BC21-C770-6905083D7F7CD324' and typename='post' and language='en-en' and published=1 and siteid='PORTAILA-D813-6982-BC79B857C1B4169' group by year(post_date),MONTH(post_date) order by post_date desc
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:894) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:794) at cfget2ecfm434816839._factor4(D:\vhosts\www.wideagency.ch\netvertisCMS\cms\handlers\default\get.cfm:228) at cfget2ecfm434816839._factor7(D:\vhosts\www.wideagency.ch\netvertisCMS\cms\handlers\default\get.cfm:171) at cfget2ecfm434816839._factor8(D:\vhosts\www.wideagency.ch\netvertisCMS\cms\handlers\default\get.cfm:1) at cfget2ecfm434816839.runPage(D:\vhosts\www.wideagency.ch\netvertisCMS\cms\handlers\default\get.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:330) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cfsidebar2ecfm1544399287.runPage(D:\vhosts\www.iig.ch\handlers\v2_blog\sidebar.cfm:10) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cfdetail2ecfm1945358417.runPage(D:\vhosts\www.iig.ch\handlers\v2_blog\detail.cfm:177) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:330) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cfinvoker2ecfm1304907224.runPage(D:\vhosts\www.wideagency.ch\netvertisCMS\cms\customtags\invoker.cfm:55) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:330) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cfdetail2ecfm2002289900.runPage(D:\vhosts\www.iig.ch\pages\detail.cfm:18) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cfindex2ecfm1591340439.runPage(D:\vhosts\www.wideagency.ch\netvertisCMS\cms\customtags\htdocs\index.cfm:57) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cfindex2ecfm184466660.runPage(D:\vhosts\www.iig.ch\html\index.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:555) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:96) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:226) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:377) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:463) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:844) Caused by: java.sql.SQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'cms_iun.cms_post_s.POST_DATE' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:764) at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:781) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1567) at coldfusion.sql.Executive.executeQuery(Executive.java:1317) at coldfusion.sql.Executive.executeQuery(Executive.java:1247) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:427) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1211) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:841) ... 79 more
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 228
RAW_TRACE at cfget2ecfm434816839._factor4(D:\vhosts\www.wideagency.ch\netvertisCMS\cms\handlers\default\get.cfm:228)
TEMPLATE D:\vhosts\www.wideagency.ch\netvertisCMS\cms\handlers\default\get.cfm
TYPE CFML
2
struct
COLUMN 0
ID CF_GET
LINE 171
RAW_TRACE at cfget2ecfm434816839._factor7(D:\vhosts\www.wideagency.ch\netvertisCMS\cms\handlers\default\get.cfm:171)
TEMPLATE D:\vhosts\www.wideagency.ch\netvertisCMS\cms\handlers\default\get.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_GET
LINE 1
RAW_TRACE at cfget2ecfm434816839._factor8(D:\vhosts\www.wideagency.ch\netvertisCMS\cms\handlers\default\get.cfm:1)
TEMPLATE D:\vhosts\www.wideagency.ch\netvertisCMS\cms\handlers\default\get.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_GET
LINE 1
RAW_TRACE at cfget2ecfm434816839.runPage(D:\vhosts\www.wideagency.ch\netvertisCMS\cms\handlers\default\get.cfm:1)
TEMPLATE D:\vhosts\www.wideagency.ch\netvertisCMS\cms\handlers\default\get.cfm
TYPE CFML
5
struct
COLUMN 0
ID CFMODULE
LINE 10
RAW_TRACE at cfsidebar2ecfm1544399287.runPage(D:\vhosts\www.iig.ch\handlers\v2_blog\sidebar.cfm:10)
TEMPLATE D:\vhosts\www.iig.ch\handlers\v2_blog\sidebar.cfm
TYPE CFML
6
struct
COLUMN 0
ID CFINCLUDE
LINE 177
RAW_TRACE at cfdetail2ecfm1945358417.runPage(D:\vhosts\www.iig.ch\handlers\v2_blog\detail.cfm:177)
TEMPLATE D:\vhosts\www.iig.ch\handlers\v2_blog\detail.cfm
TYPE CFML
7
struct
COLUMN 0
ID CFMODULE
LINE 55
RAW_TRACE at cfinvoker2ecfm1304907224.runPage(D:\vhosts\www.wideagency.ch\netvertisCMS\cms\customtags\invoker.cfm:55)
TEMPLATE D:\vhosts\www.wideagency.ch\netvertisCMS\cms\customtags\invoker.cfm
TYPE CFML
8
struct
COLUMN 0
ID CFMODULE
LINE 18
RAW_TRACE at cfdetail2ecfm2002289900.runPage(D:\vhosts\www.iig.ch\pages\detail.cfm:18)
TEMPLATE D:\vhosts\www.iig.ch\pages\detail.cfm
TYPE CFML
9
struct
COLUMN 0
ID CFINCLUDE
LINE 57
RAW_TRACE at cfindex2ecfm1591340439.runPage(D:\vhosts\www.wideagency.ch\netvertisCMS\cms\customtags\htdocs\index.cfm:57)
TEMPLATE D:\vhosts\www.wideagency.ch\netvertisCMS\cms\customtags\htdocs\index.cfm
TYPE CFML
10
struct
COLUMN 0
ID CFINCLUDE
LINE 1
RAW_TRACE at cfindex2ecfm184466660.runPage(D:\vhosts\www.iig.ch\html\index.cfm:1)
TEMPLATE D:\vhosts\www.iig.ch\html\index.cfm
TYPE CFML
Type Database
queryError Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'cms_iun.cms_post_s.POST_DATE' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
where [empty string]