Error Occurred While Processing Request The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.


The following information is meant for the website developer for debugging purposes.
Error Occurred While Processing Request

Error Executing Database Query.

[Macromedia][SQLServer JDBC Driver][SQLServer]The multi-part identifier "M.categoryId" could not be bound.
 
The error occurred in E:\websites\www.weddingbycolor.com HEADER REVAMP\_com\Project\Milestone\FUN_Milestone\queryByCategory.cfm: line 135
Called from E:\websites\www.weddingbycolor.com HEADER REVAMP\_com\Project\Milestone\Milestone.cfc: line 117
Called from E:\websites\www.weddingbycolor.com HEADER REVAMP\_com\Project\Milestone\FUN_Milestone\writeByCategory.cfm: line 1
Called from E:\websites\www.weddingbycolor.com HEADER REVAMP\_com\Project\Milestone\Milestone.cfc: line 463
Called from E:\websites\www.weddingbycolor.com HEADER REVAMP\_com\Gui\Parts\FUN_SiteFooterPosts\init.cfm: line 70
Called from E:\websites\www.weddingbycolor.com HEADER REVAMP\_com\Gui\Parts\SiteFooterPosts.cfc: line 14
Called from E:\websites\www.weddingbycolor.com HEADER REVAMP\members\inc\member.cfm: line 17
Called from E:\websites\www.weddingbycolor.com HEADER REVAMP\members\member.cfm: line 133
Called from E:\websites\www.weddingbycolor.com HEADER REVAMP\milestones\milestone.cfm: line 22
Called from E:\websites\www.weddingbycolor.com HEADER REVAMP\_com\Project\Milestone\FUN_Milestone\queryByCategory.cfm: line 135
Called from E:\websites\www.weddingbycolor.com HEADER REVAMP\_com\Project\Milestone\Milestone.cfc: line 117
Called from E:\websites\www.weddingbycolor.com HEADER REVAMP\_com\Project\Milestone\FUN_Milestone\writeByCategory.cfm: line 1
Called from E:\websites\www.weddingbycolor.com HEADER REVAMP\_com\Project\Milestone\Milestone.cfc: line 463
Called from E:\websites\www.weddingbycolor.com HEADER REVAMP\_com\Gui\Parts\FUN_SiteFooterPosts\init.cfm: line 70
Called from E:\websites\www.weddingbycolor.com HEADER REVAMP\_com\Gui\Parts\SiteFooterPosts.cfc: line 14
Called from E:\websites\www.weddingbycolor.com HEADER REVAMP\members\inc\member.cfm: line 17
Called from E:\websites\www.weddingbycolor.com HEADER REVAMP\members\member.cfm: line 133
Called from E:\websites\www.weddingbycolor.com HEADER REVAMP\milestones\milestone.cfm: line 22
133 : 	</cfif>
134 : 	<cfif orderBy_ToUse neq "">
135 : 		ORDER BY #orderBy_ToUse#
136 : 	</cfif>
137 : <!---

SQLSTATE   HY000
SQL   WITH QRY_Top_Score_Records AS (SELECT TOP 100 ROW_NUMBER() OVER (ORDER BY MS.createdTime DESC) AS Row, MS.*, CASE MS.categoryId WHEN 255 THEN MS.categoryOther ELSE C.name END AS categoryName, CASE M.categoryId WHEN 255 THEN M.categoryOther ELSE C.urlName END AS categoryUrlName, IsNull(PH.imageFileId, 0) AS imageFileId, PH.caption AS photoCaption ,S.score , MB.userId, MB.isPro, MB.proExpiryFROM PROJ_Milestone MS, PROJ_MS_Category C, PROJ_MS_Photo PH , STAT_Milestone S , PRS_Member MB, PROJ_Project P WHERE 1 = 1 AND MS.categoryId = 13AND MS.categoryId *= C.idAND MS.isDeleted = 0AND MS.keyPhotoId *= PH.idAND PH.isDeleted = 0 AND MS.id *= S.milestoneId AND MS.projectId = P.id AND P.memberId = MB.id AND MS.typeId = 0 AND MS.isPresentable = 1 AND MB.isSpammer = 0 AND MS.createdTime >= {ts '2010-12-01 19:23:19'} AND MB.isFaked = 0 AND MS.projectId NOT IN (4744,39))SELECT TOP 3 *FROM QRY_Top_Score_RecordsWHERE 1 = 1 ORDER BY score DESC
VENDORERRORCODE   4104
DATASOURCE   weddingbycolor
Resources:

