[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