hi.
I am noticing a very wierd problem at my website, each time I try to search, either as guest or authenticated user, I get the following error:
. user warning: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' query: do_search CREATE TEMPORARY TABLE temp_search_results SELECT i.type, i.sid, 5 * (9.71305588655 * i.relevance) + 5 * POW(2, (GREATEST(n.created, n.changed, c.last_comment_timestamp) - 1171617940) * 6.43e-8) + 5 * (2.0 - 2.0 / (1.0 + c.comment_count * 0.111111111111)) + 5 * (2.0 - 2.0 / (1.0 + nc.totalcount * 0.00061804697157)) AS score FROM temp_search_sids i INNER JOIN search_dataset d ON i.sid = d.sid AND i.type = d.type INNER JOIN node n ON n.nid = i.sid LEFT JOIN node_comment_statistics c ON c.nid = i.sid LEFT JOIN node_counter nc ON nc.nid = i.sid WHERE (d.data LIKE '% auda %') ORDER BY score DESC in /home/nattiqc/public_html/includes/database.mysql.inc on line 172. . user warning: Table 'nattiqc_nattiq.temp_search_results' doesn't exist query: do_search SELECT COUNT(*) FROM temp_search_results in /home/nattiqc/public_html/includes/database.mysql.inc on line 172.
I tried to "reindex" but that didn't work. I read in the forums about a similar wierd issue but it wasn't about search in particular.
any clues?
the site url is: www.nattiq.com you may want to see www.nattiq.com/en as the default language is arabic.
Regards,
Mohammed Al-shar'