The mailing list for listmasters using Sympa

["Holger Rabbach (ICT)" <address@concealed>]

Hi David,

 

What would have been helpful would have been at least a document that lists the differences between the previous and the current database schema. Even if you can’t make it automatic for postgresql users, by not providing that kind of information, you’re making it harder than necessary…

 

Best regards,

Holger

 

From: address@concealed [mailto:address@concealed] On Behalf Of David Verdin
Sent: 03 December 2010 09:23
To: address@concealed
Subject: Re: [sympa-users] upgrade process: is postgresql supported?

 

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