struct

EVENTNAME

[empty string]

EXCEPTION

struct

Cause

struct

Cause

struct

Cause

struct

Message

HOUR_OF_DAY: 2 -> 3

StackTrace

java.lang.IllegalArgumentException: HOUR_OF_DAY: 2 -> 3 at java.base/java.util.GregorianCalendar.computeTime(GregorianCalendar.java:2826) at java.base/java.util.Calendar.updateTime(Calendar.java:3425) at java.base/java.util.Calendar.getTimeInMillis(Calendar.java:1812) at com.mysql.cj.result.SqlTimestampValueFactory.localCreateFromTimestamp(SqlTimestampValueFactory.java:108) at com.mysql.cj.result.SqlTimestampValueFactory.localCreateFromTimestamp(SqlTimestampValueFactory.java:50) at com.mysql.cj.result.AbstractDateTimeValueFactory.createFromTimestamp(AbstractDateTimeValueFactory.java:87) at com.mysql.cj.protocol.a.MysqlTextValueDecoder.decodeTimestamp(MysqlTextValueDecoder.java:81) at com.mysql.cj.protocol.result.AbstractResultsetRow.decodeAndCreateReturnValue(AbstractResultsetRow.java:87) at com.mysql.cj.protocol.result.AbstractResultsetRow.getValueFromBytes(AbstractResultsetRow.java:241) at com.mysql.cj.protocol.a.result.TextBufferRow.getValue(TextBufferRow.java:132) at com.mysql.cj.jdbc.result.ResultSetImpl.getTimestamp(ResultSetImpl.java:914) at com.mysql.cj.jdbc.result.ResultSetImpl.getObject(ResultSetImpl.java:1254) at coldfusion.sql.QueryTable.populate(QueryTable.java:426) at coldfusion.sql.QueryTable.populate(QueryTable.java:289) at coldfusion.sql.Executive.getRowSet(Executive.java:722) at coldfusion.sql.Executive.executeQuery(Executive.java:1604) at coldfusion.sql.Executive.executeQuery(Executive.java:1327) at coldfusion.sql.Executive.executeQuery(Executive.java:1257) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:876) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821) at cfEventSVC2ecfc2061729744$funcGETEVENTMEMBER.runFunction(/home/balboa/public_html/com/archinet/balboa/EventSVC.cfc:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:553) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:681) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:980) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:762) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4165) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4129) at cfEventDAO2ecfc1357935367$funcREAD.runFunction(/home/balboa/public_html/com/archinet/balboa/model/EventDAO.cfc:76) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:553) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:310) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4254) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4217) at cfEventSVC2ecfc2061729744$funcREAD.runFunction(/home/balboa/public_html/com/archinet/balboa/EventSVC.cfc:39) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:553) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:310) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4254) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4217) at cfviewEvent2ecfm792433810._factor17(/home/balboa/public_html/viewEvent.cfm:35) at cfviewEvent2ecfm792433810.runPage(/home/balboa/public_html/viewEvent.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:573) 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:97) 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:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:228) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:163) 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:190) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:163) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:190) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:163) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143) 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:373) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:462) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:893) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1723) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:834)

Suppressed

array[empty]

TagContext

array

struct
COLUMN	0
ID	CFQUERY
LINE	449
RAW_TRACE	at cfEventSVC2ecfc2061729744$funcGETEVENTMEMBER.runFunction(/home/balboa/public_html/com/archinet/balboa/EventSVC.cfc:449)
TEMPLATE	/home/balboa/public_html/com/archinet/balboa/EventSVC.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	76
RAW_TRACE	at cfEventDAO2ecfc1357935367$funcREAD.runFunction(/home/balboa/public_html/com/archinet/balboa/model/EventDAO.cfc:76)
TEMPLATE	/home/balboa/public_html/com/archinet/balboa/model/EventDAO.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	39
RAW_TRACE	at cfEventSVC2ecfc2061729744$funcREAD.runFunction(/home/balboa/public_html/com/archinet/balboa/EventSVC.cfc:39)
TEMPLATE	/home/balboa/public_html/com/archinet/balboa/EventSVC.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	35
RAW_TRACE	at cfviewEvent2ecfm792433810._factor17(/home/balboa/public_html/viewEvent.cfm:35)
TEMPLATE	/home/balboa/public_html/viewEvent.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_VIEWEVENT
LINE	1
RAW_TRACE	at cfviewEvent2ecfm792433810.runPage(/home/balboa/public_html/viewEvent.cfm:1)
TEMPLATE	/home/balboa/public_html/viewEvent.cfm
TYPE	CFML

