I just spent some more time experimenting with Glom 1.0 to try and figure out the cause of the problem.
Not that may LANG is: murrayc ubuntumurrayc:~$ echo $LANG en_US.UTF-8
[segphault lain:~]% env | grep LANG LANG=en_US.UTF-8 LANGUAGE=en_US:en_GB:en
Also, is there anything unusual about your Postgres server? What version is it, and have you used any special/clever configuration with it?
I appear to be using 7.5.16.1: [segphault lain:~]% apt-cache policy postgresql postgresql: Installed: 7.5.16.1 Candidate: 7.5.16.1 Version table: *** 7.5.16.1 0 500 http://archive.ubuntu.com dapper/universe Packages 100 /var/lib/dpkg/status I'm not doing anything special with it, it's just the standard configuration. The only changes I made are the changes you list in the "Initial Postgres Configuration" page at the Glom wiki. When I start Glom from the command line, it emits messages saying that the server is version 7.4: [segphault lain:~]% glom Glom: connecting. Postgres Server version: 7.4 The other thing I see in stdout that is probably relevant is a debug message about date parsing: DEBUG: Skipping std::time_get<> because it is incapable of parsing 4-digit years in the current locale. I tried entering the date several other ways. When I type in 04/20/06, it converts it to 4/20/6 or 20/04/6. After it converts it, the program either experiences a segmentation fault, or emits one of two different errors. After a segmentation fault, when I restart the program the value in that field becomes 06/04/2020. For your reference, I have attached a pair of images that show the error messages. When the second one (error-2.jpg) comes up I also see the following in stdout: Glom Base_DB::Query_execute(): Error while executing SQL UPDATE "articles" SET "date_assigned" = '20-04-06' WHERE "articles_id" = 9 Internal error: ERROR: date/time field value out of range: "20-04-06" HINT: Perhaps you need a different "datestyle" setting. I hope this helps. Thanks! -- Ryan On Thu, 2006-04-20 at 18:46 +0200, Murray Cumming wrote:
On Tue, 2006-04-18 at 20:42 +0200, Murray Cumming wrote:On Sat, 2006-04-15 at 18:50 -0700, Ryan Paul wrote:I just tested Glom 1.0 in Ubuntu Dapper. So far, it seems to be working relatively well, except for a problem with date fields. Glom transposes the month and day of date fields. When I type "April 15 2006" into a date field, it becomes 15/04/2006.When exactly does it "become 15/04/2006". Are you, for instance, pressing Enter, or clicking away from the field? I didn't even know that it could recognise such a freeform date. However, I can't reproduce the effect. For me, when I enter "April 15 2006" in the Date Of Birth field in the contact details, then click into a different field, or press Enter, the field shows 04/16/2006 (Note that you seem to have the British format instead). When I click around some more, I can't get that error dialog. Not that may LANG is: murrayc ubuntumurrayc:~$ echo $LANG en_US.UTF-8 As soon as we can reliably and exactly reproduce this problem, we can fix it.Please do take another look at this. I am eager to fix any bug.
-- Ryan Paul <segphault sbcglobal net>
Attachment:
error-1.jpg
Description: JPEG image
Attachment:
error-2.jpg
Description: JPEG image