phpPgAdmin 7.13.0 (PHP 8.1.16) issue - No unique identifier for this row

kanon

Registered
Apr 14, 2023
4
1
3
Brazil
cPanel Access Level
Root Administrator
cPanel Version: 110.0.5
phpPgAdmin Version: 7.13.0
PostgreSQL Version: 9.6.24
PHP Version: 8.1.16

When trying to delete or edit a record in any table, the message occurs:
No unique identifier for this row

According to the project(fork) on github, the version that supports PHP 8.1 is 7.14.x-mod:
- Releases · ReimuHakurei/phpPgAdmin

The latest version available from the official repository was updated in 2020, which does not support new versions of PHP and PostgreSQL.
 
Last edited by a moderator:

cPRex

Jurassic Moderator
Staff member
Oct 19, 2014
16,570
2,612
363
cPanel Access Level
Root Administrator
Hey there! Is it possible there is something else that may be interfering with that deletion, such as another CREATE statement?

To rule out PHPPgAdmin as the issue, have you tried manually deleting that entry from the command line?
 

kanon

Registered
Apr 14, 2023
4
1
3
Brazil
cPanel Access Level
Root Administrator
Hello,
Thanks for the answer.

Yes.
First I updated the permissions (grant) in the database, tables, schemas and sequences.
Afterwards, I inserted, modified and deleted records normally through the terminal.
I also used PGAdmin, there were no problems.
Only in phppgadmin does the problem occur when changing or removing the registry.
 

cPRex

Jurassic Moderator
Staff member
Oct 19, 2014
16,570
2,612
363
cPanel Access Level
Root Administrator
Thanks for the additional details. Could you submit a ticket to our team so we can reproduce this on your system? If this is an issue with the interface, we may have to file an upstream case to get that taken care of by the PHPPgAdmin team.