phppgadmin-help — For broadcasting of forum and big reports to developers

[ppa-help] [ phppgadmin-Bugs-3550565 ] Some text badly truncated or not shown at all

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

Bugs item #3550565, was opened at 2012-07-28 00:19
Message generated for change (Comment added) made by xzilla
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3550565&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: General
Group: None
>Status: Pending
Resolution: None
Priority: 5
Private: No
Submitted By: Christoph Berg (df7cb)
>Assigned to: Robert Treat (xzilla)
Summary: Some text badly truncated or not shown at all

Initial Comment:
http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=682954

I've received a report from a Debian user where text in some table (see the screenshot) got truncated, apparently in the middle of some utf8 character. Some other cell is reported as being empty where it should have some content.

--------------

Date: Fri, 27 Jul 2012 11:35:25 +0200
From: Csanyi Pal <csa...@gm...>
Subject: Bug#682954: [phppgadmin] The phpPgAdmin displays table data poorly

Package: phppgadmin
Version: 5.0.4-1
Severity: important

Hi,

in the Table Browse view some of the datas are poorly displayed.

What I'm mean here is visible if one download the image of this
display problem from here (one must click on the download icon):

http://cspl.me/joomla/index.php/itt-helyben/kepek

I can try to explain the problem here in words.
(English isn't my first language.)

On the image one can see 9 rows in the Table.
All rows are displayed properly but but the second, third and sixth.

In the column named 'unnep_neve' phpPgAdmin display the column
too strait so one can see the text in the second row as
'A II. világháború szerb áldozatainak emlékna&#8230;'
in place of the proper text:
'A II. világháború szerb áldozatainak emléknapja'.

In the second row in the 'megjegyzes' column one can see empty field,
but there should to be the text:
'November 11. a napja, de az vasárnapra esik, ezért hétfőn ünnepeljük meg.'

In the sixth row the problem is the same as in the second row,
but with different text.

So it seems to me that that phpPgAdmin displays Table data poorly because if
a text in a column exceeds some length then it can't be seen properly or at all.

Certainly in the psql prompt these rows can be seen properly when I run the
SELECT statement on this table.


----------------------------------------------------------------------

>Comment By: Robert Treat (xzilla)
Date: 2012-11-27 22:31

Message:
The screenshot is no longer valid, so it's hard to say for sure, but we do
show only partial data for very long text fields. If you want to see the
full data, there is an "expand" option at the bottom of most display pages
which should show the full data. IIRC, you can control how much data to
show before truncating in the config. 

If your problem was something else, please update the ticket and or provide
a new screen shot, but hopefully that solves it. 

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3550565&group_id=37132

[ppa-help] login

[<gsu...@gm...>]

The following data was submitted on 2012/11/28 06:28.



====== E-mail ======

Name
		suhartono
PostgreSQL ver.
		postgresql91
phpPgAdmin ver.
		phpPgAdmin 5.0.4 
Comments
		I want to login

[ppa-help] [ phppgadmin-Bugs-3544661 ] phpMyAdmin Chrome Non resizable left column

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

Bugs item #3544661, was opened at 2012-07-16 09:04
Message generated for change (Comment added) made by xzilla
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3544661&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: General
Group: None
>Status: Closed
>Resolution: Invalid
Priority: 5
Private: No
Submitted By: https://www.google.com/accounts ()
>Assigned to: Robert Treat (xzilla)
Summary: phpMyAdmin Chrome Non resizable left column

Initial Comment:
The left column is not resizeable under Chrome version 20.0.

The fix consists in edit the frameborder in the index.php file.

See http://www.edmondscommerce.co.uk/php/phpmyadmin-chrome-resizable-left-column-solution/

----------------------------------------------------------------------

>Comment By: Robert Treat (xzilla)
Date: 2012-11-27 22:26

Message:
phppgadmin doesnt have this problem

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3544661&group_id=37132

[ppa-help] [ phppgadmin-Bugs-3243916 ] bytea columns are mangled when displayed or exported

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

Bugs item #3243916, was opened at 2011-03-25 07:19
Message generated for change (Comment added) made by xzilla
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3243916&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: Types
Group: 5.0.1
Status: Open
Resolution: None
>Priority: 9
Private: No
Submitted By: Leon P Smith (lpsmith)
>Assigned to: Robert Treat (xzilla)
Summary: bytea columns are mangled when displayed or exported

Initial Comment:
I'm using a bytea column to store sha-1 hashes in 24 bytes per hash.   However, phpPgAdmin mangles these hashes when displaying them on a webpage or exporting them to a file.  For example:

$ psql

psql (9.0.3)
Type "help" for help.

ali=> create table bytea_test (filename text, sha1hash bytea);
CREATE TABLE
ali=> insert into bytea_test values
ali->    (  'phpPgAdmin-5.0.2.tar.gz'
ali(>    ,  decode('908226ba8482a641172383d58823b171c05029a1','hex')  );
INSERT 0 1
ali=> select * from bytea_test;
        filename         |                  sha1hash                  
-------------------------+--------------------------------------------
 phpPgAdmin-5.0.2.tar.gz | \x908226ba8482a641172383d58823b171c05029a1
(1 row)

However,  phpPgAdmin displays sha1hash as

   \x903832323662613834383261363431313732333833643538383233623137316330353032396131

Which leaves \x90 unchanged,  but everything else is replaced by the hexadecimal ascii character code of the hex digit.   The problem is related to escapeBytea in classes/database/Postgres.php;  either it is broken or it is being used inappropriately.   My guess is the former.  I've confirmed this issue with phpPgAdmin 4.2.3 and phpPgAdmin 5.0.2 on PHP 5.3.3-1ubuntu9.3 and PostgreSQL 9.0.3.   It probably affects a much wider range of configurations, however. 

----------------------------------------------------------------------

>Comment By: Robert Treat (xzilla)
Date: 2012-11-27 20:54

Message:
Hey, I've been working on this a bit the last few days, with plans to fix
it in the next major version of PPA. PHP's bytea handling is pretty poor,
so this has taken me longer than I had hoped. Your's is a good usecase to
work from though, so thanks for the report. If there's any chance you came
up with a fix, I'd love to hear about it, otherwise I'll update this ticket
once I get things working. 

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3243916&group_id=37132

[ppa-help] [ phppgadmin-Bugs-3420712 ] Auto complete does not work for foreign key constraints

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

Bugs item #3420712, was opened at 2011-10-08 22:53
Message generated for change (Settings changed) made by xzilla
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3420712&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: Constraints
Group: 5.0.3
>Status: Pending
>Resolution: Fixed
Priority: 5
Private: No
Submitted By: Brandon Phelps (brandonnc83)
Assigned to: Robert Treat (xzilla)
Summary: Auto complete does not work for foreign key constraints

Initial Comment:
When a foreign key constraint exists and you are inserting a record from the web gui, selecting an option from the popup inserts "<div  style="text-align: right; background-color: rgb(61, 128, 223); color: rgb(255, 255, 255);">ID</div>" into the input box instead of just the ID.  This obviously results in an SQL query if you submit.

Using Firefox 7.0.1 and PostgreSQL 9.1 with phpPgAdmin 5.0.3.

----------------------------------------------------------------------

Comment By: Robert Treat (xzilla)
Date: 2012-11-27 20:49

Message:
This is fixed in my local repo and will be merged into the official repo
shortly, on the master branch. You can get the immediate fix at
https://github.com/xzilla/phppgadmin/commit/bcf3cae0584becfd6cba7bf7b97fd166c97ab392

If you could test and confirm this fixes your issue, that would be great.
Thanks for the bug report. 


----------------------------------------------------------------------

Comment By: Nate Bessette (frickenate)
Date: 2012-06-26 18:51

Message:
Just ran into this bug, quite annoying. jQuery will handle this for you:

jQuery('input[name="values['+ a[i].name +']"]').val(jQuery(a[i]).text());

----------------------------------------------------------------------

Comment By: J.Guillaume (ioguix) de Rorthais (ioguix)
Date: 2012-01-24 09:26

Message:
Hey, 

Thank you for reviving this bug...

I'm currently pretty almost alone "working" on PPA on my free time right
now and I have so much to do with the plugin arch presently.

Anyway, I'll try to fix this bug in our current dev tree as soon as
possible...

Cheers!

----------------------------------------------------------------------

Comment By: woodz (woodz_)
Date: 2012-01-14 15:14

Message:
Hi guys,
I was digging a bit deeper since I absolutely want that feature working
well. I found out that the provided solution from vicpopov does not work
for Mozilla Firefox. You can check
http://www.davidtong.me/innerhtml-innertext-textcontent-html-and-text/.
They link to the dom/w3c and there is a cross browser replacement given:

var text = x.innerText || x.textContent;

FF does not know about innerText, it just knows textContent. By the way I
do not understand why  the funky browser manufacturers can't have a
standard between in 2012?

So I suggest to extend our workaround to:

With context: replace string
jQuery('input[name="values['+ a[i].name +']"]').val(a[i].innerHTML);
with
jQuery('input[name="values['+ a[i].name +']"]').val(a[i].innerText ||
a[i].textContent);

Die-hard ppa developers may consider the further workarounds mentioned
under the resource above, especially when keeping white spaces is required
when doing inline editing.

Good night

----------------------------------------------------------------------

Comment By: J.Guillaume (ioguix) de Rorthais (ioguix)
Date: 2011-11-10 10:51

Message:
Hello,

Thank you for the report, patch proposal and feedback !

I'll try to review / commit this as soon as possible, probably on next
week.

----------------------------------------------------------------------

Comment By: Xiguang Wang (kurapicapku)
Date: 2011-11-10 05:33

Message:
I've tryed vicpopov's patch and it does work.

Not found any other problem caused by the patch yet.

----------------------------------------------------------------------

Comment By: Victor Popov (vicpopov)
Date: 2011-10-26 03:34

Message:
Quick fix, not sure if it is absolutely correct:
replace occurence of "InnerHTML" text in file js/ac_insert_row.js (there is
only one such) with "innerText".

With context: replace string
jQuery('input[name="values['+ a[i].name +']"]').val(a[i].innerHTML);
with
jQuery('input[name="values['+ a[i].name +']"]').val(a[i].innerText);

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3420712&group_id=37132

[ppa-help] [ phppgadmin-Bugs-3420712 ] Auto complete does not work for foreign key constraints

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

Bugs item #3420712, was opened at 2011-10-08 22:53
Message generated for change (Comment added) made by xzilla
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3420712&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: Constraints
Group: 5.0.3
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Brandon Phelps (brandonnc83)
>Assigned to: Robert Treat (xzilla)
Summary: Auto complete does not work for foreign key constraints

Initial Comment:
When a foreign key constraint exists and you are inserting a record from the web gui, selecting an option from the popup inserts "<div  style="text-align: right; background-color: rgb(61, 128, 223); color: rgb(255, 255, 255);">ID</div>" into the input box instead of just the ID.  This obviously results in an SQL query if you submit.

Using Firefox 7.0.1 and PostgreSQL 9.1 with phpPgAdmin 5.0.3.

----------------------------------------------------------------------

>Comment By: Robert Treat (xzilla)
Date: 2012-11-27 20:49

Message:
This is fixed in my local repo and will be merged into the official repo
shortly, on the master branch. You can get the immediate fix at
https://github.com/xzilla/phppgadmin/commit/bcf3cae0584becfd6cba7bf7b97fd166c97ab392

If you could test and confirm this fixes your issue, that would be great.
Thanks for the bug report. 


----------------------------------------------------------------------

Comment By: Nate Bessette (frickenate)
Date: 2012-06-26 18:51

Message:
Just ran into this bug, quite annoying. jQuery will handle this for you:

jQuery('input[name="values['+ a[i].name +']"]').val(jQuery(a[i]).text());

----------------------------------------------------------------------

Comment By: J.Guillaume (ioguix) de Rorthais (ioguix)
Date: 2012-01-24 09:26

Message:
Hey, 

Thank you for reviving this bug...

I'm currently pretty almost alone "working" on PPA on my free time right
now and I have so much to do with the plugin arch presently.

Anyway, I'll try to fix this bug in our current dev tree as soon as
possible...

Cheers!

----------------------------------------------------------------------

Comment By: woodz (woodz_)
Date: 2012-01-14 15:14

Message:
Hi guys,
I was digging a bit deeper since I absolutely want that feature working
well. I found out that the provided solution from vicpopov does not work
for Mozilla Firefox. You can check
http://www.davidtong.me/innerhtml-innertext-textcontent-html-and-text/.
They link to the dom/w3c and there is a cross browser replacement given:

var text = x.innerText || x.textContent;

FF does not know about innerText, it just knows textContent. By the way I
do not understand why  the funky browser manufacturers can't have a
standard between in 2012?

So I suggest to extend our workaround to:

With context: replace string
jQuery('input[name="values['+ a[i].name +']"]').val(a[i].innerHTML);
with
jQuery('input[name="values['+ a[i].name +']"]').val(a[i].innerText ||
a[i].textContent);

Die-hard ppa developers may consider the further workarounds mentioned
under the resource above, especially when keeping white spaces is required
when doing inline editing.

Good night

----------------------------------------------------------------------

Comment By: J.Guillaume (ioguix) de Rorthais (ioguix)
Date: 2011-11-10 10:51

Message:
Hello,

Thank you for the report, patch proposal and feedback !

I'll try to review / commit this as soon as possible, probably on next
week.

----------------------------------------------------------------------

Comment By: Xiguang Wang (kurapicapku)
Date: 2011-11-10 05:33

Message:
I've tryed vicpopov's patch and it does work.

Not found any other problem caused by the patch yet.

----------------------------------------------------------------------

Comment By: Victor Popov (vicpopov)
Date: 2011-10-26 03:34

Message:
Quick fix, not sure if it is absolutely correct:
replace occurence of "InnerHTML" text in file js/ac_insert_row.js (there is
only one such) with "innerText".

With context: replace string
jQuery('input[name="values['+ a[i].name +']"]').val(a[i].innerHTML);
with
jQuery('input[name="values['+ a[i].name +']"]').val(a[i].innerText);

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3420712&group_id=37132

[ppa-help] [ phppgadmin-Bugs-3573308 ] Password change process is insecure

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

Bugs item #3573308, was opened at 2012-09-30 18:00
Message generated for change (Comment added) made by xzilla
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3573308&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: Users
>Group: GIT
Status: Open
Resolution: None
Priority: 5
Private: Yes
Submitted By: Karl O. Pinc (kpinc)
>Assigned to: Robert Treat (xzilla)
Summary: Password change process is insecure

Initial Comment:
An attacker who is physically present can change a user's Postgres password. To thwart this attack phpPgAdmin should require re-authentication from the user before accepting a new password.

----------------------------------------------------------------------

>Comment By: Robert Treat (xzilla)
Date: 2012-11-27 20:45

Message:
I'm not sure I entirely understand the threat model, or don't agree with
it. 

istm you can only change a password if you have 
1) authenticated already, and 2) with superuser account. 

