Error when using phpPgAdmin

From: Adam Bruss <abruss(at)awrcorp(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Error when using phpPgAdmin
Date: 2010-12-22 16:47:37
Message-ID: D81DB5ADDC5C3B4484C581AF3D8EFF9D943967@ex2a.awr.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello and thanks for this great application named pgql.

I've setup pg on a windows machine and have installed phppgadmin. The phppgadmin php application comes up correctly in a browser but I get an error message when viewing the databases. The apache log shows this:

"[Wed Dec 22 10:27:34 2010] [error] [client 127.0.0.1] PHP Fatal error: Call to a member function recordCount() on a non-object in C:\\Program Files (x86)\\PostgreSQL\\EnterpriseDB-ApachePhp\\apache\\www\\phpPgAdmin\\classes\\Misc.php<file:///\\PostgreSQL\EnterpriseDB-ApachePhp\apache\www\phpPgAdmin\classes\Misc.php> on line 1805, referer: http://localhost:81/phpPgAdmin/browser.php"

And the webpage shows this:

"SQL error:
ERROR: could not stat file "base/16396/16397": Permission denied
In statement:
SELECT pdb.datname AS datname, pr.rolname AS datowner, pg_encoding_to_char(encoding) AS datencoding,
(SELECT description FROM pg_catalog.pg_shdescription pd WHERE pdb.oid=pd.objoid) AS datcomment,
(SELECT spcname FROM pg_catalog.pg_tablespace pt WHERE pt.oid=pdb.dattablespace) AS tablespace,
CASE WHEN pg_catalog.has_database_privilege(current_user, pdb.oid, 'CONNECT')
THEN pg_catalog.pg_database_size(pdb.oid)
ELSE NULL END as dbsize
FROM pg_catalog.pg_database pdb LEFT JOIN pg_catalog.pg_roles pr ON (pdb.datdba = pr.oid)
WHERE true
AND NOT pdb.datistemplate

ORDER BY pdb.datname"

I'm running on Windows 7 x64.

On a side note I've been using the pgql command line tool and pgadmin 3 for a few days without any problems.

Thanks,
Adam

Adam Bruss
Development Engineer
AWR Corporation/Simulation Technology & Applied Research
11520 N. Port Washington Rd., Suite 201
Mequon, WI 53092 USA
P: 1.262.240.0291 x104
F: 1.262.240.0294
E: abruss(at)awrcorp(dot)com
W: http://www.awrcorp.com

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2010-12-22 17:00:25 Re: extra TARGETENTRY when group by function( col )?
Previous Message Adrian Klaver 2010-12-22 16:45:32 Re: could not open relation...No such file or directory