The mailing list for listmasters using Sympa

[David Verdin <address@concealed>]

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
Le 15/05/12 15:44, Alex Hanselka a écrit :
> That's what I thought, but when I tried to run sympa.pl --upgrade it was like 
> "nope, already 6.1.11"
>
> I use Postgres here.
>
>
> On May 15, 2012, at 8:40 AM, David Verdin wrote:
>
> > Hi Alex,
> >
> > What RDBMS so you use with Sympa?
> >
> > Your lists don't show up because their db cache was not initiliazed. 
> > Normally, this is done at upgrade time except if the database structure was 
> > not updated.
> >
> > Le 15/05/12 15:29, Alex Hanselka a écrit :
> > > I have recently upgraded to Sympa 6.1.11 from 6.1.7 I believe and now, my 
> > > public lists are not showing up sort of.
> > >
> > > http://lists.opennicproject.org/lists
> > >
> > > As you can see there, the "D" is lit up as if there is a list, but it is not 
> > > showing up.  Any ideas?
> > >
> > > Thank you,
> > > Alex=

Attachment: smime.p7s
Description: Signature cryptographique S/MIME