#6115 - [beta6] Newsletter bugs
-
By Adam Edington
- Added
- 4 views
| Identifier | #6115 |
|---|---|
| Issue type | Minor issue (breaks specific functionality) |
| Title | [beta6] Newsletter bugs |
| Status | Completed |
| Tags |
Roadmap: v11 (custom) |
| Handling member | PDStig |
| Version | 11 beta7 |
| Addon | newsletter |
| Description | A query has failed [SELECT SUBSTR(email,INSTR(email,'@')) AS email,COUNT(*) as cnt FROM cms_newsletter_subscribe WHERE 1=1 GROUP BY SUBSTR(email,INSTR(email,'@'))] ['agentdiamond-35303533aec9.cms_newsletter_subscribe.email' isn't in GROUP BY] (version: 11 beta6, PHP version: 8.3.13, URL: adminzone/index.php?page=admin-newsletter&type=subscribers&lang=EN&id=2) |
| Steps to reproduce | |
| Additional information | Using a .csv generated from Mozilla Thunderbird results in 0 emails being added to the selected Newsletter! We are using a Display name field as we deal with artists, bands and labels. Perhaps an all inclusive name field which takes First, First and Last or Display name would be useful. It would also be useful to be able to add emails to the list without needed to use .csv, just a Name and Email field would suffice, or whatever Composr can handle or expects. |
| Funded? | No |
| Commits |
The system will post a comment when this issue is modified (e.g., status changes). To be notified of this, click "Enable comment notifications".
Comments
Please mark the note "Private" before uploading so only staff see it. Thank you!
There was an error in the ORDER BY clause in the SQL. This hotfix fixes it.