[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