<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.3059" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>hi. </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>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:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>• user warning: Illegal mix of collations
(utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='
query: do_search CREATE TEMPORARY<BR>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)<BR>- 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<BR>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<BR>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<BR>on line 172.
<BR>• 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<BR>on line 172.
<BR></FONT></DIV>
<DIV><FONT face=Arial size=2>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.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>any clues?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>the site url is: <A
href="http://www.nattiq.com">www.nattiq.com</A> you may want to see <A
href="http://www.nattiq.com/en">www.nattiq.com/en</A> as the default language is
arabic.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Regards,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Mohammed Al-shar'</DIV></FONT></BODY></HTML>