2025-01-15 13:36:26
SQL Error: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like' at /home/ftpaccess/emportugal.pt/www/classes/catalog/user/Search.class.php line 58
Array ( [code] => 1267 [message] => Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like' [query] => SELECT COUNT(*) FROM `new_v22_listings` WHERE ((domain LIKE '%α%' || description LIKE '%α%' || title LIKE '%α%' || keyword1 LIKE '%α%' || keyword2 LIKE '%α%' || keyword3 LIKE '%α%' || keyword4 LIKE '%α%' || keyword5 LIKE '%α%') && (domain LIKE '%σ%' || description LIKE '%σ%' || title LIKE '%σ%' || keyword1 LIKE '%σ%' || keyword2 LIKE '%σ%' || keyword3 LIKE '%σ%' || keyword4 LIKE '%σ%' || keyword5 LIKE '%σ%') && (domain LIKE '%ε%' || description LIKE '%ε%' || title LIKE '%ε%' || keyword1 LIKE '%ε%' || keyword2 LIKE '%ε%' || keyword3 LIKE '%ε%' || keyword4 LIKE '%ε%' || keyword5 LIKE '%ε%') && (domain LIKE '%π%' || description LIKE '%π%' || title LIKE '%π%' || keyword1 LIKE '%π%' || keyword2 LIKE '%π%' || keyword3 LIKE '%π%' || keyword4 LIKE '%π%' || keyword5 LIKE '%π%')) && status='active' [context] => /home/ftpaccess/emportugal.pt/www/classes/catalog/user/Search.class.php line 58 )