by steve© » Fri Jul 31, 2009 6:00 pm
[code]SQL ERROR [ mysql4 ]
The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay [1104]
SQL
SELECT p.post_id FROM (phpbb_search_wordmatch m1, phpbb_search_wordmatch m2, phpbb_search_wordmatch m3, phpbb_search_wordmatch m0) LEFT JOIN phpbb_posts p ON (m0.post_id = p.post_id) WHERE m0.word_id = 666 AND m1.word_id = 1271 AND m1.post_id = m0.post_id AND m2.word_id = 1562 AND m2.post_id = m0.post_id AND m3.word_id = 2467 AND m3.post_id = m0.post_id AND p.post_approved = 1 AND p.forum_id NOT IN (10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 24, 26, 27, 28, 29) GROUP BY p.post_id, p.post_time ORDER BY p.post_time DESC LIMIT 250
BACKTRACE
FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()
FILE: includes/db/mysql.php
LINE: 221
CALL: dbal_mysql->sql_query()
FILE: includes/db/dbal.php
LINE: 170
CALL: dbal_mysql->_sql_query_limit()
FILE: includes/search/fulltext_native.php
LINE: 727
CALL: dbal->sql_query_limit()
FILE: search.php
LINE: 432
CALL: fulltext_native->keyword_search()[/code]