View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 6115 | Composr | newsletter | public | 2025-01-08 05:06 | 2025-03-30 21:06 |
| Reporter | Adam Edington | Assigned To | PDStig | ||
| Priority | normal | Severity | minor | ||
| Status | resolved | Resolution | fixed | ||
| Product Version | 11.beta7 | ||||
| Summary | 6115: [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 | ||||
| Attach Tags | |||||
| Time estimation (hours) | |||||
| 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! |
|
|
Automated response: Query failure viewing subscribers of a newsletter There was an error in the ORDER BY clause in the SQL. This hotfix fixes it. |
|
|
Fixed in Git commit fa0551850e (https://gitlab.com/composr-foundation/composr/commit/fa0551850e - link will become active once code pushed to GitLab) |
|
|
|
| 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 | |
| 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 | |
| 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 | |
| 2025-02-06 20:21 | Adam Edington | Additional Information Updated | |
| 2025-03-14 22:42 | PDStig | Note Added: 0009865 | |
| 2025-03-14 22:42 | PDStig | Tag Attached: Roadmap: v11 | |
| 2025-03-30 21:06 | PDStig | Note Added: 9905 | |
| 2025-03-30 21:06 | PDStig | File Added: hotfix-6115, 2025-03-30 9pm.tar | |
| 2025-03-30 21:06 | PDStig | Assigned To | Guest => PDStig |
| 2025-03-30 21:06 | PDStig | Status | Not Assigned => Resolved |
| 2025-03-30 21:06 | PDStig | Resolution | open => fixed |
