View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 4859 | Composr | galleries | public | 2022-06-27 12:24 | 2022-06-27 19:51 |
| Reporter | Adam Edington | Assigned To | Chris Graham | ||
| Priority | normal | Severity | major | ||
| Status | resolved | Resolution | fixed | ||
| Product Version | 10.0.42 | ||||
| Fixed in Version | 10.0.43 | ||||
| Summary | 4859: SQL error | ||||
| Description | Unfortunately a query has failed [SELECT COUNT(*) FROM cms_images r WHERE (cat='mainstream' OR cat='ms_rock' OR cat='ms_metal') AND r.validated=1AND (EXISTS (SELECT * FROM cms_group_category_access a WHERE a.module_the_name='galleries' AND r.cat=a.category_name AND (a.group_id=0)) OR EXISTS (SELECT * FROM cms_member_category_access ma WHERE ma.module_the_name='galleries' AND r.cat=ma.category_name AND ((ma.active_until IS NULL OR ma.active_until>1656332371) AND ma.member_id=0))) LIMIT 1] [SQLSTATE[42000]: Syntax error or access violation: 1305 FUNCTION mf_dev_a1.1AND does not exist] (version: 10.0.42, PHP version: 8.0.20, URL: /composr/mediafeeder/dev_a1/index.php?page=galleries&type=browse&id=video_vault%2Fmainstream) | ||||
| Steps To Reproduce | Not sure, was working fine before I went to bed. Not using any gallery images, just videos. | ||||
| Additional Information | I am using the PDO driver | ||||
| Tags | No tags attached. | ||||
| Attach Tags | |||||
| Attached Files | |||||
| Time estimation (hours) | |||||
| Sponsorship open | |||||
|
|
Automated response: Galleries error if privacy addon not installed and narrow-in browsing used If the privacy addon is not installed (and possibly in other subtle situations), an SQL error will be returned when "narrow in" mode is enabled for browsing galleries. |
|
|
Fixed in git commit 8807d4a30a (https://gitlab.com/composr-foundation/composr/commit/8807d4a30a - link will become active once code pushed to GitLab) A hotfix (a TAR of files to upload) has been uploaded to this issue. These files are made to the latest intra-version state (i.e. may roll in earlier fixes too if made to the same files) - so only upload files newer than what you have already. If there are files in a hot-fix that you don't have then they probably relate to addons that you don't have installed and should be skipped. Always take backups of files you are replacing or keep a copy of the manual installer for your version, and only apply fixes you need. These hotfixes are not necessarily reliable or well supported. Not sure how to extract TAR files to your Windows computer? Try 7-zip (http://www.7-zip.org/). |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2022-06-27 12:24 | Adam Edington | New Issue |
