When hovering any item and clicking on account search, this error comes up on the account search page.

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

Great, thank you! I will test it when the day rolls over. :)

Trying to do battle quests on database.subeta.net. When I finish a battle I just get a black bar on the results page and the battle doesn't register as done. https://database.subeta.net/games/battle/battle.php?act=end_game&id=6930993 and https://database.subeta.net/games/battle/battle.php?act=end_game&id=6930982 I can go back to the battle and redo it but can't get it to end. If I then go back to subeta.net, I can end the battle (but it doesn't show the back to BQ button on the results page). If I redo the battle on subeta.net then it does register as a finished battle quest and the BQ counter goes up both on subeta.net and on database.subeta.net as well. Like , I am seeing battle text on database.subeta.net but not on subeta.net.

Can you take a screen shot for me? Clicking on those links won't work because I'm not on your account

omg pls ignore this post I said something dumb back to browsing!

BQs appear to be progressing normally on database server now.

Sorry, editing forum posts is being funky again. If you click wishlist search in a user shop, you get the following error

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 ')' at line 1 (SQL: SELECT itemid, CONCAT(price, '.', csc) AS newprice FROM user_shop_prices WHERE shopid='4429' AND itemid IN ())

- sorry, I should know that. Here is the screenshot. The number in the black bar changed from 0 to 1 for the second BQ, but otherwise both were the same.

And you're still getting that error now? That was from my debugging about two hours ago

- I got it right before I made the first post, so about 11:39 pm Subeta time. However, just tried it again today for today's BQs and it's now working correctly on database.server.net.

Getting application error pages trying to read profile comments.

Editing a minion's name and using an apostrophe causes a blank page and doesn't save the change. Using apostrophes in a pet description and clicking Update Description causes a blank page and doesn't save the change.

I tried the same exact thing on the main site and it always goes through just fine.

I finished all BQs on the database server and everything acted as expected. I checked Ennui’s battle stats and there were no wins or losses added to his count from BQs this time. I think battling is okay now, unless there is some other glaring error that I missed. (I’ll be honest, I go through BQs so quickly that I never look at the battle text and it took pointing it out to me yesterday before I noticed it was missing. I am obviously very observant.)

The breaks in updated ended up so that I didn't end up having to lose my streak! c:

While doing Saggi quests I get a purchase error on one of the two items, but the quest completes anyway. I have nothing else in my inventory except the locked Lizard Minion Trap and Lizard Minion Repellant so it's not that I happened to have the correct item anyhow.

Purchase error screenshot

Since it doesn't happen every time, I'm not positive this is a database.subeta.net problem, but I haven't seen this error on subeta.net

not sure if this was already reported but the CW main page is hella borked both on the current version and the new database one n_n

Tried to edit my previous post - the edit appeared to work, but doesn't show up.

Doing an account search on Mauve Trading Card, got the following error

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

URL: http://database.subeta.net/isearch.php?search=Book+in+a+Bottle

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

also - - -

http://database.subeta.net/trade/trades.php (aka 'my trades') shows the two trades i have up...

HOWEVER http://database.subeta.net/trade/search.php?keyword=impulse&type=1&action=find doesn't show anything

http://database.subeta.net/trade/search.php?keyword=Death+Shard&type=2&action=find DOES however show the two trades of mine containing death shards