Tech:Deleting Echo notifications

From Miraheze Meta, Miraheze's central coordination wiki

While quite a rare occurrence, it sometimes happens that a user is left with global Echo notifications from wikis that are either now private or have been deleted. There is currently no other method to get rid of them globally, so this method must be used in order to remove the notification for the user.

  1. Select the mhglobal database
  2. Run SELECT gu_id FROM globaluser WHERE gu_name = '[USERNAME]';
  3. Select the metawiki database
  4. Run DELETE FROM echo_unread_wikis WHERE euw_user = '[RESULT FROM PREVIOUS QUERY]' AND euw_wiki = '[desired wiki]';