unless you are saying if someone walks away, someone might come up and
change the password? but, they could do that via straight SQL as well,
which we cant really prevent. 

so i am inclined to think this is a "wont fix"  


----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3573308&group_id=37132

[ppa-help] [ phppgadmin-Bugs-3589376 ] phppgadmin is providing version info

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

Bugs item #3589376, was opened at 2012-11-23 02:40
Message generated for change (Comment added) made by xzilla
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3589376&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: Security
Group: GIT
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Gandalf (gandalf001)
Assigned to: Robert Treat (xzilla)
Summary: phppgadmin is providing version info

Initial Comment:
Hi, I think its security bug to provide php version info and phppgadmin to anonymous user. So please change line 20 from intro.php to:

<h1><?php echo "$appName  ?></h1>

----------------------------------------------------------------------

>Comment By: Robert Treat (xzilla)
Date: 2012-11-27 20:36

Message:
I understand your concern, and it seems legit, but the information can be
useful for us (which is why we added it iirc). I was thinking maybe we
would just alter it so that if you have the "extra login security" flag
true (the default) we would hide it, but if not, we would display it.
thoughts?  

----------------------------------------------------------------------

Comment By: Robert Treat (xzilla)
Date: 2012-11-27 20:33

Message:
I understand your concern, and it seems legit, but the information can be
useful for us (which is why we added it iirc). I was thinking maybe we
would just alter it so that if you have the "extra login security" flag
true (the default) we would hide it, but if not, we would display it.
thoughts?  

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3589376&group_id=37132