Type

java.lang.IllegalArgumentException

Message

HOUR_OF_DAY: 2 -> 3

SQLState

S1009

StackTrace

com.mysql.cj.exceptions.WrongArgumentException: HOUR_OF_DAY: 2 -> 3 at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490) at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) at com.mysql.cj.result.SqlTimestampValueFactory.localCreateFromTimestamp(SqlTimestampValueFactory.java:112) at com.mysql.cj.result.SqlTimestampValueFactory.localCreateFromTimestamp(SqlTimestampValueFactory.java:50) at com.mysql.cj.result.AbstractDateTimeValueFactory.createFromTimestamp(AbstractDateTimeValueFactory.java:87) at com.mysql.cj.protocol.a.MysqlTextValueDecoder.decodeTimestamp(MysqlTextValueDecoder.java:81) at com.mysql.cj.protocol.result.AbstractResultsetRow.decodeAndCreateReturnValue(AbstractResultsetRow.java:87) at com.mysql.cj.protocol.result.AbstractResultsetRow.getValueFromBytes(AbstractResultsetRow.java:241) at com.mysql.cj.protocol.a.result.TextBufferRow.getValue(TextBufferRow.java:132) at com.mysql.cj.jdbc.result.ResultSetImpl.getTimestamp(ResultSetImpl.java:914) at com.mysql.cj.jdbc.result.ResultSetImpl.getObject(ResultSetImpl.java:1254) at coldfusion.sql.QueryTable.populate(QueryTable.java:426) at coldfusion.sql.QueryTable.populate(QueryTable.java:289) at coldfusion.sql.Executive.getRowSet(Executive.java:722) at coldfusion.sql.Executive.executeQuery(Executive.java:1604) at coldfusion.sql.Executive.executeQuery(Executive.java:1327) at coldfusion.sql.Executive.executeQuery(Executive.java:1257) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:876) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821) at cfEventSVC2ecfc2061729744$funcGETEVENTMEMBER.runFunction(/home/balboa/public_html/com/archinet/balboa/EventSVC.cfc:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:553) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:681) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:980) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:762) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4165) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4129) at cfEventDAO2ecfc1357935367$funcREAD.runFunction(/home/balboa/public_html/com/archinet/balboa/model/EventDAO.cfc:76) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:553) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:310) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4254) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4217) at cfEventSVC2ecfc2061729744$funcREAD.runFunction(/home/balboa/public_html/com/archinet/balboa/EventSVC.cfc:39) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:553) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:310) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4254) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4217) at cfviewEvent2ecfm792433810._factor17(/home/balboa/public_html/viewEvent.cfm:35) at cfviewEvent2ecfm792433810.runPage(/home/balboa/public_html/viewEvent.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:573) 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:97) 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:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:228) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:163) 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:190) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:163) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:190) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:163) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143) 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:373) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:462) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:893) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1723) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:834) Caused by: java.lang.IllegalArgumentException: HOUR_OF_DAY: 2 -> 3 at java.base/java.util.GregorianCalendar.computeTime(GregorianCalendar.java:2826) at java.base/java.util.Calendar.updateTime(Calendar.java:3425) at java.base/java.util.Calendar.getTimeInMillis(Calendar.java:1812) at com.mysql.cj.result.SqlTimestampValueFactory.localCreateFromTimestamp(SqlTimestampValueFactory.java:108) ... 103 more

Suppressed

array[empty]

TagContext

array

struct
COLUMN	0
ID	CFQUERY
LINE	449
RAW_TRACE	at cfEventSVC2ecfc2061729744$funcGETEVENTMEMBER.runFunction(/home/balboa/public_html/com/archinet/balboa/EventSVC.cfc:449)
TEMPLATE	/home/balboa/public_html/com/archinet/balboa/EventSVC.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	76
RAW_TRACE	at cfEventDAO2ecfc1357935367$funcREAD.runFunction(/home/balboa/public_html/com/archinet/balboa/model/EventDAO.cfc:76)
TEMPLATE	/home/balboa/public_html/com/archinet/balboa/model/EventDAO.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	39
RAW_TRACE	at cfEventSVC2ecfc2061729744$funcREAD.runFunction(/home/balboa/public_html/com/archinet/balboa/EventSVC.cfc:39)
TEMPLATE	/home/balboa/public_html/com/archinet/balboa/EventSVC.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	35
RAW_TRACE	at cfviewEvent2ecfm792433810._factor17(/home/balboa/public_html/viewEvent.cfm:35)
TEMPLATE	/home/balboa/public_html/viewEvent.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_VIEWEVENT
LINE	1
RAW_TRACE	at cfviewEvent2ecfm792433810.runPage(/home/balboa/public_html/viewEvent.cfm:1)
TEMPLATE	/home/balboa/public_html/viewEvent.cfm
TYPE	CFML

