The mailing list for listmasters using Sympa

[David Verdin <address@concealed>]

Hi Amos,

Sorry, the db upgrade is automatic for MySQL and SQLite only. We don't have enough expertise with the other RDBMS to provide an automatic upgrade.
For PostgreSQL, Sybase and Oracle, you must update the database manually. We provide the query to use to create the database in the sources directory: src/etc/script

Regards,

David

Le 02/12/2010 21:43, Amos a écrit :

When attempting to upgrade from 6.0.3 to 6.1.3 I get an error because
a table doesn't have the column wrong_login_count_user.  This is what
it looks like.  I tried to open a bug issue for this, but must admit
that tracker doesn't seem to be very intuitive (I guess I'm too used
to JIRA.)


dsympa:/opt/sympa# /opt/sympa/bin/sympa.pl --upgrade
info Configuration file read, default log level 1
debug Conf::_load_auth() Conf::_load_auth(/opt/sympa/etc/auth.conf)
debug Running server 13444 for sympa purpose
notice Sympa 6.1.3 started
notice Conf::checkfiles() TT2 file /opt/sympa/default/web_tt2/css.tt2
has changed; updating static CSS file
/opt/sympa/static_content/css/sty
le.css ; previous file renamed
notice Conf::checkfiles() TT2 file /opt/sympa/default/web_tt2/css.tt2
has changed; updating static CSS file
/opt/sympa/static_content/css/pri
nt.css ; previous file renamed
notice Conf::checkfiles() TT2 file /opt/sympa/default/web_tt2/css.tt2
has changed; updating static CSS file
/opt/sympa/static_content/css/ful
lPage.css ; previous file renamed
notice Conf::checkfiles() TT2 file /opt/sympa/default/web_tt2/css.tt2
has changed; updating static CSS file
/opt/sympa/static_content/css/pri
nt-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 4819.
err List::get_user_db() Unable to execute SQL statement "SELECT
email_user AS email, gecos_user AS gecos, password_user AS password,
cookie_d
elay_user AS cookie_delay, lang_user AS lang , attributes_user AS
attributes, data_user AS data, last_login_date_user AS
last_login_date, wro
ng_login_count_user AS wrong_login_count, last_login_host_user AS
last_login_host FROM user_table WHERE email_user = '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...
                                                             ^
debug Language::PushLang() Language::PushLang(en_US)
debug Language::PopLang()
debug mail::sending() NOT USING BULK
notice Upgrade process...
notice Upgrading from 6.0.3 to 6.1.3...
notice Upgrade::upgrade() Upgrade::upgrade(6.0.3, 6.1.3)
notice Upgrade::upgrade() Rebuilding config.bin files for ALL
lists...it may take a while...
  

--
David Verdin
Comité réseau des universités

Due to the limitations of human brain, I fail to remember all the mails.
So if you want your bug reports or feature requests for Sympa to be processed, please post them to the Sympa tracker