Media Gallery

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]Conversion failed when converting from a character string to uniqueidentifier.

43 : 	WHERE 	RowNumber BETWEEN 1 AND #getMediaGallerySettings.intMediaGalleryItemsPerGallery#
44 : 	<cfelseif url.action EQ "email">
45 : 	WHERE 	RowNumber BETWEEN #url.Page# AND #url.Page#
46 : 	</cfif>
47 : </cfquery>

SQLSTATE	HY000
EXCEPTIONS	<small><i>not set</i></small>
DATASOURCE	DWebCMS
VENDORERRORCODE	8169
SQL	WITH Items AS ( SELECT MGIL., MGI.datItemDate, MT.vchMediaTypeName, WebsitePage = ( SELECT TOP 1 vchFilename FROM tblWebsitePages WP LEFT JOIN tblWebsitePageMediaGalleries WPMG ON WP.unqPageId = WPMG.unqWebsitePageId WHERE WP.unqCustomerID = (param 1) AND WP.unqPageTypeId = 'a5ac8a7c-7023-499a-91b1-dfda5b5454cf' AND WP.bitActive = 1 AND (WPMG.unqMediaGalleryId = MGI.unqMediaGalleryId OR WPMG.unqMediaGalleryId IS NULL) ORDER BY unqMediaGalleryId DESC ), ROW_NUMBER() OVER (ORDER BY MGI.bitFeatured DESC, MGI.intSortOrder) AS RowNumber FROM SysApp_v2_MediaGalleryItems MGI JOIN SysApp_v2_MediaGalleryItemLocalizations MGIL ON (MGI.unqMediaGalleryItemId = MGIL.unqMediaGalleryItemId AND MGIL.unqLanguageId = (param 2) ) JOIN SysApp_v2_MediaTypes MT ON (MGI.unqMediaTypeId = MT.unqMediaTypeId) WHERE 1 = 1 AND MGI.unqMediaGalleryId = (param 3) ) SELECT FROM Items

Resources:

Check the ColdFusion documentation to verify that you are using the correct syntax.
Search the Knowledge Base to find a solution to your problem.

Browser	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote Address	18.227.140.152
Referrer
Date/Time	02-Jan-25 09:11 PM

Stack Trace

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Conversion failed when converting from a character string to uniqueidentifier.
	at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1103)
	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980)
	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124)
	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193)
	at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153)
	at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126)
	at macromedia.jdbc.sqlserver.tds.r.a(|SQLServer|6.0.0.1282|:1059)
	at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275)
	at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035)
	at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632)
	at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699)
	at macromedia.jdbc.sqlserver.base.BasePreparedStatement.G(|SQLServer|6.0.0.1282|:526)
	at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508)
	at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358)
	at macromedia.jdbc.sqlserver.base.BasePreparedStatement.execute(|SQLServer|6.0.0.1282|:2703)
	at macromedia.jdbc.sqlserver.base.fg.execute(|SQLServer|6.0.0.1282|:525)
	at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1658)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1384)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1314)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1250)
	at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:877)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:822)
	at cfactGetMediaItems2ecfm791442647.runPage(D:\sites\DWebCMS\website\SystemApplications\mediagallery\Galleries\actGetMediaItems.cfm:45)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083)
	at cfindex2ecfm2032472885.runPage(D:\sites\DWebCMS\website\SystemApplications\mediagallery\Galleries\index.cfm:23)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083)
	at cfindex2ecfm1406979841.runPage(D:\sites\DWebCMS\website\SystemApplications\mediagallery\index.cfm:27)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083)
	at cfpage_mediagallery_v22ecfm2055383549.runPage(D:\sites\DWebCMS\website\page_mediagallery_v2.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083)
	at cfbody2ecfm1287691414.runPage(D:\sites\DWebCMS\website\body.cfm:92)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083)
	at cftemplate2ecfm1701196461.runPage(D:\sites\CMSDemo\template.cfm:280)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083)
	at cfindex2ecfm980576805.runPage(D:\sites\DWebCMS\website\index.cfm:45)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083)
	at cfindex2ecfm63432370.runPage(D:\sites\CMSDemo\html\index.cfm:5)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083)
	at cfmedia2dgallery2ecfm568180139.runPage(d:\sites\cmsdemo\html\media-gallery.cfm:3)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:613)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:162)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
	at coldfusion.filter.LicenseFilter.invoke(LicenseFilter.java:30)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97)
	at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60)
	at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
	at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
	at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
	at coldfusion.CfmServlet.service(CfmServlet.java:231)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
	at coldfusion.inspect.weinre.MobileDeviceDomInspectionFilter.doFilter(MobileDeviceDomInspectionFilter.java:57)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357)
	at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:448)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:936)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63)
	at java.base/java.lang.Thread.run(Thread.java:833)