I am trying to get a survey (PHP files) to work on an Apache server. I tried it first with XAMPP, but then got the following error message:
Fatal error: Call to undefined function pg_escape_string() in /opt/lampp/htdocs/imageability/SkjemaDatabase.php on line 551
I tried a variety of solutions to this to get PostgreSQL to work together with XAMPP, but nothing seemed to work. So I have now decided to try installing PHP5, Apache2, PostgreSQL (and MYSQL) seperately. I followed these instructions for the installations and thought I would have got PostgreSQL installed and working this time for sure. But instead of working, or rendering the same error message again, this just gives me a blank page when trying to check out the survey in Firefox. Am running Lubuntu 14.02 by the way.
I have some other PHP files on the server that work fine. Could it still be something about PostgreSQL that's not working? While trying out XAMPP I tried uncommenting the following lines in my php.ini file
But now (with the various software installed seperately) I actually can't find the lines at all in
/etc/php5/cli/php.ini, but I'm not sure which file to look in.
I also read advise (during XAMPP problem with PostgreSQL) to copy the file
/xampp/apache/bin/, but I didn't seem to have this file and still don't.
Below are some other ideas about what might be wrong, but maybe the above are more plausible?
Another problem I had during the process was that while following the last instructions at the link above, I made the mistake of creating a super user with password and switching to postgres user. After this I couldn't open Pgadmin3, so I switched back to the usual user and then that at least worked. Could my error now have something to do with still having this superuser? Or is there something I have to do in Pgadmin3 to get my survey to work on the server? (I.e. I haven't done anything in Pgadmin3 now, just installed the above mentioned software and put my files in
Very grateful for any help!