View Issue Details

IDProjectCategoryView StatusLast Update
0006109Composr[All Projects] General / Uncategorisedpublic2025-01-06 14:59
ReporterAdam EdingtonAssigned To 
SeverityMinor-bug 
Status non-assignedResolutionopen 
Product Version10.0.50 
Fixed in Version 
Summary0006109: Issue sending "one off" Newsletter
DescriptionUnfortunately a query has failed [SELECT * FROM cms_calendar_events e LEFT JOIN cms_content_privacy priv ON priv.content_id=CAST(e.id AS CHAR(20)) AND priv.content_type='event' WHERE e_add_date>1641567420 AND e_member_calendar IS NULL AND ((e_type=8)) AND (priv.content_id IS NULL OR priv.guest_view=1) AND (NOT EXISTS(SELECT * FROM cms_content_regions cr WHERE CAST(r.id AS CHAR(20))=cr.content_id AND content_type='event') OR EXISTS(SELECT * FROM cms_content_regions cr WHERE CAST(r.id AS CHAR(20))=cr.content_id AND cr.region='GB' AND content_type='event')) ORDER BY e_add_date DESC LIMIT 300] [Unknown column 'r.id' in 'where clause'] (version: 10.0.50, PHP version: 7.4.33, URL: /adminzone/admin-newsletter/whatsnew_2?lang=EN)
TagsNo tags attached.
Time estimation (hours)
Sponsorship open

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2025-01-06 14:59 Adam Edington New Issue