Transient

Type

com.mysql.cj.exceptions.WrongArgumentException

VendorCode

ErrorCode

Message

HOUR_OF_DAY: 2 -> 3

SQLState

S1009

StackTrace

java.sql.SQLException: HOUR_OF_DAY: 2 -> 3 at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:85) at com.mysql.cj.jdbc.result.ResultSetImpl.getTimestamp(ResultSetImpl.java:914) at com.mysql.cj.jdbc.result.ResultSetImpl.getObject(ResultSetImpl.java:1254) at coldfusion.sql.QueryTable.populate(QueryTable.java:426) at coldfusion.sql.QueryTable.populate(QueryTable.java:289) at coldfusion.sql.Executive.getRowSet(Executive.java:722) at coldfusion.sql.Executive.executeQuery(Executive.java:1604) at coldfusion.sql.Executive.executeQuery(Executive.java:1327) at coldfusion.sql.Executive.executeQuery(Executive.java:1257) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:876) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821) at cfEventSVC2ecfc2061729744$funcGETEVENTMEMBER.runFunction(/home/balboa/public_html/com/archinet/balboa/EventSVC.cfc:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:553) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:681) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:980) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:762) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4165) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4129) at cfEventDAO2ecfc1357935367$funcREAD.runFunction(/home/balboa/public_html/com/archinet/balboa/model/EventDAO.cfc:76) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:553) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:310) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4254) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4217) at cfEventSVC2ecfc2061729744$funcREAD.runFunction(/home/balboa/public_html/com/archinet/balboa/EventSVC.cfc:39) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:553) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:310) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4254) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4217) at cfviewEvent2ecfm792433810._factor17(/home/balboa/public_html/viewEvent.cfm:35) at cfviewEvent2ecfm792433810.runPage(/home/balboa/public_html/viewEvent.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:573) 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:97) 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:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:228) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:163) 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:190) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:163) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:190) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:163) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143) 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:373) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:462) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:893) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1723) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:834) Caused by: com.mysql.cj.exceptions.WrongArgumentException: HOUR_OF_DAY: 2 -> 3 at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490) at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) at com.mysql.cj.result.SqlTimestampValueFactory.localCreateFromTimestamp(SqlTimestampValueFactory.java:112) at com.mysql.cj.result.SqlTimestampValueFactory.localCreateFromTimestamp(SqlTimestampValueFactory.java:50) at com.mysql.cj.result.AbstractDateTimeValueFactory.createFromTimestamp(AbstractDateTimeValueFactory.java:87) at com.mysql.cj.protocol.a.MysqlTextValueDecoder.decodeTimestamp(MysqlTextValueDecoder.java:81) at com.mysql.cj.protocol.result.AbstractResultsetRow.decodeAndCreateReturnValue(AbstractResultsetRow.java:87) at com.mysql.cj.protocol.result.AbstractResultsetRow.getValueFromBytes(AbstractResultsetRow.java:241) at com.mysql.cj.protocol.a.result.TextBufferRow.getValue(TextBufferRow.java:132) ... 97 more Caused by: java.lang.IllegalArgumentException: HOUR_OF_DAY: 2 -> 3 at java.base/java.util.GregorianCalendar.computeTime(GregorianCalendar.java:2826) at java.base/java.util.Calendar.updateTime(Calendar.java:3425) at java.base/java.util.Calendar.getTimeInMillis(Calendar.java:1812) at com.mysql.cj.result.SqlTimestampValueFactory.localCreateFromTimestamp(SqlTimestampValueFactory.java:108) ... 103 more

Suppressed

array[empty]

TagContext

array

struct
COLUMN	0
ID	CFQUERY
LINE	449
RAW_TRACE	at cfEventSVC2ecfc2061729744$funcGETEVENTMEMBER.runFunction(/home/balboa/public_html/com/archinet/balboa/EventSVC.cfc:449)
TEMPLATE	/home/balboa/public_html/com/archinet/balboa/EventSVC.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	76
RAW_TRACE	at cfEventDAO2ecfc1357935367$funcREAD.runFunction(/home/balboa/public_html/com/archinet/balboa/model/EventDAO.cfc:76)
TEMPLATE	/home/balboa/public_html/com/archinet/balboa/model/EventDAO.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	39
RAW_TRACE	at cfEventSVC2ecfc2061729744$funcREAD.runFunction(/home/balboa/public_html/com/archinet/balboa/EventSVC.cfc:39)
TEMPLATE	/home/balboa/public_html/com/archinet/balboa/EventSVC.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	35
RAW_TRACE	at cfviewEvent2ecfm792433810._factor17(/home/balboa/public_html/viewEvent.cfm:35)
TEMPLATE	/home/balboa/public_html/viewEvent.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_VIEWEVENT
LINE	1
RAW_TRACE	at cfviewEvent2ecfm792433810.runPage(/home/balboa/public_html/viewEvent.cfm:1)
TEMPLATE	/home/balboa/public_html/viewEvent.cfm
TYPE	CFML

