Developers of Sympa

[Hargitai Gábor <address@concealed>]

Hi

the question is in the subject. I tried the cvs version today, and it
had a lot of problems with Postgresql. But I would like to translate the
hu.po file and I can't check it well without the web interface (and I
don't know anything about mysql).

Some bog reports: check_perl_modules.pl doesn't check XML::LibXML (I
can't see it in doc too)
In create_db.Pg: postgresql doesn't have enum data type, you can simply
use constraints or domains, so you had to modify create_.Pg-s last
section to this: 
CREATE TABLE admin_table (
        list_admin              varchar(50) NOT NULL,
        user_admin              varchar(100) NOT NULL,
        role_admin              varchar(9) CHECK (role_admin IN
('listmaster','owner','editor')) NOT NULL,
        date_admin              timestamp with time zone NOT NULL,
        update_admin            timestamp with time zone,
        reception_admin         varchar(20),
        comment_admin           varchar(150),
        subscribed_admin        bit(1),
        included_admin          bit(1),
        include_sources_admin   varchar(50),
        info_admin              varchar(150),
        profile_admin           varchar(10) CHECK (profile_admin IN
('privileged','normal')),
       CONSTRAINT ind_admin PRIMARY KEY (list_admin,
user_admin,role_admin)
);
CREATE  INDEX admin_idx ON admin_table(list_admin,
user_admin,role_admin);

After correcting these problems starting sympa.pl -d says:
Unable to execute SQL statement UPDATE subscriber_table SET
subscribed_subscriber='1' WHERE ((included_subscriber IS NULL ||
included_subscriber!='1') && (subscribed_subscriber IS NULL ||
subscribed_subscriber!='1')) : ERROR:  operator does not exist: boolean
|| bit

-- 
Üdv
Gábor