[ppa-help] [ phppgadmin-Bugs-3589376 ] phppgadmin is providing version info

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

Bugs item #3589376, was opened at 2012-11-23 02:40
Message generated for change (Comment added) made by xzilla
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3589376&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: Security
>Group: GIT
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Gandalf (gandalf001)
>Assigned to: Robert Treat (xzilla)
>Summary: phppgadmin is providing version info

Initial Comment:
Hi, I think its security bug to provide php version info and phppgadmin to anonymous user. So please change line 20 from intro.php to:

<h1><?php echo "$appName  ?></h1>

----------------------------------------------------------------------

>Comment By: Robert Treat (xzilla)
Date: 2012-11-27 20:33

Message:
I understand your concern, and it seems legit, but the information can be
useful for us (which is why we added it iirc). I was thinking maybe we
would just alter it so that if you have the "extra login security" flag
true (the default) we would hide it, but if not, we would display it.
thoughts?  

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3589376&group_id=37132

[ppa-help] [Help] RE: ERROR: column "tgisconstraint&qu...

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

The following forum message was posted by xzilla at http://sourceforge.net/projects/phppgadmin/forums/forum/115884/topic/6150737:

Hi Jasmine,

This is fixed in the latest code in development, which you can grab from our
github page at https://github.com/phppgadmin/phppgadmin.  We will hopefully
have a new release out soon which will include that fix, but if you can use
that for now, it should fix this for you. Thanks for using phppgadmin.

