From: SourceForge.net <no...@so...> - 2010-10-13 10:23:58
|
Bugs item #3086563, was opened at 2010-10-13 10:23 Message generated for change (Tracker Item Submitted) made by You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3086563&group_id=37132 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Databases Group: 4.2.3 Status: Open Resolution: None Priority: 5 Private: No Submitted By: gabrimonfa () Assigned to: Nobody/Anonymous (nobody) Summary: Click on schema proposes to download redirect.php Initial Comment: Ubuntu 10.10 phppgadmin version 4.2.3 php version 5.3.3 postgresql server 8.3, client 8.4 firefox 3.6.10 Click on schema name proposes to download redirect.php instead of showing schema tables I think this may be a problem in ADODB problem or even in my PHP Proposed workaround, to change the file libraries/adodb/drivers/adodb-postgres64.inc.php on line 812 from $this->_errorMsg = @pg_last_error($this->_connectionID); to $this->_errorMsg = @pg_result_error($this->_connectionID); Backtrace: libraries/adodb/drivers/adodb-postgres64.inc.php line 812 $this->_errorMsg = @pg_last_error($this->_connectionID); libraries/adodb/drivers/adodb_postgres64.inc.php line 824 $e = $this->ErrorMsg(); classes/database/ADODB_base.php line 76 return $this->conn->ErrorNo(); classes/database/Postgres73.php line 116 return $this->execute($sql); classes/database/Postgres73.php line 84 $status = $this->setSearchPath($search_path); libraries/lib.inc.php line 183 $status = $data->setSchema($_REQUEST['schema']); ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3086563&group_id=37132 |
From: SourceForge.net <no...@so...> - 2010-10-16 19:26:51
|
Bugs item #3086563, was opened at 2010-10-13 12:23 Message generated for change (Settings changed) made by ioguix You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3086563&group_id=37132 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Databases Group: 4.2.3 Status: Open Resolution: None Priority: 5 Private: No Submitted By: gabrimonfa () >Assigned to: Guillaume `ioguix` de Rorthais (ioguix) Summary: Click on schema proposes to download redirect.php Initial Comment: Ubuntu 10.10 phppgadmin version 4.2.3 php version 5.3.3 postgresql server 8.3, client 8.4 firefox 3.6.10 Click on schema name proposes to download redirect.php instead of showing schema tables I think this may be a problem in ADODB problem or even in my PHP Proposed workaround, to change the file libraries/adodb/drivers/adodb-postgres64.inc.php on line 812 from $this->_errorMsg = @pg_last_error($this->_connectionID); to $this->_errorMsg = @pg_result_error($this->_connectionID); Backtrace: libraries/adodb/drivers/adodb-postgres64.inc.php line 812 $this->_errorMsg = @pg_last_error($this->_connectionID); libraries/adodb/drivers/adodb_postgres64.inc.php line 824 $e = $this->ErrorMsg(); classes/database/ADODB_base.php line 76 return $this->conn->ErrorNo(); classes/database/Postgres73.php line 116 return $this->execute($sql); classes/database/Postgres73.php line 84 $status = $this->setSearchPath($search_path); libraries/lib.inc.php line 183 $status = $data->setSchema($_REQUEST['schema']); ---------------------------------------------------------------------- >Comment By: Guillaume `ioguix` de Rorthais (ioguix) Date: 2010-10-16 21:26 Message: Hello guys, First of all, PPA 4.2 is NOT compatible with 8.4. You should use PPA 5.0-beta2 for 8.4 and 9.0. http://github.com/xzilla/phppgadmin/archives/master I selected your language (we had some bugs about that few weeks ago) but I couldn't reproduce this bug :-( Honestly, the fix seems just wrong to me. "pg_result_error" takes a *result* resource as argument, not a connection one. So it seems to me that this fix actually will introduce a new bug :-(( Please, could you confirm this bug exists with PPA 5.0 ? What are your database encoding ? do you have any special/accentued chars in your table's names or in their comments ? Did you check your PostgreSQL logs ? could you set up your postgresql with : log_min_messages = info log_min_duration_statement = 0 Reload you conf and report here any useful information from your postgres logs ? Thank you in advance. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3086563&group_id=37132 |
From: SourceForge.net <no...@so...> - 2010-10-16 19:46:09
|
Bugs item #3086563, was opened at 2010-10-13 14:23 Message generated for change (Comment added) made by jerromo You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3086563&group_id=37132 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Databases Group: 4.2.3 Status: Open Resolution: None Priority: 5 Private: No Submitted By: gabrimonfa () Assigned to: Guillaume `ioguix` de Rorthais (ioguix) Summary: Click on schema proposes to download redirect.php Initial Comment: Ubuntu 10.10 phppgadmin version 4.2.3 php version 5.3.3 postgresql server 8.3, client 8.4 firefox 3.6.10 Click on schema name proposes to download redirect.php instead of showing schema tables I think this may be a problem in ADODB problem or even in my PHP Proposed workaround, to change the file libraries/adodb/drivers/adodb-postgres64.inc.php on line 812 from $this->_errorMsg = @pg_last_error($this->_connectionID); to $this->_errorMsg = @pg_result_error($this->_connectionID); Backtrace: libraries/adodb/drivers/adodb-postgres64.inc.php line 812 $this->_errorMsg = @pg_last_error($this->_connectionID); libraries/adodb/drivers/adodb_postgres64.inc.php line 824 $e = $this->ErrorMsg(); classes/database/ADODB_base.php line 76 return $this->conn->ErrorNo(); classes/database/Postgres73.php line 116 return $this->execute($sql); classes/database/Postgres73.php line 84 $status = $this->setSearchPath($search_path); libraries/lib.inc.php line 183 $status = $data->setSchema($_REQUEST['schema']); ---------------------------------------------------------------------- Comment By: Jerromo (jerromo) Date: 2010-10-16 23:46 Message: bug in adodb in php 5.3.3 (phpPgAdmin 5.0-beta2 (PHP 5.3.3-1ubuntu9) postgresql 8.4) http://sourceforge.net/projects/phppgadmin/forums/forum/115884/topic/3890018 ---------------------------------------------------------------------- Comment By: Guillaume `ioguix` de Rorthais (ioguix) Date: 2010-10-16 23:26 Message: Hello guys, First of all, PPA 4.2 is NOT compatible with 8.4. You should use PPA 5.0-beta2 for 8.4 and 9.0. http://github.com/xzilla/phppgadmin/archives/master I selected your language (we had some bugs about that few weeks ago) but I couldn't reproduce this bug :-( Honestly, the fix seems just wrong to me. "pg_result_error" takes a *result* resource as argument, not a connection one. So it seems to me that this fix actually will introduce a new bug :-(( Please, could you confirm this bug exists with PPA 5.0 ? What are your database encoding ? do you have any special/accentued chars in your table's names or in their comments ? Did you check your PostgreSQL logs ? could you set up your postgresql with : log_min_messages = info log_min_duration_statement = 0 Reload you conf and report here any useful information from your postgres logs ? Thank you in advance. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3086563&group_id=37132 |
From: SourceForge.net <no...@so...> - 2010-10-18 07:44:58
|
Bugs item #3086563, was opened at 2010-10-13 12:23 Message generated for change (Comment added) made by ioguix You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3086563&group_id=37132 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Databases Group: 4.2.3 Status: Open Resolution: None Priority: 5 Private: No Submitted By: gabrimonfa () Assigned to: Guillaume `ioguix` de Rorthais (ioguix) Summary: Click on schema proposes to download redirect.php Initial Comment: Ubuntu 10.10 phppgadmin version 4.2.3 php version 5.3.3 postgresql server 8.3, client 8.4 firefox 3.6.10 Click on schema name proposes to download redirect.php instead of showing schema tables I think this may be a problem in ADODB problem or even in my PHP Proposed workaround, to change the file libraries/adodb/drivers/adodb-postgres64.inc.php on line 812 from $this->_errorMsg = @pg_last_error($this->_connectionID); to $this->_errorMsg = @pg_result_error($this->_connectionID); Backtrace: libraries/adodb/drivers/adodb-postgres64.inc.php line 812 $this->_errorMsg = @pg_last_error($this->_connectionID); libraries/adodb/drivers/adodb_postgres64.inc.php line 824 $e = $this->ErrorMsg(); classes/database/ADODB_base.php line 76 return $this->conn->ErrorNo(); classes/database/Postgres73.php line 116 return $this->execute($sql); classes/database/Postgres73.php line 84 $status = $this->setSearchPath($search_path); libraries/lib.inc.php line 183 $status = $data->setSchema($_REQUEST['schema']); ---------------------------------------------------------------------- >Comment By: Guillaume `ioguix` de Rorthais (ioguix) Date: 2010-10-18 09:44 Message: Jerromo, could you please give some more details about your last message ? Did I miss something in this thread on ppa-help or did you forget to read my last answer on this bug report *completly* ? In my opinion, this fix you are providing seems to be buggy. Please, refer to the PHP doc : http://php.net/pg_result_error ---------------------------------------------------------------------- Comment By: Jerromo (jerromo) Date: 2010-10-16 21:46 Message: bug in adodb in php 5.3.3 (phpPgAdmin 5.0-beta2 (PHP 5.3.3-1ubuntu9) postgresql 8.4) http://sourceforge.net/projects/phppgadmin/forums/forum/115884/topic/3890018 ---------------------------------------------------------------------- Comment By: Guillaume `ioguix` de Rorthais (ioguix) Date: 2010-10-16 21:26 Message: Hello guys, First of all, PPA 4.2 is NOT compatible with 8.4. You should use PPA 5.0-beta2 for 8.4 and 9.0. http://github.com/xzilla/phppgadmin/archives/master I selected your language (we had some bugs about that few weeks ago) but I couldn't reproduce this bug :-( Honestly, the fix seems just wrong to me. "pg_result_error" takes a *result* resource as argument, not a connection one. So it seems to me that this fix actually will introduce a new bug :-(( Please, could you confirm this bug exists with PPA 5.0 ? What are your database encoding ? do you have any special/accentued chars in your table's names or in their comments ? Did you check your PostgreSQL logs ? could you set up your postgresql with : log_min_messages = info log_min_duration_statement = 0 Reload you conf and report here any useful information from your postgres logs ? Thank you in advance. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3086563&group_id=37132 |
From: SourceForge.net <no...@so...> - 2010-10-18 07:45:39
|
Bugs item #3086563, was opened at 2010-10-13 12:23 Message generated for change (Comment added) made by ioguix You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3086563&group_id=37132 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Databases Group: 4.2.3 Status: Open Resolution: None Priority: 5 Private: No Submitted By: gabrimonfa () Assigned to: Guillaume `ioguix` de Rorthais (ioguix) Summary: Click on schema proposes to download redirect.php Initial Comment: Ubuntu 10.10 phppgadmin version 4.2.3 php version 5.3.3 postgresql server 8.3, client 8.4 firefox 3.6.10 Click on schema name proposes to download redirect.php instead of showing schema tables I think this may be a problem in ADODB problem or even in my PHP Proposed workaround, to change the file libraries/adodb/drivers/adodb-postgres64.inc.php on line 812 from $this->_errorMsg = @pg_last_error($this->_connectionID); to $this->_errorMsg = @pg_result_error($this->_connectionID); Backtrace: libraries/adodb/drivers/adodb-postgres64.inc.php line 812 $this->_errorMsg = @pg_last_error($this->_connectionID); libraries/adodb/drivers/adodb_postgres64.inc.php line 824 $e = $this->ErrorMsg(); classes/database/ADODB_base.php line 76 return $this->conn->ErrorNo(); classes/database/Postgres73.php line 116 return $this->execute($sql); classes/database/Postgres73.php line 84 $status = $this->setSearchPath($search_path); libraries/lib.inc.php line 183 $status = $data->setSchema($_REQUEST['schema']); ---------------------------------------------------------------------- >Comment By: Guillaume `ioguix` de Rorthais (ioguix) Date: 2010-10-18 09:45 Message: And please, if you want to help me fix this issue, answer my questions from my first answer. Thank you in advance. ---------------------------------------------------------------------- Comment By: Guillaume `ioguix` de Rorthais (ioguix) Date: 2010-10-18 09:44 Message: Jerromo, could you please give some more details about your last message ? Did I miss something in this thread on ppa-help or did you forget to read my last answer on this bug report *completly* ? In my opinion, this fix you are providing seems to be buggy. Please, refer to the PHP doc : http://php.net/pg_result_error ---------------------------------------------------------------------- Comment By: Jerromo (jerromo) Date: 2010-10-16 21:46 Message: bug in adodb in php 5.3.3 (phpPgAdmin 5.0-beta2 (PHP 5.3.3-1ubuntu9) postgresql 8.4) http://sourceforge.net/projects/phppgadmin/forums/forum/115884/topic/3890018 ---------------------------------------------------------------------- Comment By: Guillaume `ioguix` de Rorthais (ioguix) Date: 2010-10-16 21:26 Message: Hello guys, First of all, PPA 4.2 is NOT compatible with 8.4. You should use PPA 5.0-beta2 for 8.4 and 9.0. http://github.com/xzilla/phppgadmin/archives/master I selected your language (we had some bugs about that few weeks ago) but I couldn't reproduce this bug :-( Honestly, the fix seems just wrong to me. "pg_result_error" takes a *result* resource as argument, not a connection one. So it seems to me that this fix actually will introduce a new bug :-(( Please, could you confirm this bug exists with PPA 5.0 ? What are your database encoding ? do you have any special/accentued chars in your table's names or in their comments ? Did you check your PostgreSQL logs ? could you set up your postgresql with : log_min_messages = info log_min_duration_statement = 0 Reload you conf and report here any useful information from your postgres logs ? Thank you in advance. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3086563&group_id=37132 |
From: SourceForge.net <no...@so...> - 2010-10-18 10:48:42
|
Bugs item #3086563, was opened at 2010-10-13 14:23 Message generated for change (Comment added) made by jerromo You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3086563&group_id=37132 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Databases Group: 4.2.3 Status: Open Resolution: None Priority: 5 Private: No Submitted By: gabrimonfa () Assigned to: Guillaume `ioguix` de Rorthais (ioguix) Summary: Click on schema proposes to download redirect.php Initial Comment: Ubuntu 10.10 phppgadmin version 4.2.3 php version 5.3.3 postgresql server 8.3, client 8.4 firefox 3.6.10 Click on schema name proposes to download redirect.php instead of showing schema tables I think this may be a problem in ADODB problem or even in my PHP Proposed workaround, to change the file libraries/adodb/drivers/adodb-postgres64.inc.php on line 812 from $this->_errorMsg = @pg_last_error($this->_connectionID); to $this->_errorMsg = @pg_result_error($this->_connectionID); Backtrace: libraries/adodb/drivers/adodb-postgres64.inc.php line 812 $this->_errorMsg = @pg_last_error($this->_connectionID); libraries/adodb/drivers/adodb_postgres64.inc.php line 824 $e = $this->ErrorMsg(); classes/database/ADODB_base.php line 76 return $this->conn->ErrorNo(); classes/database/Postgres73.php line 116 return $this->execute($sql); classes/database/Postgres73.php line 84 $status = $this->setSearchPath($search_path); libraries/lib.inc.php line 183 $status = $data->setSchema($_REQUEST['schema']); ---------------------------------------------------------------------- Comment By: Jerromo (jerromo) Date: 2010-10-18 14:48 Message: Sorry, my english is very poor. Use: Ubuntu 10.10 PostgreSQL 8.4.5 (from dist repository) Apache 2.2.16 (from dist repository) PHP 5.3.3 (from dist repository) phpPgAdmin 5.0 (from http://github.com/xzilla/phppgadmin/archives/master) Request: GET /redirect.php?subject=schema&server=%3A5432%3Aallow&database=postgres&schema=public HTTP/1.1 Response: HTTP/0.9 200 OK and body size = 0 postgres log: 2010-10-18 13:30:58 MSD LOG: duration: 0.124 ms statement: set datestyle='ISO' 2010-10-18 13:30:58 MSD LOG: duration: 0.287 ms statement: select version() 2010-10-18 13:30:58 MSD LOG: duration: 1.605 ms statement: select oid,typname from pg_type 2010-10-18 13:30:58 MSD LOG: duration: 0.252 ms statement: SELECT current_schemas(false) AS search_path 2010-10-18 13:30:58 MSD LOG: duration: 0.048 ms statement: SET SEARCH_PATH TO "public","public" 2010-10-18 13:30:58 MSD LOG: unexpected EOF on client connection Apache error log: clear database: postgres (default from dist) > What are your database encoding ? UTF8 > do you have any special/accentued chars in your table's names or in their comments ? NO PS. Also on another project uses adodb exact same problem. ---------------------------------------------------------------------- Comment By: Guillaume `ioguix` de Rorthais (ioguix) Date: 2010-10-18 11:45 Message: And please, if you want to help me fix this issue, answer my questions from my first answer. Thank you in advance. ---------------------------------------------------------------------- Comment By: Guillaume `ioguix` de Rorthais (ioguix) Date: 2010-10-18 11:44 Message: Jerromo, could you please give some more details about your last message ? Did I miss something in this thread on ppa-help or did you forget to read my last answer on this bug report *completly* ? In my opinion, this fix you are providing seems to be buggy. Please, refer to the PHP doc : http://php.net/pg_result_error ---------------------------------------------------------------------- Comment By: Jerromo (jerromo) Date: 2010-10-16 23:46 Message: bug in adodb in php 5.3.3 (phpPgAdmin 5.0-beta2 (PHP 5.3.3-1ubuntu9) postgresql 8.4) http://sourceforge.net/projects/phppgadmin/forums/forum/115884/topic/3890018 ---------------------------------------------------------------------- Comment By: Guillaume `ioguix` de Rorthais (ioguix) Date: 2010-10-16 23:26 Message: Hello guys, First of all, PPA 4.2 is NOT compatible with 8.4. You should use PPA 5.0-beta2 for 8.4 and 9.0. http://github.com/xzilla/phppgadmin/archives/master I selected your language (we had some bugs about that few weeks ago) but I couldn't reproduce this bug :-( Honestly, the fix seems just wrong to me. "pg_result_error" takes a *result* resource as argument, not a connection one. So it seems to me that this fix actually will introduce a new bug :-(( Please, could you confirm this bug exists with PPA 5.0 ? What are your database encoding ? do you have any special/accentued chars in your table's names or in their comments ? Did you check your PostgreSQL logs ? could you set up your postgresql with : log_min_messages = info log_min_duration_statement = 0 Reload you conf and report here any useful information from your postgres logs ? Thank you in advance. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3086563&group_id=37132 |
From: SourceForge.net <no...@so...> - 2010-10-18 17:18:52
|
Bugs item #3086563, was opened at 2010-10-13 06:23 Message generated for change (Comment added) made by jspezia You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3086563&group_id=37132 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Databases Group: 4.2.3 Status: Open Resolution: None Priority: 5 Private: No Submitted By: gabrimonfa () Assigned to: Guillaume `ioguix` de Rorthais (ioguix) Summary: Click on schema proposes to download redirect.php Initial Comment: Ubuntu 10.10 phppgadmin version 4.2.3 php version 5.3.3 postgresql server 8.3, client 8.4 firefox 3.6.10 Click on schema name proposes to download redirect.php instead of showing schema tables I think this may be a problem in ADODB problem or even in my PHP Proposed workaround, to change the file libraries/adodb/drivers/adodb-postgres64.inc.php on line 812 from $this->_errorMsg = @pg_last_error($this->_connectionID); to $this->_errorMsg = @pg_result_error($this->_connectionID); Backtrace: libraries/adodb/drivers/adodb-postgres64.inc.php line 812 $this->_errorMsg = @pg_last_error($this->_connectionID); libraries/adodb/drivers/adodb_postgres64.inc.php line 824 $e = $this->ErrorMsg(); classes/database/ADODB_base.php line 76 return $this->conn->ErrorNo(); classes/database/Postgres73.php line 116 return $this->execute($sql); classes/database/Postgres73.php line 84 $status = $this->setSearchPath($search_path); libraries/lib.inc.php line 183 $status = $data->setSchema($_REQUEST['schema']); ---------------------------------------------------------------------- Comment By: Jamiel Spezia (jspezia) Date: 2010-10-18 13:18 Message: Hello! I'm having the same problem. I noticed the problem when I used the function pg_last_error (). The browser execute the download the file test.php when is run the following script in apache: Filename: test.php <?php $bd = pg_connect("dbname=postgres user=postgres"); pg_last_error($bd); ?> The script performs successfully when execute in command line. I belive where the problem is to use php and apache. Versions: - PHP 5.3.3-1ubuntu9 with Suhosin-Patch (cli) (built: Sep 20 2010 20:39:59) - Apache/2.2.16 (Ubuntu) - psql (PostgreSQL) 8.4.5 - Kubuntu 10.10 Will does that the problem is some segmentation fault when executing the function?. Because the php returns no error. Sorry my english. ---------------------------------------------------------------------- Comment By: Jerromo (jerromo) Date: 2010-10-18 06:48 Message: Sorry, my english is very poor. Use: Ubuntu 10.10 PostgreSQL 8.4.5 (from dist repository) Apache 2.2.16 (from dist repository) PHP 5.3.3 (from dist repository) phpPgAdmin 5.0 (from http://github.com/xzilla/phppgadmin/archives/master) Request: GET /redirect.php?subject=schema&server=%3A5432%3Aallow&database=postgres&schema=public HTTP/1.1 Response: HTTP/0.9 200 OK and body size = 0 postgres log: 2010-10-18 13:30:58 MSD LOG: duration: 0.124 ms statement: set datestyle='ISO' 2010-10-18 13:30:58 MSD LOG: duration: 0.287 ms statement: select version() 2010-10-18 13:30:58 MSD LOG: duration: 1.605 ms statement: select oid,typname from pg_type 2010-10-18 13:30:58 MSD LOG: duration: 0.252 ms statement: SELECT current_schemas(false) AS search_path 2010-10-18 13:30:58 MSD LOG: duration: 0.048 ms statement: SET SEARCH_PATH TO "public","public" 2010-10-18 13:30:58 MSD LOG: unexpected EOF on client connection Apache error log: clear database: postgres (default from dist) > What are your database encoding ? UTF8 > do you have any special/accentued chars in your table's names or in their comments ? NO PS. Also on another project uses adodb exact same problem. ---------------------------------------------------------------------- Comment By: Guillaume `ioguix` de Rorthais (ioguix) Date: 2010-10-18 03:45 Message: And please, if you want to help me fix this issue, answer my questions from my first answer. Thank you in advance. ---------------------------------------------------------------------- Comment By: Guillaume `ioguix` de Rorthais (ioguix) Date: 2010-10-18 03:44 Message: Jerromo, could you please give some more details about your last message ? Did I miss something in this thread on ppa-help or did you forget to read my last answer on this bug report *completly* ? In my opinion, this fix you are providing seems to be buggy. Please, refer to the PHP doc : http://php.net/pg_result_error ---------------------------------------------------------------------- Comment By: Jerromo (jerromo) Date: 2010-10-16 15:46 Message: bug in adodb in php 5.3.3 (phpPgAdmin 5.0-beta2 (PHP 5.3.3-1ubuntu9) postgresql 8.4) http://sourceforge.net/projects/phppgadmin/forums/forum/115884/topic/3890018 ---------------------------------------------------------------------- Comment By: Guillaume `ioguix` de Rorthais (ioguix) Date: 2010-10-16 15:26 Message: Hello guys, First of all, PPA 4.2 is NOT compatible with 8.4. You should use PPA 5.0-beta2 for 8.4 and 9.0. http://github.com/xzilla/phppgadmin/archives/master I selected your language (we had some bugs about that few weeks ago) but I couldn't reproduce this bug :-( Honestly, the fix seems just wrong to me. "pg_result_error" takes a *result* resource as argument, not a connection one. So it seems to me that this fix actually will introduce a new bug :-(( Please, could you confirm this bug exists with PPA 5.0 ? What are your database encoding ? do you have any special/accentued chars in your table's names or in their comments ? Did you check your PostgreSQL logs ? could you set up your postgresql with : log_min_messages = info log_min_duration_statement = 0 Reload you conf and report here any useful information from your postgres logs ? Thank you in advance. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3086563&group_id=37132 |
From: SourceForge.net <no...@so...> - 2010-10-18 21:18:49
|
Bugs item #3086563, was opened at 2010-10-13 12:23 Message generated for change (Comment added) made by ioguix You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3086563&group_id=37132 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Databases Group: 4.2.3 Status: Open Resolution: None Priority: 5 Private: No Submitted By: gabrimonfa () Assigned to: Guillaume `ioguix` de Rorthais (ioguix) Summary: Click on schema proposes to download redirect.php Initial Comment: Ubuntu 10.10 phppgadmin version 4.2.3 php version 5.3.3 postgresql server 8.3, client 8.4 firefox 3.6.10 Click on schema name proposes to download redirect.php instead of showing schema tables I think this may be a problem in ADODB problem or even in my PHP Proposed workaround, to change the file libraries/adodb/drivers/adodb-postgres64.inc.php on line 812 from $this->_errorMsg = @pg_last_error($this->_connectionID); to $this->_errorMsg = @pg_result_error($this->_connectionID); Backtrace: libraries/adodb/drivers/adodb-postgres64.inc.php line 812 $this->_errorMsg = @pg_last_error($this->_connectionID); libraries/adodb/drivers/adodb_postgres64.inc.php line 824 $e = $this->ErrorMsg(); classes/database/ADODB_base.php line 76 return $this->conn->ErrorNo(); classes/database/Postgres73.php line 116 return $this->execute($sql); classes/database/Postgres73.php line 84 $status = $this->setSearchPath($search_path); libraries/lib.inc.php line 183 $status = $data->setSchema($_REQUEST['schema']); ---------------------------------------------------------------------- >Comment By: Guillaume `ioguix` de Rorthais (ioguix) Date: 2010-10-18 23:18 Message: Hello, Very interesting. I am using : - Lighttpd 1.4.28 - PHP 5.3.2 CGI The demo server ( http://phppgadmin.kattare.com:81/phppgadmin-devel/ ) is running : - Lighttpd 1.4.28 - PHP 5.3.3 CGI Both are ok. So it seems it might be a bug in the PHP apache module. Could you please remove the '@' in front of "pg_last_error" so we can eventually catch a real PHP error ? You can try to run Apache with the -X option. If I understand it correctly, apache will not fork so you might see it crashing. thank you for your tests ! ---------------------------------------------------------------------- Comment By: Jamiel Spezia (jspezia) Date: 2010-10-18 19:18 Message: Hello! I'm having the same problem. I noticed the problem when I used the function pg_last_error (). The browser execute the download the file test.php when is run the following script in apache: Filename: test.php <?php $bd = pg_connect("dbname=postgres user=postgres"); pg_last_error($bd); ?> The script performs successfully when execute in command line. I belive where the problem is to use php and apache. Versions: - PHP 5.3.3-1ubuntu9 with Suhosin-Patch (cli) (built: Sep 20 2010 20:39:59) - Apache/2.2.16 (Ubuntu) - psql (PostgreSQL) 8.4.5 - Kubuntu 10.10 Will does that the problem is some segmentation fault when executing the function?. Because the php returns no error. Sorry my english. ---------------------------------------------------------------------- Comment By: Jerromo (jerromo) Date: 2010-10-18 12:48 Message: Sorry, my english is very poor. Use: Ubuntu 10.10 PostgreSQL 8.4.5 (from dist repository) Apache 2.2.16 (from dist repository) PHP 5.3.3 (from dist repository) phpPgAdmin 5.0 (from http://github.com/xzilla/phppgadmin/archives/master) Request: GET /redirect.php?subject=schema&server=%3A5432%3Aallow&database=postgres&schema=public HTTP/1.1 Response: HTTP/0.9 200 OK and body size = 0 postgres log: 2010-10-18 13:30:58 MSD LOG: duration: 0.124 ms statement: set datestyle='ISO' 2010-10-18 13:30:58 MSD LOG: duration: 0.287 ms statement: select version() 2010-10-18 13:30:58 MSD LOG: duration: 1.605 ms statement: select oid,typname from pg_type 2010-10-18 13:30:58 MSD LOG: duration: 0.252 ms statement: SELECT current_schemas(false) AS search_path 2010-10-18 13:30:58 MSD LOG: duration: 0.048 ms statement: SET SEARCH_PATH TO "public","public" 2010-10-18 13:30:58 MSD LOG: unexpected EOF on client connection Apache error log: clear database: postgres (default from dist) > What are your database encoding ? UTF8 > do you have any special/accentued chars in your table's names or in their comments ? NO PS. Also on another project uses adodb exact same problem. ---------------------------------------------------------------------- Comment By: Guillaume `ioguix` de Rorthais (ioguix) Date: 2010-10-18 09:45 Message: And please, if you want to help me fix this issue, answer my questions from my first answer. Thank you in advance. ---------------------------------------------------------------------- Comment By: Guillaume `ioguix` de Rorthais (ioguix) Date: 2010-10-18 09:44 Message: Jerromo, could you please give some more details about your last message ? Did I miss something in this thread on ppa-help or did you forget to read my last answer on this bug report *completly* ? In my opinion, this fix you are providing seems to be buggy. Please, refer to the PHP doc : http://php.net/pg_result_error ---------------------------------------------------------------------- Comment By: Jerromo (jerromo) Date: 2010-10-16 21:46 Message: bug in adodb in php 5.3.3 (phpPgAdmin 5.0-beta2 (PHP 5.3.3-1ubuntu9) postgresql 8.4) http://sourceforge.net/projects/phppgadmin/forums/forum/115884/topic/3890018 ---------------------------------------------------------------------- Comment By: Guillaume `ioguix` de Rorthais (ioguix) Date: 2010-10-16 21:26 Message: Hello guys, First of all, PPA 4.2 is NOT compatible with 8.4. You should use PPA 5.0-beta2 for 8.4 and 9.0. http://github.com/xzilla/phppgadmin/archives/master I selected your language (we had some bugs about that few weeks ago) but I couldn't reproduce this bug :-( Honestly, the fix seems just wrong to me. "pg_result_error" takes a *result* resource as argument, not a connection one. So it seems to me that this fix actually will introduce a new bug :-(( Please, could you confirm this bug exists with PPA 5.0 ? What are your database encoding ? do you have any special/accentued chars in your table's names or in their comments ? Did you check your PostgreSQL logs ? could you set up your postgresql with : log_min_messages = info log_min_duration_statement = 0 Reload you conf and report here any useful information from your postgres logs ? Thank you in advance. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3086563&group_id=37132 |
From: SourceForge.net <no...@so...> - 2010-10-19 16:08:10
|
Bugs item #3086563, was opened at 2010-10-13 06:23 Message generated for change (Comment added) made by jspezia You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3086563&group_id=37132 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Databases Group: 4.2.3 Status: Open Resolution: None Priority: 5 Private: No Submitted By: gabrimonfa () Assigned to: Guillaume `ioguix` de Rorthais (ioguix) Summary: Click on schema proposes to download redirect.php Initial Comment: Ubuntu 10.10 phppgadmin version 4.2.3 php version 5.3.3 postgresql server 8.3, client 8.4 firefox 3.6.10 Click on schema name proposes to download redirect.php instead of showing schema tables I think this may be a problem in ADODB problem or even in my PHP Proposed workaround, to change the file libraries/adodb/drivers/adodb-postgres64.inc.php on line 812 from $this->_errorMsg = @pg_last_error($this->_connectionID); to $this->_errorMsg = @pg_result_error($this->_connectionID); Backtrace: libraries/adodb/drivers/adodb-postgres64.inc.php line 812 $this->_errorMsg = @pg_last_error($this->_connectionID); libraries/adodb/drivers/adodb_postgres64.inc.php line 824 $e = $this->ErrorMsg(); classes/database/ADODB_base.php line 76 return $this->conn->ErrorNo(); classes/database/Postgres73.php line 116 return $this->execute($sql); classes/database/Postgres73.php line 84 $status = $this->setSearchPath($search_path); libraries/lib.inc.php line 183 $status = $data->setSchema($_REQUEST['schema']); ---------------------------------------------------------------------- Comment By: Jamiel Spezia (jspezia) Date: 2010-10-19 12:08 Message: Hello. I ran Apache with the option -X. The result was: jamiel@eagle:/etc/apache2$ sudo /etc/init.d/apache2 start * Starting web server apache2 [Tue Oct 19 13:45:26 2010] [warn] NameVirtualHost *:80 has no VirtualHosts Action 'start' failed. The Apache error log may have more information. I verified the files log and there was no register of error in the files. I checked the followings log files: /var/log/apache2/access.log /var/log/apache2/error.log /var/log/apache2/gnuteca.eagle-access.log /var/log/apache2/gnuteca.eagle-error.log I believe where the bug is in the PHP apache module. tank you ---------------------------------------------------------------------- Comment By: Guillaume `ioguix` de Rorthais (ioguix) Date: 2010-10-18 17:18 Message: Hello, Very interesting. I am using : - Lighttpd 1.4.28 - PHP 5.3.2 CGI The demo server ( http://phppgadmin.kattare.com:81/phppgadmin-devel/ ) is running : - Lighttpd 1.4.28 - PHP 5.3.3 CGI Both are ok. So it seems it might be a bug in the PHP apache module. Could you please remove the '@' in front of "pg_last_error" so we can eventually catch a real PHP error ? You can try to run Apache with the -X option. If I understand it correctly, apache will not fork so you might see it crashing. thank you for your tests ! ---------------------------------------------------------------------- Comment By: Jamiel Spezia (jspezia) Date: 2010-10-18 13:18 Message: Hello! I'm having the same problem. I noticed the problem when I used the function pg_last_error (). The browser execute the download the file test.php when is run the following script in apache: Filename: test.php <?php $bd = pg_connect("dbname=postgres user=postgres"); pg_last_error($bd); ?> The script performs successfully when execute in command line. I belive where the problem is to use php and apache. Versions: - PHP 5.3.3-1ubuntu9 with Suhosin-Patch (cli) (built: Sep 20 2010 20:39:59) - Apache/2.2.16 (Ubuntu) - psql (PostgreSQL) 8.4.5 - Kubuntu 10.10 Will does that the problem is some segmentation fault when executing the function?. Because the php returns no error. Sorry my english. ---------------------------------------------------------------------- Comment By: Jerromo (jerromo) Date: 2010-10-18 06:48 Message: Sorry, my english is very poor. Use: Ubuntu 10.10 PostgreSQL 8.4.5 (from dist repository) Apache 2.2.16 (from dist repository) PHP 5.3.3 (from dist repository) phpPgAdmin 5.0 (from http://github.com/xzilla/phppgadmin/archives/master) Request: GET /redirect.php?subject=schema&server=%3A5432%3Aallow&database=postgres&schema=public HTTP/1.1 Response: HTTP/0.9 200 OK and body size = 0 postgres log: 2010-10-18 13:30:58 MSD LOG: duration: 0.124 ms statement: set datestyle='ISO' 2010-10-18 13:30:58 MSD LOG: duration: 0.287 ms statement: select version() 2010-10-18 13:30:58 MSD LOG: duration: 1.605 ms statement: select oid,typname from pg_type 2010-10-18 13:30:58 MSD LOG: duration: 0.252 ms statement: SELECT current_schemas(false) AS search_path 2010-10-18 13:30:58 MSD LOG: duration: 0.048 ms statement: SET SEARCH_PATH TO "public","public" 2010-10-18 13:30:58 MSD LOG: unexpected EOF on client connection Apache error log: clear database: postgres (default from dist) > What are your database encoding ? UTF8 > do you have any special/accentued chars in your table's names or in their comments ? NO PS. Also on another project uses adodb exact same problem. ---------------------------------------------------------------------- Comment By: Guillaume `ioguix` de Rorthais (ioguix) Date: 2010-10-18 03:45 Message: And please, if you want to help me fix this issue, answer my questions from my first answer. Thank you in advance. ---------------------------------------------------------------------- Comment By: Guillaume `ioguix` de Rorthais (ioguix) Date: 2010-10-18 03:44 Message: Jerromo, could you please give some more details about your last message ? Did I miss something in this thread on ppa-help or did you forget to read my last answer on this bug report *completly* ? In my opinion, this fix you are providing seems to be buggy. Please, refer to the PHP doc : http://php.net/pg_result_error ---------------------------------------------------------------------- Comment By: Jerromo (jerromo) Date: 2010-10-16 15:46 Message: bug in adodb in php 5.3.3 (phpPgAdmin 5.0-beta2 (PHP 5.3.3-1ubuntu9) postgresql 8.4) http://sourceforge.net/projects/phppgadmin/forums/forum/115884/topic/3890018 ---------------------------------------------------------------------- Comment By: Guillaume `ioguix` de Rorthais (ioguix) Date: 2010-10-16 15:26 Message: Hello guys, First of all, PPA 4.2 is NOT compatible with 8.4. You should use PPA 5.0-beta2 for 8.4 and 9.0. http://github.com/xzilla/phppgadmin/archives/master I selected your language (we had some bugs about that few weeks ago) but I couldn't reproduce this bug :-( Honestly, the fix seems just wrong to me. "pg_result_error" takes a *result* resource as argument, not a connection one. So it seems to me that this fix actually will introduce a new bug :-(( Please, could you confirm this bug exists with PPA 5.0 ? What are your database encoding ? do you have any special/accentued chars in your table's names or in their comments ? Did you check your PostgreSQL logs ? could you set up your postgresql with : log_min_messages = info log_min_duration_statement = 0 Reload you conf and report here any useful information from your postgres logs ? Thank you in advance. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3086563&group_id=37132 |
From: SourceForge.net <no...@so...> - 2010-10-19 16:16:47
|
Bugs item #3086563, was opened at 2010-10-13 12:23 Message generated for change (Comment added) made by ioguix You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3086563&group_id=37132 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Databases Group: 4.2.3 Status: Open Resolution: None Priority: 5 Private: No Submitted By: gabrimonfa () Assigned to: Guillaume `ioguix` de Rorthais (ioguix) Summary: Click on schema proposes to download redirect.php Initial Comment: Ubuntu 10.10 phppgadmin version 4.2.3 php version 5.3.3 postgresql server 8.3, client 8.4 firefox 3.6.10 Click on schema name proposes to download redirect.php instead of showing schema tables I think this may be a problem in ADODB problem or even in my PHP Proposed workaround, to change the file libraries/adodb/drivers/adodb-postgres64.inc.php on line 812 from $this->_errorMsg = @pg_last_error($this->_connectionID); to $this->_errorMsg = @pg_result_error($this->_connectionID); Backtrace: libraries/adodb/drivers/adodb-postgres64.inc.php line 812 $this->_errorMsg = @pg_last_error($this->_connectionID); libraries/adodb/drivers/adodb_postgres64.inc.php line 824 $e = $this->ErrorMsg(); classes/database/ADODB_base.php line 76 return $this->conn->ErrorNo(); classes/database/Postgres73.php line 116 return $this->execute($sql); classes/database/Postgres73.php line 84 $status = $this->setSearchPath($search_path); libraries/lib.inc.php line 183 $status = $data->setSchema($_REQUEST['schema']); ---------------------------------------------------------------------- >Comment By: Guillaume `ioguix` de Rorthais (ioguix) Date: 2010-10-19 18:16 Message: Hello Jspezia, I believe you couldn't even start Apache here. You are not supposed to start it with /etc/init.d/apache2, but directly by hand from a terminal. As it should be able to fork, the processus shoudl stay in the foreground and might crash as soon as you play with PPA... ---------------------------------------------------------------------- Comment By: Jamiel Spezia (jspezia) Date: 2010-10-19 18:08 Message: Hello. I ran Apache with the option -X. The result was: jamiel@eagle:/etc/apache2$ sudo /etc/init.d/apache2 start * Starting web server apache2 [Tue Oct 19 13:45:26 2010] [warn] NameVirtualHost *:80 has no VirtualHosts Action 'start' failed. The Apache error log may have more information. I verified the files log and there was no register of error in the files. I checked the followings log files: /var/log/apache2/access.log /var/log/apache2/error.log /var/log/apache2/gnuteca.eagle-access.log /var/log/apache2/gnuteca.eagle-error.log I believe where the bug is in the PHP apache module. tank you ---------------------------------------------------------------------- Comment By: Guillaume `ioguix` de Rorthais (ioguix) Date: 2010-10-18 23:18 Message: Hello, Very interesting. I am using : - Lighttpd 1.4.28 - PHP 5.3.2 CGI The demo server ( http://phppgadmin.kattare.com:81/phppgadmin-devel/ ) is running : - Lighttpd 1.4.28 - PHP 5.3.3 CGI Both are ok. So it seems it might be a bug in the PHP apache module. Could you please remove the '@' in front of "pg_last_error" so we can eventually catch a real PHP error ? You can try to run Apache with the -X option. If I understand it correctly, apache will not fork so you might see it crashing. thank you for your tests ! ---------------------------------------------------------------------- Comment By: Jamiel Spezia (jspezia) Date: 2010-10-18 19:18 Message: Hello! I'm having the same problem. I noticed the problem when I used the function pg_last_error (). The browser execute the download the file test.php when is run the following script in apache: Filename: test.php <?php $bd = pg_connect("dbname=postgres user=postgres"); pg_last_error($bd); ?> The script performs successfully when execute in command line. I belive where the problem is to use php and apache. Versions: - PHP 5.3.3-1ubuntu9 with Suhosin-Patch (cli) (built: Sep 20 2010 20:39:59) - Apache/2.2.16 (Ubuntu) - psql (PostgreSQL) 8.4.5 - Kubuntu 10.10 Will does that the problem is some segmentation fault when executing the function?. Because the php returns no error. Sorry my english. ---------------------------------------------------------------------- Comment By: Jerromo (jerromo) Date: 2010-10-18 12:48 Message: Sorry, my english is very poor. Use: Ubuntu 10.10 PostgreSQL 8.4.5 (from dist repository) Apache 2.2.16 (from dist repository) PHP 5.3.3 (from dist repository) phpPgAdmin 5.0 (from http://github.com/xzilla/phppgadmin/archives/master) Request: GET /redirect.php?subject=schema&server=%3A5432%3Aallow&database=postgres&schema=public HTTP/1.1 Response: HTTP/0.9 200 OK and body size = 0 postgres log: 2010-10-18 13:30:58 MSD LOG: duration: 0.124 ms statement: set datestyle='ISO' 2010-10-18 13:30:58 MSD LOG: duration: 0.287 ms statement: select version() 2010-10-18 13:30:58 MSD LOG: duration: 1.605 ms statement: select oid,typname from pg_type 2010-10-18 13:30:58 MSD LOG: duration: 0.252 ms statement: SELECT current_schemas(false) AS search_path 2010-10-18 13:30:58 MSD LOG: duration: 0.048 ms statement: SET SEARCH_PATH TO "public","public" 2010-10-18 13:30:58 MSD LOG: unexpected EOF on client connection Apache error log: clear database: postgres (default from dist) > What are your database encoding ? UTF8 > do you have any special/accentued chars in your table's names or in their comments ? NO PS. Also on another project uses adodb exact same problem. ---------------------------------------------------------------------- Comment By: Guillaume `ioguix` de Rorthais (ioguix) Date: 2010-10-18 09:45 Message: And please, if you want to help me fix this issue, answer my questions from my first answer. Thank you in advance. ---------------------------------------------------------------------- Comment By: Guillaume `ioguix` de Rorthais (ioguix) Date: 2010-10-18 09:44 Message: Jerromo, could you please give some more details about your last message ? Did I miss something in this thread on ppa-help or did you forget to read my last answer on this bug report *completly* ? In my opinion, this fix you are providing seems to be buggy. Please, refer to the PHP doc : http://php.net/pg_result_error ---------------------------------------------------------------------- Comment By: Jerromo (jerromo) Date: 2010-10-16 21:46 Message: bug in adodb in php 5.3.3 (phpPgAdmin 5.0-beta2 (PHP 5.3.3-1ubuntu9) postgresql 8.4) http://sourceforge.net/projects/phppgadmin/forums/forum/115884/topic/3890018 ---------------------------------------------------------------------- Comment By: Guillaume `ioguix` de Rorthais (ioguix) Date: 2010-10-16 21:26 Message: Hello guys, First of all, PPA 4.2 is NOT compatible with 8.4. You should use PPA 5.0-beta2 for 8.4 and 9.0. http://github.com/xzilla/phppgadmin/archives/master I selected your language (we had some bugs about that few weeks ago) but I couldn't reproduce this bug :-( Honestly, the fix seems just wrong to me. "pg_result_error" takes a *result* resource as argument, not a connection one. So it seems to me that this fix actually will introduce a new bug :-(( Please, could you confirm this bug exists with PPA 5.0 ? What are your database encoding ? do you have any special/accentued chars in your table's names or in their comments ? Did you check your PostgreSQL logs ? could you set up your postgresql with : log_min_messages = info log_min_duration_statement = 0 Reload you conf and report here any useful information from your postgres logs ? Thank you in advance. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3086563&group_id=37132 |
From: SourceForge.net <no...@so...> - 2010-10-19 16:51:55
|
Bugs item #3086563, was opened at 2010-10-13 06:23 Message generated for change (Comment added) made by jspezia You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3086563&group_id=37132 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Databases Group: 4.2.3 Status: Open Resolution: None Priority: 5 Private: No Submitted By: gabrimonfa () Assigned to: Guillaume `ioguix` de Rorthais (ioguix) Summary: Click on schema proposes to download redirect.php Initial Comment: Ubuntu 10.10 phppgadmin version 4.2.3 php version 5.3.3 postgresql server 8.3, client 8.4 firefox 3.6.10 Click on schema name proposes to download redirect.php instead of showing schema tables I think this may be a problem in ADODB problem or even in my PHP Proposed workaround, to change the file libraries/adodb/drivers/adodb-postgres64.inc.php on line 812 from $this->_errorMsg = @pg_last_error($this->_connectionID); to $this->_errorMsg = @pg_result_error($this->_connectionID); Backtrace: libraries/adodb/drivers/adodb-postgres64.inc.php line 812 $this->_errorMsg = @pg_last_error($this->_connectionID); libraries/adodb/drivers/adodb_postgres64.inc.php line 824 $e = $this->ErrorMsg(); classes/database/ADODB_base.php line 76 return $this->conn->ErrorNo(); classes/database/Postgres73.php line 116 return $this->execute($sql); classes/database/Postgres73.php line 84 $status = $this->setSearchPath($search_path); libraries/lib.inc.php line 183 $status = $data->setSchema($_REQUEST['schema']); ---------------------------------------------------------------------- Comment By: Jamiel Spezia (jspezia) Date: 2010-10-19 12:51 Message: I edited the file /usr/sbin/apache2ctl for run with -X. The process was in the foreground, until php script to run. After that the process was aborted. I found the bug registered in the list of ubuntu: https://bugs.launchpad.net/ubuntu/+source/php5/+bug/660227 Thank you ---------------------------------------------------------------------- Comment By: Guillaume `ioguix` de Rorthais (ioguix) Date: 2010-10-19 12:16 Message: Hello Jspezia, I believe you couldn't even start Apache here. You are not supposed to start it with /etc/init.d/apache2, but directly by hand from a terminal. As it should be able to fork, the processus shoudl stay in the foreground and might crash as soon as you play with PPA... ---------------------------------------------------------------------- Comment By: Jamiel Spezia (jspezia) Date: 2010-10-19 12:08 Message: Hello. I ran Apache with the option -X. The result was: jamiel@eagle:/etc/apache2$ sudo /etc/init.d/apache2 start * Starting web server apache2 [Tue Oct 19 13:45:26 2010] [warn] NameVirtualHost *:80 has no VirtualHosts Action 'start' failed. The Apache error log may have more information. I verified the files log and there was no register of error in the files. I checked the followings log files: /var/log/apache2/access.log /var/log/apache2/error.log /var/log/apache2/gnuteca.eagle-access.log /var/log/apache2/gnuteca.eagle-error.log I believe where the bug is in the PHP apache module. tank you ---------------------------------------------------------------------- Comment By: Guillaume `ioguix` de Rorthais (ioguix) Date: 2010-10-18 17:18 Message: Hello, Very interesting. I am using : - Lighttpd 1.4.28 - PHP 5.3.2 CGI The demo server ( http://phppgadmin.kattare.com:81/phppgadmin-devel/ ) is running : - Lighttpd 1.4.28 - PHP 5.3.3 CGI Both are ok. So it seems it might be a bug in the PHP apache module. Could you please remove the '@' in front of "pg_last_error" so we can eventually catch a real PHP error ? You can try to run Apache with the -X option. If I understand it correctly, apache will not fork so you might see it crashing. thank you for your tests ! ---------------------------------------------------------------------- Comment By: Jamiel Spezia (jspezia) Date: 2010-10-18 13:18 Message: Hello! I'm having the same problem. I noticed the problem when I used the function pg_last_error (). The browser execute the download the file test.php when is run the following script in apache: Filename: test.php <?php $bd = pg_connect("dbname=postgres user=postgres"); pg_last_error($bd); ?> The script performs successfully when execute in command line. I belive where the problem is to use php and apache. Versions: - PHP 5.3.3-1ubuntu9 with Suhosin-Patch (cli) (built: Sep 20 2010 20:39:59) - Apache/2.2.16 (Ubuntu) - psql (PostgreSQL) 8.4.5 - Kubuntu 10.10 Will does that the problem is some segmentation fault when executing the function?. Because the php returns no error. Sorry my english. ---------------------------------------------------------------------- Comment By: Jerromo (jerromo) Date: 2010-10-18 06:48 Message: Sorry, my english is very poor. Use: Ubuntu 10.10 PostgreSQL 8.4.5 (from dist repository) Apache 2.2.16 (from dist repository) PHP 5.3.3 (from dist repository) phpPgAdmin 5.0 (from http://github.com/xzilla/phppgadmin/archives/master) Request: GET /redirect.php?subject=schema&server=%3A5432%3Aallow&database=postgres&schema=public HTTP/1.1 Response: HTTP/0.9 200 OK and body size = 0 postgres log: 2010-10-18 13:30:58 MSD LOG: duration: 0.124 ms statement: set datestyle='ISO' 2010-10-18 13:30:58 MSD LOG: duration: 0.287 ms statement: select version() 2010-10-18 13:30:58 MSD LOG: duration: 1.605 ms statement: select oid,typname from pg_type 2010-10-18 13:30:58 MSD LOG: duration: 0.252 ms statement: SELECT current_schemas(false) AS search_path 2010-10-18 13:30:58 MSD LOG: duration: 0.048 ms statement: SET SEARCH_PATH TO "public","public" 2010-10-18 13:30:58 MSD LOG: unexpected EOF on client connection Apache error log: clear database: postgres (default from dist) > What are your database encoding ? UTF8 > do you have any special/accentued chars in your table's names or in their comments ? NO PS. Also on another project uses adodb exact same problem. ---------------------------------------------------------------------- Comment By: Guillaume `ioguix` de Rorthais (ioguix) Date: 2010-10-18 03:45 Message: And please, if you want to help me fix this issue, answer my questions from my first answer. Thank you in advance. ---------------------------------------------------------------------- Comment By: Guillaume `ioguix` de Rorthais (ioguix) Date: 2010-10-18 03:44 Message: Jerromo, could you please give some more details about your last message ? Did I miss something in this thread on ppa-help or did you forget to read my last answer on this bug report *completly* ? In my opinion, this fix you are providing seems to be buggy. Please, refer to the PHP doc : http://php.net/pg_result_error ---------------------------------------------------------------------- Comment By: Jerromo (jerromo) Date: 2010-10-16 15:46 Message: bug in adodb in php 5.3.3 (phpPgAdmin 5.0-beta2 (PHP 5.3.3-1ubuntu9) postgresql 8.4) http://sourceforge.net/projects/phppgadmin/forums/forum/115884/topic/3890018 ---------------------------------------------------------------------- Comment By: Guillaume `ioguix` de Rorthais (ioguix) Date: 2010-10-16 15:26 Message: Hello guys, First of all, PPA 4.2 is NOT compatible with 8.4. You should use PPA 5.0-beta2 for 8.4 and 9.0. http://github.com/xzilla/phppgadmin/archives/master I selected your language (we had some bugs about that few weeks ago) but I couldn't reproduce this bug :-( Honestly, the fix seems just wrong to me. "pg_result_error" takes a *result* resource as argument, not a connection one. So it seems to me that this fix actually will introduce a new bug :-(( Please, could you confirm this bug exists with PPA 5.0 ? What are your database encoding ? do you have any special/accentued chars in your table's names or in their comments ? Did you check your PostgreSQL logs ? could you set up your postgresql with : log_min_messages = info log_min_duration_statement = 0 Reload you conf and report here any useful information from your postgres logs ? Thank you in advance. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3086563&group_id=37132 |
From: SourceForge.net <no...@so...> - 2010-10-19 17:08:13
|
Bugs item #3086563, was opened at 2010-10-13 06:23 Message generated for change (Comment added) made by jspezia You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3086563&group_id=37132 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Databases Group: 4.2.3 Status: Open Resolution: None Priority: 5 Private: No Submitted By: gabrimonfa () Assigned to: Guillaume `ioguix` de Rorthais (ioguix) Summary: Click on schema proposes to download redirect.php Initial Comment: Ubuntu 10.10 phppgadmin version 4.2.3 php version 5.3.3 postgresql server 8.3, client 8.4 firefox 3.6.10 Click on schema name proposes to download redirect.php instead of showing schema tables I think this may be a problem in ADODB problem or even in my PHP Proposed workaround, to change the file libraries/adodb/drivers/adodb-postgres64.inc.php on line 812 from $this->_errorMsg = @pg_last_error($this->_connectionID); to $this->_errorMsg = @pg_result_error($this->_connectionID); Backtrace: libraries/adodb/drivers/adodb-postgres64.inc.php line 812 $this->_errorMsg = @pg_last_error($this->_connectionID); libraries/adodb/drivers/adodb_postgres64.inc.php line 824 $e = $this->ErrorMsg(); classes/database/ADODB_base.php line 76 return $this->conn->ErrorNo(); classes/database/Postgres73.php line 116 return $this->execute($sql); classes/database/Postgres73.php line 84 $status = $this->setSearchPath($search_path); libraries/lib.inc.php line 183 $status = $data->setSchema($_REQUEST['schema']); ---------------------------------------------------------------------- Comment By: Jamiel Spezia (jspezia) Date: 2010-10-19 13:08 Message: Solution for ubuntu 10.10: # vim /etc/apt/sources.list -- Add line: deb http://br.archive.ubuntu.com/ubuntu/ maverick-proposed restricted main multiverse universe # apt-get update # apt-get install php5-pgsql # /etc/init.d/apache2 restart ---------------------------------------------------------------------- Comment By: Jamiel Spezia (jspezia) Date: 2010-10-19 12:51 Message: I edited the file /usr/sbin/apache2ctl for run with -X. The process was in the foreground, until php script to run. After that the process was aborted. I found the bug registered in the list of ubuntu: https://bugs.launchpad.net/ubuntu/+source/php5/+bug/660227 Thank you ---------------------------------------------------------------------- Comment By: Guillaume `ioguix` de Rorthais (ioguix) Date: 2010-10-19 12:16 Message: Hello Jspezia, I believe you couldn't even start Apache here. You are not supposed to start it with /etc/init.d/apache2, but directly by hand from a terminal. As it should be able to fork, the processus shoudl stay in the foreground and might crash as soon as you play with PPA... ---------------------------------------------------------------------- Comment By: Jamiel Spezia (jspezia) Date: 2010-10-19 12:08 Message: Hello. I ran Apache with the option -X. The result was: jamiel@eagle:/etc/apache2$ sudo /etc/init.d/apache2 start * Starting web server apache2 [Tue Oct 19 13:45:26 2010] [warn] NameVirtualHost *:80 has no VirtualHosts Action 'start' failed. The Apache error log may have more information. I verified the files log and there was no register of error in the files. I checked the followings log files: /var/log/apache2/access.log /var/log/apache2/error.log /var/log/apache2/gnuteca.eagle-access.log /var/log/apache2/gnuteca.eagle-error.log I believe where the bug is in the PHP apache module. tank you ---------------------------------------------------------------------- Comment By: Guillaume `ioguix` de Rorthais (ioguix) Date: 2010-10-18 17:18 Message: Hello, Very interesting. I am using : - Lighttpd 1.4.28 - PHP 5.3.2 CGI The demo server ( http://phppgadmin.kattare.com:81/phppgadmin-devel/ ) is running : - Lighttpd 1.4.28 - PHP 5.3.3 CGI Both are ok. So it seems it might be a bug in the PHP apache module. Could you please remove the '@' in front of "pg_last_error" so we can eventually catch a real PHP error ? You can try to run Apache with the -X option. If I understand it correctly, apache will not fork so you might see it crashing. thank you for your tests ! ---------------------------------------------------------------------- Comment By: Jamiel Spezia (jspezia) Date: 2010-10-18 13:18 Message: Hello! I'm having the same problem. I noticed the problem when I used the function pg_last_error (). The browser execute the download the file test.php when is run the following script in apache: Filename: test.php <?php $bd = pg_connect("dbname=postgres user=postgres"); pg_last_error($bd); ?> The script performs successfully when execute in command line. I belive where the problem is to use php and apache. Versions: - PHP 5.3.3-1ubuntu9 with Suhosin-Patch (cli) (built: Sep 20 2010 20:39:59) - Apache/2.2.16 (Ubuntu) - psql (PostgreSQL) 8.4.5 - Kubuntu 10.10 Will does that the problem is some segmentation fault when executing the function?. Because the php returns no error. Sorry my english. ---------------------------------------------------------------------- Comment By: Jerromo (jerromo) Date: 2010-10-18 06:48 Message: Sorry, my english is very poor. Use: Ubuntu 10.10 PostgreSQL 8.4.5 (from dist repository) Apache 2.2.16 (from dist repository) PHP 5.3.3 (from dist repository) phpPgAdmin 5.0 (from http://github.com/xzilla/phppgadmin/archives/master) Request: GET /redirect.php?subject=schema&server=%3A5432%3Aallow&database=postgres&schema=public HTTP/1.1 Response: HTTP/0.9 200 OK and body size = 0 postgres log: 2010-10-18 13:30:58 MSD LOG: duration: 0.124 ms statement: set datestyle='ISO' 2010-10-18 13:30:58 MSD LOG: duration: 0.287 ms statement: select version() 2010-10-18 13:30:58 MSD LOG: duration: 1.605 ms statement: select oid,typname from pg_type 2010-10-18 13:30:58 MSD LOG: duration: 0.252 ms statement: SELECT current_schemas(false) AS search_path 2010-10-18 13:30:58 MSD LOG: duration: 0.048 ms statement: SET SEARCH_PATH TO "public","public" 2010-10-18 13:30:58 MSD LOG: unexpected EOF on client connection Apache error log: clear database: postgres (default from dist) > What are your database encoding ? UTF8 > do you have any special/accentued chars in your table's names or in their comments ? NO PS. Also on another project uses adodb exact same problem. ---------------------------------------------------------------------- Comment By: Guillaume `ioguix` de Rorthais (ioguix) Date: 2010-10-18 03:45 Message: And please, if you want to help me fix this issue, answer my questions from my first answer. Thank you in advance. ---------------------------------------------------------------------- Comment By: Guillaume `ioguix` de Rorthais (ioguix) Date: 2010-10-18 03:44 Message: Jerromo, could you please give some more details about your last message ? Did I miss something in this thread on ppa-help or did you forget to read my last answer on this bug report *completly* ? In my opinion, this fix you are providing seems to be buggy. Please, refer to the PHP doc : http://php.net/pg_result_error ---------------------------------------------------------------------- Comment By: Jerromo (jerromo) Date: 2010-10-16 15:46 Message: bug in adodb in php 5.3.3 (phpPgAdmin 5.0-beta2 (PHP 5.3.3-1ubuntu9) postgresql 8.4) http://sourceforge.net/projects/phppgadmin/forums/forum/115884/topic/3890018 ---------------------------------------------------------------------- Comment By: Guillaume `ioguix` de Rorthais (ioguix) Date: 2010-10-16 15:26 Message: Hello guys, First of all, PPA 4.2 is NOT compatible with 8.4. You should use PPA 5.0-beta2 for 8.4 and 9.0. http://github.com/xzilla/phppgadmin/archives/master I selected your language (we had some bugs about that few weeks ago) but I couldn't reproduce this bug :-( Honestly, the fix seems just wrong to me. "pg_result_error" takes a *result* resource as argument, not a connection one. So it seems to me that this fix actually will introduce a new bug :-(( Please, could you confirm this bug exists with PPA 5.0 ? What are your database encoding ? do you have any special/accentued chars in your table's names or in their comments ? Did you check your PostgreSQL logs ? could you set up your postgresql with : log_min_messages = info log_min_duration_statement = 0 Reload you conf and report here any useful information from your postgres logs ? Thank you in advance. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3086563&group_id=37132 |
From: SourceForge.net <no...@so...> - 2010-10-19 23:11:18
|
Bugs item #3086563, was opened at 2010-10-13 12:23 Message generated for change (Comment added) made by ioguix You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3086563&group_id=37132 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Databases >Group: None >Status: Closed >Resolution: Invalid Priority: 5 Private: No Submitted By: gabrimonfa () Assigned to: Guillaume `ioguix` de Rorthais (ioguix) Summary: Click on schema proposes to download redirect.php Initial Comment: Ubuntu 10.10 phppgadmin version 4.2.3 php version 5.3.3 postgresql server 8.3, client 8.4 firefox 3.6.10 Click on schema name proposes to download redirect.php instead of showing schema tables I think this may be a problem in ADODB problem or even in my PHP Proposed workaround, to change the file libraries/adodb/drivers/adodb-postgres64.inc.php on line 812 from $this->_errorMsg = @pg_last_error($this->_connectionID); to $this->_errorMsg = @pg_result_error($this->_connectionID); Backtrace: libraries/adodb/drivers/adodb-postgres64.inc.php line 812 $this->_errorMsg = @pg_last_error($this->_connectionID); libraries/adodb/drivers/adodb_postgres64.inc.php line 824 $e = $this->ErrorMsg(); classes/database/ADODB_base.php line 76 return $this->conn->ErrorNo(); classes/database/Postgres73.php line 116 return $this->execute($sql); classes/database/Postgres73.php line 84 $status = $this->setSearchPath($search_path); libraries/lib.inc.php line 183 $status = $data->setSchema($_REQUEST['schema']); ---------------------------------------------------------------------- >Comment By: Guillaume `ioguix` de Rorthais (ioguix) Date: 2010-10-20 01:11 Message: ok, thank you Jspezia for your feedback and research ! Much appreciated:) Cheers ---------------------------------------------------------------------- Comment By: Jamiel Spezia (jspezia) Date: 2010-10-19 19:08 Message: Solution for ubuntu 10.10: # vim /etc/apt/sources.list -- Add line: deb http://br.archive.ubuntu.com/ubuntu/ maverick-proposed restricted main multiverse universe # apt-get update # apt-get install php5-pgsql # /etc/init.d/apache2 restart ---------------------------------------------------------------------- Comment By: Jamiel Spezia (jspezia) Date: 2010-10-19 18:51 Message: I edited the file /usr/sbin/apache2ctl for run with -X. The process was in the foreground, until php script to run. After that the process was aborted. I found the bug registered in the list of ubuntu: https://bugs.launchpad.net/ubuntu/+source/php5/+bug/660227 Thank you ---------------------------------------------------------------------- Comment By: Guillaume `ioguix` de Rorthais (ioguix) Date: 2010-10-19 18:16 Message: Hello Jspezia, I believe you couldn't even start Apache here. You are not supposed to start it with /etc/init.d/apache2, but directly by hand from a terminal. As it should be able to fork, the processus shoudl stay in the foreground and might crash as soon as you play with PPA... ---------------------------------------------------------------------- Comment By: Jamiel Spezia (jspezia) Date: 2010-10-19 18:08 Message: Hello. I ran Apache with the option -X. The result was: jamiel@eagle:/etc/apache2$ sudo /etc/init.d/apache2 start * Starting web server apache2 [Tue Oct 19 13:45:26 2010] [warn] NameVirtualHost *:80 has no VirtualHosts Action 'start' failed. The Apache error log may have more information. I verified the files log and there was no register of error in the files. I checked the followings log files: /var/log/apache2/access.log /var/log/apache2/error.log /var/log/apache2/gnuteca.eagle-access.log /var/log/apache2/gnuteca.eagle-error.log I believe where the bug is in the PHP apache module. tank you ---------------------------------------------------------------------- Comment By: Guillaume `ioguix` de Rorthais (ioguix) Date: 2010-10-18 23:18 Message: Hello, Very interesting. I am using : - Lighttpd 1.4.28 - PHP 5.3.2 CGI The demo server ( http://phppgadmin.kattare.com:81/phppgadmin-devel/ ) is running : - Lighttpd 1.4.28 - PHP 5.3.3 CGI Both are ok. So it seems it might be a bug in the PHP apache module. Could you please remove the '@' in front of "pg_last_error" so we can eventually catch a real PHP error ? You can try to run Apache with the -X option. If I understand it correctly, apache will not fork so you might see it crashing. thank you for your tests ! ---------------------------------------------------------------------- Comment By: Jamiel Spezia (jspezia) Date: 2010-10-18 19:18 Message: Hello! I'm having the same problem. I noticed the problem when I used the function pg_last_error (). The browser execute the download the file test.php when is run the following script in apache: Filename: test.php <?php $bd = pg_connect("dbname=postgres user=postgres"); pg_last_error($bd); ?> The script performs successfully when execute in command line. I belive where the problem is to use php and apache. Versions: - PHP 5.3.3-1ubuntu9 with Suhosin-Patch (cli) (built: Sep 20 2010 20:39:59) - Apache/2.2.16 (Ubuntu) - psql (PostgreSQL) 8.4.5 - Kubuntu 10.10 Will does that the problem is some segmentation fault when executing the function?. Because the php returns no error. Sorry my english. ---------------------------------------------------------------------- Comment By: Jerromo (jerromo) Date: 2010-10-18 12:48 Message: Sorry, my english is very poor. Use: Ubuntu 10.10 PostgreSQL 8.4.5 (from dist repository) Apache 2.2.16 (from dist repository) PHP 5.3.3 (from dist repository) phpPgAdmin 5.0 (from http://github.com/xzilla/phppgadmin/archives/master) Request: GET /redirect.php?subject=schema&server=%3A5432%3Aallow&database=postgres&schema=public HTTP/1.1 Response: HTTP/0.9 200 OK and body size = 0 postgres log: 2010-10-18 13:30:58 MSD LOG: duration: 0.124 ms statement: set datestyle='ISO' 2010-10-18 13:30:58 MSD LOG: duration: 0.287 ms statement: select version() 2010-10-18 13:30:58 MSD LOG: duration: 1.605 ms statement: select oid,typname from pg_type 2010-10-18 13:30:58 MSD LOG: duration: 0.252 ms statement: SELECT current_schemas(false) AS search_path 2010-10-18 13:30:58 MSD LOG: duration: 0.048 ms statement: SET SEARCH_PATH TO "public","public" 2010-10-18 13:30:58 MSD LOG: unexpected EOF on client connection Apache error log: clear database: postgres (default from dist) > What are your database encoding ? UTF8 > do you have any special/accentued chars in your table's names or in their comments ? NO PS. Also on another project uses adodb exact same problem. ---------------------------------------------------------------------- Comment By: Guillaume `ioguix` de Rorthais (ioguix) Date: 2010-10-18 09:45 Message: And please, if you want to help me fix this issue, answer my questions from my first answer. Thank you in advance. ---------------------------------------------------------------------- Comment By: Guillaume `ioguix` de Rorthais (ioguix) Date: 2010-10-18 09:44 Message: Jerromo, could you please give some more details about your last message ? Did I miss something in this thread on ppa-help or did you forget to read my last answer on this bug report *completly* ? In my opinion, this fix you are providing seems to be buggy. Please, refer to the PHP doc : http://php.net/pg_result_error ---------------------------------------------------------------------- Comment By: Jerromo (jerromo) Date: 2010-10-16 21:46 Message: bug in adodb in php 5.3.3 (phpPgAdmin 5.0-beta2 (PHP 5.3.3-1ubuntu9) postgresql 8.4) http://sourceforge.net/projects/phppgadmin/forums/forum/115884/topic/3890018 ---------------------------------------------------------------------- Comment By: Guillaume `ioguix` de Rorthais (ioguix) Date: 2010-10-16 21:26 Message: Hello guys, First of all, PPA 4.2 is NOT compatible with 8.4. You should use PPA 5.0-beta2 for 8.4 and 9.0. http://github.com/xzilla/phppgadmin/archives/master I selected your language (we had some bugs about that few weeks ago) but I couldn't reproduce this bug :-( Honestly, the fix seems just wrong to me. "pg_result_error" takes a *result* resource as argument, not a connection one. So it seems to me that this fix actually will introduce a new bug :-(( Please, could you confirm this bug exists with PPA 5.0 ? What are your database encoding ? do you have any special/accentued chars in your table's names or in their comments ? Did you check your PostgreSQL logs ? could you set up your postgresql with : log_min_messages = info log_min_duration_statement = 0 Reload you conf and report here any useful information from your postgres logs ? Thank you in advance. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3086563&group_id=37132 |