Type

java.sql.SQLException

DataSource

balboa_ds

Detail

HOUR_OF_DAY: 2 -> 3

ErrorCode

S1009

Exceptions

array

struct

causes

array

struct

Message

HOUR_OF_DAY: 2 -> 3

StackTrace

Suppressed

array[empty]

TagContext

array

struct
COLUMN	0
ID	CFQUERY
LINE	449
RAW_TRACE	at cfEventSVC2ecfc2061729744$funcGETEVENTMEMBER.runFunction(/home/balboa/public_html/com/archinet/balboa/EventSVC.cfc:449)
TEMPLATE	/home/balboa/public_html/com/archinet/balboa/EventSVC.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	76
RAW_TRACE	at cfEventDAO2ecfc1357935367$funcREAD.runFunction(/home/balboa/public_html/com/archinet/balboa/model/EventDAO.cfc:76)
TEMPLATE	/home/balboa/public_html/com/archinet/balboa/model/EventDAO.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	39
RAW_TRACE	at cfEventSVC2ecfc2061729744$funcREAD.runFunction(/home/balboa/public_html/com/archinet/balboa/EventSVC.cfc:39)
TEMPLATE	/home/balboa/public_html/com/archinet/balboa/EventSVC.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	35
RAW_TRACE	at cfviewEvent2ecfm792433810._factor17(/home/balboa/public_html/viewEvent.cfm:35)
TEMPLATE	/home/balboa/public_html/viewEvent.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_VIEWEVENT
LINE	1
RAW_TRACE	at cfviewEvent2ecfm792433810.runPage(/home/balboa/public_html/viewEvent.cfm:1)
TEMPLATE	/home/balboa/public_html/viewEvent.cfm
TYPE	CFML

Type

java.lang.IllegalArgumentException

class

java.sql.SQLException

message

HOUR_OF_DAY: 2 -> 3

Message

Error Executing Database Query.

NativeErrorCode

RootCause

struct

Cause

struct

Cause

struct

Message

HOUR_OF_DAY: 2 -> 3

StackTrace

Suppressed

array[empty]

TagContext

array

struct
COLUMN	0
ID	CFQUERY
LINE	449
RAW_TRACE	at cfEventSVC2ecfc2061729744$funcGETEVENTMEMBER.runFunction(/home/balboa/public_html/com/archinet/balboa/EventSVC.cfc:449)
TEMPLATE	/home/balboa/public_html/com/archinet/balboa/EventSVC.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	76
RAW_TRACE	at cfEventDAO2ecfc1357935367$funcREAD.runFunction(/home/balboa/public_html/com/archinet/balboa/model/EventDAO.cfc:76)
TEMPLATE	/home/balboa/public_html/com/archinet/balboa/model/EventDAO.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	39
RAW_TRACE	at cfEventSVC2ecfc2061729744$funcREAD.runFunction(/home/balboa/public_html/com/archinet/balboa/EventSVC.cfc:39)
TEMPLATE	/home/balboa/public_html/com/archinet/balboa/EventSVC.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	35
RAW_TRACE	at cfviewEvent2ecfm792433810._factor17(/home/balboa/public_html/viewEvent.cfm:35)
TEMPLATE	/home/balboa/public_html/viewEvent.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_VIEWEVENT
LINE	1
RAW_TRACE	at cfviewEvent2ecfm792433810.runPage(/home/balboa/public_html/viewEvent.cfm:1)
TEMPLATE	/home/balboa/public_html/viewEvent.cfm
TYPE	CFML

Type

java.lang.IllegalArgumentException

Message

HOUR_OF_DAY: 2 -> 3

SQLState

S1009

StackTrace

Suppressed

array[empty]

TagContext

array

