[OGo-Users] Postgre fatal error after new install on Suse 10.2

Adam Tauno Williams users@opengroupware.org
Tue, 30 Jan 2007 09:57:18 -0500


> > > This really looks to me like it is attempting to insert the *LITERAL*
> > > value of "%Y-%m-%d %H:%M:%S%z" which isn't getting replaced with the
> > > timestamp values.
> > Yes, looks like that.
> Look around relating to bug #1828,  where I see something similair on a
> SuSE 9.3 box, the literal value seems to come from:
> - (NSString *)startDate {
> "[self dateTimeTZFormat]".  For some reason the
> "descriptionWithCalendarFormat" method seems to just be returning the
> format string instead of the time formatted according to the string.  
> But [date descriptionWithCalendarFormat:@"%A"] is working.  As one can
> get "Thursday" for example.  The date returned by [[self appointment]
> valueForKey:@"startDate"] must be OK.

Problem seems pervasive with regards to date formatting.  If I disable
the session log [*1] I can get logged in, but just see the problem
appear in other place.

[1]  Defaults write NSGlobalDomain LSDisableSessionLog YES

Log snippet:
-------------
Jan 30 14:52:33 ogo-webui-1.1 [7662]: PG0x0x890749c SQL: SELECT DISTINCT
t1.company_id FROM  team t1, company_assignment t2 WHERE
t2.sub_company_id = 10160 AND t1.company_id = t2.company_id
  0.002s account::teams
Jan 30 14:52:33 ogo-webui-1.1 [7662]: Note: PostgreSQL72 adaptor using
timezone 'GMT' as default
Jan 30 14:52:33 ogo-webui-1.1 [7662]: PG0x0x890749c SQL: SELECT DISTINCT
t2.date_id FROM  date_company_assignment t1, date_x t2 WHERE
((t1.company_id IN (472990,10003,9991,9981,10160)) AND (t2.end_date > '%
Y-%m-%d %H:%M:%S%z')) AND (t2.start_date < '%Y-%m-%d %H:%M:%S%z') AND
t2.date_id = t1.date_id
Jan 30 14:52:33 ogo-webui-1.1 [7662]: (1DEE1DEE0145BF5BB1) command
appointment::query({
    companies = (
        <0x0x8a4528c[EOKeyGlobalID]: Person 10160>
    );
    fromDate = "2007-01-30";
    toDate = "2007-02-06";
}) failed:
  name:   LSDBObjectCommandException  reason: appointment::query failed:
could not get date ids  info:   <none>
Jan 30 14:52:33 ogo-webui-1.1 [7662]: [ERROR] (1DEE1DEE0145BF5BB1)
failed: appointment::query({
    companies = (
        <0x0x8a4528c[EOKeyGlobalID]: Person 10160>
    );
    fromDate = "2007-01-30";
    toDate = "2007-02-06";
})
    0.000s appointment::access
  0.000s appointment::get-by-globalid