From nobody Sat Dec 09 06:10:01 2023 X-Original-To: ports-bugs@mlmmj.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mlmmj.nyi.freebsd.org (Postfix) with ESMTP id 4SnHfd3hgxz53QDP for ; Sat, 9 Dec 2023 06:10:01 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from mxrelay.nyi.freebsd.org (mxrelay.nyi.freebsd.org [IPv6:2610:1c1:1:606c::19:3]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256 client-signature RSA-PSS (4096 bits) client-digest SHA256) (Client CN "mxrelay.nyi.freebsd.org", Issuer "R3" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4SnHfd0m0rz4G9t for ; Sat, 9 Dec 2023 06:10:01 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) ARC-Seal: i=1; s=dkim; d=freebsd.org; t=1702102201; a=rsa-sha256; cv=none; b=usUuXjE90M3iG43zM85M+e57MDKVBA9NNTv7apYuLoPtrZQPKvxHX7M61G1jPP256e7xt3 2eXp3xB05JWXe0zoDQK9r/KesyFigUbtNhrlq5Tz49PwYEbV4kAxrJOZphMMa/P9xP4n9T MJWmWKPr0b+l51wnsswkETwXOiuOkfkI+yIEo8hI5AuLpDwNMA6+eMQilHyQXUAqKElE11 0GvRggWVzlaT0Dg9/S+/4WGwGeHgP9/bbKv4FZZuzxzIyMl0nCYUDl+OMx2c+xtaZNLEWj hqtgpc3C5pswmd+hsC4eKWTjb6QQrDSGuhB9ow0lvrREXWH/1xW2gQYvyLjX4w== ARC-Authentication-Results: i=1; mx1.freebsd.org; none ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1702102201; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding; bh=gEU6IpGATcdDQKLDZOolf+JmK6QrZOMwsBuYJCuW/jo=; b=IbliiDKS1vNzX1q/ddFDwU60wYKVwiSSfBEzdtRL5PS8W2ddGD+/5g52IHuJYgAsV1aTA9 xXWGgSaalICZVEwvVMnQNbmwztLiyY2dn/nh1zGVXlpMmL99AiSlpaJkz9+lhaSJRhEafA E8n4BiEuqG/8Di90a9gWTDixVPiPG6+xjNyaex13zGKU142MiButMc6p2bh0m0MWo/PeKW 3twnWXMbU25bc0/qWh3az79uLkzX+PLPWH/GVUfe+bu34K+0UWDHhCpXJemOobHkEGu1BV IGzqcQmr9w//geWFDEz7OY4yQqbATYx4cJHt4Qz80ynRMUB3opZiMkGk+Q68Eg== Received: from kenobi.freebsd.org (kenobi.freebsd.org [IPv6:2610:1c1:1:606c::50:1d]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256) (Client did not present a certificate) by mxrelay.nyi.freebsd.org (Postfix) with ESMTPS id 4SnHfc6rlMzsk0 for ; Sat, 9 Dec 2023 06:10:00 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from kenobi.freebsd.org ([127.0.1.5]) by kenobi.freebsd.org (8.15.2/8.15.2) with ESMTP id 3B96A08i096405 for ; Sat, 9 Dec 2023 06:10:00 GMT (envelope-from bugzilla-noreply@freebsd.org) Received: (from www@localhost) by kenobi.freebsd.org (8.15.2/8.15.2/Submit) id 3B96A05x096404 for ports-bugs@FreeBSD.org; Sat, 9 Dec 2023 06:10:00 GMT (envelope-from bugzilla-noreply@freebsd.org) X-Authentication-Warning: kenobi.freebsd.org: www set sender to bugzilla-noreply@freebsd.org using -f From: bugzilla-noreply@freebsd.org To: ports-bugs@FreeBSD.org Subject: [Bug 275649] www/nextcloud-mail-php82: Nextcloud mail retains messages deleted from IMAP server Date: Sat, 09 Dec 2023 06:10:01 +0000 X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: new X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: Ports & Packages X-Bugzilla-Component: Individual Port(s) X-Bugzilla-Version: Latest X-Bugzilla-Keywords: X-Bugzilla-Severity: Affects Only Me X-Bugzilla-Who: lloydsystems1@tpg.com.au X-Bugzilla-Status: New X-Bugzilla-Resolution: X-Bugzilla-Priority: --- X-Bugzilla-Assigned-To: ports-bugs@FreeBSD.org X-Bugzilla-Flags: X-Bugzilla-Changed-Fields: bug_id short_desc product version rep_platform op_sys bug_status bug_severity priority component assigned_to reporter Message-ID: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable X-Bugzilla-URL: https://bugs.freebsd.org/bugzilla/ Auto-Submitted: auto-generated List-Id: Ports bug reports List-Archive: https://lists.freebsd.org/archives/freebsd-ports-bugs List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-freebsd-ports-bugs@freebsd.org X-BeenThere: freebsd-ports-bugs@freebsd.org MIME-Version: 1.0 https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D275649 Bug ID: 275649 Summary: www/nextcloud-mail-php82: Nextcloud mail retains messages deleted from IMAP server Product: Ports & Packages Version: Latest Hardware: amd64 OS: Any Status: New Severity: Affects Only Me Priority: --- Component: Individual Port(s) Assignee: ports-bugs@FreeBSD.org Reporter: lloydsystems1@tpg.com.au Overview: The Nextcloud mail app keeps a cache of email data in the Nextcloud SQL database. If server-side cleanup scripts on the IMAP server are used to pur= ge old messages from user Trash or Junk folders, it is observed that Nextcloud gets out of sync with the IMAP server and these deleted messages remain in = the mail app Trash/Junk folder message list. Selecting one of these messages displays "not found" in the message detail panel. Steps to Reproduce: Purge old messages from a user's Trash folder by server-side script. For example, with Cyrus-IMAP: ipurge -d 365 -f user/jsmith/Trash to remove deleted messages older than 1 year. Login to Nextcloud, open the mail app and select the Trash folder. Actual Results: Messages older than 1 year still appear in the Trash folder message list. Selecting one shows "not found" in the message detail panel. Expected Results: Nextcloud folders should sync to the IMAP server. Messages older than 1 year should be gone from the Trash folder message lis= t. Additional Information: 1. Selecting the 3 dots next to the Trash/Junk folder shows the correct mes= sage count, even though the message list is wrong. 2. Attempting to delete these "ghost" messages in the Nextcloud mail app produces an error. 3. Attempts to correct this with occ "mail:clean-up" or "mail:account:sync" commands were unsuccessful. 4. The only methods of recovery are: a) From the Nextcloud mail app, select the 3 dots next to the folder and "c= lear mailbox" to empty all its contents. b) Write SQL queries to manually delete the ghost messages from the Nextclo= ud database mail tables. The Nextcloud mail app behaviour is fundamentally wrong. The IMAP server is= the master and one source of truth, NOT the Nextcloud database. Software Versions: FreeBSD version is 13.2-p4. The Nextcloud software installed is: nextcloud-php82 27.1.0=20 nextcloud-calendar-php82 4.5.1 nextcloud-contacts-php82 5.4.2 nextcloud-mail-php82 3.4.0 nextcloud-notes-php82 4.8.1 --=20 You are receiving this mail because: You are the assignee for the bug.=