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