Can't Access Gallery Category
Filter
Show Official Posts OnlyReplies
I can't seem to access one of my categories in my Gallery" Embrace the Night" called" I'll put a spell on you" and when I do try to access it. This message pops up:
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 'll Put A Spell On You' GROUP BY itemid ORDER BY itemid' at line 1 (SQL: SELECT itemid, SUM(amount) AS amount, category FROM user_shop_galleries WHERE shopid='3404' AND category='I'll Put A Spell On You' GROUP BY itemid ORDER BY itemid)
I can't even delete nor rename the category so I can retrieve my items. Can someone help me please. Thank you
It looks like it is having trouble with the apostrophe in the category name.
As a workaround for now, I can manually rename this category for you, to something without an apostrophe. What would you like it to be named to?
🐝 ☕ bug (he/him) | your friendly neighborhood code wrangler. stay in the loop! join and check out the latest admin post highlights
Witchery would be fine and thank you.
Done <3 Thank you for the report, and sorry for the inconvenience!
🐝 ☕ bug (he/him) | your friendly neighborhood code wrangler. stay in the loop! join and check out the latest admin post highlights