Prompt lost for new characters after logout
The first time somebody logs in, they get the default prompt. The second time they log in, the prompt is cleared. After that the prompt gets preserved correctly.
Comments (7)
-
-
reporter You need to create a new character, then maybe set the prompt, log out, log in and watch it disappear.
-
I'll bet this is a side-effect of all the leftover player-specific data in the sneezy sql dump. I would guess it's what happens when a new player's player_id collides with an existing stale entry in the playerprompt table.
Hurray for a complete lack of referential integrity!
-
reporter One more pro-nosql argument. Player save should have been just a giant JSON dump of whatever the player happens to be and hold.
-
Well, really, this is more a pro-relational-integrity argument. Foreign keys and on cascade delete are very useful and powerful, but sql newcomers rarely use them at the beginning and pretty soon the data is too messed up to add them later. I plan to explore adding some foreign key constraints to sneezy.
In your example, nosql doesn't help you if you want to be able to make changes to an in-game object and have them easily apply to rented items, because they've all been denormalized. Plus, since most nosql systems lack transactions, an interrupted global edit would leave the items half-upgraded.
-
Oh, also, I don't know for sure that pull request #11 fixes this, but it probably does (and a host of other latent issues).
-
can you still repro this?
- Log in to comment
This seems to be working for me, can you be more specific about the steps to reproduce?