#6109 - Issue sending "one off" Newsletter

Identifier #6109
Issue type Minor issue (breaks specific functionality)
Title Issue sending "one off" Newsletter
Status Open
Handling member Deleted
Version 10.0.50
Addon General / Uncategorised
Description Unfortunately 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)
Steps to reproduce

Funded? No
The system will post a comment when this issue is modified (e.g., status changes). To be notified of this, click "Enable comment notifications".

Rating

Unrated