Thanks, Yes, the query is definitely coming from that part of configuration...
Here is my .htaccess config. Anything wrong? RewriteEngine On RewriteRule ^(typo3|typo3temp|typo3conf|t3lib|tslib|fileadmin|uploads|showpic\.php)/ - [L] RewriteCond %{REQUEST_FILENAME} !-f RewriteCond %{REQUEST_FILENAME} !-d RewriteCond %{REQUEST_FILENAME} !-l RewriteRule .* index.php Dan Osipov Calkins Media http://danosipov.com/blog/ Dmitry Dulepov wrote: > Hi! > > Dan Osipov wrote: >> When checking processlist, I often see queries like this: >> SELECT uid FROM tt_news WHERE title='fileadmin' AND deleted=0 AND hidden=0 >> SELECT uid FROM tt_news WHERE title='typo3' AND deleted=0 AND hidden=0 >> SELECT uid FROM tt_news WHERE title='typo3temp' AND deleted=0 AND hidden=0 >> SELECT uid FROM tt_news WHERE title='typo3conf' AND deleted=0 AND hidden=0 >> >> I think it comes from this part of the configuration: >> $GLOBALS['TYPO3_CONF_VARS']['EXTCONF']['realurl']['_DEFAULT']['postVarSets']['_DEFAULT']['article'] > > To be sure change the following line like this: > >> 'addWhereClause' => ' AND deleted=0 AND hidden=0 /* check */', > >> But why are those queries generated? Is there a way to avoid it? > > Most likely the following part of rewrite rules does not work at your > installation: > > RewriteRule > ^(typo3|typo3temp|typo3conf|t3lib|tslib|fileadmin|uploads|showpic\.php)/ - [L] > > It is possible if you moved it from .htaccess to the Apache configuration. In > certain cases it will require / after ^. > >> Has anyone encountered something like this? > > Not me. > _______________________________________________ TYPO3-english mailing list TYPO3-english@lists.netfielders.de http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english