Skip to main content

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

kanon
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: - The latest version available from the official repository was updated in 2020, which does not support new versions of PHP and PostgreSQL.

Comments

10 comments

Date Votes
  • cPRex Jurassic Moderator
    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?
    0
  • kanon
    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.
    0
  • cPRex Jurassic Moderator
    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.
    0
  • kanon
    • Edited

    Hello, how can I submit a ticket? 
    At the moment we have two servers with this problem.
    But, we will change all old servers ( redhat 7 and before ) to new servers ( redhat 8 or later ).
    The issue occur with the phppgadmin 7.13 and php 8.1

    -Main release supports until the php 7.2:
     https://github.com/phppgadmin/phppgadmin/releases

    - Fork release supports until the php 8.2+
    https://github.com/ReimuHakurei/phpPgAdmin/releases

    AlmaLinux 8 by defect have the php 8.1

    Thank you.
    [UPDATE]

    I saw that there is an internal case to check the situation.
    https://support.cpanel.net/hc/en-us/articles/14001332493463-Error-in-phpPgAdmin-when-trying-to-edit-or-delete-a-row-
    CPANEL-42746

    Is there any update on the situation?

    0
  • cPRex Jurassic Moderator

    I just checked the case on my end and I'm not seeing any updates at this time, but I did leave a comment on this and I'm watching the case now, so if I hear anything I'll be sure to post!

    0
  • cPRex Jurassic Moderator

    I'm not sure if this is something that we'll be able to fix.  The most recent update to phpPgAdmin was from November 2020, so if the software itself isn't being maintained there isn't much we can do on our end, and I doubt making a custom version and maintaining that will be something we want to do.

    I'll be sure to keep you updated if I hear anything else related to the case, but I wouldn't count on this getting fixed at this time.

    0
  • kanon

    Hello,

    Is there any chance to replace phppgadmin with the fork?
    The last update was last month.

    - Fork release supports until the php 8.2+
    https://github.com/ReimuHakurei/phpPgAdmin/releases

     

    0
  • cPRex Jurassic Moderator

    kanon - I'm not sure, but I did send that link over to or team so they are aware that exists, in case they weren't already!

    1
  • atmozphera
    • Edited

    Hello,

    I have the same problem with my PhpPgadmin in this version. Is there any resolution to this case?

    I'm using PHP 8.1 (Cpanel 110.024 / phpPGAdmin 7.13.0)

    Best regards,

     

    0
  • cPRex Jurassic Moderator

    atmozphera - I don't believe this case is going to get resolved.  I think the long-term plan will likely be to remove PHPPgAdmin and see if we can use a better tool.

    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post