When disconnecting your twitter account from the profile settings page, the record in the "user_socials" table is removed but the "social_twitter" column in the "users" table is not cleared out. This can cause confusion on the part of the users where they think the system still remembers their disconnected account name and there is no current way on the UI to clear that out. This fix clears out the "social_twitter" column when the user clicks the disconnect twitter account button.
As reported on discord:
I've also included a migration script that will null out any "social_twitter" columns where there is not a corresponding record in the "user_socials" table for the user.
Fixes #359
When disconnecting your twitter account from the profile settings page, the record in the "user_socials" table is removed but the "social_twitter" column in the "users" table is not cleared out. This can cause confusion on the part of the users where they think the system still remembers their disconnected account name and there is no current way on the UI to clear that out. This fix clears out the "social_twitter" column when the user clicks the disconnect twitter account button.
As reported on discord:![image](https://user-images.githubusercontent.com/5142625/204947143-ec08e7d4-6636-42bb-b0f6-145a9cad2d65.png)
I've also included a migration script that will null out any "social_twitter" columns where there is not a corresponding record in the "user_socials" table for the user.