Probleme connexion base postgrsql de free.fr
Error in phpPgAdmin when trying to edit or delete a row.
Project Moved To Github
Home
Leading slash in form path breaks when deployed in subfolder
Look at this great solution https://www.developpez.net/forums/d1304918/bases-donnees/postgresql/installation/probleme-apres-installation-postgresql-9-2-2-a/ File : Postgres.php (you can find this file by command find, generally it exists in : /usr/share/phpPgAdmin/classes/database) in line : 6983 you edit the classe by this code : SELECT spcname, pg_catalog.pg_get_userbyid(spcowner) AS spcowner, pg_tablespace_location(oid) AS spclocation, (SELECT description FROM pg_catalog.pg_shdescription pd WHERE...
phpPgAdmin 7.12.1 (PHP 7.4.4) still here
I was unable to find a version at the above repository.
Good afternoon, Is possible to connect phpPhAdmin to a google database? I'm trying to configure config.inc.php file with ssl certificates but i cannot login. phpPgAdmin version 5.6 PHP version 7.3.15 Thank you in advance.
Cross Site Scripting vulnerability
Thanks for the information. Using an older version 5.1 of phppgadmin works. Hopefully there will be an applied patch for newer versions.
I have not fully tested it, but I appear to have been able to fix my local copy by modifying the following file: /usr/local/cpanel/base/3rdparty/phpPgAdmin/classes/database/Postgres.php In the getSequence() function I modified this $sql variable: $sql = " SELECT c.relname AS seqname, s.*, m.seqstart AS start_value, m.seqincrement AS increment_by, m.seqmax AS max_value, m.seqmin AS min_value, m.seqcache AS cache_value, m.seqcycle AS is_cycled, pg_catalog.obj_description(m.seqrelid, 'pg_class') AS...
I'm having the same issue. PostgreSQL 8.4.20 phpPgAdmin 5.6 (PHP 7.3.6) Works fine in phpPgAdmin 5.1 (PHP 7.2.7)
It has been corrected by the PostgreSQL Team in their own repository. Please visit there and install their repository. https://www.postgresql.org/download/
Some text badly truncated or not shown at all
This is fixed in git master and will be released soon. Thanks so much for the repeatable test case!
We also insteadll version 5.6 as we were using a 7.x-dev version http://phppgadmin.sourceforge.net/doku.php?id=download However we get the same error. Anyone have any similar experiences?
I should note we can still view them via command line. It's within phppgadmin that we aren't able to see the sequences anymore.
Issue with viewing Sequences
Can't list/see/edit sequences owned by group
THis issue should be fixed in git master, and will be made available in the next release. For access to the patch, check out https://github.com/phppgadmin/phppgadmin/commit/fd9c78875b2683dea27989943345f91ce2f31450.
Hello and HELP please. I'm stuck and in need of some idiot-proof assistance. Yesterday, after a while of not using it, I tried to access phpPGAdmin, only to find that I had a "page not found" error. That I cured by following the steps in this video https://www.youtube.com/watch?v=2z8lSlh3xBw Sadly though, what hasn't yet been sorted out is my ability to log in to the default database that's on the server. My setup: There is a Postgres database on my Synology 415+ NAS unit (localhost) I access the...
column p.proisagg does not exist
I believe this is fixed in git and as such will be part of the next release. If you want to see the patch, check out: https://github.com/phppgadmin/phppgadmin/commit/e3e8087bfd8f1fb93564b7a691f8ac9ed7c63a02
The result of that change breaks support for older versions of PostgreSQL including but not limited to 9.3. Therefore the change needs to take PostgreSQL versions into account to use the correct form.
The result of that change breaks support for older versions of PostgreSQL including but not limited to 9.3.
I modified my own server like this: Add to config.inc.php: $conf['allowed login'] = array('datauser'); Add to classes/Misc.php within the block for extra_login_security: if (isset($conf['allowed login'])) { if (! in_array($username, $conf['allowed login'])) { unset($_SESSION['webdbLogin'][$_REQUEST['server']]); $msg = $lang['strlogindisallowed']; include('./login.php'); exit; } }
request for allowed user list
Can't list/see/edit sequences owned by group
Update: The definition of the query to access the list of functions should be modified in phpPgAdmin to replace pg_proc.proisagg with pg_proc.prokind. See: https://dba.stackexchange.com/questions/238903/postgresql-11-error-column-p-proisagg-does-not-exist#238906
Update: Seems that this is a PostgreSQL problem, rather than a phpPgAdmin one. I get the same error using psql. The current ticket could now be closed.
Update: Seems that this is a PostgreSQL problem, rather than a phpPgAdmin one. I get the same error using psql.
column p.proisagg does not exist
The each() function is deprecated in PHP 7.2+
phpPgAdmin doesn't work with PHP 7.x
I found out how to fix this error. See my post on Stack Overflow. Simply edit any of the files above using the solution, which I described here: https://stackoverflow.com/questions/52537682/phppgadmin-no-objects-found/54510195#54510195
I found out how to fix this error. See my post on Stack Overflow. Simply edit any of the files above using the solution, which I described here: https://stackoverflow.com/questions/52537682/phppgadmin-no-objects-found/54510195#54510195
I found out how to fix this error. See my post on Stack Overflow: https://stackoverflow.com/questions/52537682/phppgadmin-no-objects-found/54510195#54510195
column proisagg removed from pg_catalog.pg_proc in postgresql 11
Greetings, I am working with phpPgAdmin deployed into Pivotal Cloud Foundry so that I can manage my various pg db's, but recently needed to troubleshoot a function. During this time, I discovered that the output for "RAISE NOTICE" is not being displayed. Is there a way that I can enable the display of "RAISE NOTICE" in phpPgAdmin or an alternative?
Alex, yes. It works on pgsql 10.4. Thanks for your great work!
This project seems to be abandoned by the original developers. I updated phpPgAdmin to work with newer PostgreSQL/PHP versions here: https://github.com/ReimuHakurei/phppgadmin
PostgreSQL 10.3 not supported by phpPgAdmin 5.1
looks like a bug. the instruction of ... Click (server-name) > (database-name) > Schemas > public > Tables > (table-name) on left-pane. Shows table columns on right-pane. -- (a) Click Select on the bottom of right-pane. Click "Select all fields" and fill a value for something of column, then Click "Select" button. Example: column id, operator "=", value 1. Shows filtered records. -- (b) When click something column-name, back to table columns (a) status. ^- link url on column-name contains ".../phpPgAdmin/tables.php?server=..."...
looks like a bug. the instruction of ... Click (server-name) > (database-name) > Schemas > public > Tables > (table-name) on left-pane. Shows table columns on right-pane. -- (a) Click Select on the bottom of right-pane. Click "Select all fields" and fill a value for something of column, then Click "Select" button. Example: column id, operator "=", value 1. Shows filtered records. -- (b) When click something column-name, back to table columns (a) status. ^- link url on column-name contains ".../phpPgAdmin/tables.php?server=..."...
looks like a bug. the instruction of ... Click (server-name) > (database-name) > Schemas > public > Tables > (table-name) on left-pane. Shows table columns on right-pane. -- (a) Click Select on the bottom of right-pane. Click "Select all fields" and fill a value for something of column, then Click "Select" button. Shows filtered records. -- (b) When click something column-name, back to table columns (a) status. ^- link url on column-name contains ".../phpPgAdmin/tables.php?server=..." collect url...
looks like a bug. the instruction of ... Click (server-name) > (database-name) > Schemas > public > Tables > (table-name) on left-pane. Shows table columns on right-pane. -- (a) Click Select on the bottom of right-pane. Click "Select all fields" and fill a value for something of column, then Click "Select" button. Shows filtered records. -- (b) When click something column-name, back to table columns (a) status. ^- link url on column-name contains ".../phpPgAdmin/tables.php?server=..." collect url...
Hi. Thanks for this. I have however an error in all_db.php, which in line 19 references $misc If I change it by $__construct the error persists. I'm not at all developper, so any assitance would be much appreciated.
Deprecated error
Deprecated error
BUG: Bad auth in for a single DB clears session credentials
Hi I've installed the phpPgAdmin package, but whenever I try to access the Admin page (http://IP-Address/phpPgAdmin/) all I get is redirected back to the Synology main control panel page (http://IP-Address:5000/) What else needs doing to access the phpPgAdmin facility please? Thanks in advance. Martin
Hello, I run a software company in healthcare. We are currently migrating to HIPAA compliant hosting environement and I want to install phpPgAdmin to access my PostgreSQL database. The hosting provider is wondering if installing phpPgAdmin will compromise hosting security. Any thouhgts? Are there encryption available to use phpPgAdmin? Thank you
Error left Website Panel
configs under /usr/share/phpPgAdmin/conf must be symlinks to /etc/phpPgAdmin
Thanks for fix and share information about phpPgadmin. My PhpPgadmin on ubuntu solve.
DIFF of changes from git
DIFF of changes from git
I had the same problem, and I can give you some a way reproduce this bug: create a table with 2 columns (but 1 would suffice): id | integer | non NULL Par défaut, nextval('oea.test_id_seq'::regclass) label | character varying(256) | (the label column can be "text" as well) and then, insert a line with the following text: "AA: Abcdefghijlmnop Abcdefghijklmnop xüx das abücdef" (without the quotes) the text will not show on a normal table browsing, but it will if you show the full value of the text...
I had the same problem, and I can give you some a way reproduce this bug: create a table with 2 columns (but 1 would suffice): id | integer | non NULL Par défaut, nextval('oea.test_id_seq'::regclass) label | character varying(256) | (the label column can be "text" as well) and then, insert a line with the following text: "AA: Abcdefghijlmnop Abcdefghijklmnop xüx das abücdef" the text will not show on a normal browse of data, but it will if you show the full value of the text field (with the "Expand"...
Hi All! I was changed phppgadmin 5.1 to be compatible with php 7 version so link...
Misc has a deprecated constructor
Hello all, My database dropped a column somehow when I was out of the office for...
Autocomplete does not work on 5.1/9.5.4 combination
I have a problem accessing two servers on the same host using different port numbers....
Error Export Data
As a side note: This seems to appear for composite primary keys.
Getting "Notice: Undefined Index" messages in result rows
nice to have? it is a must have!
Hi I installed PostgreSQL 9.2.14 and phpPgAdmin 5.1 (more or less out of the box)...
Hi I installed PostgreSQL 9.2.14 and phpPgAdmin 5.1 (more or less out of the box)...
I am using Iceweasel 38.1
Hi! Hehe I'm pretty sure that I'm human :) You are actually right, it works in IE...
Hi, I just gave it a try and it worked as expected. Are you sure you are a human...
CAPTCHA is not working on Getting Help
Hi there. First, I am in a rush so I couldn't find the right sub-forum, so I am sorry...
Hi there. First, I am in a rush so I couldn't find the right sub-forum, so I am sory...
Redirect on table's view when we group data in select's view
Hi@all, I install phppgadmin on my debian8/64bit os an it works out of the box on...
In order to elaborate more, consider that I want to create a plugin that adds an...
Fail the authentification
similar to #436
I have similar problem with pagination. == Scenario 1. == 1. Doing - "Paginate result"...
I have similar problem with pagination. == Scenario 1. == 1. Doing - "Paginate result"...
Add ability to select multiple tables to export
Export is adding duplicate carriage return and new line characters into TEXT field
When I connect to a remote server I immediately get the following error: SQL error:...
support for shared database hosting with limited permissions
Here is a gist of that code: https://gist.github.com/fnkr/51f0a92b9f0c658287ec I...
Demo admin login fails
A fix is available at https://github.com/phppgadmin/phppgadmin/pull/27/
PhpPgAdmin - Problema Criando Nova Tabela
Cancel/Kill Action use procpid 0 (undefined)
This is fixed in the 5.1 branch and in git master, and will be included in the next...
pagination not changing page (through select)
Creating functoins via SQL fails if paginate checkbox is selected.
I believe this is a duplicate of issue 422.
executeScript ignore querries when ; is on a single line
How do you export a function? I know how to export a view; however, I cannot find...