Re: Search error

That's one of those real PITA problems...

The query that originates this is:

$ignoreRequest = $smcFunc['db_search_query']('insert_log_search_topics', ($smcFunc['db_support_ignore'] ? ( '

INSERT IGNORE INTO {db_prefix}' . ($createTemporary ? 'tmp_' : '') . 'log_search_topics

(' . ($createTemporary ? '' : 'id_search, ') . 'id_topic)') : '') . '

SELECT ' . ($createTemporary ? '' : $_SESSION['search_cache']['id_search'] . ', ') . 't.id_topic

FROM ' . $subject_query['from'] . (empty($subject_query['inner_join']) ? '' : '

INNER JOIN ' . implode('

INNER JOIN ', $subject_query['inner_join'])) . (empty($subject_query['left_join']) ? '' : '

LEFT JOIN ' . implode('

LEFT JOIN ', $subject_query['left_join'])) . '

WHERE ' . implode('

AND ', $subject_query['where']) . (empty($modSettings['search_max_results']) ? '' : '

LIMIT ' . ($modSettings['search_max_results'] - $numSubjectResults)),

$subject_query['params']

);Which, as everyone can see, is plain simple

I would say (a bit guessing) that, due to you being searching several terms, the JOINS would need to "dig" more rows than your MySQL is configured to allow... Since this doesn't happen everywhere, I would say that you need to "stretch" your server limits...

What's the size of your forum? (topics/posts)