Back

Bug Report Forums

Report bugs and errors to the Flight Rising development team.
TOPIC | Crim's Collection Cart Problem
1 2 3 4 5
Looks like Crim just broke today.
If you post a report, please include the following information:

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

SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; 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
Looks like Crim just broke today.
If you post a report, please include the following information:

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

SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; 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
jH4jccn.png
I'm not getting an error, but I'm unable to trade with her or move to the next trade. It just doesn't load.
I'm not getting an error, but I'm unable to trade with her or move to the next trade. It just doesn't load.
tumblr_otxe4lVheo1wwx926o1_1280.jpg
I'm having the same probs with hanging and not being able to click, plus I got this error:

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'm having the same probs with hanging and not being able to click, plus I got this error:

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
b6f3d4ea76e68d8090de5809afe1f0105cf2c98e.pngoYfCraJ.png0HxJjfZ.gif TAzcwMk.gif
I got an error one time, but I thought I'd just re-load and try again. Silly me.

Repeatedly, nothing happens when I click "yes."
I got an error one time, but I thought I'd just re-load and try again. Silly me.

Repeatedly, nothing happens when I click "yes."
Not even getting errors with Crim. It just sits there.
Not even getting errors with Crim. It just sits there.
TOW2n3q.png
[quote name="Blanche" date=2016-09-20 17:04:38] [quote name="SilverDeath" date=2016-09-20 16:38:26] While I don't get an error code, it won't let me click 'Yes' to confirm giving an item to her. I can click 'No' and the window will close just fine though.[/quote] Same experience. Also, the new hour has passed and she hasn't reset the quest number to the full 5. [/quote] After hitting the "Yes" button, nothing seems to happen... but if I leave the tab alone (which I just tried to do), it eventually processes the transaction. So it seems to be major lag, eventually causing a crash.
Blanche wrote on 2016-09-20:
SilverDeath wrote on 2016-09-20:
While I don't get an error code, it won't let me click 'Yes' to confirm giving an item to her. I can click 'No' and the window will close just fine though.


Same experience. Also, the new hour has passed and she hasn't reset the quest number to the full 5.


After hitting the "Yes" button, nothing seems to happen... but if I leave the tab alone (which I just tried to do), it eventually processes the transaction. So it seems to be major lag, eventually causing a crash.
7irhbB2.png
I got this one:

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` = 4804, `val` = 500, `created_at` = 2016-09-20 17:32:19 where `userid` = 54953) in /Connection.php Line 539


And now it's lagging at the yes button for another one.
I got this one:

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` = 4804, `val` = 500, `created_at` = 2016-09-20 17:32:19 where `userid` = 54953) in /Connection.php Line 539


And now it's lagging at the yes button for another one.
1MeHaCI.gifyKp0KRf.pngPiDMVwk.pngDmRdZYl.png1MeHaCI.gif
My error:

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
My error:

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
I also got an error at Crim's with this -

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

- when I clicked new offer.
I also got an error at Crim's with this -

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

- when I clicked new offer.
nudX0O8.png
I don't get errors, but I also cannot hand more items to Crim. I use Google Chrome. I guess Pink either put his talon down or Crim finally has no room whatsoever for new stuff...
I don't get errors, but I also cannot hand more items to Crim. I use Google Chrome. I guess Pink either put his talon down or Crim finally has no room whatsoever for new stuff...
Pings are disabled.

If writers are supposed to "show not tell," why are we called "storytellers" and not "storyshow-ers"?
1 2 3 4 5