|
|
| Reporter | Adam Edington | Assigned To | Guest | |
|---|
| Priority | normal | Severity | minor | |
|---|
| Status | new | Resolution | open | |
|---|
| Product Version | 10.0.50 | |
|---|
|
|
| Summary | 6109: Issue sending "one off" Newsletter |
|---|
| 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) |
|---|
| Tags | No tags attached. |
|---|
| Attach Tags |
|
|---|
|
|
| Time estimation (hours) | |
|---|
| Sponsorship open | |
|---|
|
|
