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

[ppa-help] hash signatures for production release files??

[<ot...@gm...>]

The following data was submitted on 2013/03/18 11:29.



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

Name
		Otheus
PostgreSQL ver.
		?
phpPgAdmin ver.
		5.0.4
Comments
		Can you please post md5/sha1 signatures for the 5.0.4 releases on your website. It's not that I don't trust you guys, but downloads to sourceforge are susceptible to man-in-middle attacks.

[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: 2013-03-14 22:22

Message:
Well, this through us for quite a loop, but this has finally been fixed. I
have a patch in my tree at
https://github.com/xzilla/phppgadmin/commit/1ab13f459a8ac95c8970d1100edca750ca2048ee
which keeps the data from being munged, although it displays it as escape
data rather than hex (which psql does). It appears that you can modify
classes/database/Postgres.php and set it to false to have it print hex
values, which also appears to allow for safe updating, if you really need
it to appear that way. That isn't currently recommend though. I will leave
this ticket open for a few more days, but I expect to push this patch into
the main ppa repo in a few days. 

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

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-3607547 ] PhpPgAdmin - Problema Criando Nova Tabela

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

Bugs item #3607547, was opened at 2013-03-10 10:29
Message generated for change (Settings changed) made by ernestovm
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3607547&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: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: ernesto vieira magalhães (ernestovm)
Assigned to: Nobody/Anonymous (nobody)
>Summary: PhpPgAdmin - Problema Criando Nova Tabela

Initial Comment:
AO tentar criar nova tabela ou alterar uma existente está dando o seguinte erro:

Erro de SQL:

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

No bloco:

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

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

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

[ppa-help] [ phppgadmin-Bugs-3607547 ] Problema Criando Nova Tabela

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

Bugs item #3607547, was opened at 2013-03-10 10:29
Message generated for change (Tracker Item Submitted) made by ernestovm
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3607547&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: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: ernesto vieira magalhães (ernestovm)
Assigned to: Nobody/Anonymous (nobody)
Summary: Problema Criando Nova Tabela

Initial Comment:
AO tentar criar nova tabela ou alterar uma existente está dando o seguinte erro:

Erro de SQL:

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

No bloco:

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

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

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

[ppa-help] [Open Discussion] parameter for dump command

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

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

Hello,
I would like to add the --no-owner parameter to pg_dump & pg_dumpall. I have
add this to the config command, but this does not work. How can I add parameters
in the configuration to the dump command?

Thanks

[ppa-help] [ phppgadmin-Feature Requests-3605514 ] Table filter

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

Feature Requests item #3605514, was opened at 2013-02-21 01:01
Message generated for change (Tracker Item Submitted) made by jaures
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=418983&aid=3605514&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: None
Group: None
Status: Open
Priority: 5
Private: No
Submitted By: Jaures Pedrelli (jaures)
Assigned to: Nobody/Anonymous (nobody)
Summary: Table filter

Initial Comment:
For a more fast table browsing (if you have thousand) can be useful a filter like phpMyAdmin or SquirrelSQL

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

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

[ppa-help] (no subject)

[Polimati S. <pol...@gm...>]

-- 
Sir/Madam,

I Use Windows 7 os and install postgres sql, php and phppgadmin. But we
recieve error message like below when create a table or database in that.

error:

*SQL error:*

ERROR:  column "spclocation" does not exist
LINE 1: ...pg_catalog.pg_get_userbyid(spcowner) AS spcowner, spclocatio...
                                                             ^

*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


Thanks & Regards,
name : P. Sunil Babu
Mobile: (91) 9032034250
Email: pol...@gm... <vis...@gm...>


    Sunil babu
   9032034250

[ppa-help] [ phppgadmin-Bugs-3602305 ] INSTALL refers to out-of-date server parameters

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

Bugs item #3602305, was opened at 2013-01-27 11:50
Message generated for change (Tracker Item Submitted) made by viritrilbia
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3602305&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: Install
Group: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Michael Shulman (viritrilbia)
Assigned to: Nobody/Anonymous (nobody)
Summary: INSTALL refers to out-of-date server parameters