[ppa-help] [ phppgadmin-Bugs-3579602 ] escapeBytea returns "x" for blank strings

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

Bugs item #3579602, was opened at 2012-10-23 18:32
Message generated for change (Comment added) made by xzilla
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3579602&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: Tables
>Group: GIT
>Status: Pending
>Resolution: Fixed
Priority: 5
Private: No
Submitted By: Rick Yorgason (skrapion)
>Assigned to: Robert Treat (xzilla)
Summary: escapeBytea returns "x" for blank strings

Initial Comment:
When selecting from a table with a bytea field, the field is automatically filled with a single "x" character, meaning you have to clear it before an actual selection will work.

The problem is a result of the call to pg_escape_bytea in Postgres::escapeBytea (classes/database/Postgres.php). For some reason, when pg_escape_bytea("") is called in this function, it returns "\\x".

The confusing part is that if I write a script that does nothing but print the output of pg_escape_bytea(""), it returns an empty string as expected. I haven't figured out what phpPgAdmin does to alter the behaviour of this function.

I'm currently using phpPgAdmin 5.0.3-1, PostgreSQL  9.1+129ubuntu1, Apache 2.2.22-1ubuntu1, and php 5.3.10-1ubuntu3.4 under Ubuntu 12.04.1 LTS.

----------------------------------------------------------------------

