Apologies if I'm posting this in the wrong forum! Whenever I attempt to view the category "Melody's Cottage" in my gallery "13th Avenue" the following error shows up on the screen:

Database error - send this to Keith: SQLSTATE[42000]: Syntax error or access violation: 1064 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 's Cottage'' at line 1 (SQL: SELECT COUNT(item.itemid) as count FROM user_shop_galleries LEFT JOIN item ON item.itemid=user_shop_galleries.itemid WHERE user_shop_galleries.shopid=20249 AND category='Melody's Cottage' )

This happens both when I try to view the gallery and when I try to search for items in the category via the edit items page. I've even tried deleting the category as a last attempt, but it will not go away. Whenever I tried to delete, it just loaded a blank page that only showed my Subeta theme along with the shop title.

I am using Safari on a MacBook that's running MacOS Catalina version 10.15.3.

Hopefully there hasn't been a solution posted for this bug prior. I've been gone for a while and only recently returned. Any help would be much appreciated. Thanks!

Edit: Posted this in the error codes thread instead! Sorry!

I would prefer that you rename it to "Melodys Cottage" without the apostrophe. Thanks so much for the update!