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
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 |