One question, Is it safe to remove users directly from the “users” table in the database? I remove users from the configuration interface and yet they still remain in the database, only to get email notifications at a later date and I can’t do anything to act on them. I would like to just remove them completely from the system.
If there is another path to control users that are missing from the interface yet still get email messages from the system, please let me know. In the past this has caused issues and having some way to control information IN sents out automatically is very important.
As a general rule never manually delete anything in the database.
There are two tables of interest here.
users table
company_users table
The users table is the table which contains the user and their personal information.
The company_users table is the linking table which associates a user with a company. It would be the company_users table that we need to look at here.
This is the first time we’ve had a report that deleted users are receiving system notifications, so I’ll look into this and see whether i can reproduce this.
As a general rule, I always follow the general rule (hence my asking here because, as the general rule goes, deleting stuff from any underlying database could be very dangerous).
With more information you’ve provided about the database, I can show more of what’s going on in my database… hopefully it helps.
User ids 2, 4, and 6 have been “deleted” and have no representation in the interface to control notification settings yet they have begun getting email notifications (when is hard to say, but perhaps some logic in the application eventually allowed for this condition):