[sympa-fr] sympa.pl dies ! (probleme postgresql)

["Samuel Torton" <adresse@cachée>]

Bonjour,

Je reviens a la charge avec mon probleme d'hier, je pense l'avoir cerné bcp
mieux.
(packages sous debian sarge: sympa 5.1.2 + postgresql 7.4.7)

-1- Voila ce que je recupere dans le "/var/log/sympa.log" apres avoir lancé
"/etc/init.d/sympa start":

   sympa[8420]: Configuration file read, default log level  0
   sympa[8422]: Sympa 5.1.2 started
   sympa[8422]: Upgrading from Sympa version  to 5.1.2
   sympa[8422]: Updating subscribed field of the subscriber table...
   sympa[8422]: Unable to execute SQL statement UPDATE subscriber_table SET
subscribed_subscriber=1 WHERE ((included_subscriber IS NULL OR
included_subscriber!=1) AND (subscribed_subscriber IS NULL OR
subscribed_subscriber!=1)) : ERROR:  operator does not exist: bit <> integer
HINT:  No operator matches the given name and argument type(s). You may need
to add explicit type casts.
   sympa[8422]: Exiting.
   archived[8431]: archived 0.1 Started
   task_manager[8435]: Configuration file read, default log level  0
   task_manager[8435]: Running task
/var/spool/sympa/task/1147430442.INIT.sync_include.test4, line 0 with vars )
   task_manager[8435]: List:sync_include(test4): 2 users updated
   task_manager[8435]: line 5 of 1147430442.INIT.sync_include.test4 : next
(1147434055, INIT)
   task_manager[8435]: creation of
/var/spool/sympa/task/1147434055.INIT.sync_include.test4
   task_manager[8435]: with model
/usr/share/sympa/list_task_models/sync_include.ttl.task
   task_manager[8435]: --> new task sync_include (12 Fri May 2006  13 h 40
min 55 s)
   bounced[8441]: bounced Started

-2- Voila quels sont mes process (ps -deaf):

   (sympa)     /usr/bin/perl /usr/lib/sympa/bin/archived.pl
   (sympa)     /usr/bin/perl /usr/lib/sympa/bin/task_manager.pl
   (sympa)     /usr/bin/perl /usr/lib/sympa/bin/bounced.pl
   (postgres)  postgres: sympa sympa 127.0.0.1 idle

... il manque donc "/usr/lib/sympa/bin/sympa.pl" !


-3- Et si je relance "/usr/lib/sympa/bin/sympa.pl -d" (mode debug):

   Configuration file read, log level set using options : 2
   cookie is stable
   Running server 8587 with main::daemon_usage = command_and_message
   Sympa 5.1.2 started
   Upgrading from Sympa version  to 5.1.2
   Updating subscribed field of the subscriber table...
   DBD::Pg::db do failed: ERROR:  operator does not exist: bit <> integer
   HINT:  No operator matches the given name and argument type(s). You may
need to add explicit type casts.
   List::send_notify_to_listmaster(sympa_died, )
   List::send_global_file(listmaster_notification,
adresse@cachée, )
   List::get_user_db(adresse@cachée)
   tools::decrypt_password (crypt.098bD3I70dhj76EC1L7KzZw=)
   mail::mailfile(/usr/share/sympa/mail_tt2/listmaster_notification.tt2,
adresse@cachée, , )
   smtp::smtpto(adresse@cachée,
adresse@cachée,  )
   Language::SetLang(en_US)
   Language::SetLang(en_US)
   Unable to execute SQL statement UPDATE subscriber_table SET
subscribed_subscriber=1 WHERE ((included_subscriber IS NULL OR
included_subscriber!=1) AND (subscribed_subscriber IS NULL OR
subscribed_subscriber!=1)) : ERROR:  operator does not exist: bit <> integer
HINT:  No operator matches the given name and argument type(s). You may need
to add explicit type casts.



