c2c-oerpscenario team mailing list archive

["Amit Parik \(OpenERP\)" <amp@xxxxxxxxxxx>]

*** This bug is a duplicate of bug 720935 ***
    https://bugs.launchpad.net/bugs/720935

** This bug has been marked a duplicate of bug 720935
   [6.0] base_contact install breaks function field res_user.user_email

-- 
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