The mailing list for listmasters using Sympa

[Alex Hanselka <address@concealed>]

That fixed the issue, but while running the upgrade, I also got this error

notice Upgrade::upgrade() fixing robot column of exclusion table.
DBD::Pg::st execute failed: ERROR:  column "robot_exclusion" of relation 
"exclusion_table" does not exist
LINE 1: UPDATE exclusion_table SET robot_exclusion = 'lists.darkdna....
                                   ^ at /srv/sympa/bin/Upgrade.pm line 737.
err Upgrade::upgrade() Unable to execute SQL statement "UPDATE 
exclusion_table SET robot_exclusion = 'lists.darkdna.net' WHERE 
list_exclusion='serverstatus' AND address@concealed'" : 
ERROR:  column "robot_exclusion" of relation "exclusion_table" does not exist
LINE 1: UPDATE exclusion_table SET robot_exclusion = 'lists.darkdna....
                                   ^
notice Upgrade::upgrade() Caching all lists config subset to database

Sorry that I have become a pain :)

Alex


On May 15, 2012, at 10:12 AM, David Verdin wrote:

> Hi,
> 
> Postgres is not upgraded automatically - at least in 6.1, It will be 
> starting 6.2.
> 
> To create the list_table table, please use the following requests:
> 
> CREATE TYPE type_list_status AS ENUM ('open', 'closed', 'pending', 
> 'error_config', 'family_closed');
> CREATE TABLE list_table (
>    creation_email_list    varchar(100),
>    creation_epoch_list    timestamptz,
>    editors_list        varchar(100),
>    name_list        varchar(100) NOT NULL,
>    owners_list        varchar(100),
>    path_list        varchar(100),
>    robot_list        varchar(100) NOT NULL,
>    status_list        type_list_status,
>    subject_list        varchar(100),
>    topics_list        varchar(100),
>    web_archive_list    int2,
>    constraint ind_list primary key (name_list,robot_list)
> );
> 
> After that, you should edit the etc/data_structure.version file. replace 
> "6.1.11" by "6.1.10" and run sympa.pl --upgrade again.
> 
> Regards,
> 
> David
>

Attachment: signature.asc
Description: Message signed with OpenPGP using GPGMail