[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:  ports                  |     Version:  2.0.3                                
 Keywords:                         |        Port:  port                                 
-----------------------------------+----------------------------------------
 Hello,

 after upgrading my ports from 1.9.x to 2.03 I am unable to install any
 package, see example below

 #port install ascii
 --->  Installing ascii @3.8_0
 Error: Target org.macports.install returned: sqlite error: no such table:
 registry.ports (1) while executing query: INSERT INTO registry.ports
 (name, version, revision, variants, epoch) VALUES (?, ?, ?, ?, ?)
 Log for ascii is at:
 /opt/local/var/macports/logs/_opt_local_var_macports_sources_rsync.macports.org_release_ports_textproc_ascii/ascii/main.log
 Error: Status 1 encountered during processing.
 To report a bug, see <http://guide.macports.org/#project.tickets>

 ''Contents of
 /opt/local/var/macports/logs/_opt_local_var_macports_sources_rsync.macports.org_release_ports_textproc_ascii/ascii/main.log'':

 version:1
 :debug:main Executing org.macports.main (ascii)
 :debug:main Skipping completed org.macports.archivefetch (ascii)
 :debug:main Skipping completed org.macports.fetch (ascii)
 :debug:main Skipping completed org.macports.checksum (ascii)
 :debug:main Skipping completed org.macports.extract (ascii)
 :debug:main Skipping completed org.macports.patch (ascii)
 :debug:main Skipping completed org.macports.configure (ascii)
 :debug:main Skipping completed org.macports.build (ascii)
 :debug:main Skipping completed org.macports.destroot (ascii)
 :debug:install install phase started at Wed Sep 14 01:57:06 EEST 2011
 :notice:install --->  Installing ascii @3.8_0
 :debug:install Executing org.macports.install (ascii)
 :error:install Target org.macports.install returned: sqlite error: no such
 table: registry.ports (1) while executing query: INSERT INTO
 registry.ports (name, version, revision, variants, epoch) VALUES (?, ?, ?,
 ?, ?)
 :debug:install Backtrace: sqlite error: no such table: registry.ports (1)
 while executing query: INSERT INTO registry.ports (name, version,
 revision, variants, epoch) VALUES (?, ?, ?, ?, ?)
     while executing
 "registry::entry create $subport $version $revision $portvariants $epoch"
     invoked from within
 "registry::write {

         set regref [registry::entry create $subport $version $revision
 $portvariants $epoch]

         if {[info exists user_options..."
     (procedure "portinstall::install_main" line 35)
     invoked from within
 "$procedure $targetname"
 :info:install Warning: the following items did not execute (for ascii):
 org.macports.activate org.macports.install
 :notice:install Log for ascii is at:
 /opt/local/var/macports/logs/_opt_local_var_macports_sources_rsync.macports.org_release_ports_textproc_ascii/ascii/main.log

 if you need more info please let me know.
 thanks in advance

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