Make WordPress Core

Opened 16 years ago

Closed 15 years ago

#7774 closed defect (bug) (fixed)

Deleting a user does not update link category count

Reported by: timbutterfield's profile TimButterfield Owned by: timbutterfield's profile TimButterfield
Milestone: 2.8 Priority: normal
Severity: normal Version: 2.6.1
Component: Administration Keywords: has-patch
Focuses: Cc:


I created an administrator user, logged in as that user, created a link category, and then created four pages assigned to that category. Later, when I deleted the user (not reassigning to admin), the links were deleted, but the link category still showed the count of four. The link category should have been decremented by the count of deleted links.

FYI: This was with version 2.6.2, though that was not available in the version drop-down for creating the ticket.

Attachments (1)

7774.diff (785 bytes) - added by scohoust 15 years ago.

Download all attachments as: .zip

Change History (5)

#1 @TimButterfield
16 years ago

The fix for this is to modify wp-admin\includes\user.php. In the wp_delete_user function, replace this code:

		// Clean links
		$wpdb->query( $wpdb->prepare("DELETE FROM $wpdb->links WHERE link_owner = %d", $id) );

with this code:

		// Clean links
		$link_ids = $wpdb->get_col( $wpdb->prepare("SELECT LINK_ID FROM $wpdb->links WHERE link_owner = %d", $id) );

		if ($link_ids) {
			foreach ($link_ids as $link_id)

#2 @TimButterfield
16 years ago

  • Cc TimButterfield added
  • Component changed from General to Administration
  • Owner changed from anonymous to TimButterfield

#3 @scohoust
15 years ago

  • Cc wp@… added
  • Keywords has-patch added

Still present in r10963 but the above patch sorts it. I've added it as a diff.

15 years ago

#4 @ryan
15 years ago

  • Resolution set to fixed
  • Status changed from new to closed

(In [10975]) Use API to delete links when deleting a user. Props TimButterfield, scohoust. fixes #7774

Note: See TracTickets for help on using tickets.