Unable to delete workspace if records have an attachment | Twenty | Page 1

solar elbow Mar 7, 2025, 5:19 AM

#

Error received:
null value in column "authorId" of relation "attachment" violates not-null constraint

How to fix?

grand crescent Mar 7, 2025, 6:22 AM

#

Hello @solar elbow, what version of twenty are you running ? ( If you're on the latest please describe how you inserted an attachement that has no authorId, such as through api ? )

To address your issue go in database and find null authotId row and delete it manually then you should be able to delete the workspace

( Ps screenshot is weirdly cropped)

solar elbow Mar 7, 2025, 6:25 AM

#

But all my rows have authorId in them. I use the API

#

#

Running twenty .42

#

After I remove all the attachments, I can delete the workspace

solar elbow Mar 7, 2025, 6:42 AM

#

So intriguing

grand crescent Mar 7, 2025, 8:14 AM

#

Mhm there might be a bug when deleting a workspace containing attachements, would you be able to reproduce by creating a workspace with an attachement and delete it ? Will attempt to do so on the latest 0.43

solar elbow Mar 9, 2025, 12:32 PM

#

Were you able to reproduce?

restive oar Mar 9, 2025, 12:51 PM

#

@solar elbow I believe it's similar case to this https://github.com/twentyhq/twenty/issues/7755

GitHub

Account can't be deleted if file is uploaded · Issue #7755 · twenty...

Scenario: Log in Go to People tab Check details of any existing record Upload file Go to Settings > Profile Click "Delete account" button Type email in input and click "Delete acc...

solar elbow Mar 9, 2025, 1:02 PM

#

Yes that’s right

solar elbow Apr 29, 2025, 8:31 AM

#

fixed by adding await workspaceDataSource?.query(
DELETE FROM ${dataSourceMetadata.schema}."attachment",
);

in the deleteUserFromWorkspace function

#

Then it deletes smoothly

#Unable to delete workspace if records have an attachment