Cannot uninstall local port with invalid version number

[S P Arif Sahari Wibowo]

The resolution:

On 2018-07-18, 16:56, S P Arif Sahari Wibowo via macports-users wrote:
> I am upgrading to more recent version of macOS (Sierra), so 
> after that I am migrating macports using instructions in 
> https://trac.macports.org/wiki/Migration
...
> # port -f uninstall installed
> Warning: Failed to open Portfile from registry for alpine @2.20_0.97.114.105.102.115.97.104.97.1+without_tcl
> Error: port uninstall failed: Registry error: Invalid version '2.20_0.97.114.105.102.115.97.104.97.1+without_tcl' specified for alpine. 
> Please specify a version as recorded in the port registry.

ua3arifsaha:~ root# sqlite3 /opt/local/var/macports/registry/registry.db
SQLite version 3.25.2 2018-09-25 19:08:10
Enter ".help" for usage hints.
sqlite> select version,revision from ports where revision='0.97.114.105.102.115.97.104.97.1';
sqlite> .load /opt/local/var/macports/sources/rsync.macports.org/release/tarballs/base/src/cregistry/macports.sqlext 
sqlite> update ports set revision=27516 where revision='0.97.114.105.102.115.97.104.97.1';
sqlite> .q

The number 27516 is arbitrary, I chose somewhat random number so 
I can find it again if I need to. After this the uninstall 
worked fine. I did not change the path in the database so it 
seemed that macports had no problem finding which files and 
paths to uninstall.

Thanks!

-- 
    ____  ____  ____  ____ (stephan paul) Arif Sahari Wibowo
   /___  /___/ /___/ /___      http://www.arifsaha.com/
  ____/ /     /   / ____/