getting an error whenever i try using the account search feature

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

blank page upon finishing a cinthia quest. https://database.subeta.net/quests.php/cinthia/finish

was finishing her quests fine before with no problem. after i refreshed i did noticed that the bonus CSC from the morty card had run out, so maybe it has to do with that?

got this error while doing an account 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='12039' GROUP BY shopid' at line 1 (SQL: SELECT shopid, SUM(amount) AS total FROM ushop_stock WHERE shopid IN () AND itemid='12039' GROUP BY shopid)

I am currently seeing my Battle Quest wins showing up as losses on database.subeta.net. This is not happening on subeta.net. (I tried using each site for alternating quests.) My BQ opponents are showing up in the statistics list on both sites - even on subeta.net where checking that challenger correctly indicates no battles fought.

Screen Images

Before BQ vs Maybel

After BQ vs Maybel

got this when using the shop search

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

After completing Level 21 of Battle Quests against Surge I clicked the link back to BQs to begn level 22 but then realized I needed to heal, so I challenged Buttwing Bomber in a regular challenge and got this screen when I finished the battle.

image of after battle screen

When I clicked the link to return to Battle Quests it now say start level 23 the previous level. Trying the same sequence on subeta.net works correctly with the battle against Buttwing Bomber treated as a regular battle and not affecting BQs or BQ level.

it won't let me edit my post but it was supposed to be account search not shop search

another account search error here ;;

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

I started BQ on level 1. I had a battle I needed to finish against Euclid (Impossible difficulty) before fighting Willowisp (Easy difficulty). I won the Euclid battle and got this: You Won! You have defeated Euclid Uf earned 250 EXP Points! Head back to the Battle Quest headquarters to finish up this quest! Because this was level 1 you earned 250 experience!

So instead of getting the correct win info and prize/exp/sp it acted like I had fought the level 1 BQ opponent and gave me BQ exp and no prize drop or sp.

https://subeta.net/games/battle/battle.php?act=end_game&id=6928757 - link for win page. No code or error to copy for you.

I am wondering about this: every time I go to the Restocking Shops page, my sidebar remains frozen with friend feed info, etc. and everything else from over a year ago.

During BQs, if I click challenge opponent again after completing the BQ, instead of bringing me back to a "normal battle" it lets me do the "BQ battle" again and rewards the BQ exp rather than the "normal" battle loot.

I am unable to comment on a user's profile using the database server.

When I commented, it took me to a white page, but no comment was made (there were no apostrophes in my comment)

Doing wishlist search in user shop:

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='40599' AND itemid IN ())

I don't think the 'You have Purchases!" notification is working. I wondered if no one bought from my shop and I had almost 2m after APing yesterdady.

White page errors

-When sending a gift via the Gift Center (gift was still sent) - final page when you click the send button.

-When viewing a collection by clicking the link via my profile AND activating an achievement. When NOT activating an achievement, it works fine. Technically, it's not completely white, as I still get a notice of the achievement: (I was able to also check this on the normal version of the site.)

Vending Machines

Today, I can only get Ocean Depths to work. I found out that if I went to the non-database site and vended at least once at the machine, then went back to the database site, I could then vend at that particular machine on the database site. Yesterday I could vend at all the machines, without having to vend at them on the non-database site first.

when in shop search and purchasing from user shops, I get the unknown error where it doesn't let me buy on the first shop FAR more often than I've ever had before. Is it possible the page isn't updating to remove user shops where something has sold out already?

Also, I just activated a morty card and did not get the "return to inventory" link or anything else on the activation page.

Shinwas quest has somehow not reset for me today. Also am I not getting any pings from the crypts. Not sure if others got the same issues, but just felt like mentioning them here.

Welp It seems that my post did post earlier, but it wasnt letting me see that it had happened. I just kept getting the cant post twice in a row message