[TYPO3-mvc] Extbase tx_dam_mm_ref SQL errors

ktt kestutis98 at yahoo.com
Fri Oct 28 17:11:30 CEST 2011


Hello,

After upgrading extbase from 1.2 to extbase 1.3.1-devel started to get strange
SQL errors on frontend:
-------------
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 tx_dam_mm_ref LEFT JOIN ON tx_dam_mm_ref.uid_local = .uid WHERE (tx_dam_' at line 1: SELECT .* FROM tx_dam_mm_ref LEFT
JOIN ON tx_dam_mm_ref.uid_local = .uid WHERE (tx_dam_mm_ref.uid_foreign = '142' AND tx_dam_mm_ref.ident = 'tx_myext_image')
ORDER BY tx_dam_mm_ref.sorting_foreign ASC LIMIT 1
-------------
I dumped all SQL strings from the extbase 1.2 "typo3\sysext\extbase\Classes\Persistence\Storage\Typo3DbBackend.php" buildQuery function
and didn't detect any queries to tx_dam_mm_ref, this only appears(and buggy) after upgrading to extbase 1.3.1 devel.

Is it related to bad extbase support of 'tablenames' and TCA 'group' types?
Same errors appear in extbase 1.4(TYPO3 4.6).

Thank you in advance,
Kast



More information about the TYPO3-project-typo3v4mvc mailing list