---
title: "Breaking: #93029 - Dropped deleted field from sys_refindex"
manual: "TYPO3 Core Changelog"
version: "main"
permalink: "https://docs.typo3.org/permalink/changelog:breaking-93029"
source: "Changelog/11.0/Breaking-93029-DroppedDeletedFieldFromSys_refindex.rst"
modified: "2026-09-15T10:46:36+00:00"
---

# Breaking: #93029 - Dropped deleted field from sys_refindex

See [forge#93029](https://forge.typo3.org/issues/93029)

## Description

The database field `deleted` has been removed from table
`sys_refindex`. Therefore, the table does no longer store
relations between soft deleted records.

Following properties and methods of class
`\TYPO3\CMS\Core\Database\ReferenceIndex` have been set to
protected:

-   `temp_flexRelations`
-   `relations` \- not scanned by extension scanner
-   `hashVersion`
-   `getWorkspaceId()` \- not scanned by extension scanner
-   `getRelations_procDB()`
-   `setReferenceValue_dbRels()`
-   `setReferenceValue_softreferences()`
-   `isReferenceField()` \- not scanned by extension scanner

Following methods of class `\TYPO3\CMS\Core\Database\ReferenceIndex`
have been removed:

-   `generateRefIndexData()`
-   `createEntryData()`
-   `createEntryData_dbRels()`
-   `createEntryData_softreferences()`

## Impact

Accessing the properties of class `ReferenceIndex` or calling
dropped or protected methods will raise fatal PHP errors.

Querying the `deleted` field of table `sys_refindex` will raise a
doctrine dbal exception.

## Affected Installations

The hash sums of existing table rows change. The reference index
should be updated, typically by using the CLI command
`bin/typo3 referenceindex:update`

Codewise, instances with extensions that query table `sys_refindex`
or use class `ReferenceIndex` may be affected. The extension
scanner helps to find some usages.

## Migration

Use the CLI command `bin/typo3 referenceindex:update` to update
the reference index.

The `sys_refindex.deleted` field should be dropped from database
queries.

When accessing class `ReferenceIndex`, use the main API method
`->updateRefIndexTable()`, plus a couple of other less often
used methods.