c2c-oerpscenario team mailing list archive

[John Bradshaw <805375@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

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 | xxxxxxxx@xxxxxxxxxxxx
(1 row)

** Affects: openobject-client-web
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.
https://bugs.launchpad.net/bugs/805375

Title:
  Editing user's email changes all users' emails

Status in OpenERP Web Client:
  New

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 | xxxxxxxx@xxxxxxxxxxxx
  (1 row)

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-client-web/+bug/805375/+subscriptions