[support] search errors

[Mohammed Al-shar']

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'
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20070216/6790d67e/attachment.htm