🇺🇦

This module is maintained by Ukrainian developers.
Please consider supporting Ukraine in a fight for their freedom and safety of Europe.

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.

Supporting organizations: 
Coding
Contribution, PM, Release Management

Project information

Releases