[TYPO3-dev] 'SYS' -> 'sqlDebug' => '2',

[Jigal van Hemert]

Hi,

On 11-8-2013 9:40, Robert Wildling wrote:
> The dev-enviroment is a Mac 10.7.5 with MAMP Pro 2, a TYPO3 CMS 6.1.2
> and php 5.4.10.

I tried it on Windows Vista, XAMPP, TYPO3 CMS 6.2-dev, PHP 5.4.7.

> To debug some TypoScript database queries in the FrontEnd, I activated
> the sql-debug mode in the install tool
[...]
> At least I tried to, because doing so actually puts TYPO3 in a
> never-ending loop, not responding to anything.

I didn't notice any difference in speed (it's quite slow already on my 
machine, but that is due the slow MySQL initialization) and the frontend 
came up nicely with a long list of queries.

> Does anybody of you have a similar problem? Do you know work-arounds?

If it's a query from a CONTENT object you'd like to debug you could make 
a deliberate spelling mistake in a table or column name. If you have 
sqlDebug set to 1 the failed query will be shown and you only need to 
correct the spelling error to try the query directly on a database.

-- 
Jigal van Hemert
TYPO3 CMS Active Contributor

TYPO3 .... inspiring people to share!
Get involved: typo3.org