#4859 - SQL error
-
By Adam Edington
- Added
- 6 views
| Identifier | #4859 |
|---|---|
| Issue type | Major issue (breaks an entire feature) |
| Title | SQL error |
| Status | Completed |
| Handling member | Chris Graham |
| Version | 10.0.42 |
| Addon | galleries |
| 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 |
| Funded? | No |
| Commits |
The system will post a comment when this issue is modified (e.g., status changes). To be notified of this, click "Enable comment notifications".
Comments
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.