>Comment By: Robert Treat (xzilla)
Date: 2012-11-23 07:33

Message:
Well, afaict, the reason you end up with an "x" is that we are calling
stripslashes as well. It's odd that your test script produces an empty
string, it should return \x I would think. In any case, fixing the above
seems straightforward enough. I have a patch committed in my working tree:
https://github.com/xzilla/phppgadmin/commit/00ba6912c15e04221e15574072449051af645685

Please take a look and LMK if you have any problems with this. I'll
probably merge it into upstream in a few days, though I think there are
some additional escaping problems you should watch out for (that deal with
9.1's new escape format, which is incompatible with PPA's escape handling).


----------------------------------------------------------------------

Comment By: Rick Yorgason (skrapion)
Date: 2012-10-23 18:37

Message:
I just realized my first sentence might be confusing since I'm using the
term 'field' in two different ways.

What I meant to say is, if you have a table with a bytea field and try to
use the 'Select' action on it (ie tables.php?action=confselectrows), it
fills the textarea next to the bytea column with an 'x' character.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3579602&group_id=37132

[ppa-help] [ phppgadmin-Bugs-3589376 ] Pgadmin is providing versino info

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

Bugs item #3589376, was opened at 2012-11-23 02:40
Message generated for change (Tracker Item Submitted) made by gandalf001
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3589376&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: Security
Group: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Gandalf (gandalf001)
Assigned to: Christopher Kings-Lynne (chriskl)
Summary: Pgadmin is providing versino info

Initial Comment:
Hi, I think its security bug to provide php version info and phppgadmin to anonymous user. So please change line 20 from intro.php to:

<h1><?php echo "$appName  ?></h1>

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3589376&group_id=37132

[ppa-help] [Open Discussion] RE: phpPgAdmin 5.1 & Postgres 9.2

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

The following forum message was posted by ronironi2 at http://sourceforge.net/projects/phppgadmin/forums/forum/115883/topic/6013775:

I would like to know too.

phpPgAdmin is now trailing by two major versions (9.0> 9.1 and 9.2)

Even using 5.1 there are still issues with pg9.2

Thanks

[ppa-help] [Help] RE: Configuration Error! HELP!

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

The following forum message was posted by uniksist at http://sourceforge.net/projects/phppgadmin/forums/forum/115884/topic/1341160:

[quote]The config.inc.php file is a symlink from the config.inc.php contained
in another directory. Many installation has base_dir restriction so the
config.inc.php is not readable for the webserver. Delete the @config.inc.php
and copy another version. It will work.[/quote]
I also had this problem after installing phppgdmin:
[quote]Configuration error: Copy conf/config.inc.php-dist to conf/config.inc.php
and edit appropriately.[/quote]
 And your advice helped me a lot. Thank you very much friend! Thanks, it works!

