[TYPO3-core] RFC: #10241: DB check ->Full search ->Advanced query always includes deleted field

[Christian Kuhn]

This is a SVN patch request.

Type: bugfix, no-brainer

Bugtracker references:
http://bugs.typo3.org/view.php?id=10241

Branches: 4.2-branch, trunk

Problem:
The query generator used in Tools -> DB check -> Full search -> Advanced 
query always adds the deleted field to the SELECT fields. Those queries 
fail for tables without the deleted field.

Solution:
Check TCA[table]['ctrl']['delete'] field and use it.

How to reproduce:
* Tools -> DB check -> Full search -> Advanced query
* Select a table without deleted field (eg. countries from 
ext:static_info_tables)
* Watch the query fail: "Unknown column 'deleted' in 'field list'"

Cheers
Christian
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: 10241.diff
Url: http://lists.netfielders.de/pipermail/typo3-team-core/attachments/20090123/cf589cc2/attachment.txt