SQL Storage cleanup
Categories
Component ID
Component name
Component type
Maintenance status
Development status
Component security advisory coverage
Downloads
Component created
Component changed
Component body
This project aims to remove possible abandoned data out of field SQL storage tables.
Usually you really don't need it - Drupal has a mature storage system with transactions that leads to consistent database.
But Drupal users are people. They make mistakes, period.
Also some type of custom migrations can introduce such errors.
If you have strange exceptions with duplicates within field or revision tables - you got problems.
Thats why this tool published here.
The root of the problem - records were deleted from entity base table, but not from field storage. Or there are records in field storage that have ids that greater than maximum id in base table.
How-to use this module.
Install, enable and look at the form /admin/config/development/stcl
Normally Get Info button should show you empty information. If not - use Cleanup button to remove that data.
Don't forget to make backup of your database before manipulating with current module.
I'm not responsible for any damage this module can bring to you.
Just for sure I have used transaction for removing data out from the tables, so this can help to rollback if there are possible errors in module's code.
Please, feel free to post issues if any.