J'ai donc un probleme avec Postgres et l'operateur "bit <> integer" ! :-/
Qq'un saurait-il resoudre ce probleme de cast sous Postgres ?
Pour info, voir en fin de mail le dump du schema de ma base... au cas ou il
y aurait une erreur dans mes schemas de table.

Merci,
Samuel Torton



--
-- PostgreSQL database dump
--

SET client_encoding = 'SQL_ASCII';
SET check_function_bodies = false;

SET SESSION AUTHORIZATION 'postgres';

--
-- TOC entry 4 (OID 2200)
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--

REVOKE ALL ON SCHEMA public FROM PUBLIC;
GRANT ALL ON SCHEMA public TO PUBLIC;


SET SESSION AUTHORIZATION 'sympa';

SET search_path = public, pg_catalog;

--
-- TOC entry 5 (OID 33656)
-- Name: user_table; Type: TABLE; Schema: public; Owner: sympa
--

CREATE TABLE user_table (
    email_user character varying(100) NOT NULL,
    gecos_user character varying(150),
    cookie_delay_user integer,
    password_user character varying(40),
    lang_user character varying(10),
    attributes_user character varying(255)
);


--
-- TOC entry 6 (OID 33660)
-- Name: subscriber_table; Type: TABLE; Schema: public; Owner: sympa
--

CREATE TABLE subscriber_table (
    list_subscriber character varying(50) NOT NULL,
    user_subscriber character varying(100) NOT NULL,
    date_subscriber timestamp with time zone NOT NULL,
    update_subscriber timestamp with time zone,
    visibility_subscriber character varying(20),
    reception_subscriber character varying(20),
    bounce_subscriber character varying(35),
    bounce_score_subscriber integer,
    comment_subscriber character varying(150),
    subscribed_subscriber bit(1),
    included_subscriber bit(1),
    include_sources_subscriber character varying(50)
);


--
-- TOC entry 7 (OID 33665)
-- Name: admin_table; Type: TABLE; Schema: public; Owner: sympa
--

CREATE TABLE admin_table (
    list_admin character varying(50) NOT NULL,
    user_admin character varying(100) NOT NULL,
    role_admin character varying(15) NOT NULL,
    date_admin timestamp with time zone NOT NULL,
    update_admin timestamp with time zone,
    reception_admin character varying(20),
    comment_admin character varying(150),
    subscribed_admin bit(1),
    included_admin bit(1),
    include_sources_admin character varying(50),
    info_admin character varying(150),
    profile_admin character varying(15)
);


--
-- TOC entry 10 (OID 33664)
-- Name: subscriber_idx; Type: INDEX; Schema: public; Owner: sympa
--

CREATE INDEX subscriber_idx ON subscriber_table USING btree
(user_subscriber, list_subscriber);


--
-- TOC entry 11 (OID 33669)
-- Name: admin_idx; Type: INDEX; Schema: public; Owner: sympa
--

CREATE INDEX admin_idx ON admin_table USING btree (list_admin, user_admin,
role_admin);


--
-- TOC entry 8 (OID 33658)
-- Name: ind_user; Type: CONSTRAINT; Schema: public; Owner: sympa
--

ALTER TABLE ONLY user_table
    ADD CONSTRAINT ind_user PRIMARY KEY (email_user);


--
-- TOC entry 9 (OID 33662)
-- Name: ind_subscriber; Type: CONSTRAINT; Schema: public; Owner: sympa
--

ALTER TABLE ONLY subscriber_table
    ADD CONSTRAINT ind_subscriber PRIMARY KEY (list_subscriber,
user_subscriber);


--
-- TOC entry 12 (OID 33667)
-- Name: ind_admin; Type: CONSTRAINT; Schema: public; Owner: sympa
--

ALTER TABLE ONLY admin_table
    ADD CONSTRAINT ind_admin PRIMARY KEY (list_admin, user_admin,
role_admin);


SET SESSION AUTHORIZATION 'postgres';

--
-- TOC entry 3 (OID 2200)
-- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
--

COMMENT ON SCHEMA public IS 'Standard public schema';