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

[Steffen Kamper]

Hi,

+1 from reading.

btw - the query generator is very limited, i often wanted to do more 
complex queries. Why isn't there an option to paste complete queries?
But ok, another story

vg Steffen

Christian Kuhn schrieb:
> 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
>