[support] search errors

[Laura Scott]

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.

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.

Again, I am not a mysql expert, so I may be wrong here.

Laura


On Feb 16, 2007, at 4:23 AM, Mohammed Al-shar' wrote:

> 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/082be2ac/attachment.htm