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)

[miamikill@…]

The following dependencies were not installed: XviD autoconf gettext expat libiconv gperf ncurses xz automake libtool bzip2 fontconfig freetype libpng zlib pkgconfig fribidi glib2 libffi pcre libedit gmake gnutls curl-ca-bundle perl5 perl5.22 gdbm gmp libidn libtasn1 nettle p11-kit desktop-file-utils popt libxslt libxml2 lame libass yasm libbluray libmodplug libogg libopus libsdl xorg-libXext xorg-libX11 xorg-bigreqsproto xorg-inputproto xorg-kbproto xorg-libXau xorg-xproto xorg-libXdmcp xorg-libxcb python27 db48 openssl python2_select python_select sqlite3 xorg-libpthread-stubs xorg-xcb-proto xorg-util-macros xorg-xcmiscproto xorg-xextproto xorg-xf86bigfontproto xorg-xtrans xorg-libXrandr xorg-randrproto xrender xorg-renderproto libtheora libvorbis libvpx openjpeg15 jbigkit lcms2 jpeg tiff schroedinger orc coreutils soxr cmake curl libarchive lzo2 speex texinfo help2man p5.22-locale-gettext x264 xorg-libXfixes xorg-fixesproto

[dbevans (David B. Evans)]

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.

[miamikill@…]

the ports version is the last one

old-SSDs-MacBook-Pro:expat administrator$ sudo port selfupdate ---> Updating MacPorts base sources using rsync MacPorts base version 2.3.4 installed, MacPorts base version 2.3.4 downloaded. ---> Updating the ports tree ---> MacPorts base is already the latest version

The ports tree has been updated. To upgrade your installed ports, you should run

port upgrade outdated

old-SSDs-MacBook-Pro:expat administrator$ sudo port upgrade outdated Nothing to upgrade.

[dbevans (David B. Evans)]

Perhaps you installed the development version (2.3.99) of MacPorts base from svn trunk and then reverted to 2.3.4? At any rate, your registry database is malformed/corrupted. I suggest uninstalling your current MacPorts installation (saving a list of currently installed ports if possible) and then re-installing MacPorts 2.3.4 (as if you were migrating to a new OS version) using the Migration instructions. Once reinstalled you can reinstall your ports from the saved list and should be up and running again.

[miamikill@…]

thanks

everything are up and running after un-install completely

[raimue (Rainer Müller)]

Duplicate of #52855, closing this one as the other ticket explains the problem with additional commands to check the registry version.

This will be solved with [16239f7540cf03f6b5b3c71b5b8825999bd2b90e/macports-base] in the future.