[ppa-help] [ phppgadmin-Bugs-3086563 ] Click on schema proposes to download redirect.php

[SourceForge.net <no...@so...>]

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