[TYPO3-mvc] FileReference

[Marc Bastian Heinrichs]

Hey Philipp,

have a look at following patch: https://review.typo3.org/#/c/17159/

will be merged in master soon

Best
Maba


Am 06.03.2013 17:17, schrieb Philipp:
> Hi,
> 
> i have many troubles getting FAL working for extbase.
> 
> First i didnt manage to set  a property
> \TYPO3\CMS\Extbase\Persistence\ObjectStorage<\TYPO3\CMS\Extbase\Domain\Model\FileReference>
> 
> 
> in my model. Then i though about creating a own FileReference Model
> (extending the original) and mapping it with TS to sys_file_reference
> Now my property is like this:
> \TYPO3\CMS\Extbase\Persistence\ObjectStorage<\Vendor\ExtensionName\Domain\Model\FileReference>
> 
> 
> But now i get an SQL error. TYPO3 generates a wired join. How can i make
> this work correctly?
> 
> SQL ERROR:
> 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 '* FROM
> sys_file_reference LEFT JOIN ON sys_file_reference.uid_local = .uid
> WHER' at line 1: SELECT .* FROM sys_file_reference LEFT JOIN ON
> sys_file_reference.uid_local = .uid WHERE
> (sys_file_reference.uid_foreign = '87' AND sys_file_reference.tablenames
> = 'tx_regionalobject_domain_model_regionalobject') AND
> sys_file_reference.deleted=0 AND sys_file_reference.t3ver_state<=0 AND
> sys_file_reference.pid<>-1 AND sys_file_reference.hidden=0 ORDER BY
> sys_file_reference.sorting_foreign ASC
> 
> As far as i see it here is absolutely no join needed, so why does
> Extbase/Typo3 make one here?