[OGo-Users] URLs Accessible from ZideStore
Adam Tauno Williams
users@opengroupware.org
Wed, 23 Apr 2008 15:20:48 -0400
> > class:PostgreSQL72Exception reason:fatal pgsql error
> > (channel=<0x0x84511b4[PostgreSQL72Channel]:
> > connection=<0x0x8488964[PGConnection]: connection=0x0x84a7238>>):
> > ERROR: syntax error at end of input
> > LINE 1: ...ob_status <> '30_archived') AND (t1.executant_id IN
> > 10100))
> > I'll check into this.
> > If you discover what is the problem, you say me it, please.
> The SQL is missing the closing paren. I need to find and fix this in
> the code, so the patch will be submitted upstream.
What version do you have installed? It looks like this was fixed
recently (r2097: Mar 11 18:47:07 2008 UTC)
> > It isn't the fastest thing in the world, but isn't terrible. Enabling
> > profiling and seeing where the time goes would be useful (see WMOGAG).
> > Often it is people having never performed a "VACUUM ANALYZE;" on their
> > database. There is also a [undocumented] bulk get method which helps
> > allot; with it you can retrieve multiple objects in a single request.
> > I am going to review wmogag, Do you know what is the method?
> You can set defaults that enable additional logging either outputting
> the literal SQLs generated or that time the various Logic commands.