Search within shop gives SQL error
Filter
Show Official Posts OnlyReplies
Database error - send this to Keith: SQLSTATE[42000]: Syntax error or access violation: 1064 ... https://subeta.net/user_shops.php/shop/7867/find/Plushie
shop:
sP-end Two Owned by Georgie Database error - send this to Keith: SQLSTATE[42000]: Syntax error or access violation: 1064...
Thank you for the report! I am looking into this.
🐝 ☕ bug (he/him) | your friendly neighborhood code wrangler. stay in the loop! join and check out the latest admin post highlights
As per your request, Bug. Hope it's fixed soon. Good luck.
<p>
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 &;user_shop_itemsWHEREitemidIN (SELECTitemidFROMitemWHEREnameLIK' at line 1 (SQL: SELECTitemid, amountFROMuser_shop_itemsWHEREitemidIN (SELECTitemidFROMitemWHEREnameLIKE &;%charity%&;) ANDshopid=&;2592&; GROUP BYitemid)
Why does the title of this say to lock it? Is the issue resolved for you?
[edit] Seems like this is still a problem, so we're going to leave this report open. I've edited the topic title for clarity.
🐝 ☕ bug (he/him) | your friendly neighborhood code wrangler. stay in the loop! join and check out the latest admin post highlights
All right, this should now be fixed! Sorry for the wait on this one!
🐝 ☕ bug (he/him) | your friendly neighborhood code wrangler. stay in the loop! join and check out the latest admin post highlights
i don't remember closing it, i only do that for problems that only concern me, i normally leave those things open, i'm a bit surprised that it was a separate entry, because doesn't it belong in a bug tread? no matter, the main thing is that it was fixed and thanks for the help Bug