I get this error when I run a webapp Im trying to use:
Fatal error: Call to undefined function pg_escape_string() in ...
I know the application works, as Ive been developing and modifying it for a while now. Im trying to get it running on my Linux desktop so editing will be easier.
My server setup:
-Apache2 on Linux (Ubuntu)
-PHP 5.3.2
-PostgreSQL 8.4
PHP IS CONFIGURED to use postgres, I know thats the most obvious thing that stands out with this problem, but I did configure PHP with:
'./configure' '--with-apxs2=/usr/local/apache2/bin/apxs' '--with-pgsql=/opt/PostgreSQL/8.4/'
and in phpinfo It has a section for "PostgreSQL Support"; and if I run php -m pgsql is on the list of installed modules. I can use other PG commands, and can connect to a postgres server and such. This function doesnt work though.
Im completely baffled. If it makes any difference, I had PHP 5.3.1 installed earlier, and I got this error; then I downloaded/compiled/installed 5.3.2 to see if it fixed it, but it didn't.
Thanks, any help appreciated.