Bug #2636

Problem removing "default contributor" user

Added by Jesús García Crespo over 11 years ago. Updated over 7 years ago.

Status:DuplicateStart date:
Priority:LowDue date:
Assignee:David Juhasz% Done:

0%

Category:-
Target version:Release 1.3
Google Code Legacy ID:atom-686 Tested version:
Sponsored: Requires documentation:

Description

PHP 5.2.9-1-Win32
Apache 2.2.11-Win32
Qubit-Toolkit from SVN/trunk/qubit

When you try to remove "default contributor" user
(http://host/user/delete/id/251 the browser unexpectly redirects me to
http://host/sfInstallPlugin/check A message was written in my Apache vhost
log error file:

Unable to execute DELETE statement. [wrapped: SQLSTATE[HY000]: General
error: 1451 Cannot delete or update a parent row: a foreign key constraint
fails (`qubit/q_note`, CONSTRAINT `q_note_FK_3` FOREIGN KEY (`user_id`)
REFERENCES `q_user` (`id`))], referer: http://host/index.php/user/edit/id/251

The problem seems to be around the method doDelete (line 73) from
lib/model/om/BaseObject.php but not idea about why this is happening. This
could be a bug. It seems the user can't be removed since it exists many
tuples at q_note table linked to this user.

This is not happening when you remove other users.

[g] Legacy categories: User management


Related issues

Duplicates Access to Memory (AtoM) - Bug #3063: Can't delete a user if they have created a note Verified

History

#1 Updated by Evelyn McLellan over 11 years ago

  • Status changed from New to New
  • Target version set to Release 1.0.6

Added David as owner, added milestone release and component

[g] Labels added: Milestone-Release-1.0.6, Component-User-Mgmt
[g] New owner: David Juhasz

#2 Updated by David Juhasz over 11 years ago

Great bug report jgc.sevein! Thanks for filing it and for all the detail you put
into the report!

#3 Updated by Jesús García Crespo over 11 years ago

Richard Dancy also commented this bug at qubit-dev mailing list:

http://groups.google.com/group/qubit-dev/browse_thread/thread/cc9cacc2db31895b

#4 Updated by David Juhasz about 11 years ago

  • Target version set to Release 1.0.8

Move to 1.0.8

[g] Labels added: Milestone-Release-1.0.8

#5 Updated by David Juhasz almost 11 years ago

  • Target version set to Release 1.1

Bumped to Release 1.1

[g] Labels added: Milestone-Release-1.1

#6 Updated by Anonymous about 10 years ago

  • Priority set to Low

[g] Labels added: Priority-Low

#7 Updated by Evelyn McLellan almost 10 years ago

  • Target version set to Release 1.2

Moved to 1.2.

[g] Labels added: Milestone-Release-1.2

#8 Updated by Anonymous about 9 years ago

It might be nice to be able to add a "disabled and date" next to the name of a default contributor that is no-longer active with the organization.

#9 Updated by David Juhasz over 8 years ago

  • Target version set to Release 1.3

Roll over to Release 1.3

[g] Labels added: Milestone-Release-1.3

#10 Updated by Jesús García Crespo over 8 years ago

  • Status changed from New to Duplicate

#11 Updated by David Juhasz about 8 years ago

Re-assign to David's new account.

[g] New owner: David Juhasz

Also available in: Atom PDF