PostgreSQL functions missing

Hi,

My sys admin installed an update to H-Sphere (control panel software) that
broke PEAR::DB and phpBB last week. After much trial and error, I finally
tracked it down to missing pg_affected_rows() and pg_cmdtuples() functions
(for PEAR and phpBB respectively) in PHP. I'm assuming that the H-Sphere
update also included an upgrade for PHP and they didn't compile it right.

Does anyone know how we can fix this? Does Psoft (the company that makes
H-Sphere) have to recompile libpq? The server is currently running PHP 4.4.2
and PosgreSQL 7.4.11. Any insight would be much appreciated.

Thanks in advance,
Tony

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

Re: PostgreSQL functions missing

On 4/27/06, Tony Grimes wrote:
> Hi,
>
> My sys admin installed an update to H-Sphere (control panel software) tha=
t
> broke PEAR::DB and phpBB last week. After much trial and error, I finally
> tracked it down to missing pg_affected_rows() and pg_cmdtuples() function=
s
> (for PEAR and phpBB respectively) in PHP. I'm assuming that the H-Sphere
> update also included an upgrade for PHP and they didn't compile it right.
>
> Does anyone know how we can fix this? Does Psoft (the company that makes
> H-Sphere) have to recompile libpq? The server is currently running PHP 4.=
4.2
> and PosgreSQL 7.4.11. Any insight would be much appreciated.

Was postgres updated at the same time or possibly compiled against a
different version to yours?

http://www.php.net/manual/en/ref.pgsql.php

Note: Not all functions are supported by all builds. It depends on
your libpq (The PostgreSQL C client library) version and how libpq is
compiled. If PHP PostgreSQL extensions are missing, then it is because
your libpq version does not support them.

I guess psoft needs to help you sort this one out..

--
Postgresql & php tutorials
http://www.designmagick.com/

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

Re: PostgreSQL functions missing

Hi Chris,

I'm not sure if PG was updated at the same time. I do know that a separate
server has no problem connecting to the database and it's running PHP 4.3.
In any case, I think I've given the support guys enough info to go on.

I figure if they broke it, they can fix it :)

Thanks,
Tony


On 4/26/06 8:55 PM, "chris smith" wrote:

> On 4/27/06, Tony Grimes wrote:
>> Hi,
>>
>> My sys admin installed an update to H-Sphere (control panel software) that
>> broke PEAR::DB and phpBB last week. After much trial and error, I finally
>> tracked it down to missing pg_affected_rows() and pg_cmdtuples() functions
>> (for PEAR and phpBB respectively) in PHP. I'm assuming that the H-Sphere
>> update also included an upgrade for PHP and they didn't compile it right.
>>
>> Does anyone know how we can fix this? Does Psoft (the company that makes
>> H-Sphere) have to recompile libpq? The server is currently running PHP 4.4.2
>> and PosgreSQL 7.4.11. Any insight would be much appreciated.
>
> Was postgres updated at the same time or possibly compiled against a
> different version to yours?
>
> http://www.php.net/manual/en/ref.pgsql.php
>
> Note: Not all functions are supported by all builds. It depends on
> your libpq (The PostgreSQL C client library) version and how libpq is
> compiled. If PHP PostgreSQL extensions are missing, then it is because
> your libpq version does not support them.
>
> I guess psoft needs to help you sort this one out..
>
> --
> Postgresql & php tutorials
> http://www.designmagick.com/

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