Re: undefined function pg_connect()

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



SOLVED !!!

Yes, postgres is already installed.  (My problem started when I upgraded from PHP 5.2.3 to 5.2.6.)

After some more digging around, I found the following:

Bug #44905 PHP 5.2.6 fails to load PostgreSQL related libraries

http://bugs.php.net/bug.php?id=44905

In the documentation for this bug is the circumvention which is
"Simply add your PostgreSQL bin directory ("C:\Program
Files\PostgreSQL\8.3\bin" on my system) to your system path."
I did this and the problem disappeared.

Thank you for your help.
jfc



2008/11/21 Lester Caine <lester@xxxxxxxxxxx>
James Chubb wrote:
Hello,

I wonder if someone could help me resolve this problem.

Today, after upgrading from PHP 5.2.3. <http://5.2.3.> to 5.2.6, this little program:


<?php
       $db = pg_connect('host=localhost dbname=xxxx user=chubb password=yyyyyy')
           or die('Could not connect: ' . pg_last_error());
?>

is now getting this error:

*Fatal error*: Call to undefined function pg_connect() in *C:\Inetpub\cu\code_tests\db_connect.php* on line *2

*
According to phpinfo() ...

Server API: ISAPI
Loaded Configuration File: C:\Program Files\PHP\php.ini
PHP Extension: 20060613
Path environment variable: C:\Program Files\PHP\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\QuickTime\QTSystem\
But is it showing pgsql installed?


In the php.ini file, I do have:
extension=php_pgsql.dll

And on my system, I do have:
C:\Program Files\PHP\ext\php_pgsql.dll   (98,368   2008-05-02 18:07)

I am running Windows/XP and IIS 5.1.

What is causing this problem?
I would suspect it's not finding postgres so php_pgsql is not actually being installed when php starts.

--
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/lsces/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


[Index of Archives]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [Postgresql]     [PHP Books]     [PHP Databases]     [PHP SOAP]
  Powered by Linux