Platform info: Passbolt Version: 4.5.2 (CE) Platfor

Thanks for the report <a class="user-mention notranslate" data-hovercard-type="user" d

My current workaround is to disable the "folders" plugin: <div class="snippet-clip

Hi <a class="user-mention notranslate" data-hovercard-type="user" data-hovercard-url="

<a class="user-mention notranslate" data-hovercard-type="user" data-hovercard-url="/us

SQL error on creating folders when using PostgreSQL database about passbolt_api HOT 6 OPEN

chris968 commented on May 27, 2024

SQL error on creating folders when using PostgreSQL database

from passbolt_api.

Comments (6)

stripthis commented on May 27, 2024

Thanks for the report @chris968, we'll look into it.

from passbolt_api.

chris968 commented on May 27, 2024

I just realized that this have an impact on creating new passwords.

from passbolt_api.

chris968 commented on May 27, 2024

My current workaround is to disable the "folders" plugin:

<?php

return [
  'passbolt' => [
    'plugins' => [
      'folders' => [
        'enabled' => false,
      ],
    ],
  ],
];
``

from passbolt_api.

pabloelcolombiano commented on May 27, 2024

Hi @chris968 ,

it could be that during the migration from MySQL to Postgres, some folders got their id set to null.

Could you run this query in your postgres client, to see if this is the case?
select * from folders where "id" = null;
Also this query could be interesting:
select column_name, data_type, character_maximum_length, column_default, is_nullable from INFORMATION_SCHEMA.COLUMNS where table_name = 'folders';

from passbolt_api.

chris968 commented on May 27, 2024

@pabloelcolombiano of course I can run both commands but we have no folders in our setup:

passbolt-db=>  select * from folders where "id" = null;
 id | name | created | modified | created_by | modified_by
----+------+---------+----------+------------+-------------
(0 rows)

passbolt-db=> select column_name, data_type, character_maximum_length, column_default, is_nullable from INFORMATION_SCHEMA.COLUMNS where table_name = 'folders';
 column_name |        data_type         | character_maximum_length | column_default | is_nullable
-------------+--------------------------+--------------------------+----------------+-------------
 created     | timestamp with time zone |                          |                | NO
 modified    | timestamp with time zone |                          |                | NO
 id          | character                |                       36 |                | NO
 name        | character varying        |                      256 |                | NO
 created_by  | character                |                       36 |                | NO
 modified_by | character                |                       36 |                | NO
(6 rows)

from passbolt_api.