Subject: Developers of Sympa
List archive
- From: David Verdin <address@concealed>
- To: Amos <address@concealed>
- Cc: address@concealed
- Subject: Re: [sympa-dev] upgrade error for 6.1b2
- Date: Thu, 03 Jun 2010 21:37:34 +0200
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. |
-
[sympa-dev] upgrade error for 6.1b2,
Amos, 06/03/2010
-
Re: [sympa-dev] upgrade error for 6.1b2,
David Verdin, 06/03/2010
- Re: [sympa-dev] upgrade error for 6.1b2, Amos, 06/03/2010
-
Re: [sympa-dev] upgrade error for 6.1b2,
David Verdin, 06/03/2010
Archive powered by MHonArc 2.6.19+.