Bug:

[garett-at-liquidlight]

Summary

The DatatableController.php makes the assumption that there will be a column called "deleted", which is true for many tables, but not all. It should instead be looking this up in the TCA in ctrl > enablecolumns > disabled.

Steps to reproduce

Build a datatable controller which selects from, or joins with, a table that does not have a deleted column, such as sys_language

There are a few places this appears in the code:

• typo3-module-data-listing/Classes/Controller/DatatableController.php

  Line 145 in b8db6cd

  $this->table . '.deleted',

• typo3-module-data-listing/Classes/Controller/DatatableController.php

  Line 223 in b8db6cd

  $this->table . '.deleted',

• typo3-module-data-listing/Classes/Controller/DatatableController.php

  Line 390 in b8db6cd

  $joinTable . '.deleted',

• typo3-module-data-listing/Classes/Controller/DatatableController.php

  Line 394 in b8db6cd

  $joinTable . '.deleted'

[mikestreety]

@zaqmughal-ll This is actually half resolved (I think).

In the first example, above where @garett-at-liquidlight has pointed to is

->removeAll()
->add(GeneralUtility::makeInstance(DeletedRestriction::class))

Which is doing exactly what you are doing in the lines below (as per your comment)

I wonder if adding the DeletedRestriction handles tables which don't have a deleted column?