Thanx! I've commented (/**/) all the lines for visual verification, and now reports a bit less errors. Now I only get errors when searching from the action=search2 page, and they disappear when I refresh it.
Hey, seems like I solved it by commenting these lines:
// REF (see above) ATTN: wordzilla, LEFT_JOIN
// LEFT JOIN smf_tmp_log_search_topics AS lst ON (lst.ID_TOPIC = t.ID_TOPIC)
// WHERE t.ID_TOPIC = m.ID_TOPIC
// AND lsm.ID_MSG = m.ID_MSG AND lst.ID_TOPIC = t.ID_TOPIC
db_query("
INSERT IGNORE INTO {$db_prefix}log_search_results
(" . implode(', ', array_keys($main_query['select'])) . ")
SELECT
" . implode(',
', $main_query['select']) . "
FROM (" . implode(', ', $main_query['from']) . ')' . (empty($main_query['left_join']) ? '' : "
LEFT JOIN " . implode("
LEFT JOIN ", $main_query['left_join'])) . "
WHERE " . implode("
AND ", $main_query['where']) . (empty($main_query['group_by']) ? '' : "
GROUP BY " . implode(', ', $main_query['group_by'])) . (empty($modSettings['search_max_results']) ? '' : "
LIMIT $modSettings[search_max_results]"), __FILE__, __LINE__);
$_SESSION['search_cache']['num_results'] = db_affected_rows();*/