Forums / Cotonti / General / Found a mistake to do searches

Fatal error

elfrenazo
#1 2012-06-10 00:59

Found a mistake to do searches. Paste title in search and it came out.

 

2012-06-10 00:56

SQL error HY000: General error: 1267 Illegal mix of collations (latin1_general_ci,IMPLICIT) and (utf8_unicode_ci,COERCIBLE) for operation 'like'

#0  cot_diefatal(SQL error HY000: General error: 1267 Illegal mix of collations (latin1_general_ci,IMPLICIT) and (utf8_unicode_ci,COERCIBLE) for operation 'like') called at [/malditopc/system/database.php:449]
#1  CotDB->query(SELECT SQL_CALC_FOUND_ROWS p.* 
			FROM sed_pages AS p 
			WHERE page_cat IN ('news','ofimatica','winamp','fonts','phpscripts','radios','paginasweb','windows8','manuales','recursos','edicion','juegosflash','android','descargas','diseno','internet','juegos','mensajeria','escritorio','seguridad') AND page_state = '0' AND page_cat <> 'system' AND page_begin <= 1339289802 AND (page_expire = 0 OR page_expire > 1339289802) AND (page_title LIKE '%KakaoTalk%Mes​sen​ger%' OR page_desc LIKE '%KakaoTalk%Mes​sen​ger%' OR page_text LIKE '%KakaoTalk%Mes​sen​ger%')
			ORDER BY page_date ASC
			LIMIT 0, 200) called at [/malditopc/plugins/search/search.php:287]
#2  include(/malditopc/plugins/search/search.php) called at [/malditopc/system/plugin.php:99]
#3  require_once(/malditopc/system/plugin.php) called at [/malditopc/index.php:92]

only to help, the search goes well. I think we do research

---------------------------------------------------------------------

OTHER TOPIC:

seeker. yes, think of searching more coherent example, search for "msn messenger" see results example, search for "msn messenger 7837482130" absence of any results.

could solve?

 

This post was edited by elfrenazo (2012-06-10 01:15, 11 years ago)