Failing to install package due to sqlite insert error

[anastasiosm@…]

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

[ryandesign (Ryan Carsten Schmidt)]

Please remember to use WikiFormatting.