Replies

Mar 8, 2020 6 years ago
Mirabel
is a skilled hooker
User Avatar

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)

Mar 8, 2020 6 years ago Official
Bug
User Avatar
Segfault

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

Mar 8, 2020 6 years ago
Mirabel
is a skilled hooker
User Avatar

Yes, please. I'm pretty sure I got everything out of the one with the apostrophe.

Mar 8, 2020 6 years ago Official
Bug
User Avatar
Segfault

All right, done :)

🐝 ☕ bug (he/him) | your friendly neighborhood code wrangler. stay in the loop! join and check out the latest admin post highlights

Mar 9, 2020 6 years ago
Mirabel
is a skilled hooker
User Avatar

Looks like everything is okay now. Thanks!

Mar 9, 2020 6 years ago Official
Spotlight Champion
Destiny
User Avatar
Dexter

locking up as resolved!

Dexter by

Please log in to reply to this topic.