View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006115 | Composr alpha bug reports | [All Projects] General / Uncategorised | public | 2025-01-08 05:06 | 2025-03-14 22:42 |
| Reporter | Adam Edington | Assigned To | |||
| Severity | Minor-bug | ||||
| Status | non-assigned | Resolution | open | ||
| Summary | 0006115: [beta6] Newsletter bugs | ||||
| 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) | ||||
| 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. | ||||
| Tags | Roadmap: v11 | ||||
| Sponsorship open | |||||
|
|
As I do not have Mozilla Thunderbird, can you upload a CSV file exported from Thunderbird so I can analyze the structure? Please mark the note "Private" before uploading so only staff see it. Thank you! |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2025-01-08 05:06 | Adam Edington | New Issue | |
| 2025-01-08 05:06 | Adam Edington | View Status | public => private |
| 2025-01-08 05:06 | Adam Edington | Summary | Cannot view Newsletter subs => [beta6] Cannot view Newsletter subs |
| 2025-01-08 05:22 | Adam Edington | Additional Information Updated | View Revisions |
| 2025-01-08 05:23 | Adam Edington | Summary | [beta6] Cannot view Newsletter subs => [beta6] Newsletter bugs |
| 2025-01-08 05:24 | Adam Edington | Additional Information Updated | View Revisions |
| 2025-01-08 05:25 | Adam Edington | Severity | Trivial-bug => Minor-bug |
| 2025-01-08 05:26 | Adam Edington | View Status | private => public |
| 2025-01-08 05:26 | Adam Edington | Description Updated | View Revisions |
| 2025-02-06 20:21 | Adam Edington | Additional Information Updated | View Revisions |
| 2025-03-14 22:42 | Patrick Schmalstig | Note Added: 0009865 | |
| 2025-03-14 22:42 | Patrick Schmalstig | Tag Attached: Roadmap: v11 |