Re: [ppa-help] phppgadmin fatal error

[Jehan-Guillaume (i. de R. <io...@fr...>]

phpPgAdmin 5.0 does NOT support PostgreSQL 9.2.

Please, download our current developpement branch if you want to use
it with PostgreSQL 9.2:

  https://github.com/phppgadmin/phppgadmin/archive/master.zip

Cheers,

On 13/11/2012 16:03, fj...@gm... wrote:
> The following data was submitted on 2012/11/13 15:03.
> 
> 
> 
> ====== E-mail ======
> 
> Name Frank PostgreSQL ver. 9.2 phpPgAdmin ver. 5.04 Comments I get
> the following error when I try to create a table thru phppgadmin
> interface
> 
> SQL error:
> 
> ERROR:  column "spclocation" does not exist at character 67
> 
> In statement:
> 
> SELECT spcname, pg_catalog.pg_get_userbyid(spcowner) AS spcowner,
> spclocation, (SELECT description FROM pg_catalog.pg_shdescription
> pd WHERE pg_tablespace.oid=pd.objoid) AS spccomment FROM
> pg_catalog.pg_tablespace WHERE spcname NOT LIKE $$pg\_%$$ ORDER BY
> spcname
> 

[ppa-help] phppgadmin fatal error

[<fj...@gm...>]

The following data was submitted on 2012/11/13 15:04.



====== E-mail ======

Name
		Frank
PostgreSQL ver.
		9.2
phpPgAdmin ver.
		5.04
Comments
		I get the following error when I try to create a table thru phppgadmin interface

SQL error:

ERROR:  column "spclocation" does not exist at character 67

In statement:

SELECT spcname, pg_catalog.pg_get_userbyid(spcowner) AS spcowner, spclocation,
                    (SELECT description FROM pg_catalog.pg_shdescription pd WHERE pg_tablespace.oid=pd.objoid) AS spccomment
					FROM pg_catalog.pg_tablespace WHERE spcname NOT LIKE $$pg\_%$$ ORDER BY spcname

[ppa-help] phppgadmin fatal error

[<fj...@gm...>]

The following data was submitted on 2012/11/13 15:04.



====== E-mail ======

Name
		Frank
PostgreSQL ver.
		9.2
phpPgAdmin ver.
		5.04
Comments
		I get the following error when I try to create a table thru phppgadmin interface

SQL error:

ERROR:  column "spclocation" does not exist at character 67

In statement:

SELECT spcname, pg_catalog.pg_get_userbyid(spcowner) AS spcowner, spclocation,
                    (SELECT description FROM pg_catalog.pg_shdescription pd WHERE pg_tablespace.oid=pd.objoid) AS spccomment
					FROM pg_catalog.pg_tablespace WHERE spcname NOT LIKE $$pg\_%$$ ORDER BY spcname

[ppa-help] phppgadmin fatal error

[<fj...@gm...>]

The following data was submitted on 2012/11/13 15:03.



====== E-mail ======

Name
		Frank
PostgreSQL ver.
		9.2
phpPgAdmin ver.
		5.04
Comments
		I get the following error when I try to create a table thru phppgadmin interface

SQL error:

ERROR:  column "spclocation" does not exist at character 67

In statement:

SELECT spcname, pg_catalog.pg_get_userbyid(spcowner) AS spcowner, spclocation,
                    (SELECT description FROM pg_catalog.pg_shdescription pd WHERE pg_tablespace.oid=pd.objoid) AS spccomment
					FROM pg_catalog.pg_tablespace WHERE spcname NOT LIKE $$pg\_%$$ ORDER BY spcname

[ppa-help] [Help] ERROR: column "tgisconstraint&qu...

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

The following forum message was posted by jasmine629 at http://sourceforge.net/projects/phppgadmin/forums/forum/115884/topic/6150737:

Hello,

I'm running phpPgAdmin 5.0.4 with PostgreSQL 9.2.1 on Mac 10.7.5, and have received
the error below when attempting to create a trigger.  I had no problems creating
the function.  I installed phpPgAdmin using the PostgreSQL Add-ons feature of
its install dmg.

[code]SQL error:

ERROR:  column "tgisconstraint" does not exist
LINE 9:     AND (NOT tgisconstraint OR NOT EXISTS
                     ^
In statement:

SELECT
				t.tgname, pg_catalog.pg_get_triggerdef(t.oid) AS tgdef,
				CASE WHEN t.tgenabled = 'D' THEN FALSE ELSE TRUE END AS tgenabled, p.oid
AS prooid,
				p.proname || ' (' || pg_catalog.oidvectortypes(p.proargtypes) || ')' AS
proproto,
				ns.nspname AS pronamespace
			FROM pg_catalog.pg_trigger t, pg_catalog.pg_proc p, pg_catalog.pg_namespace
ns
			WHERE t.tgrelid = (SELECT oid FROM pg_catalog.pg_class WHERE
relname='Sessions'
				AND relnamespace=(SELECT oid FROM pg_catalog.pg_namespace WHERE
nspname='public'))
				AND (NOT tgisconstraint OR NOT EXISTS
						(SELECT 1 FROM pg_catalog.pg_depend d    JOIN pg_catalog.pg_constraint c
							ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
						WHERE d.classid = t.tableoid AND d.objid = t.oid AND d.deptype = 'i' AND
c.contype = 'f'))
				AND p.oid=t.tgfoid
				AND p.pronamespace = ns.oid[/code]

Any assistance would be greatly appreciated.

Thank you,

Jasmine

[ppa-help] [ phppgadmin-Bugs-3585343 ] Strict Standards Error during Login

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

Bugs item #3585343, was opened at 2012-11-07 23:10
Message generated for change (Comment added) made by ioguix
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3585343&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: Login
Group: 5.0.4
>Status: Closed
Resolution: None
Priority: 5
Private: No
Submitted By: MichaelG7355 (michaelg7355)
Assigned to: Christopher Kings-Lynne (chriskl)
Summary: Strict Standards Error during Login

Initial Comment:
During login to PostgreSQL receive the following error from PHP concerning Strict Standards.

Using phpPgAdmin-5.0.4 with PHP 3.5.4 on a WAMP server.  No problems with install or actuation of phpPgAdmin in WAMP, but login fails due to error:

Strict Standards:  Only variables should be assigned by reference in: (File Root)...\classes\database\Connection.php, line 23.

Have attached screenshot of error message.



----------------------------------------------------------------------

>Comment By: J.Guillaume (ioguix) de Rorthais (ioguix)
Date: 2012-11-08 02:06

Message:
Hello,

PHP 3.5.4 doesn't exists, I suppose you talk about a 5.4 version of PHP.

Anyway, this has been fixed in our dev repository:

 
https://github.com/phppgadmin/phppgadmin/commit/9b19f9cd742e1a6831d59bc40400636d9f55f520

The next version of phpPgAdmin should be released soon. However, you can
already download a snapshot today from github.

Thank you for your report.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3585343&group_id=37132

[ppa-help] [ phppgadmin-Bugs-3585343 ] Strict Standards Error during Login

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

Bugs item #3585343, was opened at 2012-11-07 23:10
Message generated for change (Tracker Item Submitted) made by michaelg7355
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3585343&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: Login
Group: 5.0.4
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: MichaelG7355 (michaelg7355)
Assigned to: Christopher Kings-Lynne (chriskl)
Summary: Strict Standards Error during Login

Initial Comment:
During login to PostgreSQL receive the following error from PHP concerning Strict Standards.

Using phpPgAdmin-5.0.4 with PHP 3.5.4 on a WAMP server.  No problems with install or actuation of phpPgAdmin in WAMP, but login fails due to error:

Strict Standards:  Only variables should be assigned by reference in: (File Root)...\classes\database\Connection.php, line 23.

Have attached screenshot of error message.



----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3585343&group_id=37132

Re: [ppa-help] COPY Command and Quotes

[Sebastian H. <sh...@ip...>]

Hi,

Thanks for your reply. Yes this was the problem. Thanks!

Best regards,
Sebastian Hahn

On 4 November 2012 14:43, Jehan-Guillaume (ioguix) de Rorthais
<io...@fr...> wrote:
> Hello,
>
> I suspect your magic_quote_gpc to be turned on in your PHP setup.
>
> On 10/09/2012 16:52, sh...@ip... wrote:
>> The following data was submitted on 2012/09/10 14:52.
>>
>>
>>
>> ====== E-mail ======
>>
>> Name Sebastian Hahn PostgreSQL ver. PostgreSQL 8.3.18 phpPgAdmin
>> ver. phpPgAdmin 5.0.4 (PHP 5.3.8) Comments Dear Developers,
>>
>> I always get an error message using the command:
>>
>> SQL error:
>>
>> ERROR:  syntax error at or near "\" LINE 1: COPY warp_grid
>> (id,cell,ind_ld,ind_l,geog) FROM \'/srv/www/h... ^
>>
>> In statement: COPY warp_grid (id,cell,ind_ld,ind_l,geog) FROM
>> \'/srv/www/htdocs/radar/warp_grid_insert.txt\' WITH DELIMITER AS
>> \',\';
>>
>> The original query looks like: COPY warp_grid
>> (id,cell,ind_ld,ind_l,geog) FROM
>> '/srv/www/htdocs/radar/warp_grid_insert.txt' WITH DELIMITER AS
>> ',';
>>
>> Why does phpPgAdmin add \ ? Why do I get the error msg? What needs
>> to be changed? Thanks in advance!
>>
>> Best regards, Sebastian
>



-- 
Dipl.-Ing. Sebastian Hahn
Vienna University of Technology
Institute of Photogrammetry and Remote Sensing
Gusshaustraße 27-29, A-1040 Vienna
Tel: +43 1 58801 12240
Fax: +43 1 58801 12299
sh...@ip...
http://www.ipf.tuwien.ac.at/

Re: [ppa-help] Dead links

[Jehan-Guillaume (i. de R. <io...@fr...>]

Thank you for this report on the website.

Links has been fixed.

Cheers!

On 26/03/2012 21:57, hp...@ps... wrote:
> The following data was submitted on 2012/03/26 19:57.
> 
> 
> 
> ====== E-mail ======
> 
> Name Henry Pfeil PostgreSQL ver. n/a phpPgAdmin ver. n/a Comments 
> Page affected -
> http://phppgadmin.sourceforge.net/doku.php?id=download Name: "The
> PostgreSQL Yum Repository" Link: http://yum.pgsqlrpms.org/
> 
> Pgsqlrpms is a dead link. It redirects to 
> http://domains.googlesyndication.com/apps/domainpark
> 
> I thought I'd investigate gophp5, but http://gophp5.org/ somehow
> lands on musicroller.com. Dig shows they both have the same IP
> address.
> 
> Fedora 16+ maintains its own phppgadmin rpm files. Yum will find
> them in fedora.repo and fedora-updates.repo, or on its distribution
> mirror sites. -- Obquote: "Something's afoot, and it's not attached
> to my ankle." -Musings of Psnarf, 3.14;159
> 
> 

Re: [ppa-help] COPY Command and Quotes

[Jehan-Guillaume (i. de R. <io...@fr...>]

Hello,

I suspect your magic_quote_gpc to be turned on in your PHP setup.

On 10/09/2012 16:52, sh...@ip... wrote:
> The following data was submitted on 2012/09/10 14:52.
> 
> 
> 
> ====== E-mail ======
> 
> Name Sebastian Hahn PostgreSQL ver. PostgreSQL 8.3.18 phpPgAdmin
> ver. phpPgAdmin 5.0.4 (PHP 5.3.8) Comments Dear Developers,
> 
> I always get an error message using the command:
> 
> SQL error:
> 
> ERROR:  syntax error at or near "\" LINE 1: COPY warp_grid
> (id,cell,ind_ld,ind_l,geog) FROM \'/srv/www/h... ^
> 
> In statement: COPY warp_grid (id,cell,ind_ld,ind_l,geog) FROM
> \'/srv/www/htdocs/radar/warp_grid_insert.txt\' WITH DELIMITER AS
> \',\';
> 
> The original query looks like: COPY warp_grid
> (id,cell,ind_ld,ind_l,geog) FROM
> '/srv/www/htdocs/radar/warp_grid_insert.txt' WITH DELIMITER AS
> ',';
> 
> Why does phpPgAdmin add \ ? Why do I get the error msg? What needs
> to be changed? Thanks in advance!
> 
> Best regards, Sebastian

[ppa-help] [Open Discussion] RE: Dump encoding

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

The following forum message was posted by ioguix at http://sourceforge.net/projects/phppgadmin/forums/forum/115883/topic/6091422:

Hi Peter,

I'm not sure to understand what you try to fix, do you have a scenario that
shows any problem with that ?

Presently, in the current dev branch (which should be released really soon),
we always set the client_encoding to 'UTF-8', so the backend should send the
dump encoded in UTF-8.

See "classes/Misc.php" line 508.