Modify

Opened 3 years ago

#10056 new defect

Removing users without group

Reported by: czarnymb Owned by: dolfandringa
Priority: normal Component: SqlFlexibleAuthStorePlugin
Severity: normal Keywords:
Cc: Trac Release: 0.12

Description

Removing users without group removes additional info like name or email, but not the users.

When I've changed the sql_delete_user_query (52 line in sqlflexibleauthstore.py) from

sql_delete_user_query = Option('account-manager','sql_delete_user_query',"DELETE users.*,membership.* FROM users,membership WHERE membership.userid=users.userid AND users.$username_field$='$username$'",

to

sql_delete_user_query = Option('account-manager','sql_delete_user_query',"DELETE u,m FROM users AS u LEFT JOIN membership AS m ON m.userid=u.userid WHERE u.$username_field$='$username$'",

it worked

Attachments (0)

Change History (0)

Add Comment

Modify Ticket

Action
as new The owner will remain dolfandringa.
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.