[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