Let me convert this bug to a question and answer it there, as I think it
is starting to become a Frequently Asked Question.
PS: I also corrected the project to 'OpenERP Server', as the definition
of Users is part of the core server, and not specific to the web client
** Project changed: openobject-client-web => openobject-server
** Changed in: openobject-server
Status: New => Invalid
** Converted to question:
https://answers.launchpad.net/openobject-server/+question/170876
--
You received this bug notification because you are a member of OpenERP
CTP, which is subscribed to OpenERP Server.
https://bugs.launchpad.net/bugs/805375
Title:
Editing user's email changes all users' emails
Status in OpenERP Server:
Invalid
Bug description:
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_address.email is being
shown/updated.
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_address.email)
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 protected]
(1 row)
To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-server/+bug/805375/+subscriptions
_______________________________________________
Mailing list: https://launchpad.net/~openerp-dev-gtk
Post to : [email protected]
Unsubscribe : https://launchpad.net/~openerp-dev-gtk
More help : https://help.launchpad.net/ListHelp
