-1

A working torrentflux setup seems to have gone broken after upgrading PHP to 5.3 and Postrgres to 9.2beta3 on a FreeBSD 8.2 server. The login screen will show up fine, but after clicking the login button, I get an error :

Fatal error: Call to undefined function pg_escape_string() in \
/usr/home/parker/tf/html/inc/lib/adodb/drivers/adodb-postgres64.inc.php \
on line 241

Seems to be an error with PHP and the pgsql php package. The phppgsql package itself is not totally broken because I'm using it to host database driven apps on this server. This is the first and only error I'm seeing from it.

How might I go about fixing this problem?

4
  • 1
    I suggest you roll back the software until you figure out the conflict. Its more likely the beta release of your Postrgres start with that.
    – Ramhound
    Nov 24, 2012 at 5:13
  • Sounds reasonable, but I need some help with the commands to do so on FreeBSD... I never really learned how to properly manage packages. Nov 24, 2012 at 5:26
  • As a heads up: the FreeBSD community generally frowns upon questions regarding stuff that is well documented on the main site and especially questions about stuff documented in the Handbook. Frankly, I understand and share this position, even though I'm not part of that community. Nov 25, 2012 at 16:09
  • As a heads up, FreeBSD sucks and I've decided not to use it anymore. Nov 26, 2012 at 8:20

2 Answers 2

2

there is a tool called portdowngrade in the portstree which helps to deal with this issues.

If you don't want to use it, the best way would be, checkout the old version of the postgres port from SVN

1
  • Gave a concise answer to my question. In the end, I've decided to ditch FreeBSD. After years of using Debian for my home servers, I tried FreeBSD because I thought it would help me learn something new... all I've learned is where to buy the cheapest tylenol for the headaches Nov 26, 2012 at 3:28
1

If you compiled the ports by hand, you have probably failed to include the PHP functionality that is required for your web application. I don't have much experience with FreeBSD or the PHP package there, but the general instructions in 5.6.3.3 Reconfiguring Ports should suffice.

What I'm saying is you need to enable PostgreSQL support in PHP and recompile or use a binary that has all the modules required by your web application.

Not the answer you're looking for? Browse other questions tagged .