Developers of Sympa

[David Verdin <address@concealed>]

That's - unfortunately - normal. Sympa does the automatic upgrade for MySQL and SQLite only.
For PostreSQL, you need to use the query you will find in the source directory in src/etc/script/ named create_db.Pg.

Apply this query to your database and it will add the required column.

Regards,

david

PS : Side note: one of our developper is currently working on a unified handling of database creation / upgrade. It should allow automatic creation and upgrade for all the supported RDBMS. So keep a stiff upper lip! :-)

Amos a écrit :

I thought I'd upgrade a test instance of sympa from 6.0.2 to 6.1b2.
When I ran the "sympa.pl --upgrade" command, this is what I got:

# /opt/sympa/bin/sympa.pl --upgrade

info Configuration file read, default log level 0
notice Sympa 6.1b.2 started
notice Conf::checkfiles() Updating static CSS file
/opt/sympa/static_content/css/style.css ; previous file renamed
notice Conf::checkfiles() Updating static CSS file
/opt/sympa/static_content/css/print.css ; previous file renamed
notice Conf::checkfiles() Updating static CSS file
/opt/sympa/static_content/css/fullPage.css ; previous file renamed
notice Conf::checkfiles() Updating static CSS file
/opt/sympa/static_content/css/print-preview.css ; previous file
renamed
DBD::Pg::st execute failed: ERROR:  column "wrong_login_count_user"
does not exist
LINE 1: ...AS data, last_login_date_user AS last_login_date, wrong_logi...
                                                             ^ at
/opt/sympa/bin/List.pm line 4811.
err List::get_user_db() Unable to execute SQL statement "SELECT
email_user AS email, gecos_user AS gecos, password_user AS password,
cookie_delay_user AS cookie_delay, lang_user AS lang , attributes_user
AS attributes, data_user AS data, last_login_date_user AS
last_login_date, wrong_login_count_user AS wrong_login_count,
last_login_host_user AS last_login_host FROM user_table WHERE
email_user = 'address@concealed,address@concealed,address@concealed' " : ERROR:
 column "wrong_login_count_user" does not exist
LINE 1: ...AS data, last_login_date_user AS last_login_date, wrong_logi...
                                                             ^
notice Upgrade process...
err Current version : 6.1b.2 ; no upgrade is required.