[PHP-DB] php 5.1.4 and PostgreSQL 8.1.4

2006-06-05 Thread [EMAIL PROTECTED] 
I had php 5.1.4 on FreeBSD 5.4 with Apache 1.3.36 and PostgreSQL 8.0.8 
for some time and all was OK. The last days I went to PostgreSQL 8.1.4 
and since then the PGSQL extension crashes Apache, no matter what I do.


Is there any experience in this direction?

Thanks,
Iv.

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

Re: [PHP-DB] php 5.1.4 and PostgreSQL 8.1.4

2006-06-05 Thread Chris 

[EMAIL PROTECTED] wrote:
I had php 5.1.4 on FreeBSD 5.4 with Apache 1.3.36 and PostgreSQL 8.0.8 
for some time and all was OK. The last days I went to PostgreSQL 8.1.4 
and since then the PGSQL extension crashes Apache, no matter what I do.


I was going to ask if you compiled php yourself but bsd doesn't have 
pre-compiled stuff does it? (I have no experience with *bsd so excuse 
the newbie question)..


Did you recompile php after upgrading postgresql?

You might need to generate a backtrace and get the internals list to 
help you out..


http://bugs.php.net/bugs-generating-backtrace.php

--
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] php 5.1.4 and PostgreSQL 8.1.4

2006-06-05 Thread Marius Claian 
On Monday 05 June 2006 22:26, [EMAIL PROTECTED] wrote:
 I had php 5.1.4 on FreeBSD 5.4 with Apache 1.3.36 and PostgreSQL 8.0.8
 for some time and all was OK. The last days I went to PostgreSQL 8.1.4
 and since then the PGSQL extension crashes Apache, no matter what I do.

 Is there any experience in this direction?

 Thanks,
 Iv.

You have to recompile the postgresql extension for php 
(cd /usr/ports/databases/php5-pgsql  make clean  make reinstall)

Also, postgresql's internal files are not backward-compatible, so if you are 
updating from 8.0.x to 8.1.x, you should do a dump of all your databases with 
your old version of postgresql (8.0.x) and import with the new one  (8.1.x) 
(sorry if you already did this, just wanted to make sure, but can you connect 
to the database using other method than php ? (psql for example ?) )

I am have the same configuration for php and postgresql and it works fine 
here.

Hope this helps you.
-- 
Marius

GPG/PGP: https://unkn.homeunix.org/unkn.asc

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