struct
COLUMN	0
ID	CFQUERY
LINE	449
RAW_TRACE	at cfEventSVC2ecfc2061729744$funcGETEVENTMEMBER.runFunction(/home/balboa/public_html/com/archinet/balboa/EventSVC.cfc:449)
TEMPLATE	/home/balboa/public_html/com/archinet/balboa/EventSVC.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	76
RAW_TRACE	at cfEventDAO2ecfc1357935367$funcREAD.runFunction(/home/balboa/public_html/com/archinet/balboa/model/EventDAO.cfc:76)
TEMPLATE	/home/balboa/public_html/com/archinet/balboa/model/EventDAO.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	39
RAW_TRACE	at cfEventSVC2ecfc2061729744$funcREAD.runFunction(/home/balboa/public_html/com/archinet/balboa/EventSVC.cfc:39)
TEMPLATE	/home/balboa/public_html/com/archinet/balboa/EventSVC.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	35
RAW_TRACE	at cfviewEvent2ecfm792433810._factor17(/home/balboa/public_html/viewEvent.cfm:35)
TEMPLATE	/home/balboa/public_html/viewEvent.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_VIEWEVENT
LINE	1
RAW_TRACE	at cfviewEvent2ecfm792433810.runPage(/home/balboa/public_html/viewEvent.cfm:1)
TEMPLATE	/home/balboa/public_html/viewEvent.cfm
TYPE	CFML

Transient

Type

com.mysql.cj.exceptions.WrongArgumentException

VendorCode

ErrorCode

Message

HOUR_OF_DAY: 2 -> 3

SQLState

S1009

StackTrace

Suppressed

array[empty]

TagContext

array

struct
COLUMN	0
ID	CFQUERY
LINE	449
RAW_TRACE	at cfEventSVC2ecfc2061729744$funcGETEVENTMEMBER.runFunction(/home/balboa/public_html/com/archinet/balboa/EventSVC.cfc:449)
TEMPLATE	/home/balboa/public_html/com/archinet/balboa/EventSVC.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	76
RAW_TRACE	at cfEventDAO2ecfc1357935367$funcREAD.runFunction(/home/balboa/public_html/com/archinet/balboa/model/EventDAO.cfc:76)
TEMPLATE	/home/balboa/public_html/com/archinet/balboa/model/EventDAO.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	39
RAW_TRACE	at cfEventSVC2ecfc2061729744$funcREAD.runFunction(/home/balboa/public_html/com/archinet/balboa/EventSVC.cfc:39)
TEMPLATE	/home/balboa/public_html/com/archinet/balboa/EventSVC.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	35
RAW_TRACE	at cfviewEvent2ecfm792433810._factor17(/home/balboa/public_html/viewEvent.cfm:35)
TEMPLATE	/home/balboa/public_html/viewEvent.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_VIEWEVENT
LINE	1
RAW_TRACE	at cfviewEvent2ecfm792433810.runPage(/home/balboa/public_html/viewEvent.cfm:1)
TEMPLATE	/home/balboa/public_html/viewEvent.cfm
TYPE	CFML

Type

java.sql.SQLException

SQLState

S1009

Sql

SELECT e.default_tee_id, e.event_date, e.event_title, me.member_event_id, me.event_id, me.member_id, m.MemberGHIN, m.MemberFirstName, m.MemberPrefName, m.MemberLastName, CONCAT(m.MemberPrefName, ' ', m.MemberLastName) AS MemberFullName, CONCAT(m.MemberLastName, ', ', m.MemberPrefName) AS MemberFullNameRev, m.ctp_status_id, ctp.ctp_status_label, ctp.ctp_status_abbrev, ctp.ctp_status_desc, DATE_ADD(m.ctp_status_update_ts,INTERVAL -3 HOUR) AS ctp_status_update_ts, m.ctp_status_updated_member_id, CONCAT(ctpum.MemberPrefName, ' ', ctpum.MemberLastName) AS CTPStatusUpdatedMemberFullName, m.MemberType, m.MemberRank, m.MemberRankPrev, CASE WHEN m.MemberType LIKE 'BOA%' THEN m.MemberType WHEN m.MemberType LIKE 'MAJ%' THEN m.MemberType ELSE 'z' END AS MemberTypeNew, m.MemberEmail, m.MemberEmailVerified, m.MemberPhotoURL, m.MemberBirthDate, m.MemberHI, ROUND((m.MemberHI * t.tee_slope / 113) + (t.tee_rating - c.course_par)) AS MemberCH, m.MemberHI AS MemberHILow3, ROUND((m.MemberHI * t.tee_slope / 113)) AS MemberCHLow3, m.MemberHI AS MemberHILow6, ROUND((m.MemberHI * t.tee_slope / 113)) AS MemberCHLow6, m.MemberHI AS MemberHILow12, ROUND((m.MemberHI * t.tee_slope / 113)) AS MemberCHLow12, me.member_event_status_id, mes.member_event_status_order, mes.member_event_status_label, mes.member_event_status_class, me.member_event_comment, me.tee_id, t.tee_label, t.tee_rating, t.tee_slope, me.flight_id, me.ctp_standard, me.ctp_senior, f.flight_label, me.member_event_ch, me.entry_num, p.priority_tier, p.priority_reason, p.last_waitlist_event_id, p.last_waitlist_event_date, p.last_waitlist_event_title, p.waitlist_priority_eligible, DATE_ADD(me.first_attending_ts, INTERVAL -3 HOUR) AS first_attending_ts, DATE_ADD(me.updated_ts,INTERVAL -3 HOUR) AS updated_ts, me.updated_member_id, CONCAT(um.MemberPrefName, ' ', um.MemberLastName) AS UpdatedMemberFullName, CONCAT(um.MemberLastName, ', ', um.MemberPrefName) AS UpdatedMemberFullNameRev FROM members_events_tbl me LEFT JOIN events_tbl e ON me.event_id = e.event_id LEFT JOIN members_tbl m ON me.member_id = m.MemberID LEFT JOIN ghin_members_hi_tbl mhi ON (m.MemberGHIN = mhi.MemberGHIN AND mhi.GHINRevisionActive = 1) LEFT JOIN ghin_revisions_tbl gr ON (mhi.GHINRevisionID = gr.GHINRevisionID AND gr.GHINRevisionStatus = 1) LEFT JOIN member_event_status_tbl mes ON me.member_event_status_id = mes.member_event_status_id LEFT JOIN tees_tbl t ON e.default_tee_id = t.tee_id LEFT JOIN courses_tbl c ON c.course_id = t.course_id LEFT JOIN flights_tbl f ON me.flight_id = f.flight_id LEFT JOIN ctp_status_tbl ctp ON m.ctp_status_id = ctp.ctp_status_id LEFT JOIN members_tbl ctpum ON m.ctp_status_updated_member_id = ctpum.MemberID LEFT JOIN members_tbl um ON um.MemberID = me.updated_member_id LEFT JOIN ( /* Priority + correct "previously waitlisted" anchored to this event */ SELECT me.member_id, CASE WHEN bm.is_board = 1 THEN 1 WHEN mj.is_major_winner = 1 THEN 2 WHEN wl.waitlist_priority_eligible = 1 THEN 3 WHEN fe.is_first_ever = 1 THEN 4 WHEN f12.is_first_12_months = 1 THEN 5 ELSE 11 END AS priority_tier, CASE WHEN bm.is_board = 1 THEN 'Board member' WHEN mj.is_major_winner = 1 THEN 'Major winner' WHEN wl.waitlist_priority_eligible = 1 THEN 'Previously waitlisted' WHEN fe.is_first_ever = 1 THEN 'First club event ever' WHEN f12.is_first_12_months = 1 THEN 'First event in 12-months' ELSE '' END AS priority_reason, wl.last_waitlist_event_id, wl.last_waitlist_event_date, wl.last_waitlist_event_title, wl.waitlist_priority_eligible FROM members_events_tbl me JOIN events_tbl ecur ON ecur.event_id = me.event_id JOIN event_types_tbl etcur ON etcur.event_type_id = ecur.event_type_id AND etcur.event_type_golf = 1 /* board */ LEFT JOIN ( SELECT MemberID AS member_id, 1 AS is_board FROM members_tbl WHERE MemberType LIKE 'BOA%' ) bm ON bm.member_id = me.member_id /* major winner */ LEFT JOIN ( SELECT MemberID AS member_id, 1 AS is_major_winner FROM members_tbl WHERE MemberType = 'MAJOR' ) mj ON mj.member_id = me.member_id /* first ever */ LEFT JOIN ( SELECT me0.member_id, CASE WHEN pa.member_id IS NULL THEN 1 ELSE 0 END AS is_first_ever FROM members_events_tbl me0 LEFT JOIN ( SELECT me2.member_id FROM members_events_tbl me2 JOIN events_tbl e2 ON e2.event_id = me2.event_id JOIN event_types_tbl et2 ON et2.event_type_id = e2.event_type_id AND et2.event_type_golf = 1 JOIN events_tbl ecur2 ON ecur2.event_id = (param 1) WHERE me2.member_event_status_id = 2 AND DATE(ecur2.event_date) > DATE(e2.event_date) GROUP BY me2.member_id ) pa ON pa.member_id = me0.member_id WHERE me0.event_id = (param 2) GROUP BY me0.member_id ) fe ON fe.member_id = me.member_id /* first event in last 12 months (rolling) */ LEFT JOIN ( SELECT me0.member_id, CASE WHEN p12.member_id IS NULL THEN 1 ELSE 0 END AS is_first_12_months FROM members_events_tbl me0 LEFT JOIN ( SELECT me2.member_id FROM members_events_tbl me2 JOIN events_tbl e2 ON e2.event_id = me2.event_id JOIN event_types_tbl et2 ON et2.event_type_id = e2.event_type_id AND et2.event_type_golf = 1 JOIN events_tbl ecur2 ON ecur2.event_id = (param 3) WHERE me2.member_event_status_id = 2 AND DATE(ecur2.event_date) > DATE(e2.event_date) AND DATE(e2.event_date) >= DATE_SUB(DATE(ecur2.event_date), INTERVAL 12 MONTH) GROUP BY me2.member_id ) p12 ON p12.member_id = me0.member_id WHERE me0.event_id = (param 4) GROUP BY me0.member_id ) f12 ON f12.member_id = me.member_id /* correct waitlist eligibility (anchored) */ LEFT JOIN ( SELECT base.member_id, base.last_waitlist_event_id, base.last_waitlist_event_date, ew.event_title AS last_waitlist_event_title, CASE WHEN base.last_waitlist_event_date IS NULL THEN 0 WHEN EXISTS ( SELECT 1 FROM members_events_tbl me2 JOIN events_tbl e2 ON e2.event_id = me2.event_id JOIN event_types_tbl et2 ON et2.event_type_id = e2.event_type_id AND et2.event_type_golf = 1 WHERE me2.member_id = base.member_id AND me2.member_event_status_id = 2 AND e2.active = 1 AND DATE(e2.event_date) > base.last_waitlist_event_date AND ( SELECT DATE(event_date) FROM events_tbl WHERE event_id = (param 5) ) > DATE(e2.event_date) ) THEN 0 ELSE 1 END AS waitlist_priority_eligible FROM ( SELECT me.member_id, SUBSTRING_INDEX( GROUP_CONCAT(me.event_id ORDER BY e.event_date DESC, me.event_id DESC), ',', 1 ) AS last_waitlist_event_id, SUBSTRING_INDEX( GROUP_CONCAT(DATE(e.event_date) ORDER BY e.event_date DESC, me.event_id DESC), ',', 1 ) AS last_waitlist_event_date FROM members_events_tbl me JOIN events_tbl e ON e.event_id = me.event_id JOIN event_types_tbl et ON et.event_type_id = e.event_type_id AND et.event_type_golf = 1 WHERE me.member_event_status_id = 4 AND e.active = 1 AND ( SELECT DATE(event_date) FROM events_tbl WHERE event_id = (param 6) ) > DATE(e.event_date) GROUP BY me.member_id ) base LEFT JOIN events_tbl ew ON ew.event_id = base.last_waitlist_event_id ) wl ON wl.member_id = me.member_id WHERE me.event_id = (param 7) GROUP BY me.member_id ) p ON p.member_id = me.member_id WHERE me.event_id = (param 8) ORDER BY member_event_status_order, (entry_num IS NULL), entry_num, MemberLastName, MemberFirstName;

