Deleting nodes From Mysql (node)
-
Greetings,
I've identified an issue that requires attention.
It seems that creating numerous spaces in the GoFast group using the API is straightforward and doesn't impose specific conditions, making the process efficient.However, when attempting to delete spaces either through the interface or Alfresco, I've observed their persistent existence in the MySQL database for GoFast after being deleted.
While this isn't a critical problem, it becomes a bit challenging when creating new spaces and determining their presence in the database, especially with the same string as the title.
Additionally, there seems to be a lack of API support for deleting or removing unnecessary nodes directly from the DB.The API /api/node/autocomplete is quite resourceful in getting the needed information from the intended table in the database.
but nothing is present to aid in deleting or removing the unneeded nodes.Thanks.
-
Hello, any idea about this
-
Hello, it's really not a good idea to abruptly delete nodes from the database.
There are many reasons for this: it's impossible to restore them afterwards (e.g. if restoring from alfresco recycle bin from example), many of the database entries linked to the node will still remain in the database (e.g. the node fields) so it will be far away from "clean", and no hook (e.g. synchronization hooks with alfresco and element) will be triggered, which will generate even more inconsistencies. This is why GoFAST unpublishes nodes and, by design, never deletes them outright.
Best regards,
Raphaël.