I tried to buy an item in an NPC shop from the in quest link. This resulted in
SpatieLaravelFlareExceptionsViewException vendor/laravel/framework/src/Illuminate/Database/Connection.php:826
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'is_quest_supply_shop' in 'where clause' (Connection: mysql, SQL: select shop_stocked_items.* from shop_stocked_items inner join shops on shop_stocked_items.shop_id = shops.shopid where item_id in (6141, 6143) and (exists (select * from item where shop_stocked_items.item_id = item.itemid and rarity <= 19) or amount > 0) and exists (select * from shops where shop_stocked_items.shop_id = shops.shopid and closed = 0 and main = 1 and is_quest_supply_shop != 1))
etc.
over and over again.
I tried more quests, same result. I also got this occasionally, when trying to get to the all shops page, so couldn't buy the items that way, either. Had to get them from Legacy, turning itms in/ending quests worked.
having the same issue!!!
[tot=ekowals]
Tried to do a quest on kumos... no dice. This is what I saw:
SpatieLaravelFlareExceptionsViewException
vendor/laravel/framework/src/Illuminate/Database/Connection.php:826
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'is_quest_supply_shop' in 'where clause' (Connection: mysql, SQL: select shop_stocked_items.* from shop_stocked_items inner join shops on shop_stocked_items.shop_id = shops.shopid where item_id in (163362, 2667) and (exists (select * from item where shop_stocked_items.item_id = item.itemid and rarity <= 19) or amount > 0) and exists (select * from shops where shop_stocked_items.shop_id = shops.shopid and closed = 0 and main = 1 and is_quest_supply_shop != 1))
LARAVEL 12.42.0 PHP 8.4.15 UNHANDLED CODE 0 500 GET https://kumos.subeta.net/quests
Exception trace 9 vendor frames
AppLivewireQuestBar->getShopStocksForItems(array) app/Livewire/QuestBar.php:277
272 })
273 ->join('shops', 'shop_stocked_items.shop_id', '=', 'shops.shopid')
274 ->with(['shop', 'item']);
275
276 $legacyStocks = $legacyQuery->select('shop_stocked_item
?/17,542 steamwork trinkets ?/2,200 lounge trinkets
I got the same thing trying to buy an item from a quest shop, so naturally I went to complain about it in the shoutbox. I am currently getting the same error in the shoutbox thread itself so I'm beginning to suspect it's a Kumos-wide issue.
[Center]
[/center]
I'm working on a fix now, thanks everyone! This is in an effort to make quests have items availabe a little more easily.
💖 ✨ 🤗
Hey everyone! I've racked down what was causing the error, your quests should load normally again.
Let me know if you're still seeing issues.
💖 ✨ 🤗
having issues doing quests on kumos!!
SQLSTATE[08004] [1040] Too many connections (Connection: mysql, SQL: select * from user where userid = 213425 limit 1)
[tot=ekowals]