[Bug 267394] www/nextcloud: Insufficient privilege: 7 ERROR: must be owner of table oc_comments

From: <bugzilla-noreply_at_freebsd.org>
Date: Thu, 27 Oct 2022 16:40:47 UTC
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=267394

            Bug ID: 267394
           Summary: www/nextcloud: Insufficient privilege: 7 ERROR: must
                    be owner of table oc_comments
           Product: Ports & Packages
           Version: Latest
          Hardware: Any
                OS: Any
            Status: New
          Severity: Affects Only Me
          Priority: ---
         Component: Individual Port(s)
          Assignee: brnrd@freebsd.org
          Reporter: dougs@dawnsign.com
          Assignee: brnrd@freebsd.org
             Flags: maintainer-feedback?(brnrd@freebsd.org)

The 25.0 version of nextcloud came down the pipeline. However, when attempting
to log into nextcloud after the update, it fails to update as follows:

Preparing update

Set log level to debug

Turned on maintenance mode

Repair step: Repair MySQL collation

Repair info: Not a mysql database -> nothing to do

Repair step: Repair SQLite autoincrement

Repair step: Copy data from accounts table when migrating from ownCloud

Repair step: Drop account terms table when migrating from ownCloud

Updating database schema

Exception: Database error when running migration 25000Date20220602190540 for
app core An exception occurred while executing a query: SQLSTATE[42501]:
Insufficient privilege: 7 ERROR: must be owner of table oc_comments


Seems the update code failed to account for ownership of that table as part of
the upgrade? Running 13.1-RELEASE-p2 on amd64

-- 
You are receiving this mail because:
You are the assignee for the bug.