View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0005886 | Composr | core | public | 2024-08-09 20:27 | 2024-09-13 03:48 |
| Reporter | Adam Edington | Assigned To | Patrick Schmalstig | ||
| Severity | Minor-bug | ||||
| Status | resolved | Resolution | fixed | ||
| Product Version | 10.0.47 | ||||
| Fixed in Version | |||||
| Summary | 0005886: SELECT_COUNT query failing | ||||
| Description | Composr: Unfortunately a query has failed [SELECT COUNT(*) as cnt FROM cms_videos r WHERE 1=1 AND validated=1 AND ((rcat='overspill'))] [<strong>Unknown column 'rcat' in 'where clause'</strong>] (version: 10.0.47, PHP version: 8.1.27, URL: /data/preview.php?page=start&type=step2&keep_force_open=1&utheme=admin) @ https://mediafeeder.net/data/preview.php?page=start&type=step2&keep_force_open=1&utheme=admin | ||||
| Additional Information | Again, pulled from errorlog | ||||
| Tags | No tags attached. | ||||
| Time estimation (hours) | |||||
| Sponsorship open | |||||
|
|
I need a stack trace to debug this; the information provided is not enough for me to understand what the user was trying to do. |
|
|
I think I fixed this recently... the issue is that "rcat" should have been "r.rcat". Several content hooks were missing "r." Edit: Realised this is a v10 issue. I only fixed this on v11. v10 is in maintenance status so this won't get fixed in v10 without sponsorship. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2024-08-09 20:27 | Adam Edington | New Issue | |
| 2024-08-09 22:26 | Adam Edington | Category | General / Uncategorised => core |
| 2024-08-09 22:26 | Adam Edington | Description Updated | View Revisions |
| 2024-08-12 22:05 | Patrick Schmalstig | Note Added: 0009153 | |
| 2024-09-13 03:47 | Patrick Schmalstig | Assigned To | => Patrick Schmalstig |
| 2024-09-13 03:47 | Patrick Schmalstig | Status | non-assigned => resolved |
| 2024-09-13 03:47 | Patrick Schmalstig | Resolution | open => fixed |
| 2024-09-13 03:47 | Patrick Schmalstig | Note Added: 0009373 | |
| 2024-09-13 03:48 | Patrick Schmalstig | Note Edited: 0009373 | View Revisions |
| 2024-09-13 03:48 | Patrick Schmalstig | Note Edited: 0009373 | View Revisions |
