Bug Report Forums

I was trading with Crim, too.... and got this info:

http://www1.flightrising.com/trading/crim/next

SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction (SQL: SELECT * FROM cms_trinket WHERE rarity <= '5' AND store = '0' AND gem_val = '0' AND subcat != 'holiday items' AND subcat != 'chests' AND subcat != 'dragon eggs' AND subcat != 'specialty items' AND subcat != 'blueprint' AND subcat != 'transmutation' AND subcat != 'vista' order by rand() limit 1) in /Connection.php Line 539

I also just ran into this problem. Here is my information D: if it helps

--

http://www1.flightrising.com/trading/crim/next

SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction (SQL: update `crimcart` set `turns` = 3, `item` = 684, `val` = 500, `type` = trinket, `created_at` = 2016-10-06 14:27:02 where `userid` = 126719) in /Connection.php Line 539

I was trading with Crim, and it would not load the next item up for trade. It was stuck the Fungal Colony apparel item. I left the tab for about 5 minutes and came back to find the error screen. Below is the link it asked me to include:

http://www1.flightrising.com/trading/crim/next

SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction (SQL: SELECT * FROM cms_equipment WHERE rarity <= '5' AND gem_value = '0' order by rand() limit 1) in /Connection.php Line 539

UPDATE: I checked back after about an hour and Crim was still stuck on Fungal Colony with two more offers. Nothing reset.

Crim glitches again. I feel she needs some rest :)

http://www1.flightrising.com/trading/crim/next

SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction (SQL: update `crimcart` set `turns` = 1, `item` = 10887, `val` = 1500, `type` = familiar, `created_at` = 2016-10-06 14:35:28 where `userid` = 236887) in /Connection.php Line 539

I got a bug too, but didn't copy the code since it only happened once. The next few trades didn't result in error pages, but they went super slowly and the page wouldn't reload on its own. The little popup just turned up blank instead of having the confirmation message saying you traded it. Hence no button to reload the page, hence I had to refresh. The trades did go through, though.

I'd test more to see if I can replicate the bug, but I already ran out of trades for this hour :p And it seems like other people got it covered

The next one:

http://www1.flightrising.com/trading/crim/next

SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction (SQL: SELECT * FROM cms_food WHERE rarity <= '5' order by rand() limit 1) in /Connection.php Line 539

Same issue.

http://www1.flightrising.com/trading/crim/next

SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction (SQL: update `crimcart` set `turns` = 4, `item` = 2257, `val` = 500, `type` = trinket, `created_at` = 2016-10-06 14:39:43 where `userid` = 97136) in /Connection.php Line 539

EDIT: And now I can't even trade: the button for yes won't work