[TYPO3-mvc] FileReference

Philipp philippwrann at gmx.at
Wed Mar 6 17:17:39 CET 2013


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?


More information about the TYPO3-project-typo3v4mvc mailing list