Modify

Opened 12 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)

Change History (0)

Modify Ticket

Change Properties
Set your email in Preferences
Action
as new The owner will remain Dolf Andringa.

Add Comment


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

 
Note: See TracTickets for help on using tickets.