View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 5245 | Composr alpha bug reports | General / Uncategorised | public | 2023-01-18 04:01 | 2023-01-31 23:52 |
| Reporter | Adam Edington | Assigned To | PDStig | ||
| Priority | normal | Severity | trivial | ||
| Status | resolved | Resolution | fixed | ||
| Summary | 5245: MySQL error after deleting image from gallery | ||||
| Description | A query has failed [SELECT COUNT(DISTINCT r.id) FROM cms11_images r LEFT JOIN cms11_galleries parent ON parent.name=r.id WHERE 1=1(cat='awake_consciousness') AND cat NOT LIKE 'download\_%' AND (1=1) LIMIT 1] [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(cat='awake_consciousness') AND cat NOT LIKE 'download\_%' AND (1=1) LIMIT 1' at line 1] (version: 11 alpha1, PHP version: 8.1.14, URL: https://dev.mediafeeder.net:80/composr/alpha11/site/index.php?page=galleries&type=browse&id=awake_consciousness) Also notice port 80 is still in there though I did remove it at install. | ||||
| Additional Information | Pretty much the same error when enabling Carousel mode on a gallery | ||||
| Tags | No tags attached. | ||||
| Attach Tags | |||||
| Sponsorship open | |||||
|
|
I have not been able to reproduce any of these errors on my Linux install. I will try replicating them on Windows and will get back with you. |
|
|
Hello Adam. I attempted a fix in https://gitlab.com/composr-foundation/composr/-/commit/7f1b2b5ed79b1d0e2fe4962dce248a23e2bfb6db . Please let me know if this is working for you. |
|
|
Problem solved, thanks. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2023-01-18 04:01 | Adam Edington | New Issue | |
| 2023-01-18 19:25 | Adam Edington | Description Updated | |
| 2023-01-30 10:35 | Adam Edington | Additional Information Updated | |
| 2023-01-30 10:36 | Adam Edington | Assigned To | => Chris Graham |
| 2023-01-30 10:36 | Adam Edington | Status | Not Assigned => Assigned |
| 2023-01-30 16:36 | PDStig | Note Added: 0007888 | |
| 2023-01-31 19:10 | PDStig | Note Added: 0007889 | |
| 2023-01-31 19:10 | PDStig | Assigned To | Chris Graham => user4172 |
| 2023-01-31 23:51 | Adam Edington | Note Added: 0007890 | |
| 2023-01-31 23:52 | Adam Edington | Status | Assigned => Resolved |
| 2023-01-31 23:52 | Adam Edington | Resolution | open => fixed |
| 2023-02-26 18:29 | Chris Graham | Category | General => General / Uncategorised |