Browser   CCBot/2.0 (http://commoncrawl.org/faq/)
Remote Address   54.89.70.124
Referrer  
Date/Time   01-Oct-14 07:23 PM
Stack Trace
at cfqueryByCategory2ecfm939487235.runPage(E:\websites\www.weddingbycolor.com HEADER REVAMP\_com\Project\Milestone\FUN_Milestone\queryByCategory.cfm:135) at cfMilestone2ecfc1970300403$funcQUERYBYCATEGORY.runFunction(E:\websites\www.weddingbycolor.com HEADER REVAMP\_com\Project\Milestone\Milestone.cfc:117) at cfwriteByCategory2ecfm1293103317.runPage(E:\websites\www.weddingbycolor.com HEADER REVAMP\_com\Project\Milestone\FUN_Milestone\writeByCategory.cfm:1) at cfMilestone2ecfc1970300403$funcWRITEBYCATEGORY.runFunction(E:\websites\www.weddingbycolor.com HEADER REVAMP\_com\Project\Milestone\Milestone.cfc:463) at cfinit2ecfm1082120724.runPage(E:\websites\www.weddingbycolor.com HEADER REVAMP\_com\Gui\Parts\FUN_SiteFooterPosts\init.cfm:70) at cfSiteFooterPosts2ecfc1701912548$funcINIT.runFunction(E:\websites\www.weddingbycolor.com HEADER REVAMP\_com\Gui\Parts\SiteFooterPosts.cfc:14) at cfmember2ecfm286762257.runPage(E:\websites\www.weddingbycolor.com HEADER REVAMP\members\inc\member.cfm:17) at cfmember2ecfm440869459.runPage(E:\websites\www.weddingbycolor.com HEADER REVAMP\members\member.cfm:133) at cfmilestone2ecfm2139678066.runPage(E:\websites\www.weddingbycolor.com HEADER REVAMP\milestones\milestone.cfm:22) at cfqueryByCategory2ecfm939487235.runPage(E:\websites\www.weddingbycolor.com HEADER REVAMP\_com\Project\Milestone\FUN_Milestone\queryByCategory.cfm:135) at cfMilestone2ecfc1970300403$funcQUERYBYCATEGORY.runFunction(E:\websites\www.weddingbycolor.com HEADER REVAMP\_com\Project\Milestone\Milestone.cfc:117) at cfwriteByCategory2ecfm1293103317.runPage(E:\websites\www.weddingbycolor.com HEADER REVAMP\_com\Project\Milestone\FUN_Milestone\writeByCategory.cfm:1) at cfMilestone2ecfc1970300403$funcWRITEBYCATEGORY.runFunction(E:\websites\www.weddingbycolor.com HEADER REVAMP\_com\Project\Milestone\Milestone.cfc:463) at cfinit2ecfm1082120724.runPage(E:\websites\www.weddingbycolor.com HEADER REVAMP\_com\Gui\Parts\FUN_SiteFooterPosts\init.cfm:70) at cfSiteFooterPosts2ecfc1701912548$funcINIT.runFunction(E:\websites\www.weddingbycolor.com HEADER REVAMP\_com\Gui\Parts\SiteFooterPosts.cfc:14) at cfmember2ecfm286762257.runPage(E:\websites\www.weddingbycolor.com HEADER REVAMP\members\inc\member.cfm:17) at cfmember2ecfm440869459.runPage(E:\websites\www.weddingbycolor.com HEADER REVAMP\members\member.cfm:133) at cfmilestone2ecfm2139678066.runPage(E:\websites\www.weddingbycolor.com HEADER REVAMP\milestones\milestone.cfm:22)

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]The multi-part identifier "M.categoryId" could not be bound.
	at macromedia.jdbc.base.BaseExceptions.createException(Unknown Source)
	at macromedia.jdbc.base.BaseExceptions.getException(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
	at macromedia.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)
	at macromedia.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source)
	at macromedia.jdbc.base.BaseStatement.postImplExecute(Unknown Source)
	at macromedia.jdbc.base.BaseStatement.commonExecute(Unknown Source)
	at macromedia.jdbc.base.BaseStatement.executeInternal(Unknown Source)
	at macromedia.jdbc.base.BaseStatement.execute(Unknown Source)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1220)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1008)
	at coldfusion.sql.Executive.executeQuery(Executive.java:939)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:325)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:831)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:521)
	at cfqueryByCategory2ecfm939487235.runPage(E:\websites\www.weddingbycolor.com HEADER REVAMP\_com\Project\Milestone\FUN_Milestone\queryByCategory.cfm:135)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2661)
	at cfMilestone2ecfc1970300403$funcQUERYBYCATEGORY.runFunction(E:\websites\www.weddingbycolor.com HEADER REVAMP\_com\Project\Milestone\Milestone.cfc:117)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418)
	at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360)
	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324)
	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:59)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:463)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:453)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:320)
	at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2222)
	at cfwriteByCategory2ecfm1293103317.runPage(E:\websites\www.weddingbycolor.com HEADER REVAMP\_com\Project\Milestone\FUN_Milestone\writeByCategory.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2661)
	at cfMilestone2ecfc1970300403$funcWRITEBYCATEGORY.runFunction(E:\websites\www.weddingbycolor.com HEADER REVAMP\_com\Project\Milestone\Milestone.cfc:463)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418)
	at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360)
	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324)
	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:59)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:463)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:453)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:320)
	at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2222)
	at cfinit2ecfm1082120724.runPage(E:\websites\www.weddingbycolor.com HEADER REVAMP\_com\Gui\Parts\FUN_SiteFooterPosts\init.cfm:70)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2661)
	at cfSiteFooterPosts2ecfc1701912548$funcINIT.runFunction(E:\websites\www.weddingbycolor.com HEADER REVAMP\_com\Gui\Parts\SiteFooterPosts.cfc:14)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418)
	at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360)
	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324)
	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:59)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:463)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:453)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:320)
	at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2222)
	at cfmember2ecfm286762257.runPage(E:\websites\www.weddingbycolor.com HEADER REVAMP\members\inc\member.cfm:17)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2661)
	at cfmember2ecfm440869459.runPage(E:\websites\www.weddingbycolor.com HEADER REVAMP\members\member.cfm:133)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2661)
	at cfmilestone2ecfm2139678066.runPage(E:\websites\www.weddingbycolor.com HEADER REVAMP\milestones\milestone.cfm:22)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:279)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70)
	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.CfmServlet.service(CfmServlet.java:175)
	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)