[Imc-aotearoa-tech] Re: [Catkore] postgres problems with active

[andy]

summary:
relates to SQL datetime stamps in Postgres , after the conway Debian
"woody" upgrade.


On Fri, 8 Nov 2002, finn c. wrote:

> Please note: this list is archived and searchable via the web.
> 
> Hi,
> 
> Sorry for not posting this to catgeek, but I've been trying to
> join/email that list for several months and haven't had any luck.
> 
	predator is the sole admin for catgeek - but i checked and your
on the list... not getting any mail?


> Theres a problem with the date creation on indymedia stories [aotearoa +
> brisbane], they are all showing up with the date, 'Thu Jan 1 '70', since
> around tuesday [kinda hard to pinpoint it, because new comments reset
> the date too]. The dates are showing up fine on the admin page.
> 

	This should be fixed now - quick check on the
brisbane.indymedia.org site reveals dates to be in order..


> Recaching an old page with '&override=y' in the url resets the date to
> 'Thu Jan 1 '70' as well.
> 
> I'm guessing this probably has something to do with postgres crashing
> earlier in the week? Any ideas?
> 


Basically the upgraded Postgres database defaulted to an american format
when giving out dates.

Safari changed it to be "Postgres" format when debugging the membership
database (/etc/postgresq/postmaster.conf) but this I discovered is
incompatiable with active code.

Considering there is more active code than membership code (about 10+ to
one) I changed the default datetime format to be "ISO,nonEuropean"

The CAT membership db is again giving errors, sorry. (but should be
fixable)

andy

> finn
> 
> ______________________________________________
> 
> Don't hate the media become the media!
> Aotearoa Indymedia / Te Komako Motuhake
> 
> http://www.indymedia.org.nz
> ______________________________________________
> 
> New yesyes:alpha units available now! 
> 
> http://www.yesyes.net.nz
> 
> _______________________________________________
> Check the CAT FAQ: http://www.cat.org.au/cgi-bin/fom
> Catkore mailing list - organising list for the cat@lyst collective
> Catkore@lists.cat.org.au
> http://lists.cat.org.au/cgi-bin/mailman/listinfo/catkore
>