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 45
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 45
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 |
claudebot |
| Remote Address |
3.14.142.115 |
| Referrer |
|
| Date/Time |
18-Apr-24 08:30 AM |
|
