Mantis - Quercus
Viewing Issue Advanced Details
2105 major always 10-22-07 14:01 11-14-07 19:33
rickburque  
mo  
normal  
closed 3.1.3  
fixed  
none    
none 3.1.4  
0002105: phpPgAdmin not working with quercus
I can connect to a postgresql database directly using unmodified php code in quercus (pg_connect working fine).

However when I attempt to run phpPgAdmin, the phpPgAdmin web page comes up I get a server error:

SQL error:
The server's client_encoding parameter was changed to UTF8. The JDBC driver requires client_encoding to be UNICODE for correct operation.

In statement:
SET CLIENT_ENCODING TO 'UTF8'

Failed to set client encoding in database.

The above errors are displayed directly on the webpage. I greped the phpPgAdmin php files for UTF8 and ENCODING but got no hits, leading me to thinkl that the errors are coming from quercus.

phpPgAdmin does not show up on your "known to work" php applications so I am wondering is this a known problem? Or am I the first one to try this?


phpPgadmin is working fine from standard apache mod_php.

Notes
(0002493)
mo   
11-14-07 19:31   
The attached patch fixes this problem.
(0002494)
mo   
11-14-07 19:33   
Added test cases:

php/437c.qa
php/437d.qa