StackTrace

coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:929) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821) at cfEventSVC2ecfc2061729744$funcGETEVENTMEMBER.runFunction(/home/balboa/public_html/com/archinet/balboa/EventSVC.cfc:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:553) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:681) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:980) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:762) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4165) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4129) at cfEventDAO2ecfc1357935367$funcREAD.runFunction(/home/balboa/public_html/com/archinet/balboa/model/EventDAO.cfc:76) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:553) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:310) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4254) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4217) at cfEventSVC2ecfc2061729744$funcREAD.runFunction(/home/balboa/public_html/com/archinet/balboa/EventSVC.cfc:39) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:553) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:310) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4254) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4217) at cfviewEvent2ecfm792433810._factor17(/home/balboa/public_html/viewEvent.cfm:35) at cfviewEvent2ecfm792433810.runPage(/home/balboa/public_html/viewEvent.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:573) 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:97) 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:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:228) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:163) 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:190) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:163) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:190) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:163) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143) 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:373) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:462) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:893) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1723) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:834) Caused by: java.sql.SQLException: HOUR_OF_DAY: 2 -> 3 at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:85) at com.mysql.cj.jdbc.result.ResultSetImpl.getTimestamp(ResultSetImpl.java:914) at com.mysql.cj.jdbc.result.ResultSetImpl.getObject(ResultSetImpl.java:1254) at coldfusion.sql.QueryTable.populate(QueryTable.java:426) at coldfusion.sql.QueryTable.populate(QueryTable.java:289) at coldfusion.sql.Executive.getRowSet(Executive.java:722) at coldfusion.sql.Executive.executeQuery(Executive.java:1604) at coldfusion.sql.Executive.executeQuery(Executive.java:1327) at coldfusion.sql.Executive.executeQuery(Executive.java:1257) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:876) ... 86 more Caused by: com.mysql.cj.exceptions.WrongArgumentException: HOUR_OF_DAY: 2 -> 3 at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490) at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) at com.mysql.cj.result.SqlTimestampValueFactory.localCreateFromTimestamp(SqlTimestampValueFactory.java:112) at com.mysql.cj.result.SqlTimestampValueFactory.localCreateFromTimestamp(SqlTimestampValueFactory.java:50) at com.mysql.cj.result.AbstractDateTimeValueFactory.createFromTimestamp(AbstractDateTimeValueFactory.java:87) at com.mysql.cj.protocol.a.MysqlTextValueDecoder.decodeTimestamp(MysqlTextValueDecoder.java:81) at com.mysql.cj.protocol.result.AbstractResultsetRow.decodeAndCreateReturnValue(AbstractResultsetRow.java:87) at com.mysql.cj.protocol.result.AbstractResultsetRow.getValueFromBytes(AbstractResultsetRow.java:241) at com.mysql.cj.protocol.a.result.TextBufferRow.getValue(TextBufferRow.java:132) ... 97 more Caused by: java.lang.IllegalArgumentException: HOUR_OF_DAY: 2 -> 3 at java.base/java.util.GregorianCalendar.computeTime(GregorianCalendar.java:2826) at java.base/java.util.Calendar.updateTime(Calendar.java:3425) at java.base/java.util.Calendar.getTimeInMillis(Calendar.java:1812) at com.mysql.cj.result.SqlTimestampValueFactory.localCreateFromTimestamp(SqlTimestampValueFactory.java:108) ... 103 more

