[TYPO3] DB Error in Search Content Pages

Pelopincho jcriofriol at SoftHome.net
Thu Jan 12 22:32:44 CET 2006


Hi all,
I hope somebody could help me because I have been 3 days researching using 
my very poor knowledge of TYPO3, and many hours in wiki and docs, I'm a 
newbiee.
ENVIROMENT:
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

PROBLEM DESC.:
Just install everything, no modifications.
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

The search is performed and the results are displyed below in the page, but 
the page displays this error

These are the lines in IIS logs if it is useful, 200 HTTP Status:
2006-01-12 21:24:53 GET id=24&type=1 192.168.1.88 
http://desarrollo/index.php?id=1&type=2 200 380
2006-01-12 21:25:02 POST id=24&type=1&no_cache=1 192.168.1.88 
http://desarrollo/index.php?id=24&type=1 200 480

Using the BE or the FE, the same result.
Any idea will be very apreciated.

Thanks in advance, Juan Carlos 





More information about the TYPO3-english mailing list