Replies

Mar 22, 2020 6 years ago
PiinkSparkles
User Avatar
RRaina

I was using the user shop search option and it gave me this

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, amount FROM user_shop_items WHERE itemid IN (SELECT itemid FROM item WHERE name LIKE '%humming power crystal%') AND shopid='4791' GROUP BY itemid)

Beanie Baby Pricing PM me for information and cost. https://www.facebook.com/groups/538582170337230/

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

Thank you for your report. This is a duplicate of Search within shop gives SQL error; please head over to that topic :)

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

Please log in to reply to this topic.