Initial Comment:
Step 5 in the INSTALL file says to set four server parameters to enable statistics collection (stats_start_collector, stats_command_string, stats_block_level, and stats_row_level).  It appears that as of PostgreSQL 8.3, these parameters were removed/renamed/merged respectively (http://www.postgresql.org/docs/8.3/static/release-8-3.html) and the correct parameters to set are now track_activities and track_counts.

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

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

[ppa-help] [ phppgadmin-Bugs-3600666 ] sprintf() error

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

Bugs item #3600666, was opened at 2013-01-13 03:25
Message generated for change (Comment added) made by x4801x
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3600666&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: Functions
Group: 5.0.4
>Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Benny Pedersen (x4801x)
Assigned to: Robert Treat (xzilla)
Summary: sprintf() error

Initial Comment:
Warning: sprintf(): Too few arguments in /var/www/example.org/classes/Misc.php on line 1281

exists in gentoo portage version phppgadmin-9999, php version 5.4.8

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

>Comment By: Benny Pedersen (x4801x)
Date: 2013-01-22 11:07

Message:
in git master i see this after login

Warning: sprintf(): Too few arguments in
/var/www/localhost/htdocs/phppgadmin/classes/Misc.php on line 1281

git master is here git clone git://github.com/phppgadmin/phppgadmin.git ?

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

Comment By: Robert Treat (xzilla)
Date: 2013-01-21 12:59

Message:
I am unable to reproduce this error; can you provide more details on steps
to reproduce. Also, it's possible it is fixed in git master, any chance you
could test that and see if you still have the problem? 

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

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

[ppa-help] [ phppgadmin-Bugs-3600666 ] sprintf() error

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

Bugs item #3600666, was opened at 2013-01-13 03:25
Message generated for change (Comment added) made by xzilla
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3600666&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: Functions
Group: 5.0.4
>Status: Pending
Resolution: None
Priority: 5
Private: No
Submitted By: Benny Pedersen (x4801x)
>Assigned to: Robert Treat (xzilla)
Summary: sprintf() error

Initial Comment:
Warning: sprintf(): Too few arguments in /var/www/example.org/classes/Misc.php on line 1281

exists in gentoo portage version phppgadmin-9999, php version 5.4.8

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

>Comment By: Robert Treat (xzilla)
Date: 2013-01-21 12:59

Message:
I am unable to reproduce this error; can you provide more details on steps
to reproduce. Also, it's possible it is fixed in git master, any chance you
could test that and see if you still have the problem? 

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

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

[ppa-help] [ phppgadmin-Bugs-3599031 ] html & css on insert foreign key value

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

Bugs item #3599031, was opened at 2012-12-31 10:27
Message generated for change (Comment added) made by xzilla
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3599031&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: Web Site
Group: None
>Status: Pending
>Resolution: Fixed
Priority: 5
Private: No
Submitted By: flashpixx (flashpixx)
>Assigned to: Robert Treat (xzilla)
Summary: html & css on insert foreign key value

Initial Comment:
Hello, I use phpPGAdmin under Safari on OSX. If I add a new dataset to a table which reference to another table (foreign key), on inserting the values of the other table are shown, if I click on one of the values this code will be inserted:
<div style="text-align: right; background-color: rgb(61, 128, 223); color: rgb(255, 255, 255); "> --- </div>

--- is the value of the table
Thanks

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

Comment By: Robert Treat (xzilla)
Date: 2013-01-21 12:54

Message:
This issue has been resolved and is currently fixed in GIT.  If 
you wish to acquire the fix, please download the updated code from

http://github.com/xzilla/phppgadmin/

Alternatively, you can download a nightly snapshot from:

http://phppgadmin.sourceforge.net/

Note that you may have to wait up to 24 hours for the latest GIT
changes to appear in the snapshot.

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

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

[ppa-help] [ phppgadmin-Bugs-3600666 ] sprintf() error

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

Bugs item #3600666, was opened at 2013-01-13 03:25
Message generated for change (Tracker Item Submitted) made by x4801x
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3600666&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: Functions
Group: 5.0.4
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Benny Pedersen (x4801x)
Assigned to: Christopher Kings-Lynne (chriskl)
Summary: sprintf() error

Initial Comment:
Warning: sprintf(): Too few arguments in /var/www/example.org/classes/Misc.php on line 1281

exists in gentoo portage version phppgadmin-9999, php version 5.4.8

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

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

[ppa-help] error can't create DB

[<lui...@ga...>]

The following data was submitted on 2013/01/09 12:29.



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

Name
		Luis Carlos Guaiquirián Prato
PostgreSQL ver.
		9.2
phpPgAdmin ver.
		 5.0.4 
Comments
		My problem is I can not create a database using phpphadmin, I get
___________________________________________________________________
Error de SQL:

ERROR:  no existe la columna «spclocation»
LINE 1: ...pg_catalog.pg_get_userbyid(spcowner) AS spcowner, spclocatio...

                                                             ^

En la declaración:

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

I need your help, thanks.

[ppa-help] [Help] RE: Error Loading all_db.php

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

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

I found a solution here:
[url]http://old.nabble.com/-Help--Strict-Standards-errors-td34108324.html[/url]

After placing the line [code]error_reporting(E_ALL & ~E_NOTICE & ~E_STRICT &
~E_DEPRECATED);[/code]
in my config.inc.php, the errors went away, and the tree is displayed
correctly.

(before i googled for "Error Loading all-db.php", this time i googled for "Strict
Standards: Only variables...")

Jody

[ppa-help] [Help] Error Loading all_db.php

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

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

Hi 
(sorry for crossposting - i first put this on wrong forum)
I don't know when exactly this started (probably after updating postgres to
9.1.5 or updating phpPgAdmin to 5.0.4).

Anyway, after i click on "PostgreSQL (in the tree on the left) and then log
in,
i get the following messages on top of the window: 
[code]Strict Standards: Only variables should be assigned by reference
in /var/www/localhost/htdocs/phppgadmin/classes/database/Connection.php on line
23
Strict Standards: Only variables should be passed by reference in
/var/www/localhost/htdocs/phppgadmin/redirect.php on line 14[/code]
Furthermore, instead of a tree representing the data base i only have a line: 
[code]Error Loading
all_db.php?subject=server&action=tree&server=localhost%3A5432%3Aallow
(???)[/code]
below the nodes 'Servers' and 'PostgreSQL'. 

However, access to the DB (on the right hand side of the window is working correctly.
But it is much more comfortable to navigate in the tree. 

Here are my settings of config.inc.php: [code]
    $conf['servers'][0]['desc'] = 'PostgreSQL'; 
    $conf['servers'][0]['host'] = 'localhost'; 
    $conf['servers'][0]['port'] = 5432; 
    $conf['servers'][0]['sslmode'] = 'allow'; 
    $conf['servers'][0]['defaultdb'] = 'template1'; 
    $conf['servers'][0]['pg_dump_path'] = '/usr/bin/pg_dump'; 
    $conf['servers'][0]['pg_dumpall_path'] = '/usr/bin/pg_dumpall'; 
    $conf['servers'][0]['slony_support'] = false; 
    $conf['servers'][0]['slony_sql'] = '/usr/share/pgsql'; 
    $conf['default_lang'] = 'auto'; 
    $conf['autocomplete'] = 'default on'; 
    $conf['extra_login_security'] = true; 
    $conf['owned_only'] = false; 
    $conf['show_comments'] = true; 
    $conf['show_advanced'] = false; 
    $conf['show_system'] = false; 
    $conf['show_reports'] = true; 
    $conf['reports_db'] = 'phppgadmin'; 
    $conf['reports_schema'] = 'public'; 
    $conf['reports_table'] = 'ppa_reports'; 
    $conf['min_password_length'] = 1; 
    $conf['left_width'] = 200; 
    $conf['theme'] = 'default'; 
    $conf['show_oids'] = false; 
    $conf['max_rows'] = 30; 
    $conf['max_chars'] = 50; 
    $conf['use_xhtml_strict'] = false; 
    $conf['help_base'] = 'http://www.postgresql.org/docs/%s/interactive/'; 
    $conf['ajax_refresh'] = 3; 
    /***************************************** 
     * Don't modify anything below this line * 
    *****************************************/ 
    $conf['version'] = 19; 
[/code]

How can i get phpPgAdmin to work correctly again? 

Thank You 
  Jody

[ppa-help] [Help] How do I execute parameterized queries?

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

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

I have queries of the form
[code]SELECT foo FROM bar WHERE baz=$1[/code]
which I would like to test and optimize in the SQL execution tool, but there
is no facility to provide value for the parameters.
In my regular PHP code I use pg_query_params with these queries: I was hoping
I could have an interface in phpPgAdmin to set the array of parameters and run
the query without having to replace the place-holders manually.
Maybe I will have a look at the code for the SQL execution code and try to adapt
it, but I suspect that it will be buried quite deep...

[ppa-help] [ phppgadmin-Bugs-3599031 ] html & css on insert foreign key value

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

Bugs item #3599031, was opened at 2012-12-31 10:27
Message generated for change (Tracker Item Submitted) made by flashpixx
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3599031&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: Web Site
Group: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: flashpixx (flashpixx)
Assigned to: Nobody/Anonymous (nobody)
Summary: html & css on insert foreign key value

Initial Comment:
Hello, I use phpPGAdmin under Safari on OSX. If I add a new dataset to a table which reference to another table (foreign key), on inserting the values of the other table are shown, if I click on one of the values this code will be inserted:
<div style="text-align: right; background-color: rgb(61, 128, 223); color: rgb(255, 255, 255); "> --- </div>

--- is the value of the table
Thanks

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

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

[ppa-help] [ phppgadmin-Bugs-3598866 ] SQL error when "Paginate results" is hooked

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

Bugs item #3598866, was opened at 2012-12-29 09:04
Message generated for change (Tracker Item Submitted) made by whitewolf_fox
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3598866&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: GIT
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Marc Richter (whitewolf_fox)
Assigned to: Nobody/Anonymous (nobody)
Summary: SQL error when "Paginate results" is hooked

Initial Comment:
I'm using recent Git version of phpPgAdmin along with PG 9.2 . I Just entered this one in PHPPGADMIN's SQL Editor with "Paginate results" hooked: http://pastebin.com/tZLP8HPD and got : http://pastebin.com/LhUFGfjG
When not hooked or in psql cmd promt, it works.

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

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

[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 ioguix
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: Open
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: J.Guillaume (ioguix) de Rorthais (ioguix)
Date: 2012-12-15 06:15

Message:
The new screenshot.

http://en.zimagez.com/zimage/thephppgadmindisplaystabledatapoorly.php

I'm pretty sure this bug comes from badly truncated UTF-8 chars. We do not
take care of mb-strings at all in PPA...

ISTM a thread or bug report is already floating around about that. By this
time, we discussed the possiblity to replace all string functions by the mb
equivalent when possible, as this module is often available in default PHP
installations.

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

Comment By: Christoph Berg (df7cb)
Date: 2012-11-28 00:22

Message:
The strrings there were not that long. I guess it was UTF-8 strings clipped
in the middle of some wide character, or something like that. I've asked
the OP to provide the screenshot again.

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

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] [ 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 ioguix
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: J.Guillaume (ioguix) de Rorthais (ioguix)
Date: 2012-12-15 06:00

Message:
Mh, 
"extra login security" is for ... login security (why should we keep that
btw ?).

IMHO, if this is really an issue, we should just remove the PHP version and
explain people how to get their PHP version when needed.


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

Comment By: Gandalf (gandalf001)
Date: 2012-11-28 01:14

Message:
If the default will be not displaying version information, I am fine with
it.

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

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] Only keeps last query when editing SQL

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

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

I installed phpPgAdmin 5.0.4-1 over PostgreSQL 9.2.2.
I know that support is for 9.0.x and earlier versions, but everything seems
to work fine, except one thing.

When I run different SQL queries in the SQL window of different tabs (Firefox
17.0.1), and then I click 'Edit' at the bottom of every result page, it always
shows me the last query that was executed, whatever the tab and the original
query.

When I was running phpPgAdmin 4.2.2 over PostgreSQL 8.4.2, I never had that
problem.
Is it fixable, or I have to wait for the next phpPgAdmin version ?

[ppa-help] [ phppgadmin-Bugs-3570272 ] pg_tablespace.spclocation column removed in 9.2

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

Bugs item #3570272, was opened at 2012-09-20 16:38
Message generated for change (Comment added) made by ryandesign
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3570272&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: None
Group: 5.0.3
Status: Closed
Resolution: Fixed
Priority: 5
Private: No
Submitted By: Dante Lopez (dqlopez)
Assigned to: J.Guillaume (ioguix) de Rorthais (ioguix)
Summary: pg_tablespace.spclocation column removed in 9.2

Initial Comment:
phpPgAdmin 5.0.3 (PHP 5.4.6-2~precise+1)

Can't create database/table/schema on the current build if used with Postgres 9.2. Refer to this mailing list issues:

http://archives.postgresql.org/pgsql-bugs/2012-06/msg00203.php
http://archives.postgresql.org/pgsql-bugs/2012-06/msg00202.php
http://archives.postgresql.org/pgsql-bugs/2012-06/msg00201.php
http://archives.postgresql.org/pgadmin-hackers/2012-04/msg00045.php

SQL error:
ERROR:  column "spclocation" does not exist
LINE 1: ...pg_catalog.pg_get_userbyid(spcowner) AS spcowner, spclocatio...
                                                             ^
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

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

Comment By: Ryan Schmidt (ryandesign)
Date: 2012-12-03 13:52

Message:
Please release a stable version of phpPgAdmin containing this fix.

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

Comment By: J.Guillaume (ioguix) de Rorthais (ioguix)
Date: 2012-11-04 05:26

Message:
Guys, 

You should use the latest snpashot of PPA instead of patching it.

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

Comment By: https://www.google.com/accounts ()
Date: 2012-10-25 05:57

Message:
peterireds,

You missed one thing.

Change in Postgres92.php

FROM:

class Postgres84 extends Postgres {

	var $major_version = 8.4;

TO:


class Postgres92 extends Postgres {

	var $major_version = 9.2;

It completes the fix.

Cesar

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

Comment By: J.Guillaume (ioguix) de Rorthais (ioguix)
Date: 2012-10-08 05:55

Message:
...Or just download the snapshot of the current dev branch:

https://github.com/phppgadmin/phppgadmin/zipball/master

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

Comment By: Peter Hfer (peterireds)
Date: 2012-10-06 14:11

Message:
Quick Fix: (worked with my Version (5.0.3) / pg 9.2.1 )

1) change to /classes/database
2) copy "Postgres84.php" to "Postgres92.php"
3) open Connection.php
4) add a line 
                     case '9.2': return 'Postgres92'; break; 
  at // Detect version and choose appropriate database driver  - switch 
