fixes in add user of Setup Control
diff --git a/setup/doctype/setup_control/setup_control.py b/setup/doctype/setup_control/setup_control.py
index 2feb7a2..33e2e83 100644
--- a/setup/doctype/setup_control/setup_control.py
+++ b/setup/doctype/setup_control/setup_control.py
@@ -232,7 +232,11 @@
pr.enabled = 1
pr.save(1)
if pwd:
- webnotes.conn.sql("UPDATE `__Auth` SET password=PASSWORD(%s) WHERE user=%s", (pwd, user_email))
+ webnotes.conn.sql("""insert into __Auth (user, `password`)
+ values (%s, password(%s))
+ on duplicate key update `password`=password(%s)""",
+ (user_email, pwd, pwd))
+
self.add_roles(pr)
def add_roles(self, pr):