5 ms·
My password update script for one site used this SQL: UPDATE Users SET Password=? We had backups. Selective restore. 7 accounts that were new, not in the back
by rhacker 7y ago
My password update script for one site used this SQL:
UPDATE Users SET Password=?
We had backups. Selective restore. 7 accounts that were new, not in the backup, got a special flag that required a reset.
- Nextgrid 7y agoVery similar situation here although the query had a syntax error which meant it didn’t go through, but initially I didn’t realise that and had to post the dreadful question on Slack “do we have backups of the production DB?”. Years later I still consider it my biggest screw up. Everything else can be explained by bad processes, documentation, etc but this one is just me being stupid.