Question

Delete Folder from SQL (cannot delete from client, access denied)

Laserfiche Version 9

Updated September 10, 2015

asked on September 9, 2015

I have a folder that for some reason keeps getting access denied, even when i should have rights. I can move it but not rename it, not delete it. It is empty, has no metadata, no tags, etc. Is there a way I can delete it in sql? I have tried to delete the row in dbo.toc but I get the error

The DELETE statement conflicted with the SAME TABLE REFERENCE constraint "toc_parentid_fk". The conflict occurred in database "LASERFICHE8", table "dbo.toc", column 'parentid'.

0 0

Answer

SELECTED ANSWER

replied on September 10, 2015

I believe the SQL error you got is telling you that the entryID for the folder is the parentID for another entry. Use the folder entryID to search for rows were the parentID = your folder entryID.

1 0

Replies

replied on September 10, 2015

Hi Joel,

If you are logged in as the admin user you should be able to delete the folder, or at least give yourself enough rights to be able to delete the folder. I wouldn't advise trying to delete this directly in SQL. I would spend the time to try and work out why you don't as an admin user have rights to do something as simple as delete a folder.

Hope this helps point you in the right direction!

1 0

replied on September 10, 2015

There was in fact another entry that had that as the parent. It didn't show in laserfiche but it was in SQL. Our VAR and I had tried for like an hour to delete it from the client, so we did give that route a good go.

Thanks for the help.

0 0

You are not allowed to follow up in this post.

Question

Question

Delete Folder from SQL (cannot delete from client, access denied)

Answer

Replies

Sign in to reply to this post.