Search Postgresql Archives

Error when using phpPgAdmin

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

W: http://www.awrcorp.com

 


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux