c2c-oerpscenario team mailing list archive

["Olivier Dony \(OpenERP\)" <805375@xxxxxxxxxxxxxxxxxx>]

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 C2C
OERPScenario, which is subscribed to OpenERP Project Group.
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 | xxxxxxxx@xxxxxxxxxxxx
  (1 row)

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