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.