On 18/apr/08, at 17:38, Simeon Walker wrote:

Hello,

Continuing on my quest to get hippo installed...

Is anyone using Postgres 8.3? I have managed to get the DB setup and the
repository to connect to the DB but during startup I'm getting this in
the slide log:
SQL error 0 on /: ERROR: missing FROM-clause entry for table "uri"

Googling the message I see that it is usually caused by SQL that will
work on MySQL but not on Postgres. If there's anyone here using Postgres
can you tell me what version worked? I am using the hippo-repository
trunk.


Hi,
we are working with PostgreSQL 8.1 (tested on Linux, MacOSX and Solaris x86/SPARC).

When the error you're mentioning above was raised, all that we had to do was to enable

add_missing_from = on

in postgresql.conf

Please let me know if it is working for you as well.

Cheers.
--
###########################################################

"Computer Science is no more about computers than astronomy
is about telescopes." (E. W. Dijkstra)

Dott. Francesco Chicchiriccò
Amministratore unico
Tel +393290573276

ePOSSE S.r.l.
Sedi operative
 * Via dei Marrucini, 11 - 65127 Pescara
 * V.le P.L. Nervi, 188 G 7 - 04100 Latina

Tel / FAX +390854503336
http://www.eposse.it

###########################################################

********************************************
Hippocms-dev: Hippo CMS development public mailinglist

Reply via email to