<HTML><BODY style="word-wrap: break-word; -khtml-nbsp-mode: space; -khtml-line-break: after-white-space; ">I am not a mysql expert, but it looks like your tables in your database have varying collations. They should all be using the same collation. utf8_general_ci has worked for us, but maybe either would be fine. I don't know.<DIV><BR class="khtml-block-placeholder"></DIV><DIV>There are several forum discussions on ways you can fix this, which some Googling should bring up for you. You will also want to make sure your default collation matches, so that when you install new modules and/or updates, you don't end up with mixed tables again.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>Again, I am not a mysql expert, so I may be wrong here.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>Laura</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV><BR><DIV><DIV>On Feb 16, 2007, at 4:23 AM, Mohammed Al-shar' wrote:</DIV><BR class="Apple-interchange-newline"><BLOCKQUOTE type="cite"><SPAN class="Apple-style-span" style="border-collapse: separate; border-spacing: 0px 0px; color: rgb(0, 0, 0); font-family: Verdana; font-size: 11px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: auto; -khtml-text-decorations-in-effect: none; text-indent: 0px; -apple-text-size-adjust: auto; text-transform: none; orphans: 2; white-space: normal; widows: 2; word-spacing: 0px; "><DIV><FONT face="Arial" size="2"><SPAN class="Apple-style-span" style="font-family: Arial; font-size: 9px; ">hi.</SPAN></FONT></DIV><DIV><FONT face="Arial" size="2"></FONT> </DIV><DIV><FONT face="Arial" size="2"><SPAN class="Apple-style-span" style="font-family: Arial; font-size: 9px; ">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:</SPAN></FONT></DIV><DIV><FONT face="Arial" size="2"></FONT> </DIV><DIV><FONT face="Arial" size="2"><SPAN class="Apple-style-span" style="font-family: Arial; font-size: 9px; ">• user warning: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' query: do_search CREATE TEMPORARY</SPAN><BR style="font-family: Arial; font-size: 9px; "><SPAN class="Apple-style-span" style="font-family: Arial; font-size: 9px; ">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)</SPAN><BR style="font-family: Arial; font-size: 9px; "><SPAN class="Apple-style-span" style="font-family: Arial; font-size: 9px; ">- 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</SPAN><BR style="font-family: Arial; font-size: 9px; "><SPAN class="Apple-style-span" style="font-family: Arial; font-size: 9px; ">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</SPAN><BR style="font-family: Arial; font-size: 9px; "><SPAN class="Apple-style-span" style="font-family: Arial; font-size: 9px; ">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</SPAN><BR style="font-family: Arial; font-size: 9px; "><SPAN class="Apple-style-span" style="font-family: Arial; font-size: 9px; ">on line 172. </SPAN><BR style="font-family: Arial; font-size: 9px; "><SPAN class="Apple-style-span" style="font-family: Arial; font-size: 9px; ">• 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</SPAN><BR style="font-family: Arial; font-size: 9px; "><SPAN class="Apple-style-span" style="font-family: Arial; font-size: 9px; ">on line 172. </SPAN><BR style="font-family: Arial; font-size: 9px; "></FONT></DIV><DIV><FONT face="Arial" size="2"><SPAN class="Apple-style-span" style="font-family: Arial; font-size: 9px; ">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.</SPAN></FONT></DIV><DIV><FONT face="Arial" size="2"></FONT> </DIV><DIV><FONT face="Arial" size="2"><SPAN class="Apple-style-span" style="font-family: Arial; font-size: 9px; ">any clues?</SPAN></FONT></DIV><DIV><FONT face="Arial" size="2"></FONT> </DIV><DIV><FONT face="Arial" size="2"><SPAN class="Apple-style-span" style="font-family: Arial; font-size: 9px; ">the site url is: </SPAN><A href="http://www.nattiq.com"><SPAN class="Apple-style-span" style="color: rgb(0, 0, 238); font-family: Arial; font-size: 9px; -khtml-text-decorations-in-effect: underline; ">www.nattiq.com</SPAN></A><SPAN class="Apple-style-span" style="font-family: Arial; font-size: 9px; "> you may want to see </SPAN><A href="http://www.nattiq.com/en"><SPAN class="Apple-style-span" style="color: rgb(0, 0, 238); font-family: Arial; font-size: 9px; -khtml-text-decorations-in-effect: underline; ">www.nattiq.com/en</SPAN></A><SPAN class="Apple-style-span" style="font-family: Arial; font-size: 9px; "> as the default language is arabic.</SPAN></FONT></DIV><DIV><FONT face="Arial" size="2"></FONT> </DIV><DIV><FONT face="Arial" size="2"><SPAN class="Apple-style-span" style="font-family: Arial; font-size: 9px; ">Regards,</SPAN></FONT></DIV><DIV><FONT face="Arial" size="2"></FONT> </DIV><DIV><FONT face="Arial" size="2"><SPAN class="Apple-style-span" style="font-family: Arial; font-size: 9px; ">Mohammed Al-shar'</SPAN></FONT></DIV><FONT face="Arial" size="2"></FONT><BR class="Apple-interchange-newline"></SPAN></BLOCKQUOTE></DIV><BR></DIV></BODY></HTML>