English | Français
Use the old Optimist Leaders 

English | Français

Mission, Vision & Purposes

Mission: By providing hope and positive vision, Optimists bring out the best in youth, our communities and ourselves.

Vision: Optimist International will be recognized worldwide as the premier volunteer organization that values all children and helps them develop to their full potential.

Purposes: To develop optimism as a philosophy of life utilizing the tenets of the Optimist Creed; to promote an active interest in good government and civic affairs; to inspire respect for the law; to promote patriotism and work for international accord and friendship among all people; to aid and encourage the development of youth, in the belief that the giving of one’s self in service to others will advance the well-being of humankind, community life and the world.

Optimist Creed

Optimists provide service in their communities while living by the tenets of the Optimist Creed.

Optimist International Foundations

Helping Optimists Help Kids

Optimist International Foundation

Canadian Children’s Optimist Foundation

Donate Now
To support Optimist International’s programs:

For Members and individuals who live in the United States, Caribbean and other nations.

For Members and individuals who live in Canada

Contributions are processed through the Optimist International Foundation and the Canadian Children’s Optimist Foundation.



Faces of Optimism

An unexpected error occurred.

The web developers have been alerted.

struct
Cause
struct
Cause
struct
ErrorCode 207
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'm'.
NextException
struct
ErrorCode 207
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'oh'.
SQLState 42S22
StackTrace java.sql.SQLSyntaxErrorException: [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'oh'. at macromedia.jdbc.sqlserverbase.dda4.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda4.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.ddj.l(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.e(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.v(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.r(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348) at coldfusion.sql.Executive.executeQuery(Executive.java:1420) at coldfusion.sql.Executive.executeQuery(Executive.java:1183) at coldfusion.sql.Executive.executeQuery(Executive.java:1114) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590) at cfFacesOfOptimism2ecfm2012571739.runPage(C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\FacesOfOptimism.cfm:83) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfaboutoi2dbox82den2einc415959247.runPage(C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\aboutoi\aboutoi-box8-en.inc:19) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfoi2dtemplate42einc1927714717.runPage(C:\inetpub\wwwroot\www.optimist.org\Include\oi-template4.inc:55) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfaboutoi2ecfm405934323.runPage(C:\inetpub\wwwroot\www.optimist.org\aboutoi.cfm:4) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfapplication2ecfc572326160$funcONREQUEST.runFunction(C:\inetpub\wwwroot\www.optimist.org\application.cfc:93) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:491) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:337) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:88) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:280) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:356) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:94) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:79) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) 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:201) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 83
RAW_TRACE at cfFacesOfOptimism2ecfm2012571739.runPage(C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\FacesOfOptimism.cfm:83)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\FacesOfOptimism.cfm
TYPE CFML
2
struct
COLUMN 0
ID CFINCLUDE
LINE 19
RAW_TRACE at cfaboutoi2dbox82den2einc415959247.runPage(C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\aboutoi\aboutoi-box8-en.inc:19)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\aboutoi\aboutoi-box8-en.inc
TYPE CFML
3
struct
COLUMN 0
ID CFINCLUDE
LINE 55
RAW_TRACE at cfoi2dtemplate42einc1927714717.runPage(C:\inetpub\wwwroot\www.optimist.org\Include\oi-template4.inc:55)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\Include\oi-template4.inc
TYPE CFML
4
struct
COLUMN 0
ID CFINCLUDE
LINE 4
RAW_TRACE at cfaboutoi2ecfm405934323.runPage(C:\inetpub\wwwroot\www.optimist.org\aboutoi.cfm:4)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\aboutoi.cfm
TYPE CFML
5
struct
COLUMN 0
ID CFINCLUDE
LINE 93
RAW_TRACE at cfapplication2ecfc572326160$funcONREQUEST.runFunction(C:\inetpub\wwwroot\www.optimist.org\application.cfc:93)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\application.cfc
TYPE CFML
Type java.sql.SQLSyntaxErrorException
SQLState 42S22
StackTrace java.sql.SQLSyntaxErrorException: [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'm'. at macromedia.jdbc.sqlserverbase.dda4.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda4.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.ddj.l(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.e(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.v(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.r(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348) at coldfusion.sql.Executive.executeQuery(Executive.java:1420) at coldfusion.sql.Executive.executeQuery(Executive.java:1183) at coldfusion.sql.Executive.executeQuery(Executive.java:1114) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590) at cfFacesOfOptimism2ecfm2012571739.runPage(C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\FacesOfOptimism.cfm:83) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfaboutoi2dbox82den2einc415959247.runPage(C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\aboutoi\aboutoi-box8-en.inc:19) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfoi2dtemplate42einc1927714717.runPage(C:\inetpub\wwwroot\www.optimist.org\Include\oi-template4.inc:55) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfaboutoi2ecfm405934323.runPage(C:\inetpub\wwwroot\www.optimist.org\aboutoi.cfm:4) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfapplication2ecfc572326160$funcONREQUEST.runFunction(C:\inetpub\wwwroot\www.optimist.org\application.cfc:93) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:491) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:337) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:88) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:280) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:356) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:94) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:79) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) 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:201) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 83
RAW_TRACE at cfFacesOfOptimism2ecfm2012571739.runPage(C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\FacesOfOptimism.cfm:83)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\FacesOfOptimism.cfm
TYPE CFML
2
struct
COLUMN 0
ID CFINCLUDE
LINE 19
RAW_TRACE at cfaboutoi2dbox82den2einc415959247.runPage(C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\aboutoi\aboutoi-box8-en.inc:19)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\aboutoi\aboutoi-box8-en.inc
TYPE CFML
3
struct
COLUMN 0
ID CFINCLUDE
LINE 55
RAW_TRACE at cfoi2dtemplate42einc1927714717.runPage(C:\inetpub\wwwroot\www.optimist.org\Include\oi-template4.inc:55)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\Include\oi-template4.inc
TYPE CFML
4
struct
COLUMN 0
ID CFINCLUDE
LINE 4
RAW_TRACE at cfaboutoi2ecfm405934323.runPage(C:\inetpub\wwwroot\www.optimist.org\aboutoi.cfm:4)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\aboutoi.cfm
TYPE CFML
5
struct
COLUMN 0
ID CFINCLUDE
LINE 93
RAW_TRACE at cfapplication2ecfc572326160$funcONREQUEST.runFunction(C:\inetpub\wwwroot\www.optimist.org\application.cfc:93)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\application.cfc
TYPE CFML
Type java.sql.SQLSyntaxErrorException
DataSource OIMS
Detail [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'm'.
ErrorCode 42S22
Message Error Executing Database Query.
NativeErrorCode 207
RootCause
struct
ErrorCode 207
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'm'.
NextException
struct
ErrorCode 207
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'oh'.
SQLState 42S22
StackTrace java.sql.SQLSyntaxErrorException: [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'oh'. at macromedia.jdbc.sqlserverbase.dda4.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda4.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.ddj.l(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.e(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.v(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.r(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348) at coldfusion.sql.Executive.executeQuery(Executive.java:1420) at coldfusion.sql.Executive.executeQuery(Executive.java:1183) at coldfusion.sql.Executive.executeQuery(Executive.java:1114) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590) at cfFacesOfOptimism2ecfm2012571739.runPage(C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\FacesOfOptimism.cfm:83) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfaboutoi2dbox82den2einc415959247.runPage(C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\aboutoi\aboutoi-box8-en.inc:19) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfoi2dtemplate42einc1927714717.runPage(C:\inetpub\wwwroot\www.optimist.org\Include\oi-template4.inc:55) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfaboutoi2ecfm405934323.runPage(C:\inetpub\wwwroot\www.optimist.org\aboutoi.cfm:4) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfapplication2ecfc572326160$funcONREQUEST.runFunction(C:\inetpub\wwwroot\www.optimist.org\application.cfc:93) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:491) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:337) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:88) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:280) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:356) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:94) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:79) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) 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:201) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 83
RAW_TRACE at cfFacesOfOptimism2ecfm2012571739.runPage(C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\FacesOfOptimism.cfm:83)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\FacesOfOptimism.cfm
TYPE CFML
2
struct
COLUMN 0
ID CFINCLUDE
LINE 19
RAW_TRACE at cfaboutoi2dbox82den2einc415959247.runPage(C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\aboutoi\aboutoi-box8-en.inc:19)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\aboutoi\aboutoi-box8-en.inc
TYPE CFML
3
struct
COLUMN 0
ID CFINCLUDE
LINE 55
RAW_TRACE at cfoi2dtemplate42einc1927714717.runPage(C:\inetpub\wwwroot\www.optimist.org\Include\oi-template4.inc:55)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\Include\oi-template4.inc
TYPE CFML
4
struct
COLUMN 0
ID CFINCLUDE
LINE 4
RAW_TRACE at cfaboutoi2ecfm405934323.runPage(C:\inetpub\wwwroot\www.optimist.org\aboutoi.cfm:4)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\aboutoi.cfm
TYPE CFML
5
struct
COLUMN 0
ID CFINCLUDE
LINE 93
RAW_TRACE at cfapplication2ecfc572326160$funcONREQUEST.runFunction(C:\inetpub\wwwroot\www.optimist.org\application.cfc:93)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\application.cfc
TYPE CFML
Type java.sql.SQLSyntaxErrorException
SQLState 42S22
StackTrace java.sql.SQLSyntaxErrorException: [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'm'. at macromedia.jdbc.sqlserverbase.dda4.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda4.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.ddj.l(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.e(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.v(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.r(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348) at coldfusion.sql.Executive.executeQuery(Executive.java:1420) at coldfusion.sql.Executive.executeQuery(Executive.java:1183) at coldfusion.sql.Executive.executeQuery(Executive.java:1114) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590) at cfFacesOfOptimism2ecfm2012571739.runPage(C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\FacesOfOptimism.cfm:83) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfaboutoi2dbox82den2einc415959247.runPage(C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\aboutoi\aboutoi-box8-en.inc:19) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfoi2dtemplate42einc1927714717.runPage(C:\inetpub\wwwroot\www.optimist.org\Include\oi-template4.inc:55) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfaboutoi2ecfm405934323.runPage(C:\inetpub\wwwroot\www.optimist.org\aboutoi.cfm:4) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfapplication2ecfc572326160$funcONREQUEST.runFunction(C:\inetpub\wwwroot\www.optimist.org\application.cfc:93) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:491) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:337) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:88) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:280) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:356) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:94) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:79) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) 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:201) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 83
RAW_TRACE at cfFacesOfOptimism2ecfm2012571739.runPage(C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\FacesOfOptimism.cfm:83)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\FacesOfOptimism.cfm
TYPE CFML
2
struct
COLUMN 0
ID CFINCLUDE
LINE 19
RAW_TRACE at cfaboutoi2dbox82den2einc415959247.runPage(C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\aboutoi\aboutoi-box8-en.inc:19)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\aboutoi\aboutoi-box8-en.inc
TYPE CFML
3
struct
COLUMN 0
ID CFINCLUDE
LINE 55
RAW_TRACE at cfoi2dtemplate42einc1927714717.runPage(C:\inetpub\wwwroot\www.optimist.org\Include\oi-template4.inc:55)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\Include\oi-template4.inc
TYPE CFML
4
struct
COLUMN 0
ID CFINCLUDE
LINE 4
RAW_TRACE at cfaboutoi2ecfm405934323.runPage(C:\inetpub\wwwroot\www.optimist.org\aboutoi.cfm:4)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\aboutoi.cfm
TYPE CFML
5
struct
COLUMN 0
ID CFINCLUDE
LINE 93
RAW_TRACE at cfapplication2ecfc572326160$funcONREQUEST.runFunction(C:\inetpub\wwwroot\www.optimist.org\application.cfc:93)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\application.cfc
TYPE CFML
Type java.sql.SQLSyntaxErrorException
SQLState 42S22
Sql SELECT d.District, coalesce(cl.District_Number,cm.DistrictNbr,cm.DistNbr,0) District_Number, isnull(cl.Zone,0) Zone_Number, cm.Club_Number, cm.Club, mm.Member_Number, mi.PersonID, mi.NameID, mi.AddressID, mi.PhoneHomeID, mi.PhoneWorkID, mi.PhoneCellID, mi.PhoneFaxID, mi.EmailID, mi.FullName, mi.NickName, mi.Address, mi.City, mi.State, mi.Zip, mi.Country, mi.Address_Valid_Flag, mi.E_Mail_Address E_Mail_Address, mi.Home_Phone_Number HomePhone, mi.Business_Phone_Number WorkPhone, mi.Fax_Phone_Number FaxPhone, mi.Cell_Phone_Number CellPhone, mm.Status MemberStatus, s.Status_Name MemberStatusName, c.CountryName_en Country_Name, sp.State_Province State_Province, case when DateDiff(day,mm.DateDeleted,getdate())<=89 then 'T' else 'F' end ReinstateStatus, DateDiff(day,mm.DateDeleted,getdate()) DaysAgo, mmsp.Member_Number SponsorNumber, dbo.TitleCase(mmsp.Full_Name ) SponsorName, mm.DateEffective, mm.DateDeleted, mm.Gender_Type, mm.Language_Code, ll.Language, case mm.Gender_Type when 'M' then 'Male' when 'F' then 'Female' else '' end Gender, case isnull(mm.Charter_Member_Flag,'F') when 'T' then 'Yes' else 'No' end Charter_Member, case isnull(mm.CollegeMbr,'F') when 'T' then 'Yes' else 'No' end CollegeMbr, isnull(mm.CollegeMbr_College,'') CollegeMbr_College, case isnull(mm.Spouse,'F') when 'T' then 'Yes' else 'No' end SpouseMbr, case mm.PreviousJOOI when 'T' then 'Yes' else 'No' end PreviousJOOIMbr, (case isnull(mm.Life_Member_Status,'N') when 'A' then 'Paid with Annual Dues' when 'F' then 'Fully Paid' when 'P' then 'Partially Paid' else 'No' end) Life_Member, (case when isnull(mm.Life_Member_Status,'N') in ('A','F') then 1 else 0 end) Life_Member_ShowDate, dbo.cDate(mm.Life_Membership_Date_Effective) Life_Member_Date, case isnull(mm.Diplomat_Member,'F') when 'T' then 'Yes' else 'No' end Diplomat, mm.Date_Diplomat_Member, isnull(pgi.PGI_Level,'') PGI_Level, dbo.cDate(pgi.PGI_Date) PGI_Date, case coalesce(dbo.cStr(mo.HighFiveMbr),mm.HighFiveMbr,'') when 'T' then 'Yes' when '1' then 'Yes' else 'No' end HighFiveMbr, case coalesce(dbo.cStr(mo.Free4for1Mbr),mm.Free4for1Mbr,'') when 'T' then 'Yes' when '1' then 'Yes' else 'No' end Free4for1Mbr, case coalesce(dbo.cStr(mo.eOptimistMbr),mm.eOptimistMbr,'') when 'T' then 'Yes' when '1' then 'Yes' else 'No' end eOptimistMbr, case coalesce(mo.FindSomeFriendsMbr,0) when 1 then 'Yes' else 'No' end FindSomeFriendsMbr, case coalesce(mm.ReUnitedMbr,'F') when 'T' then 'Yes' else 'No' end ReUnitedMbr, isnull(mm.ReUnitedMbr_Club,'') ReUnitedMbr_Club, case coalesce(mo.AdvertisementCode,mm.Advertisement_Flag,'T') when 'T' then 'Yes' else 'No' end AdvertisementCode, case coalesce(mo.EmailList,'T') when 'E' then 'E-Mail' when 'M' then 'Postal-Mail' when 'B' then 'E-Mail & Postal-Mail' else 'None' end EmailList, sMag.Status_Name MagazineCode, mo.EmailOptions, coalesce('('+nullif(mm.Delete_Reason,'')+')','('+dc.Delete_Reason+')','') DeleteReasonCurrent, cmsp.Name SponsorClubName, ltrim(rtrim(cm.Type_Code)) ClubType, mm.Delete_Code, isnull(dc.CantBeReinstated,0) CantBeReinstated, mm.DateRenewal, mi.FirstName FROM Member_Master mm left join vwLastPGI pgi on pgi.PersonID=mm.PersonID inner join vwMemberInfo mi on mi.Member_Number=mm.Member_Number INNER JOIN Club_Master cm ON cm.Club_Number=mm.Member_Club_Number LEFT JOIN Club_Location cl ON cl.Club_Number=cm.Club_Number and cl.Organization_Year=2018 LEFT JOIN District_Lookup d on d.District_Number= coalesce(cl.District_Number,cm.DistrictNbr,cm.DistNbr,0) INNER JOIN Country_Lookup c ON c.Country_Code=mm.Country_Code LEFT JOIN State_Province_Lookup sp ON sp.State_Province_Code=mm.State_Province_Code LEFT JOIN Delete_Lookup dc ON dc.Type='M' AND dc.Delete_Code=mm.Delete_Code LEFT JOIN Club_Master cmsp ON cmsp.Club_Number=mm.Sponsored_By_Club_Number LEFT JOIN Member_Master mmsp on mmsp.Member_Club_Number=mm.Sponsored_By_Club_Number and mmsp.Member_Roster_Number=mm.Sponsored_By_Roster_Number LEFT JOIN Member_Options mo on mo.Member_Club_Number=mm.Member_Club_Number and mo.Member_Roster_Number=mm.Member_Roster_Number left join Status_Lookup s ON s.Type='M' AND s.Status=mm.Status left join Status_Lookup sMag on sMag.Type='MAG' and sMag.Status= coalesce(mo.MagazineCode,mm.Magazine_Flag,'T') LEFT JOIN Language_Lookup ll on ll.Language_Code=mm.Language_Code WHERE mm.Member_Club_Number='wickh' AND mm.Member_Roster_Number=m-oh
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:641) at cfFacesOfOptimism2ecfm2012571739.runPage(C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\FacesOfOptimism.cfm:83) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfaboutoi2dbox82den2einc415959247.runPage(C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\aboutoi\aboutoi-box8-en.inc:19) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfoi2dtemplate42einc1927714717.runPage(C:\inetpub\wwwroot\www.optimist.org\Include\oi-template4.inc:55) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfaboutoi2ecfm405934323.runPage(C:\inetpub\wwwroot\www.optimist.org\aboutoi.cfm:4) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfapplication2ecfc572326160$funcONREQUEST.runFunction(C:\inetpub\wwwroot\www.optimist.org\application.cfc:93) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:491) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:337) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:88) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:280) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:356) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:94) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:79) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) 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:201) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Caused by: java.sql.SQLSyntaxErrorException: [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'm'. at macromedia.jdbc.sqlserverbase.dda4.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda4.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.ddj.l(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.e(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.v(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.r(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348) at coldfusion.sql.Executive.executeQuery(Executive.java:1420) at coldfusion.sql.Executive.executeQuery(Executive.java:1183) at coldfusion.sql.Executive.executeQuery(Executive.java:1114) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590) ... 54 more
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 83
RAW_TRACE at cfFacesOfOptimism2ecfm2012571739.runPage(C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\FacesOfOptimism.cfm:83)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\FacesOfOptimism.cfm
TYPE CFML
2
struct
COLUMN 0
ID CFINCLUDE
LINE 19
RAW_TRACE at cfaboutoi2dbox82den2einc415959247.runPage(C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\aboutoi\aboutoi-box8-en.inc:19)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\aboutoi\aboutoi-box8-en.inc
TYPE CFML
3
struct
COLUMN 0
ID CFINCLUDE
LINE 55
RAW_TRACE at cfoi2dtemplate42einc1927714717.runPage(C:\inetpub\wwwroot\www.optimist.org\Include\oi-template4.inc:55)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\Include\oi-template4.inc
TYPE CFML
4
struct
COLUMN 0
ID CFINCLUDE
LINE 4
RAW_TRACE at cfaboutoi2ecfm405934323.runPage(C:\inetpub\wwwroot\www.optimist.org\aboutoi.cfm:4)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\aboutoi.cfm
TYPE CFML
5
struct
COLUMN 0
ID CFINCLUDE
LINE 93
RAW_TRACE at cfapplication2ecfc572326160$funcONREQUEST.runFunction(C:\inetpub\wwwroot\www.optimist.org\application.cfc:93)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\application.cfc
TYPE CFML
Type Database
queryError [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'm'.
where [empty string]
Detail An exception occurred while invoking an event handler method from Application.cfc. The method name is: onRequest.
Message Event handler exception.
RootCause
struct
Cause
struct
ErrorCode 207
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'm'.
NextException
struct
ErrorCode 207
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'oh'.
SQLState 42S22
StackTrace java.sql.SQLSyntaxErrorException: [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'oh'. at macromedia.jdbc.sqlserverbase.dda4.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda4.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.ddj.l(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.e(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.v(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.r(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348) at coldfusion.sql.Executive.executeQuery(Executive.java:1420) at coldfusion.sql.Executive.executeQuery(Executive.java:1183) at coldfusion.sql.Executive.executeQuery(Executive.java:1114) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590) at cfFacesOfOptimism2ecfm2012571739.runPage(C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\FacesOfOptimism.cfm:83) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfaboutoi2dbox82den2einc415959247.runPage(C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\aboutoi\aboutoi-box8-en.inc:19) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfoi2dtemplate42einc1927714717.runPage(C:\inetpub\wwwroot\www.optimist.org\Include\oi-template4.inc:55) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfaboutoi2ecfm405934323.runPage(C:\inetpub\wwwroot\www.optimist.org\aboutoi.cfm:4) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfapplication2ecfc572326160$funcONREQUEST.runFunction(C:\inetpub\wwwroot\www.optimist.org\application.cfc:93) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:491) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:337) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:88) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:280) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:356) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:94) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:79) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) 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:201) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 83
RAW_TRACE at cfFacesOfOptimism2ecfm2012571739.runPage(C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\FacesOfOptimism.cfm:83)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\FacesOfOptimism.cfm
TYPE CFML
2
struct
COLUMN 0
ID CFINCLUDE
LINE 19
RAW_TRACE at cfaboutoi2dbox82den2einc415959247.runPage(C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\aboutoi\aboutoi-box8-en.inc:19)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\aboutoi\aboutoi-box8-en.inc
TYPE CFML
3
struct
COLUMN 0
ID CFINCLUDE
LINE 55
RAW_TRACE at cfoi2dtemplate42einc1927714717.runPage(C:\inetpub\wwwroot\www.optimist.org\Include\oi-template4.inc:55)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\Include\oi-template4.inc
TYPE CFML
4
struct
COLUMN 0
ID CFINCLUDE
LINE 4
RAW_TRACE at cfaboutoi2ecfm405934323.runPage(C:\inetpub\wwwroot\www.optimist.org\aboutoi.cfm:4)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\aboutoi.cfm
TYPE CFML
5
struct
COLUMN 0
ID CFINCLUDE
LINE 93
RAW_TRACE at cfapplication2ecfc572326160$funcONREQUEST.runFunction(C:\inetpub\wwwroot\www.optimist.org\application.cfc:93)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\application.cfc
TYPE CFML
Type java.sql.SQLSyntaxErrorException
SQLState 42S22
StackTrace java.sql.SQLSyntaxErrorException: [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'm'. at macromedia.jdbc.sqlserverbase.dda4.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda4.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.ddj.l(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.e(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.v(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.r(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348) at coldfusion.sql.Executive.executeQuery(Executive.java:1420) at coldfusion.sql.Executive.executeQuery(Executive.java:1183) at coldfusion.sql.Executive.executeQuery(Executive.java:1114) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590) at cfFacesOfOptimism2ecfm2012571739.runPage(C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\FacesOfOptimism.cfm:83) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfaboutoi2dbox82den2einc415959247.runPage(C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\aboutoi\aboutoi-box8-en.inc:19) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfoi2dtemplate42einc1927714717.runPage(C:\inetpub\wwwroot\www.optimist.org\Include\oi-template4.inc:55) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfaboutoi2ecfm405934323.runPage(C:\inetpub\wwwroot\www.optimist.org\aboutoi.cfm:4) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfapplication2ecfc572326160$funcONREQUEST.runFunction(C:\inetpub\wwwroot\www.optimist.org\application.cfc:93) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:491) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:337) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:88) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:280) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:356) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:94) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:79) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) 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:201) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 83
RAW_TRACE at cfFacesOfOptimism2ecfm2012571739.runPage(C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\FacesOfOptimism.cfm:83)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\FacesOfOptimism.cfm
TYPE CFML
2
struct
COLUMN 0
ID CFINCLUDE
LINE 19
RAW_TRACE at cfaboutoi2dbox82den2einc415959247.runPage(C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\aboutoi\aboutoi-box8-en.inc:19)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\aboutoi\aboutoi-box8-en.inc
TYPE CFML
3
struct
COLUMN 0
ID CFINCLUDE
LINE 55
RAW_TRACE at cfoi2dtemplate42einc1927714717.runPage(C:\inetpub\wwwroot\www.optimist.org\Include\oi-template4.inc:55)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\Include\oi-template4.inc
TYPE CFML
4
struct
COLUMN 0
ID CFINCLUDE
LINE 4
RAW_TRACE at cfaboutoi2ecfm405934323.runPage(C:\inetpub\wwwroot\www.optimist.org\aboutoi.cfm:4)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\aboutoi.cfm
TYPE CFML
5
struct
COLUMN 0
ID CFINCLUDE
LINE 93
RAW_TRACE at cfapplication2ecfc572326160$funcONREQUEST.runFunction(C:\inetpub\wwwroot\www.optimist.org\application.cfc:93)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\application.cfc
TYPE CFML
Type java.sql.SQLSyntaxErrorException
DataSource OIMS
Detail [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'm'.
ErrorCode 42S22
Message Error Executing Database Query.
NativeErrorCode 207
RootCause
struct
ErrorCode 207
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'm'.
NextException
struct
ErrorCode 207
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'oh'.
SQLState 42S22
StackTrace java.sql.SQLSyntaxErrorException: [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'oh'. at macromedia.jdbc.sqlserverbase.dda4.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda4.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.ddj.l(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.e(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.v(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.r(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348) at coldfusion.sql.Executive.executeQuery(Executive.java:1420) at coldfusion.sql.Executive.executeQuery(Executive.java:1183) at coldfusion.sql.Executive.executeQuery(Executive.java:1114) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590) at cfFacesOfOptimism2ecfm2012571739.runPage(C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\FacesOfOptimism.cfm:83) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfaboutoi2dbox82den2einc415959247.runPage(C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\aboutoi\aboutoi-box8-en.inc:19) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfoi2dtemplate42einc1927714717.runPage(C:\inetpub\wwwroot\www.optimist.org\Include\oi-template4.inc:55) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfaboutoi2ecfm405934323.runPage(C:\inetpub\wwwroot\www.optimist.org\aboutoi.cfm:4) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfapplication2ecfc572326160$funcONREQUEST.runFunction(C:\inetpub\wwwroot\www.optimist.org\application.cfc:93) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:491) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:337) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:88) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:280) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:356) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:94) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:79) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) 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:201) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 83
RAW_TRACE at cfFacesOfOptimism2ecfm2012571739.runPage(C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\FacesOfOptimism.cfm:83)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\FacesOfOptimism.cfm
TYPE CFML
2
struct
COLUMN 0
ID CFINCLUDE
LINE 19
RAW_TRACE at cfaboutoi2dbox82den2einc415959247.runPage(C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\aboutoi\aboutoi-box8-en.inc:19)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\aboutoi\aboutoi-box8-en.inc
TYPE CFML
3
struct
COLUMN 0
ID CFINCLUDE
LINE 55
RAW_TRACE at cfoi2dtemplate42einc1927714717.runPage(C:\inetpub\wwwroot\www.optimist.org\Include\oi-template4.inc:55)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\Include\oi-template4.inc
TYPE CFML
4
struct
COLUMN 0
ID CFINCLUDE
LINE 4
RAW_TRACE at cfaboutoi2ecfm405934323.runPage(C:\inetpub\wwwroot\www.optimist.org\aboutoi.cfm:4)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\aboutoi.cfm
TYPE CFML
5
struct
COLUMN 0
ID CFINCLUDE
LINE 93
RAW_TRACE at cfapplication2ecfc572326160$funcONREQUEST.runFunction(C:\inetpub\wwwroot\www.optimist.org\application.cfc:93)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\application.cfc
TYPE CFML
Type java.sql.SQLSyntaxErrorException
SQLState 42S22
StackTrace java.sql.SQLSyntaxErrorException: [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'm'. at macromedia.jdbc.sqlserverbase.dda4.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda4.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.ddj.l(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.e(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.v(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.r(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348) at coldfusion.sql.Executive.executeQuery(Executive.java:1420) at coldfusion.sql.Executive.executeQuery(Executive.java:1183) at coldfusion.sql.Executive.executeQuery(Executive.java:1114) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590) at cfFacesOfOptimism2ecfm2012571739.runPage(C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\FacesOfOptimism.cfm:83) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfaboutoi2dbox82den2einc415959247.runPage(C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\aboutoi\aboutoi-box8-en.inc:19) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfoi2dtemplate42einc1927714717.runPage(C:\inetpub\wwwroot\www.optimist.org\Include\oi-template4.inc:55) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfaboutoi2ecfm405934323.runPage(C:\inetpub\wwwroot\www.optimist.org\aboutoi.cfm:4) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfapplication2ecfc572326160$funcONREQUEST.runFunction(C:\inetpub\wwwroot\www.optimist.org\application.cfc:93) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:491) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:337) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:88) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:280) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:356) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:94) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:79) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) 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:201) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 83
RAW_TRACE at cfFacesOfOptimism2ecfm2012571739.runPage(C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\FacesOfOptimism.cfm:83)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\FacesOfOptimism.cfm
TYPE CFML
2
struct
COLUMN 0
ID CFINCLUDE
LINE 19
RAW_TRACE at cfaboutoi2dbox82den2einc415959247.runPage(C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\aboutoi\aboutoi-box8-en.inc:19)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\aboutoi\aboutoi-box8-en.inc
TYPE CFML
3
struct
COLUMN 0
ID CFINCLUDE
LINE 55
RAW_TRACE at cfoi2dtemplate42einc1927714717.runPage(C:\inetpub\wwwroot\www.optimist.org\Include\oi-template4.inc:55)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\Include\oi-template4.inc
TYPE CFML
4
struct
COLUMN 0
ID CFINCLUDE
LINE 4
RAW_TRACE at cfaboutoi2ecfm405934323.runPage(C:\inetpub\wwwroot\www.optimist.org\aboutoi.cfm:4)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\aboutoi.cfm
TYPE CFML
5
struct
COLUMN 0
ID CFINCLUDE
LINE 93
RAW_TRACE at cfapplication2ecfc572326160$funcONREQUEST.runFunction(C:\inetpub\wwwroot\www.optimist.org\application.cfc:93)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\application.cfc
TYPE CFML
Type java.sql.SQLSyntaxErrorException
SQLState 42S22
Sql SELECT d.District, coalesce(cl.District_Number,cm.DistrictNbr,cm.DistNbr,0) District_Number, isnull(cl.Zone,0) Zone_Number, cm.Club_Number, cm.Club, mm.Member_Number, mi.PersonID, mi.NameID, mi.AddressID, mi.PhoneHomeID, mi.PhoneWorkID, mi.PhoneCellID, mi.PhoneFaxID, mi.EmailID, mi.FullName, mi.NickName, mi.Address, mi.City, mi.State, mi.Zip, mi.Country, mi.Address_Valid_Flag, mi.E_Mail_Address E_Mail_Address, mi.Home_Phone_Number HomePhone, mi.Business_Phone_Number WorkPhone, mi.Fax_Phone_Number FaxPhone, mi.Cell_Phone_Number CellPhone, mm.Status MemberStatus, s.Status_Name MemberStatusName, c.CountryName_en Country_Name, sp.State_Province State_Province, case when DateDiff(day,mm.DateDeleted,getdate())<=89 then 'T' else 'F' end ReinstateStatus, DateDiff(day,mm.DateDeleted,getdate()) DaysAgo, mmsp.Member_Number SponsorNumber, dbo.TitleCase(mmsp.Full_Name ) SponsorName, mm.DateEffective, mm.DateDeleted, mm.Gender_Type, mm.Language_Code, ll.Language, case mm.Gender_Type when 'M' then 'Male' when 'F' then 'Female' else '' end Gender, case isnull(mm.Charter_Member_Flag,'F') when 'T' then 'Yes' else 'No' end Charter_Member, case isnull(mm.CollegeMbr,'F') when 'T' then 'Yes' else 'No' end CollegeMbr, isnull(mm.CollegeMbr_College,'') CollegeMbr_College, case isnull(mm.Spouse,'F') when 'T' then 'Yes' else 'No' end SpouseMbr, case mm.PreviousJOOI when 'T' then 'Yes' else 'No' end PreviousJOOIMbr, (case isnull(mm.Life_Member_Status,'N') when 'A' then 'Paid with Annual Dues' when 'F' then 'Fully Paid' when 'P' then 'Partially Paid' else 'No' end) Life_Member, (case when isnull(mm.Life_Member_Status,'N') in ('A','F') then 1 else 0 end) Life_Member_ShowDate, dbo.cDate(mm.Life_Membership_Date_Effective) Life_Member_Date, case isnull(mm.Diplomat_Member,'F') when 'T' then 'Yes' else 'No' end Diplomat, mm.Date_Diplomat_Member, isnull(pgi.PGI_Level,'') PGI_Level, dbo.cDate(pgi.PGI_Date) PGI_Date, case coalesce(dbo.cStr(mo.HighFiveMbr),mm.HighFiveMbr,'') when 'T' then 'Yes' when '1' then 'Yes' else 'No' end HighFiveMbr, case coalesce(dbo.cStr(mo.Free4for1Mbr),mm.Free4for1Mbr,'') when 'T' then 'Yes' when '1' then 'Yes' else 'No' end Free4for1Mbr, case coalesce(dbo.cStr(mo.eOptimistMbr),mm.eOptimistMbr,'') when 'T' then 'Yes' when '1' then 'Yes' else 'No' end eOptimistMbr, case coalesce(mo.FindSomeFriendsMbr,0) when 1 then 'Yes' else 'No' end FindSomeFriendsMbr, case coalesce(mm.ReUnitedMbr,'F') when 'T' then 'Yes' else 'No' end ReUnitedMbr, isnull(mm.ReUnitedMbr_Club,'') ReUnitedMbr_Club, case coalesce(mo.AdvertisementCode,mm.Advertisement_Flag,'T') when 'T' then 'Yes' else 'No' end AdvertisementCode, case coalesce(mo.EmailList,'T') when 'E' then 'E-Mail' when 'M' then 'Postal-Mail' when 'B' then 'E-Mail & Postal-Mail' else 'None' end EmailList, sMag.Status_Name MagazineCode, mo.EmailOptions, coalesce('('+nullif(mm.Delete_Reason,'')+')','('+dc.Delete_Reason+')','') DeleteReasonCurrent, cmsp.Name SponsorClubName, ltrim(rtrim(cm.Type_Code)) ClubType, mm.Delete_Code, isnull(dc.CantBeReinstated,0) CantBeReinstated, mm.DateRenewal, mi.FirstName FROM Member_Master mm left join vwLastPGI pgi on pgi.PersonID=mm.PersonID inner join vwMemberInfo mi on mi.Member_Number=mm.Member_Number INNER JOIN Club_Master cm ON cm.Club_Number=mm.Member_Club_Number LEFT JOIN Club_Location cl ON cl.Club_Number=cm.Club_Number and cl.Organization_Year=2018 LEFT JOIN District_Lookup d on d.District_Number= coalesce(cl.District_Number,cm.DistrictNbr,cm.DistNbr,0) INNER JOIN Country_Lookup c ON c.Country_Code=mm.Country_Code LEFT JOIN State_Province_Lookup sp ON sp.State_Province_Code=mm.State_Province_Code LEFT JOIN Delete_Lookup dc ON dc.Type='M' AND dc.Delete_Code=mm.Delete_Code LEFT JOIN Club_Master cmsp ON cmsp.Club_Number=mm.Sponsored_By_Club_Number LEFT JOIN Member_Master mmsp on mmsp.Member_Club_Number=mm.Sponsored_By_Club_Number and mmsp.Member_Roster_Number=mm.Sponsored_By_Roster_Number LEFT JOIN Member_Options mo on mo.Member_Club_Number=mm.Member_Club_Number and mo.Member_Roster_Number=mm.Member_Roster_Number left join Status_Lookup s ON s.Type='M' AND s.Status=mm.Status left join Status_Lookup sMag on sMag.Type='MAG' and sMag.Status= coalesce(mo.MagazineCode,mm.Magazine_Flag,'T') LEFT JOIN Language_Lookup ll on ll.Language_Code=mm.Language_Code WHERE mm.Member_Club_Number='wickh' AND mm.Member_Roster_Number=m-oh
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:641) at cfFacesOfOptimism2ecfm2012571739.runPage(C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\FacesOfOptimism.cfm:83) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfaboutoi2dbox82den2einc415959247.runPage(C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\aboutoi\aboutoi-box8-en.inc:19) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfoi2dtemplate42einc1927714717.runPage(C:\inetpub\wwwroot\www.optimist.org\Include\oi-template4.inc:55) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfaboutoi2ecfm405934323.runPage(C:\inetpub\wwwroot\www.optimist.org\aboutoi.cfm:4) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfapplication2ecfc572326160$funcONREQUEST.runFunction(C:\inetpub\wwwroot\www.optimist.org\application.cfc:93) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:491) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:337) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:88) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:280) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:356) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:94) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:79) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) 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:201) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Caused by: java.sql.SQLSyntaxErrorException: [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'm'. at macromedia.jdbc.sqlserverbase.dda4.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda4.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.ddj.l(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.e(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.v(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.r(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348) at coldfusion.sql.Executive.executeQuery(Executive.java:1420) at coldfusion.sql.Executive.executeQuery(Executive.java:1183) at coldfusion.sql.Executive.executeQuery(Executive.java:1114) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590) ... 54 more
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 83
RAW_TRACE at cfFacesOfOptimism2ecfm2012571739.runPage(C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\FacesOfOptimism.cfm:83)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\FacesOfOptimism.cfm
TYPE CFML
2
struct
COLUMN 0
ID CFINCLUDE
LINE 19
RAW_TRACE at cfaboutoi2dbox82den2einc415959247.runPage(C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\aboutoi\aboutoi-box8-en.inc:19)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\aboutoi\aboutoi-box8-en.inc
TYPE CFML
3
struct
COLUMN 0
ID CFINCLUDE
LINE 55
RAW_TRACE at cfoi2dtemplate42einc1927714717.runPage(C:\inetpub\wwwroot\www.optimist.org\Include\oi-template4.inc:55)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\Include\oi-template4.inc
TYPE CFML
4
struct
COLUMN 0
ID CFINCLUDE
LINE 4
RAW_TRACE at cfaboutoi2ecfm405934323.runPage(C:\inetpub\wwwroot\www.optimist.org\aboutoi.cfm:4)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\aboutoi.cfm
TYPE CFML
5
struct
COLUMN 0
ID CFINCLUDE
LINE 93
RAW_TRACE at cfapplication2ecfc572326160$funcONREQUEST.runFunction(C:\inetpub\wwwroot\www.optimist.org\application.cfc:93)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\application.cfc
TYPE CFML
Type Database
queryError [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'm'.
where [empty string]
StackTrace coldfusion.runtime.EventHandlerException: Event handler exception. at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:288) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:356) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:94) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:79) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) 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:201) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Caused by: coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:641) at cfFacesOfOptimism2ecfm2012571739.runPage(C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\FacesOfOptimism.cfm:83) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfaboutoi2dbox82den2einc415959247.runPage(C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\aboutoi\aboutoi-box8-en.inc:19) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfoi2dtemplate42einc1927714717.runPage(C:\inetpub\wwwroot\www.optimist.org\Include\oi-template4.inc:55) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfaboutoi2ecfm405934323.runPage(C:\inetpub\wwwroot\www.optimist.org\aboutoi.cfm:4) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfapplication2ecfc572326160$funcONREQUEST.runFunction(C:\inetpub\wwwroot\www.optimist.org\application.cfc:93) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:491) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:337) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:88) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:280) ... 28 more Caused by: java.sql.SQLSyntaxErrorException: [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'm'. at macromedia.jdbc.sqlserverbase.dda4.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda4.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.ddj.l(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.e(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.v(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.r(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348) at coldfusion.sql.Executive.executeQuery(Executive.java:1420) at coldfusion.sql.Executive.executeQuery(Executive.java:1183) at coldfusion.sql.Executive.executeQuery(Executive.java:1114) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590) ... 54 more
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 83
RAW_TRACE at cfFacesOfOptimism2ecfm2012571739.runPage(C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\FacesOfOptimism.cfm:83)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\FacesOfOptimism.cfm
TYPE CFML
2
struct
COLUMN 0
ID CFINCLUDE
LINE 19
RAW_TRACE at cfaboutoi2dbox82den2einc415959247.runPage(C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\aboutoi\aboutoi-box8-en.inc:19)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\INCLUDEDCONTENT\aboutoi\aboutoi-box8-en.inc
TYPE CFML
3
struct
COLUMN 0
ID CFINCLUDE
LINE 55
RAW_TRACE at cfoi2dtemplate42einc1927714717.runPage(C:\inetpub\wwwroot\www.optimist.org\Include\oi-template4.inc:55)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\Include\oi-template4.inc
TYPE CFML
4
struct
COLUMN 0
ID CFINCLUDE
LINE 4
RAW_TRACE at cfaboutoi2ecfm405934323.runPage(C:\inetpub\wwwroot\www.optimist.org\aboutoi.cfm:4)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\aboutoi.cfm
TYPE CFML
5
struct
COLUMN 0
ID CFINCLUDE
LINE 93
RAW_TRACE at cfapplication2ecfc572326160$funcONREQUEST.runFunction(C:\inetpub\wwwroot\www.optimist.org\application.cfc:93)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\application.cfc
TYPE CFML
Type Database
name onRequest