workspace icon indicating copy to clipboard operation
workspace copied to clipboard
verified publisher icon arawa

Workspace doesn't work with PostgreSql

Open zak39 opened this issue 2 years ago • 5 comments

Currently, Workspace is not compatible with PostgreSql. When I try to create a workspace, I have a few error messages.

image

The most strange, the Groupfolder's API/REST works to create a groupfolder and enable the advanced permissions. But, groups for Workspace (GE- and U-) didn't create.

image

image

zak39 avatar Feb 24 '23 09:02 zak39

Having the same issue

stefanh12 avatar Feb 24 '23 20:02 stefanh12

Hello, I installed Workspace yesterday on Nextcloud 25.0.7, with Postgresql v13.11 (Debian Bullseye), it seems to work fine. Any news about this issue ?

stanlog avatar Jun 10 '23 07:06 stanlog

Hi @stanlog :wave:

Did you do anything to the database ?

We have a problem with the constraint with a field in the database.

zak39 avatar Jun 29 '23 14:06 zak39

Hello @zak39 I didn't anything special on the postgres db tables schemas. I used GroupFolders module alone for a while, all works fine, no problem encounted with the use of Postgresql from the beginning (Nextcloud v25.0.8).

stanlog avatar Jun 29 '23 14:06 stanlog

Hello @stanlog

Is it possible to share your PostgreSQL configuration, please ?

I use constraint on foreign keys (https://github.com/arawa/workspace/blob/a2061d043dfd19082cedc7cd4b59669e6d81e381/lib/Migration/Version0000Date20210615125333.php#L95-L96) and it doesn't work with PostgreSQL.

zak39 avatar Aug 03 '23 09:08 zak39