QGIS 3.22: it doesnt work

[msanchezaparicio]

QGIS 3.22.7 64bit, on Windows 10.

The administrator funcionalities work but when i try to use the normal user's funcionalities it doesn't work. I attach 3 images. The first one is the administrator window, the second is the normal user's window and the third is python error. I have used the version of commit [062f752]. I did the server side installation from that commit.

[gioagu]

Hi!

In the administrator tab you create the qgis schema for user postgres. It works, as you show in the screenshot.

In the user tab, do you connect with the same credentials as well? I mean, you must connect as user postgres too, otherwise the plugin won't find the correct qgis_xxxx schema.

Besides: Is it working with the standard users °qgis_user_ro" and or °qgis_user_rw"?

[pancost]

Hello,

For what I can derive from the error message, the plpgsql function qgis_pkg.list_cdb_schemas(TRUE) returned NONE.

This could happen if

• There is no "citydb" schema in the database.
• There is one or more "citydb" schemas but without any data in them.

Can you check these bullet points?

Otherwise, in order to at least determine if its a client or server-side issue, try to execute the function directly from within pgAdmin (no plugin involved) and check if it returns something. Use SELECT qgis_pkg.list_cdb_schemas(TRUE);

[msanchezaparicio]

Thank you for your replies. My problem was that the citydb schema was empty (without data). Now, with a citydb schema with data it works without problems.