Error when setting a 1to1 relationship in postgres

Grocery CRUD Enterprise
1

I have table named personas with pk id_persona and a table Socios with pk also named id_persona. I do this:

    $crud->setTable('socios');

    $crud->setPrimaryKey('id_persona', 'personas');
    $crud->setPrimaryKey('id_persona', 'socios');

    $crud->setSubject('Socio', 'Socios');


    $crud->setRelation1to1('id_persona', 'personas', [
        'nombre']);

and get this error:

Error: Internal Server Error.
Server Response:
{
“title”: “PDOException”,
“type”: “PDOException”,
“code”: 500,
“message”: “SQLSTATE[42803]: Grouping error: 7 ERROR: la columna «p.nombre» debe aparecer en la cláusula GROUP BY o ser usada en una función de agregación\nLINE 1: SELECT COUNT(*) AS "num", "p"."nombre" AS "nombre" FROM "soc…\n ^”,
“file”: “F:\testci4\app\Libraries\GroceryCrudEnterprise\scoumbourdis\laminas-db\src\Adapter\Driver\Pdo\Connection.php”,

Any comment? Thank you

2

Hello @jgct_70,

I can reproduce the issue that you have. This is a Grocery CRUD bug. I will try to fix that for the next version. I will update you the soonest possible for it.

Regards
Johnny

3

Hello @jgct_70 ,

I am glad to inform you that this issue is now fixed on the latest version 3.2.4 . You can update the version that you are using by following the wizard: User's Page Login

Please let me know if that fixed your problem.

Regards
Johnny