Re: [PHP-DB] 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" <[EMAIL PROTECTED]> wrote: > On 4/27/06, Tony Grimes <[EMAIL PROTECTED]> 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
Re: [PHP-DB] PostgreSQL functions missing
On 4/27/06, Tony Grimes <[EMAIL PROTECTED]> 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
[PHP-DB] 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
