Accepted, pushing out a fix now, should take ~5 minutes to hit database

Huh, editing my post hasn't worked ... trying again with a new one.

Buying items from NPC shops via the Shop Search screen gives 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 ' medalid='23'' at line 1 (SQL: SELECT * FROM user_medals WHERE userid='670601', medalid='23')

But if I go into an NPC shop, then I can buy items.

Using /remove one/ from Vault via Account Search does result in an item being removed, but no /1 moved from Inventory/ message. Works fine from a user shop.

This error doesn't occur on regular subeta.net, although there is a delay in the message when doing it from the Vault.

Thank you! I'll continue browsing the site and seeing if anything is amiss.

Shop Search 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 ') AND itemid='129866' GROUP BY shopid' at line 1 (SQL: SELECT shopid, SUM(amount) AS total FROM ushop_stock WHERE shopid IN () AND itemid='129866' GROUP BY shopid)

https://database.subeta.net/isearch.php?search=500+Credit+Gift+Card when I try to do an account search

Also, I can neither make a turn in battling nor can I vend anything (related problems maybe?)

Chrome OS and Browser

Blank page when attempting to Bake with Fantine, a Lemon Rosemary Cake. No items were taken, even though there was the correct amount of ingredients with green checks.

https://database.subeta.net/explore/cooking.php?act=view&itemid=189157

works in regular site

Moving a number of items from Vault to Inventory Page is blank below the "Your Vaults" header Items were moved correctly. https://database.subeta.net/explore/vaults.php?vault=item&act=search&name=Naga+Fang&rarity=&sort=name&order=asc&category=-1

[edit] Also applies when moving just one of them, by clicking on the x below the item name. https://database.subeta.net/explore/vaults.php?act=item&itemid=6335

Also, thanks for the info! I always appreciate when a site trusts its users enough to be transparent about the technical stuff.

Not gonna be able to help with the database testing, though, alas; my subeta time is pretty limited :(

Shop Search 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 ') AND itemid='200370' GROUP BY shopid' at line 1 (SQL: SELECT shopid, SUM(amount) AS total FROM ushop_stock WHERE shopid IN () AND itemid='200370' GROUP BY shopid)

Account search; DATABASE site; Searching For: First Fallen Leaf First Fallen Leaf Item ID: 217702 Shop Search 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 ') AND itemid='217702' GROUP BY shopid' at line 1 (SQL: SELECT shopid, SUM(amount) AS total FROM ushop_stock WHERE shopid IN () AND itemid='217702' GROUP BY shopid)

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 ') AND itemid='218450' GROUP BY shopid' at line 1 (SQL: SELECT shopid, SUM(amount) AS total FROM ushop_stock WHERE shopid IN () AND itemid='218450' GROUP BY shopid)

Checked out a few items while achievement searching and they had similar errors Works fine on regular site

the pet zapper result page is blank for me on the database version. it doesn't seem to actually zap my pet. worked fine on the regular site.

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 ') AND itemid='193422' GROUP BY shopid' at line 1 (SQL: SELECT shopid, SUM(amount) AS total FROM ushop_stock WHERE shopid IN () AND itemid='193422' GROUP BY shopid)

Similar to what was said about the pet zapper, the fragmentizer is not working for me in the same way.

https://database.subeta.net/explore/fragmentizer.php?act=#

I can select items to fragmentize but they don't get fragged and I don't get any crystals. I still have the items in your inventory.

Don't mean to double post but it doesn't seem to be saving my post edits on my previous post, so: when I tried to have a pet apply for a job at the employment agency (that they were qualified for) it just showed a long black bar across the page that said "false" in orange text.

Yus, I found one! I did an account search on a book to see if my pets had read it and got 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 ') AND itemid='174570' GROUP BY shopid' at line 1 (SQL: SELECT shopid, SUM(amount) AS total FROM ushop_stock WHERE shopid IN () AND itemid='174570' GROUP BY shopid)

https://database.subeta.net/explore/recycle_beast.php?act=give_process&itemid=135606

Blank page after I turned in one item to recycle beast.

Great, thanks for fixing battling! Looks like battle quests arent correctly recognizing a win though! :(

You Won! You have defeated The Wolf in Granny's Clothing 0 time!

You earned 9000 sP for beating The Wolf in Granny's Clothing!

Aegislash earned 784 EXP Points!

I just get this odd message when I win, and it wants me to fight the Wolf again.

Fragging works now :)