[TYPO3-core] RFC: Bugfix #7545: Explain select not working with multiple tables

[Ingo Schmitt]

Hi List,

a small reminder, would be fine to have this in beta 3 solved.

ingo
> Hi,
> 
> please see my attached new patch, which corrects this problem.  (also in 
> the bugtracker).
> 
> ingo
> 
> 
>> Hey Ingo,
>>
>> just tried the patch. I can reproduce an error when using tt_news in 
>> list mode. When activated "explain SQL" I get this:
>>
>> "SHOW INDEX FROM tt_news LEFT OUTER JOIN tt_news_cat_mm ON tt_news.uid 
>> = tt_news_cat_mm.uid_local"
>>
>> 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 'LEFT OUTER JOIN tt_news_cat_mm ON tt_news.uid = 
>> tt_news_cat_mm.uid_local' at line 1
>>
>> Anyway, I applied your patch and still get the error.
>>
>>
>> ingo schmitt wrote:
>>> Hi Benjamin,
>>>
>>>> looks very good. +1 after reading. I'd really like to see this patch 
>>>> in action though.
>>>>
>>>> Can you give us small instructions on how to reproduce this? Thanks 
>>>> a ton!
>>>
>>> Activate: SQL-Debug in Install-Tool
>>> Activate: Debug and set you IP dev mask to your IP in Install-Tool
>>> (
>>> $TYPO3_CONF_VARS['FE']['debug'] = 1;
>>> $TYPO3_CONF_VARS['SYS']['sqlDebug'] = '1';
>>> )
>>> (BTW: Where can I set the later option in installtool 2?)
>>>
>>> Activate: Admin-Panel in TS
>>> Activate: "Explain SELECT queries" in Admin Panel
>>>
>>> Render in frontent a page with tt_news records:
>>>
>>> "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 'INNER JOIN tt_news_cat_mm ON (tt_news_cat.uid = 
>>> tt_news_cat_mm.uid_foreign)
>>> ' at line 2
>>>
>>> SHOW INDEX FROM tt_news_cat
>>> INNER JOIN tt_news_cat_mm ON (tt_news_cat.uid = 
>>> tt_news_cat_mm.uid_foreign)
>>> INNER JOIN tt_news ON (tt_news.uid = tt_news_cat_mm.uid_local)"
>>>
>>>
>>> ingo
>>>
>>>
>>>
>>> Mit freundlichen Gruessen
>>
> 
> 
> Mit freundlichen Gruessen
> 


Mit freundlichen Gruessen
-- 
Ingo Schmitt                        mailto:is at marketing-factory.de
Marketing Factory Consulting GmbH   http://typo3.marketing-factory.de/
Content Management mit Typo3: Beratung - Schulung - Realisierung