I'm working on my shop to get ready for the legacy move and I ran into a problem with the category "We're coming to get you Barbara" in my new active shop "With a little help". I made the category years ago before recent php updates and i think that's the problem. I removed everything out of it and tried to delete that category but it wont let me. (I made a new category called "We are coming to get you Barbara" to replace it. just fyi)
error message i got:
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 're coming to get you barbara' GROUP BY itemid ORDER BY itemid' at line 1 (SQL: SELECT itemid, SUM(amount) AS amount, category FROM user_shop_galleries WHERE shopid='32018' AND category='we're coming to get you barbara' GROUP BY itemid ORDER BY itemid)
Ah yeah, there is an apostrophe in it and that is breaking things. Would you like me to delete it for you?
🐝 ☕ bug (he/him) | your friendly neighborhood code wrangler. stay in the loop! join and check out the latest admin post highlights
All right, done :)
🐝 ☕ bug (he/him) | your friendly neighborhood code wrangler. stay in the loop! join and check out the latest admin post highlights