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.
 
The error occurred in D:/Sites/DWebCMS/website/SystemApplications/mediagallery/Galleries/actGetMediaItems.cfm: line 45
Called from D:/Sites/DWebCMS/website/SystemApplications/mediagallery/Galleries/index.cfm: line 23
Called from D:/Sites/DWebCMS/website/SystemApplications/mediagallery/index.cfm: line 27
Called from D:/Sites/DWebCMS/website/page_mediagallery_v2.cfm: line 1
Called from D:/Sites/DWebCMS/website/body.cfm: line 92
Called from D:/Sites/CMSDemo/template.cfm: line 280
Called from D:/Sites/DWebCMS/website/index.cfm: line 24
Called from d:/sites/cmsdemo/html/index.cfm: line 5
Called from d:/sites/cmsdemo/html/media-gallery.cfm: line 3
Called from D:/Sites/DWebCMS/website/SystemApplications/mediagallery/Galleries/actGetMediaItems.cfm: line 45
Called from D:/Sites/DWebCMS/website/SystemApplications/mediagallery/Galleries/index.cfm: line 23
Called from D:/Sites/DWebCMS/website/SystemApplications/mediagallery/index.cfm: line 27
Called from D:/Sites/DWebCMS/website/page_mediagallery_v2.cfm: line 1
Called from D:/Sites/DWebCMS/website/body.cfm: line 92
Called from D:/Sites/CMSDemo/template.cfm: line 280
Called from D:/Sites/DWebCMS/website/index.cfm: line 24
Called from d:/sites/cmsdemo/html/index.cfm: line 5
Called from d:/sites/cmsdemo/html/media-gallery.cfm: line 3
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
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:

Browser   CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address   44.200.25.51
Referrer  
Date/Time   17-May-22 09:27 PM
Stack Trace
at cfactGetMediaItems2ecfm791442647.runPage(D:/Sites/DWebCMS/website/SystemApplications/mediagallery/Galleries/actGetMediaItems.cfm:45) at cfindex2ecfm2032472885.runPage(D:/Sites/DWebCMS/website/SystemApplications/mediagallery/Galleries/index.cfm:23) at cfindex2ecfm1406979841.runPage(D:/Sites/DWebCMS/website/SystemApplications/mediagallery/index.cfm:27) at cfpage_mediagallery_v22ecfm2055383549.runPage(D:/Sites/DWebCMS/website/page_mediagallery_v2.cfm:1) at cfbody2ecfm1287691414.runPage(D:/Sites/DWebCMS/website/body.cfm:92) at cftemplate2ecfm1701196461.runPage(D:/Sites/CMSDemo/template.cfm:280) at cfindex2ecfm980576805.runPage(D:/Sites/DWebCMS/website/index.cfm:24) at cfindex2ecfm63432370.runPage(d:/sites/cmsdemo/html/index.cfm:5) at cfmedia2dgallery2ecfm568180139.runPage(d:/sites/cmsdemo/html/media-gallery.cfm:3) at cfactGetMediaItems2ecfm791442647.runPage(D:/Sites/DWebCMS/website/SystemApplications/mediagallery/Galleries/actGetMediaItems.cfm:45) at cfindex2ecfm2032472885.runPage(D:/Sites/DWebCMS/website/SystemApplications/mediagallery/Galleries/index.cfm:23) at cfindex2ecfm1406979841.runPage(D:/Sites/DWebCMS/website/SystemApplications/mediagallery/index.cfm:27) at cfpage_mediagallery_v22ecfm2055383549.runPage(D:/Sites/DWebCMS/website/page_mediagallery_v2.cfm:1) at cfbody2ecfm1287691414.runPage(D:/Sites/DWebCMS/website/body.cfm:92) at cftemplate2ecfm1701196461.runPage(D:/Sites/CMSDemo/template.cfm:280) at cfindex2ecfm980576805.runPage(D:/Sites/DWebCMS/website/index.cfm:24) at cfindex2ecfm63432370.runPage(d:/sites/cmsdemo/html/index.cfm:5) at cfmedia2dgallery2ecfm568180139.runPage(d:/sites/cmsdemo/html/media-gallery.cfm:3)

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Conversion failed when converting from a character string to uniqueidentifier.
	at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddcv.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.ddq.a(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source)
	at macromedia.jdbc.sqlserver.dda4.m(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddd2.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddd2.execute(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddd6.execute(Unknown Source)
	at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1583)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1317)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1247)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:427)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1211)
	at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:841)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:794)
	at cfactGetMediaItems2ecfm791442647.runPage(D:\Sites\DWebCMS\website\SystemApplications\mediagallery\Galleries\actGetMediaItems.cfm:45)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:729)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4082)
	at cfindex2ecfm2032472885.runPage(D:\Sites\DWebCMS\website\SystemApplications\mediagallery\Galleries\index.cfm:23)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:729)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4082)
	at cfindex2ecfm1406979841.runPage(D:\Sites\DWebCMS\website\SystemApplications\mediagallery\index.cfm:27)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:729)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4082)
	at cfpage_mediagallery_v22ecfm2055383549.runPage(D:\Sites\DWebCMS\website\page_mediagallery_v2.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:729)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4082)
	at cfbody2ecfm1287691414.runPage(D:\Sites\DWebCMS\website\body.cfm:92)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:729)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4082)
	at cftemplate2ecfm1701196461.runPage(D:\Sites\CMSDemo\template.cfm:280)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:729)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4082)
	at cfindex2ecfm980576805.runPage(D:\Sites\DWebCMS\website\index.cfm:24)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:729)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4082)
	at cfindex2ecfm63432370.runPage(d:\sites\cmsdemo\html\index.cfm:5)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:729)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4082)
	at cfmedia2dgallery2ecfm568180139.runPage(d:\sites\cmsdemo\html\media-gallery.cfm:3)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:729)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:597)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:162)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:96)
	at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60)
	at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
	at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
	at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
	at coldfusion.CfmServlet.service(CfmServlet.java:226)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	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:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at coldfusion.inspect.weinre.MobileDeviceDomInspectionFilter.doFilter(MobileDeviceDomInspectionFilter.java:121)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:491)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357)
	at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:422)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:764)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1388)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.base/java.lang.Thread.run(Thread.java:834)