[MacPorts] #31250: Failing to install package due to sqlite insert error

[MacPorts]

#31250: Failing to install package due to sqlite insert error
-----------------------------------+----------------------------------------
 Reporter:  anastasiosm@…          |       Owner:  macports-tickets@…                   
     Type:  defect                 |      Status:  new                                  
 Priority:  Normal                 |   Milestone:                                       
Component:  base                   |     Version:  2.0.3                                
 Keywords:                         |        Port:                                       
-----------------------------------+----------------------------------------

Comment(by macports.org@…):

 Hi there, +1:


 {{{
 $ sudo port -d selfupdate
 DEBUG: MacPorts sources location:
 /opt/local/var/macports/sources/rsync.macports.org/release/base
 --->  Updating MacPorts base sources using rsync
 receiving file list ... done
 [snip]
 sent 36 bytes  received 6813 bytes  805.76 bytes/sec
 total size is 2966591  speedup is 433.14
 MacPorts base version 2.0.3 installed,

 Total number of ports parsed:   3
 Ports successfully parsed:      3
 Ports failed:                   0
 Up-to-date ports skipped:       12345

 --->  MacPorts base is already the latest version
 DEBUG: Setting MacPorts sources ownership to root

 The ports tree has been updated. To upgrade your installed ports, you
 should run
   port upgrade outdated
 $ sudo port upgrade outdated
 Error: /opt/local/bin/port: port installed failed: sqlite error: no such
 table: ports (1) while executing query: SELECT id FROM ports WHERE
 (state='imaged' OR state='installed')
 }}}

 MacOS 10.5.8 just when I decided to rm -rf /sw/ and totally switch from
 fink to ports because of all the inconsistencies in my install... :-(

-- 
Ticket URL: <https://trac.macports.org/ticket/31250#comment:3>
MacPorts <http://www.macports.org/>
Ports system for Mac OS