Modify ↓
Opened 13 years ago
#10056 new defect
Removing users without group
Reported by: | czarnymb | Owned by: | Dolf Andringa |
---|---|---|---|
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)
Note: See
TracTickets for help on using
tickets.