Suppressed

array[empty]

TagContext

array

struct
COLUMN	0
ID	CFQUERY
LINE	449
RAW_TRACE	at cfEventSVC2ecfc2061729744$funcGETEVENTMEMBER.runFunction(/home/balboa/public_html/com/archinet/balboa/EventSVC.cfc:449)
TEMPLATE	/home/balboa/public_html/com/archinet/balboa/EventSVC.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	76
RAW_TRACE	at cfEventDAO2ecfc1357935367$funcREAD.runFunction(/home/balboa/public_html/com/archinet/balboa/model/EventDAO.cfc:76)
TEMPLATE	/home/balboa/public_html/com/archinet/balboa/model/EventDAO.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	39
RAW_TRACE	at cfEventSVC2ecfc2061729744$funcREAD.runFunction(/home/balboa/public_html/com/archinet/balboa/EventSVC.cfc:39)
TEMPLATE	/home/balboa/public_html/com/archinet/balboa/EventSVC.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	35
RAW_TRACE	at cfviewEvent2ecfm792433810._factor17(/home/balboa/public_html/viewEvent.cfm:35)
TEMPLATE	/home/balboa/public_html/viewEvent.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_VIEWEVENT
LINE	1
RAW_TRACE	at cfviewEvent2ecfm792433810.runPage(/home/balboa/public_html/viewEvent.cfm:1)
TEMPLATE	/home/balboa/public_html/viewEvent.cfm
TYPE	CFML

Type

Database

queryError

HOUR_OF_DAY: 2 -> 3

where

(param 1) = [type='IN', class='java.lang.Integer', value='831', sqltype='cf_sql_integer'] , (param 2) = [type='IN', class='java.lang.Integer', value='831', sqltype='cf_sql_integer'] , (param 3) = [type='IN', class='java.lang.Integer', value='831', sqltype='cf_sql_integer'] , (param 4) = [type='IN', class='java.lang.Integer', value='831', sqltype='cf_sql_integer'] , (param 5) = [type='IN', class='java.lang.Integer', value='831', sqltype='cf_sql_integer'] , (param 6) = [type='IN', class='java.lang.Integer', value='831', sqltype='cf_sql_integer'] , (param 7) = [type='IN', class='java.lang.Integer', value='831', sqltype='cf_sql_integer'] , (param 8) = [type='IN', class='java.lang.Integer', value='831', sqltype='cf_sql_integer']