[MacPorts] #52855: sqlite error: table registry.files has no column named mtime (1) while executing query: INSERT INTO registry.files (id, path, mtime, active) VALUES (?, ?, 0, 0)

[MacPorts]

#52855: sqlite error: table registry.files has no column named mtime (1) while
executing query: INSERT INTO registry.files (id, path, mtime, active)
VALUES (?, ?, 0, 0)
---------------------+--------------------------------
  Reporter:  MG62    |      Owner:  macports-tickets@…
      Type:  defect  |     Status:  new
  Priority:  Normal  |  Milestone:
 Component:  ports   |    Version:  2.3.4
Resolution:          |   Keywords:
      Port:          |
---------------------+--------------------------------

Comment (by raimue):

 Replying to [comment:3 neverpanic]:
 > Your version of MacPorts does not match the database your have on your
 disk. The database seems to have been upgraded by a newer version of
 MacPorts (where we removed the `mtime` field because it was unused), but
 the version of MacPorts you are currently running still expects it to be
 present.

 Indeed it looks like that, but MacPorts should have failed earlier as the
 registry version would have an unexpected value. You can check the version
 of the registry file itself with this command:

 {{{
 $ sqlite3 /opt/local/var/macports/registry/registry.db "SELECT value FROM
 metadata WHERE key = 'version';"
 }}}

 How did you uninstall and reinstall MacPorts? Do you have anything related
 to MacPorts in `/Library/Tcl/`?

--
Ticket URL: <https://trac.macports.org/ticket/52855#comment:5>
MacPorts <https://www.macports.org/>
Ports system for macOS