Editing user's email changes all users' emails
Server v6.0.2 with web client.
If we change any users email address it changes for ALL users!
I've put in a brand-new dummy email address (fred@...) and it does replicate. Seems the DB update command is missing a WHERE clause.
Please push this to crtical as it affects data integrity for all users!!
Happy to send screenshots privately.
Checking in psql...
res_users.email is null and the res_partner_
The wrong table is being referenced in the code. There is only 1 occurence of the updated email address in the Postgres database (res_partner_
crm=# select count(*) from res_users;
count
-------
7
(1 row)
crm=# select count(*) from res_users where email is null;
count
-------
7
(1 row)
crm=# select id, email from res_partner_address where email like '%xxxxxxxx.com';
id | email
----+--
1 | <email address hidden>
(1 row)
Question information
- Language:
- English Edit question
- Status:
- Answered
- Assignee:
- No assignee Edit question
- Last query:
- Last reply:
This question was originally filed as bug #805375.
Can you help with this problem?
Provide an answer of your own, or ask John Bradshaw for more information if necessary.