Skip to content

Cannot delete file entities containing unescaped space characters

When having a file entity of a file with a path containing unescaped spaces,e.g. files provided by a Windows user, any attempt at deleting that entity via web ui or caosdb-pylib fail. With pylib

import caosdb as db
a = db.execute_query("FIND ENTITY with ID>99")
a.delete()

yields a caosdb.exceptions.HTTPServerError: An unexpected server error has occurred. message if the query contains at least one problematic file path. The db can be repaired by removing the offending file directly in the mysql backend and deleting the SymLink in the local caosdb file system.

To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information