User editing

[Martin Pfeifer]

Ubuntu 18.04.2 LTS
psql (PostgreSQL) 11.2 (Ubuntu 11.2-1.pgdg18.04+1)
Server version: Apache/2.4.29 (Ubuntu) built: 2018-10-10T18:59:25
dadabik_9.2.2-Monterosso_enterprise

Hello, yesterday I performed an upgrade from DaDaBik 9.2.1 to 9.2.2
Still I can define new users and their credentials; login as such, but editing the user is not longer possible.
This goes for every user.
The error message is:
[08] Error: during query execution. SELECT "authentication_type_user" FROM "dadabik_users" WHERE "id_user" = 'root'
The DBMS server said: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for integer: "root" LINE 1: ...ion_type_user" FROM "dadabik_users" WHERE "id_user" = 'root' ^

Any idea's?

 

[eugenio]

Hello,
we didn't change anything in the database schema so I don't think the upgrade is the reason of the issue.

When does the message appear, when you save?
The strange thing here is that you have (or you are trying to have) "root" as id_user, "root" should be the username of the user, not the id, the id is numeric.

Best,