[TYPO3] DB Error in Search Content Pages

Florian Schaeffer florian.schaeffer at mercoline.de
Fri Jan 13 09:53:21 CET 2006


Hello Juan Carlos,

> IIS 6.0 (is a requirement for me, I can't use Apache)
> PHP 4.4.1 as CGI
> MySQL 4.0.26
> TYPO3 3.8.1 "Quickstart" package

> When I try to make a search(standard content type), and click fr submit the 
> form I get the following PHP error:
> Warning: mysql_query(): Your query requires a full tablescan (table 
> tt_content, 36 rows affected). Use EXPLAIN to optimize your query. in 
> E:\www\Desarrollo\t3lib\class.t3lib_db.php on line 219

It seems to me that your PHP.ini settings are much too let's say 
"communicative". So try to adjust your php.ini settings. Look for
error_reporting and adjust the values, so you won't get warnings.

HTH
Florian Schaeffer



More information about the TYPO3-english mailing list