[Pkg-sympa-devel] Bug#686845: upgrade fails when using sympa with sqlite3

[Clint Adams]

Package: sympa
Version: 6.1.11~dfsg-4
Severity: grave

When upgrading from squeeze, the postinst fails because exclusion_table
does not exist.

err Upgrade::probe_db() Table 'exclusion_table' not found in database '/var/lib/dbconfig-common/sqlite3/sympa/sympa' ; you should create it with create_db.SQLite script

After creating that table with create_db.SQLite, it STILL fails, due to

info Upgrade::probe_db() Field 'robot_exclusion' (table 'exclusion_table' ; database '/var/lib/dbconfig-common/sqlite3/sympa/sympa') was NOT found. Attempting to add it...
DBD::SQLite::db do failed: Cannot add a NOT NULL column with default value NULL at /usr/share/sympa/lib/Upgrade.pm line 1271.
err Upgrade::probe_db() Could not add field 'robot_exclusion' to table'exclusion_table'.

This renders sympa unusable after upgrading to wheezy.