Developers of Sympa

[Michelle Murrain <address@concealed>]

I've come to understand fully the problems I've been having with 
Sympa, and I believe that at least four of the five are related to 
the upgrade of Postgresql to version 7.3.2. (The sympa version in 
debian testing is 3.3.5-1)

I have had five problems, 2 have been solved:

1) Reimporting the data from the old version of the database resulted 
in a timestamp problem (I fixed that by writing a script that 
rearranged the timestamps)

2) Postgresql returns 'public.table_name' instead of 'table_name' on 
a $dbh->tables request (I fixed that with a bit of code)

Remaining problems:

1) When I look at the list of subscribers using wwsympa, I don't get 
a list. In the apache error log, the following message appears: 
""LIMIT #,# syntax not supported at .../List.pm line 2986.

2) When I try to add a subscriber (either on the web, or by mail) I 
get: Type "datetime" does not exist.

3) When I look at the bounces, an empty field in bounces somehow ends 
up representing some weird date in 1969. I don't think this has 
anything to do with Postgresql, because I get no errors during the 
listing of that page. But I'd like to understand why a blank record 
in the database results in that wierd date, since they were blank to 
begin with. If you can even point me to the right place in the code 
(I've poked around quite a bit, but can't find it.) that parses the 
bounce info, I'd appreciate it.

So, I need some help here. I don't know if these have already been 
fixed in the newest version of sympa, and are on the burner in the 
package release for unstable - so I'd appreciate any help in that 
regard. In addition, I am perfectly willing to hear that it's really 
was my problem, that I did some particular thing wrong, but I really 
need to know what it was, so I don't make the same mistakes in the 
future.
--
.Michelle

--------------------------
Michelle Murrain, Technology Consulting
tech at murrain dot net     http://www.murrain.net
413-253-2874 ph
413-222-6350 cell
413-825-0288 fax
AIM:pearlbear0 Y!:pearlbear9 ICQ:129250575
SMS: 4132226350 at messaging dot sprintpcs dot com

"I am determined to cultivate only thoughts that increase trust and 
love, to use my hands to perform only deeds that build community, to 
speak only words of harmony and aid." - Thich Nhat Hanh