search

geerlingguy / beast-challenge

A control system for MrBeast's 1-100 challenge
GNU General Public License v3.0
26 stars 1 forks source link

Database gets corrupted in some situations #66

Closed geerlingguy closed 1 year ago

geerlingguy commented 1 year ago

I think I finally figured out why the system can get a bit out of whack.

Tonight to prepare for a new game, two different people were submitting data on the Overview page. One had left it open from earlier, the other had just added a new round.

The first person then made his own changes to an existing round, and saved them.

This then caused the database to go into some wacky state, causing all subsequent page loads to be 'Internal Server Error' or something like that. I think this could be tested by just doing the same thing locally in two different browsers.

I could just add some validation that sees if there are the same number of rounds being saved as exist in the database (exclusive of any new round data). If there aren't, then don't allow the save. Something like that. It's late, will look into it tomorrow maybe.

geerlingguy commented 1 year ago

Changing the title because John Z has a different idea—it's possible that after creating 10 rounds, there is a bug that crashes the database. It seems like that's about how many rounds there are every time this problem crops up.

I wouldn't put it past me to create such a dumb bug, lol.