/library/img//unnamed_(4).jpg By Olga Bulankina Tue, May 11,2021 2894 views

IIG welcomes new professor of Digital Transformation

IIG welcomes new professor of Digital Transformation

We are pleased to welcome Vincent Ducret as a new faculty member who will be teaching Digital Transformation.

Vincent has a bachelor of science and a master of science in Computer Engineering from EPFL, a world leading engineering school. After a career as Software Architect and Project Manager in System Integrators and Hardware/Software companies with Sun Microsystems, Vincent joined PMI International cumulating with the position of Head of Information Systems Innovation.

 

Warmest Welcome, Mr Ducret!

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]