The mailing list for listmasters using Sympa

[David Verdin <address@concealed>]

To make Pg Sympa work correctly, you need to update the exclusion table and create the list table (you don't have to use the list table, but, well, if you activate this feature, Sympa will expect the tab le to be here).

Here are the Pg queries that would create the tables with the right structure; You can take them as examples to make sure your table have the right structure:

-- --------------------------------------------------------
--
-- Table structure for table `exclusion_table`
-- 

CREATE TABLE exclusion_table ( 
	 robot_exclusion 	varchar(50) NOT NULL, 
	 user_exclusion 	varchar(100) NOT NULL, 
	 date_exclusion 	int4, 
	 list_exclusion 	varchar(50) NOT NULL, 
	 CONSTRAINT ind_exclusion PRIMARY KEY (list_exclusion, user_exclusion, robot_exclusion) 
 );


-- --------------------------------------------------------
--
-- Table structure for table `list_table`
-- 

CREATE TABLE list_table ( 
	 creation_epoch_list 	timestamptz, 
	 name_list 	varchar(100) NOT NULL, 
	 topics_list 	varchar(100), 
	 robot_list 	varchar(100) NOT NULL, 
	 status_list 	varchar(15), 
	 path_list 	varchar(100), 
	 web_archive_list 	int2, 
	 owners_list 	varchar(100), 
	 subject_list 	varchar(100), 
	 creation_email_list 	varchar(100), 
	 editors_list 	varchar(100), 
	 CONSTRAINT ind_list PRIMARY KEY (name_list, robot_list) 
 );

Regards,

David

Le 04/06/12 16:00, Alex Hanselka a écrit :

Well. I use PostgreSQL and last I heard it won't update the structure on its own for that one. Been googling and such and can't seem to find the proper way to add it.

Thanks :-)

Sent from my iPhone

On Jun 4, 2012, at 6:01, David Verdin <address@concealed> wrote:

Hi,

did you try upgrading tha database structure ?

cheers,

david

Le 03/06/12 09:01, Alex Hanselka a écrit :

sympa.pl keeps failing with the following:

Previous process has died unexpectedly.
Date of crash: 02 Jun 2012  15:39
Errors:


Use of uninitialized value $_[3] in sprintf at /usr/lib/perl5/Sys/Syslog.pm
line 365.


DBD::Pg::st execute failed: ERROR:  column "robot_exclusion" does not exist


LINE 1: ...n_table WHERE list_exclusion = 'naughtylobby' AND robot_excl...


                                                            ^ at /usr/share/
sympa/lib/List.pm line 5036.

I assume this is an issue from my upgrade to 6.1.11 but I am not sure how to fix it.

Thanks guys!

Alex