search

AlbianWarp / AlbianWarpServer

Albian Warp Server component!
https://blog.albianwarp.com
GNU General Public License v3.0
11 stars 1 forks source link

A User cannot be deleted if there are still Creatures, and probably other Resources, present, that link to said user. #33

Closed KeyboardInterrupt closed 4 years ago

KeyboardInterrupt commented 5 years ago

This is because of a missing strategy for deletion of dependent resources.

sqlalchemy.exc.IntegrityError: (_mysql_exceptions.IntegrityError) (1451, 'Cannot delete or update a parent row: a foreign key constraint fails (`db_albianwarp`.`creatures`, CONSTRAINT `creatures_ibfk_2` FOREIGN KEY (`recipient_user_id`) REFERENCES `users` (`id`))') [SQL: 'DELETE FROM users WHERE users.id = %s'] [parameters: (46,)] (Background on this error at: http://sqlalche.me/e/gkpj)
KeyboardInterrupt commented 4 years ago

This is made obsolete by the Switch to ReBabel