No Priority: Search Subeta can't apostrophes
Filter
Show Official Posts OnlyReplies
Feb 19, 2020
6 years ago
krae
is a biter
Look For The Helpers
Searching for BROK in Search Subeta (/search.php) works fine, Searching for BROK' (with the apostrophe) results in:
Quote
Exact Results
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 &;&;brok&;&; AND frozen=0 ORDER BY username LIMIT 1&; at line 1 (SQL: SELECT * FROM user WHERE username=&;brok&;&; AND frozen=0 ORDER BY username LIMIT 1)
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 &;&;brok&;&; AND frozen=0 ORDER BY username LIMIT 1&; at line 1 (SQL: SELECT * FROM user WHERE username=&;brok&;&; AND frozen=0 ORDER BY username LIMIT 1)
Veteran Infection Specialist: service resumes next "mid-February"
I can lose anything - I love reminder pings!
🌼Give krae a Flower 🎃
Mar 18, 2020
6 years ago
Official
✨
Bug
Segfault
This page is old, and some of the functionality is no longer necessary (searching items, since we have the Item Directory Building for that)
I'm working on doing a minor revamp of this that will fix this issue and make it a little nicer :) Thanks for bringing this up.
🐝 ☕ 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.