🐛 Bug: cannot delete a row with a column of type link: "Failed to deleted record: the referenced record does not exist"

[Sov3rain]

Please confirm if bug report does NOT exists already ?

• I confirm there is no existing issue for this

Steps to reproduce ?

1. Create a row in a table to another row in any other table.
2. Try to delete the row.
3. You get the "Failed to deleted record: the referenced record does not exist".
4. Delete the linked record on the row.
5. Try to delete the row.
6. Works Fine

Desired Behavior

Either you should show a more relevant error message, like "Cannot delete a row with linked records" or let the user delete a row that has linked records.

Project Details

Node: v18.18.2
Arch: x64
Platform: linux
Docker: true
RootDB: pg
PackageVersion: 0.203.2
hosting: railway.app

Attachments

[DanielSolano1]

Hey just to update anyone interested on the issue I am trying to find a fix.

[DanielSolano1]

@Sov3rain Hello, I tried to reproduce the bug/issue you had with the steps provided, but was unable to have any luck, I couldn't get the error message to show up. Maybe there was a forgotten step on these instructions or a non standard environment was used? Would it be possible if you tried to recreate this error to see if the issue persists?

[Sov3rain]

Hey @DanielSolano1! Sure, I'll try to find something. Our environment is the following:

• Hosted on Railway.app using the community template
• 2 Postgres db : one for the noco metadata, one for the data itself

I'll try to export you the relation diagram if that can help with anything.

[Sov3rain]

Hey @DanielSolano1, I tried to reproduce the issue on 0.204.1, but it seems like it's gone! Don't know if it was intentional but for now it works.

[DanielSolano1]

@Sov3rain Great!

[dstala]

Closing this issue for now- assuming it was fixed in one of our earlier releases. If issue persists, reopen this thread.