Re: [MacPorts] #50112: Processing of port failed: 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) (was: Processing of port ffmpeg failed)

22 Dec 2015

      #50112: Processing of port failed: 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:  miamikill@…  |      Owner:  devans@…
      Type:  defect       |     Status:  assigned
  Priority:  Normal       |  Milestone:
 Component:  ports        |    Version:
Resolution:               |   Keywords:
      Port:               |
--------------------------+----------------------
Changes (by devans@…):

 * port:  ffmpeg =>

Comment:

 The relevent error from the attached log file is this
 {{{
 :debug:install Archive expat-2.1.0_0.darwin_15.x86_64.tbz2 packaged
 :debug:install removing file:
 /opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_release_tarballs_ports_textproc_expat/expat/work/destroot/+COMMENT
 :debug:install removing file:
 /opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_release_tarballs_ports_textproc_expat/expat/work/destroot/+CONTENTS
 :debug:install removing file:
 /opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_release_tarballs_ports_textproc_expat/expat/work/destroot/+DESC
 :debug:install removing file:
 /opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_release_tarballs_ports_textproc_expat/expat/work/destroot/+PORTFILE
 :debug:install removing file:
 /opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_release_tarballs_ports_textproc_expat/expat/work/destroot/+STATE
 :error:install org.macports.install for port expat returned: 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)
 :debug:install Error code: registry::sqlite-error
 }}}

 This can occur when the installed version of MacPorts has been reverted
 from the latest version to an earlier version.  Column mtime (expected by
 earlier versions of MacPorts) has been removed in recent versions.  It
 appears your registration database was created or updated by a more recent
 version of MacPorts than you are currently running.  Please update your
 installed copy of MacPorts to the latest version.

-- 
Ticket URL: <https://trac.macports.org/ticket/50112#comment:2>
MacPorts <https://www.macports.org/>
Ports system for OS X