nextcloud / nextcloud/mail

Add a cron job that removes duplicate entries from the mail_message_tags table

Open
#4,773 1 comment 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

1. to develop enhancement
Dominant language
JavaScript
Stars
1k
Forks
348
Avg merge
12h 28m
Merged PRs (30d)
91

Description

Feature Request

Since we don't remove any data on account deletion from the mail_message_tags table, duplicate entries are more than likely.

Summary

Write a cron job that once a day cleans up all duplicate entries for mail_message_tags

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start by locating the existing cron-job entry points and the schema or model for the mail_message_tags table. Determine how duplicate rows are identified and how scheduled cleanup is registered, then verify that a daily run removes duplicates without deleting distinct tag relationships.

Written by the indexing model from the issue text.

Assessment

Tech stack
php
Domain
backend, databases
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.