5) open "Postgres.php" & copy functions "getTablespaces" + "getTablespace"
6) open "Postgres92.php"  paste functions into the class 
7) replace ", spclocation," with ", pg_tablespace_location(oid) as
spclocation," in both functions

regards

Peter 


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

Comment By: J.Guillaume (ioguix) de Rorthais (ioguix)
Date: 2012-09-21 10:18

Message:
Hello,

phpPgAdmin 5.0 is officialy not compatible with pg 9.2.

This regression has been fixed in our current development branch of
phpPgAdmin. The next release of phpPgAdmin should be released soon.

Thank you for your bug report.

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

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

[ppa-help] [ phppgadmin-Bugs-3347388 ] fail with user with restricted access rights

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

Bugs item #3347388, was opened at 2011-06-30 11:39
Message generated for change (Settings changed) made by xzilla
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3347388&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.2
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Franz-Josef Färber (fjf2002)
>Assigned to: Robert Treat (xzilla)
Summary: fail with user with restricted access rights

Initial Comment:
If the logged-in user can't access all databases (i.e. CONNECT privilege not set on every single database), phppgadmin will fail. Each mouse click in the left tree will result in the login screen to appear on the right, even with databases this user surely has privileges on. Having read http://sourceforge.net/projects/phppgadmin/forums/forum/115884/topic/3911449, i concluded the problem could be Javascript trying to expand several subtrees, even ones without having any permission.
It seems that I was able to solve the problem at least partially by manually editing Postgres.php file, method getDatabases. I added

 "AND has_database_privilege('{$username}', pdb.datname, 'CONNECT')"

to the WHERE clause of the select query, so that only databases appear the user is able to connect to - a feature I always wanted, like in phpmyadmin.


Perhaps these access problems should be solved in future releases(?)


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

>Comment By: Robert Treat (xzilla)
Date: 2012-11-28 10:35

Message:
confirming that this is a problem, but I don't think I want to implement
the proposed fix. most postgres clients allow users to list the databases
regardless of connection privileges, I think I'd prefer to mimic that
behavior in phppgadmin 

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

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3347388&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 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: 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: Gandalf (gandalf001)
Date: 2012-11-28 01:14

Message:
If the default will be not displaying version information, I am fine with
it.

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

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-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 df7cb
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: Open
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: Christoph Berg (df7cb)
Date: 2012-11-28 00:22

Message:
The strrings there were not that long. I guess it was UTF-8 strings clipped
in the middle of some wide character, or something like that. I've asked
the OP to provide the screenshot again.

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

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