#5245 - MySQL error after deleting image from gallery

Identifier #5245
Issue type Trivial issue (does not break functionality)
Title MySQL error after deleting image from gallery
Status Completed
Handling member PDStig
Addon General / Uncategorised
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.
Steps to reproduce

Additional information Pretty much the same error when enabling Carousel mode on a gallery
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