#5230 - SQL error accessing a gallery

  • By
  • Added
  • 25 views
Identifier #5230
Issue type Minor issue (breaks specific functionality)
Title SQL error accessing a gallery
Status Closed (cannot reproduce)
Handling member Deleted
Addon General / Uncategorised
Description http://localhost/composr/index.php?page=galleries&type=browse&id=lorem-2&keep_devtest=1

A query has failed [SELECT COUNT(DISTINCT r.id) FROM cns11_images r LEFT JOIN cns11_galleries parent ON parent.name=r.id WHERE 1=1(cat='lorem_2') 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='lorem_2') AND cat NOT LIKE 'download\_%' AND (1=1) LIMIT 1' at line 1] (version: 11 alpha1, PHP version: 7.3.8-dev, URL: http://localhost/composr/index.php?page=galleries&type=browse&id=lorem-2&keep_devtest=1)

sources/content.php line 732
Steps to reproduce

Funded? No
The system will post a comment when this issue is modified (e.g., status changes). To be notified of this, click "Enable comment notifications".

Rating

Unrated