<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=windows-1252">
<META content="MSHTML 6.00.2900.3059" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY
style="WORD-WRAP: break-word; khtml-nbsp-mode: space; khtml-line-break: after-white-space"
bgColor=#ffffff>
<DIV><FONT face=Arial size=2>hi Laura!</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>you are right. "it looks like your tables in your
database have varying collations." I am almost possitive this is the problem,
but I don't know what the default collation is for drupal, especially that
my site has arabic, which might be an issue here. I know for certain that
whatever collation is the default works, because whenever I setup a new drupal
site I have no problem. this particular site was transformed from host to
another, and from mysql 4.0 to mysql 5.27. there's a known issue with utf when
upgrading. I solved that in part, it seems, because my site performs so well
aside from this search problem. how do I change the collation? it looks
it's not an easy task for someone like me, who's not a mysql
expert.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>thanks.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Mohammed Al-shar'</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=laura@pingv.com href="mailto:laura@pingv.com">Laura Scott</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=support@drupal.org
href="mailto:support@drupal.org">support@drupal.org</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Friday, February 16, 2007 6:27
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [support] search
errors</DIV>
<DIV><BR></DIV>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="WORD-SPACING: 0px; FONT: 11px Verdana; TEXT-TRANSFORM: none; COLOR: rgb(0,0,0); TEXT-INDENT: 0px; WHITE-SPACE: normal; LETTER-SPACING: normal; BORDER-COLLAPSE: separate; border-spacing: 0px 0px; khtml-text-decorations-in-effect: none; apple-text-size-adjust: auto; orphans: 2; widows: 2">
<DIV><FONT face=Arial size=2><SPAN class=Apple-style-span
style="FONT-SIZE: 9px; FONT-FAMILY: Arial">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-SIZE: 9px; FONT-FAMILY: Arial">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-SIZE: 9px; FONT-FAMILY: Arial">• 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-SIZE: 9px; FONT-FAMILY: Arial"><SPAN class=Apple-style-span
style="FONT-SIZE: 9px; FONT-FAMILY: Arial">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-SIZE: 9px; FONT-FAMILY: Arial"><SPAN class=Apple-style-span
style="FONT-SIZE: 9px; FONT-FAMILY: Arial">- 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-SIZE: 9px; FONT-FAMILY: Arial"><SPAN class=Apple-style-span
style="FONT-SIZE: 9px; FONT-FAMILY: Arial">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-SIZE: 9px; FONT-FAMILY: Arial"><SPAN class=Apple-style-span
style="FONT-SIZE: 9px; FONT-FAMILY: Arial">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-SIZE: 9px; FONT-FAMILY: Arial"><SPAN class=Apple-style-span
style="FONT-SIZE: 9px; FONT-FAMILY: Arial">on line 172. </SPAN><BR
style="FONT-SIZE: 9px; FONT-FAMILY: Arial"><SPAN class=Apple-style-span
style="FONT-SIZE: 9px; FONT-FAMILY: Arial">• 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-SIZE: 9px; FONT-FAMILY: Arial"><SPAN class=Apple-style-span
style="FONT-SIZE: 9px; FONT-FAMILY: Arial">on line 172. </SPAN><BR
style="FONT-SIZE: 9px; FONT-FAMILY: Arial"></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=Apple-style-span
style="FONT-SIZE: 9px; FONT-FAMILY: Arial">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-SIZE: 9px; FONT-FAMILY: Arial">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-SIZE: 9px; FONT-FAMILY: Arial">the site url is: </SPAN><A
href="http://www.nattiq.com"><SPAN class=Apple-style-span
style="FONT-SIZE: 9px; COLOR: rgb(0,0,238); FONT-FAMILY: Arial; khtml-text-decorations-in-effect: underline">www.nattiq.com</SPAN></A><SPAN
class=Apple-style-span style="FONT-SIZE: 9px; FONT-FAMILY: Arial"> you may
want to see </SPAN><A href="http://www.nattiq.com/en"><SPAN
class=Apple-style-span
style="FONT-SIZE: 9px; COLOR: rgb(0,0,238); FONT-FAMILY: Arial; khtml-text-decorations-in-effect: underline">www.nattiq.com/en</SPAN></A><SPAN
class=Apple-style-span style="FONT-SIZE: 9px; FONT-FAMILY: Arial"> 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-SIZE: 9px; FONT-FAMILY: Arial">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-SIZE: 9px; FONT-FAMILY: Arial">Mohammed
Al-shar'</SPAN></FONT></DIV><FONT face=Arial size=2></FONT><BR
class=Apple-interchange-newline></SPAN></BLOCKQUOTE></DIV><BR></DIV>
<P>
<HR>
<P></P>-- <BR>[ Drupal support list | http://lists.drupal.org/
]</BLOCKQUOTE></BODY></HTML>