[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.