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
