Hello, Since I migrated to the PHP 4.3.7 I have a major warning problem which appears from time to time and I cannot find the message explanation or a fix to this issue with both old tables and new created tables. The error message is: [19-Jul-2004 20:00:27] PHP Warning: mysql_query(): Your query requires a full tablescan (table table_name, 10 rows affected). Use EXPLAIN to optimize your query. in d:\www\teste\client120\villen.php on line 23 I thought that there is a problem with the keys so I start optimizing the tables and the indexes but now it appears also in just created databases with a single table and a single record manually inserted using the phpMyAdmin. I searched this problem on the Google and from the 550 records reported (actually the real number is smaller) 99,99% of the messages seems to be pages affected by this problem. The only "relevant" search result is here: http://www.manucorp.com/archives/php-cvs/200211/msg00300.php and explain that someone added there new functionalities into the PHP cvs back in 2002: Added new functionality: Warnings for table/index scans Warnings for SQL-Errors Warnings for non free result sets but I don't know which is the exact issue of my tables. It appears that after the recordset is extracted from the database a check against row[1] (?!) which should contain the ALL string or the INDEX string is made but in my case the check fails and I have this error. I know that I can disable this warning through the php.ini "mysql.trace_mode" but this is not solving the problem. Please give me some hints to know what is happening. ------------------------------------------------- Cristian MARIN - Developer Support Department - (http://www.interakt.ro/products/buy_0.html#license38) InterAKT Online (www.interakt.ro) Tel: +4021 312.53.12 Tel/Fax: +4021 312.51.91 cristic@xxxxxxxxxxx -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
