Skip to Content.
Sympa Menu

en - Postgresql problems - sympa bugs or a debian package problem?

Subject: The mailing list for listmasters using Sympa

List archive

Chronological Thread  
  • From: Michelle Murrain <address@concealed>
  • To: address@concealed, address@concealed
  • Cc: address@concealed, address@concealed
  • Subject: Postgresql problems - sympa bugs or a debian package problem?
  • Date: Thu, 29 May 2003 11:07:59 -0400

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 .../ 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 Murrain, Technology Consulting
tech at murrain dot 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

Archive powered by MHonArc 2.6.19+.

Top of Page