SQL Storage cleanup

Component ID

2398513

Component name

SQL Storage cleanup

Component type

module

Maintenance status

Development status

Component security advisory coverage

covered

Downloads

1430

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.