<!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 and all.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I have fixed this collation issue by altering the
defected tables to utf_general_si by running the following sql commands one by
one:</FONT></DIV>
<DIV><FONT face=Arial size=2>ALTER TABLE files_backup CONVERT TO CHARACTER SET
utf8 COLLATE utf8_general_ci<BR>ALTER TABLE mailman_lists CONVERT TO CHARACTER
SET utf8 COLLATE utf8_general_ci<BR>ALTER TABLE mailman_users CONVERT TO
CHARACTER SET utf8 COLLATE utf8_general_ci<BR>ALTER TABLE
node_comment_statistics CONVERT TO CHARACTER SET utf8 COLLATE
utf8_general_ci<BR>ALTER TABLE queue CONVERT TO CHARACTER SET utf8 COLLATE
utf8_general_ci<BR>ALTER TABLE search_index CONVERT TO CHARACTER SET utf8
COLLATE utf8_general_ci<BR>ALTER TABLE search_total CONVERT TO CHARACTER SET
utf8 COLLATE utf8_general_ci</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>those were the tables that needed to be fixed in my
specific case. </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>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 9:25
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [support] search
errors</DIV>
<DIV><BR></DIV><FONT class=Apple-style-span face=Helvetica size=3><SPAN
class=Apple-style-span style="FONT-SIZE: 12px"><A
href="http://drupal.org/search/node/database+collation">http://drupal.org/search/node/database+collation</A></SPAN></FONT>
<DIV><FONT class=Apple-style-span face=Helvetica size=3><SPAN
class=Apple-style-span style="FONT-SIZE: 12px"><BR
class=khtml-block-placeholder></SPAN></FONT></DIV>
<DIV><FONT class=Apple-style-span face=Helvetica size=3><SPAN
class=Apple-style-span style="FONT-SIZE: 12px">The top several hits seem to
have discussion on this very topic.</SPAN></FONT></DIV>
<DIV><FONT class=Apple-style-span face=Helvetica size=3><SPAN
class=Apple-style-span style="FONT-SIZE: 12px"><BR
class=khtml-block-placeholder></SPAN></FONT></DIV>
<DIV><FONT class=Apple-style-span face=Helvetica size=3><SPAN
class=Apple-style-span style="FONT-SIZE: 12px">Laura</SPAN></FONT></DIV>
<DIV><FONT class=Apple-style-span face=Helvetica size=3><SPAN
class=Apple-style-span style="FONT-SIZE: 12px"><BR></SPAN></FONT>
<DIV>
<DIV>On Feb 16, 2007, at 11:46 AM, Mohammed Al-shar' wrote:</DIV><BR
class=Apple-interchange-newline>
<BLOCKQUOTE type="cite">
<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>
<DIV><BR class=khtml-block-placeholder></DIV>
<HR>
<DIV><BR class=khtml-block-placeholder></DIV>-- <BR>[ Drupal support list
| <A href="http://lists.drupal.org">http://lists.drupal.org</A>/
]</BLOCKQUOTE>
<DIV style="MARGIN: 0px">--<SPAN
class=Apple-converted-space> </SPAN></DIV>
<DIV style="MARGIN: 0px">[ Drupal support list | <A
href="http://lists.drupal.org">http://lists.drupal.org</A>/
]</DIV></BLOCKQUOTE></DIV><BR></DIV>
<P>
<HR>
<P></P>-- <BR>[ Drupal support list | http://lists.drupal.org/
]</BLOCKQUOTE></BODY></HTML>