Issue Bug Closed

#77869TYPO3 8.3: Wrong sql with FlexForm with a select and foreign_table_where with an order by

Alex Kellner 09/06/16, 21:14 updated 09/12/16, 08:15

Description

This issue is related to #77868

In powermail there is a FlexForm that renders a select field with some records. Up to T3 8.2 it was possible to change the ordering with “foreign_table_where”. Now an error comes up. A simple FlexForm configuration could be:

<TCEforms>
    <label>Something</label>
    <config>
        <type>select</type>
        <renderType>selectSingle</renderType>
        <items type="array">

        </items>
        <size>1</size>
        <minitems>1</minitems>
        <maxitems>1</maxitems>
        <foreign_table>tx_powermail_domain_model_form</foreign_table>
        <foreign_table_where>AND tx_powermail_domain_model_form.deleted = 0
            AND tx_powermail_domain_model_form.hidden = 0
            AND tx_powermail_domain_model_form.sys_language_uid IN (-1,0)
            order by tx_powermail_domain_model_form.title</foreign_table_where>
    </config>
</TCEforms>

This leads to:

An exception occurred while executing 'SELECT `tx_powermail_domain_model_form`.`uid`, `tx_powermail_domain_model_form`.`title`, `tx_powermail_domain_model_form`.`t3ver_id`, `tx_powermail_domain_model_form`.`t3ver_state`, `tx_powermail_domain_model_form`.`t3ver_wsid`, `tx_powermail_domain_model_form`.`t3ver_count`, `tx_powermail_domain_model_form`.`hidden`, `tx_powermail_domain_model_form`.`starttime`, `tx_powermail_domain_model_form`.`endtime` FROM `tx_powermail_domain_model_form`, `pages` WHERE (tx_powermail_domain_model_form.deleted = 0 AND tx_powermail_domain_model_form.hidden = 0 AND tx_powermail_domain_model_form.sys_language_uid IN (-1,0) order by tx_powermail_domain_model_form.title) AND ( 1=1) AND (`pages`.`uid` = `tx_powermail_domain_model_form`.`pid`) AND ((`tx_powermail_domain_model_form`.`deleted` = 0) AND (`pages`.`deleted` = 0))': You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by tx_powermail_domain_model_form.title) AND ( 1=1) AND (`pages`.`uid` = `' at line 4

My first thought were that there is an extra configuration for sorting, but the documentation says foreign_table_where is still ok for sorting: https://docs.typo3.org/typo3cms/TCAReference/Reference/Columns/Select/Index.html#foreign-table-where

Am I wrong or is this a small bug?

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.