Re: [PHP-DB] php 5.2.9 and Postgres 8.3.7

2009-06-17 Thread Didier Gasser-Morlay

Lester,

Sorry, I should have said:
Yes: Postgres is up & running happily on the machine
yes : Postgres is listed in phpinfo; with the correct version; php was 
connecting fine to the dababase, this message only happens on the 1st 
query which is when the function pg_escape_string is called.







--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP-DB] php 5.2.9 and Postgres 8.3.7

2009-06-17 Thread Didier Gasser-Morlay

Lester,

Sorry, I should have said:
Yes: Postgres is up & running happily on the machine
yes : Postgres is listed in phpinfo; with the correct version; php was 
connecting fine to the dababase, this message only happens on the 1st 
query which is when the function pg_escape_string is called.







--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP-DB] php 5.2.9 and Postgres 8.3.7

2009-06-17 Thread danaketh
Do you have postgres module for PHP installed? This will probably be the 
cause.


Didier Gasser-Morlay napsal(a):

Hello,

I tried all day yesterday to setup a brand new machine with a fresh 
Linux install; with apache 2.2.10 (from source) php 5.2.9 (from 
source) and PostgresQL 8.3.7 (from the very neat one-click installer 
provided by Enterprisedb) ; everything compiles and installs fine but 
when trying to run the first query  to my database I consistently get 
a message about pg_escape_string function missing.


I am connecting through ADODB which filters any query via

 "'".pg_escape_string($this->_connectionID,$s)."'";

I had no problem using the same build with php 5.2.8 and Postgres 
8.3.4, so I ended up using the mod_php5.so module for apache build 
with these versions, but would like to get to the bottom of it.



Any idea or comment ?

Didier





--

S pozdravem

Daniel Tlach
Freelance webdeveloper

Email: m...@danaketh.com
ICQ: 160914875
MSN: danak...@hotmail.com
Jabber: danak...@jabbim.cz


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP-DB] php 5.2.9 and Postgres 8.3.7

2009-06-17 Thread Lester Caine

Didier Gasser-Morlay wrote:

Hello,

I tried all day yesterday to setup a brand new machine with a fresh 
Linux install; with apache 2.2.10 (from source) php 5.2.9 (from source) 
and PostgresQL 8.3.7 (from the very neat one-click installer provided by 
Enterprisedb) ; everything compiles and installs fine but when trying to 
run the first query  to my database I consistently get a message about 
pg_escape_string function missing.


I am connecting through ADODB which filters any query via

 "'".pg_escape_string($this->_connectionID,$s)."'";

I had no problem using the same build with php 5.2.8 and Postgres 8.3.4, 
so I ended up using the mod_php5.so module for apache build with these 
versions, but would like to get to the bottom of it.


The obvious question would have to be was postgres actually listed in 
phpinfo? It would need to have been anabled in your build ...


--
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk//
Firebird - http://www.firebirdsql.org/index.php

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php