[Pkg-sympa-devel] Bug#651942: Upgrade from sympa_5.3.4-6.1 fails (relation "conf_table" does not exist)

[David Verdin]

Dear all,

The conf table will be automatically added if you are using mysql or 
SQLite. Other RDBMS-driven databases are not automatically upgraded.
What RDBMS are you using?

Regards,

David

Le 19/12/11 23:32, Emmanuel Bouthenot a écrit :
> On Mon, Dec 19, 2011 at 10:58:38PM +0100, Giorgio Volpe wrote:
>> Il 19/12/2011 21.30, Emmanuel Bouthenot ha scritto:
>>> That's sound weird, could you try with the following command: $
>>> /usr/lib/sympa/bin/sympa.pl --upgrade M.
>> Same result! :-(
>>
>> I get:
>> # /usr/lib/sympa/bin/sympa.pl --upgrade
>> info Configuration file read, default log level 0
>> DBD::Pg::st execute failed: ERROR:  relation "conf_table" does not exist at /usr/share/sympa/lib/Conf.pm line 668.
>> err Conf::get_db_conf() Unable to execute SQL statement "SELECT
>> value_conf AS value FROM conf_table WHERE (robot_conf ='*' AND
>> label_conf ='color_2')": ERROR:  relation "conf_table" does not exist
>>
>> And so on ...
>> "
>> After i downgrade back with  "dpkg --force-depends -i
>> sympa_5.3.4-6.1_i386.deb" list are alive again... but wwsympa doesn't
>> work! So I need upgrading. Thanks ...
> ok, maybe the following could help a bit more:
>
> $ /usr/lib/sympa/bin/sympa.pl --upgrade --from=5.3.4 --to=6.1.7
>
>
> M.
>