Delete user

[marty-macfly]

Hello,

When I try to delete a user (which is using the openid plugin to authentificate) from the users administration page I've got the following error:

ActiveRecord::StatementInvalid (Mysql2::Error: Cannot delete or update a parent row: a foreign key constraint fails (`redmine`.`oic_sessions`, CONSTRAINT `fk_rails_fb3c08edd2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)): DELETE FROM `users` WHERE `users`.`type` IN ('User', 'AnonymousUser') AND `users`.`id` = 5):

I think cascade is missing so user entry for user in oic_sessions are removed when user is delete.

Regards,

[dcr31000]

Hello,
Did you find a solution ? I also have this problem... thanks !

[marty-macfly]

Done cleanup manually in database for the session table and delete user through web interface, it's a work around.

[maximumG]

The issue when deleting a user using the webUI is caused by a foreign key in the oic_sessions table which references the users table.

redmine_openid_connect/db/migrate/001_create_oic_sessions.rb

Line 4 in 9045f0b

t.references :user, foreign_key: true

I deleted this foreign key constraint in database and the user deletion is working as expected. I guess it should be a foreign key with on delete cascade statement ?

The issue when deleting a user using the webUI is caused by a foreign key in the oic_sessions table which references the users table.

redmine_openid_connect/db/migrate/001_create_oic_sessions.rb

Line 4 in 9045f0b

t.references :user, foreign_key: true

I deleted this foreign key constraint in database and the user deletion is working as expected. I guess it should be a foreign key with on delete cascade statement ?

Could you guys please share sql query for that.

[marty-macfly]

May be something like that:

foreign_key: { on_delete: :cascade }

[galupa]

Hi, we created this #57 to fix this problem in our place