User Error
PDOException Object
(
[message:protected] => SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation 'regexp'
[string:Exception:private] =>
[code:protected] => HY000
[file:protected] => /home/tlxuulzx/public_html/vendor/vinades/nukeviet/Core/Database.php
[line:protected] => 528
[trace:Exception:private] => Array
(
[0] => Array
(
[file] => /home/tlxuulzx/public_html/vendor/vinades/nukeviet/Core/Database.php
[line] => 528
[function] => query
[class] => PDO
[type] => ->
[args] => Array
(
[0] => SELECT COUNT(*) FROM xl_vi_news_rows as tb1 LEFT JOIN xl_vi_news_detail tb2 ON ( tb1.id = tb2.id ) LEFT JOIN xl_vi_news_authorlist a ON (tb1.id = a.id) WHERE tb1.status=1 AND (( tb1.title REGEXP 'nh(a|á|à|ả|ã|ạ|ă|ắ|ặ|ằ|ẳ|ẵ|â|ấ|ầ|ẩ|ẫ|ậ) g(i|í|ì|ỉ|ĩ|ị)(a|á|à|ả|ã|ạ|ă|ắ|ặ|ằ|ẳ|ẵ|â|ấ|ầ|ẩ|ẫ|ậ)(o|ó|ò|ỏ|õ|ọ|ô|ố|ồ|ổ|ỗ|ộ|ơ|ớ|ờ|ở|ỡ|ợ)'
OR tb1.hometext REGEXP 'nh(a|á|à|ả|ã|ạ|ă|ắ|ặ|ằ|ẳ|ẵ|â|ấ|ầ|ẩ|ẫ|ậ) g(i|í|ì|ỉ|ĩ|ị)(a|á|à|ả|ã|ạ|ă|ắ|ặ|ằ|ẳ|ẵ|â|ấ|ầ|ẩ|ẫ|ậ)(o|ó|ò|ỏ|õ|ọ|ô|ố|ồ|ổ|ỗ|ộ|ơ|ớ|ờ|ở|ỡ|ợ)'
OR tb1.author REGEXP 'nh(a|á|à|ả|ã|ạ|ă|ắ|ặ|ằ|ẳ|ẵ|â|ấ|ầ|ẩ|ẫ|ậ) g(i|í|ì|ỉ|ĩ|ị)(a|á|à|ả|ã|ạ|ă|ắ|ặ|ằ|ẳ|ẵ|â|ấ|ầ|ẩ|ẫ|ậ)(o|ó|ò|ỏ|õ|ọ|ô|ố|ồ|ổ|ỗ|ộ|ơ|ớ|ờ|ở|ỡ|ợ)'
OR tb2.bodyhtml REGEXP 'nh(a|á|à|ả|ã|ạ|ă|ắ|ặ|ằ|ẳ|ẵ|â|ấ|ầ|ẩ|ẫ|ậ) g(i|í|ì|ỉ|ĩ|ị)(a|á|à|ả|ã|ạ|ă|ắ|ặ|ằ|ẳ|ẵ|â|ấ|ầ|ẩ|ẫ|ậ)(o|ó|ò|ỏ|õ|ọ|ô|ố|ồ|ổ|ỗ|ộ|ơ|ớ|ờ|ở|ỡ|ợ)'
OR a.alias REGEXP 'nh(a|á|à|ả|ã|ạ|ă|ắ|ặ|ằ|ẳ|ẵ|â|ấ|ầ|ẩ|ẫ|ậ) g(i|í|ì|ỉ|ĩ|ị)(a|á|à|ả|ã|ạ|ă|ắ|ặ|ằ|ẳ|ẵ|â|ấ|ầ|ẩ|ẫ|ậ)(o|ó|ò|ỏ|õ|ọ|ô|ố|ồ|ổ|ỗ|ộ|ơ|ớ|ờ|ở|ỡ|ợ)'
OR a.pseudonym REGEXP 'nh(a|á|à|ả|ã|ạ|ă|ắ|ặ|ằ|ẳ|ẵ|â|ấ|ầ|ẩ|ẫ|ậ) g(i|í|ì|ỉ|ĩ|ị)(a|á|à|ả|ã|ạ|ă|ắ|ặ|ằ|ẳ|ẵ|â|ấ|ầ|ẩ|ẫ|ậ)(o|ó|ò|ỏ|õ|ọ|ô|ố|ồ|ổ|ỗ|ộ|ơ|ớ|ờ|ở|ỡ|ợ)')
OR (tb1.sourceid IN (SELECT sourceid FROM xl_vi_news_sources WHERE title LIKE '%nhà giáo%' OR link LIKE '%nhà giáo%')))
)
)
[1] => Array
(
[file] => /home/tlxuulzx/public_html/modules/news/funcs/search.php
[line] => 484
[function] => query
[class] => NukeViet\Core\Database
[type] => ->
[args] => Array
(
[0] => SELECT COUNT(*) FROM xl_vi_news_rows as tb1 LEFT JOIN xl_vi_news_detail tb2 ON ( tb1.id = tb2.id ) LEFT JOIN xl_vi_news_authorlist a ON (tb1.id = a.id) WHERE tb1.status=1 AND (( tb1.title REGEXP 'nh(a|á|à|ả|ã|ạ|ă|ắ|ặ|ằ|ẳ|ẵ|â|ấ|ầ|ẩ|ẫ|ậ) g(i|í|ì|ỉ|ĩ|ị)(a|á|à|ả|ã|ạ|ă|ắ|ặ|ằ|ẳ|ẵ|â|ấ|ầ|ẩ|ẫ|ậ)(o|ó|ò|ỏ|õ|ọ|ô|ố|ồ|ổ|ỗ|ộ|ơ|ớ|ờ|ở|ỡ|ợ)'
OR tb1.hometext REGEXP 'nh(a|á|à|ả|ã|ạ|ă|ắ|ặ|ằ|ẳ|ẵ|â|ấ|ầ|ẩ|ẫ|ậ) g(i|í|ì|ỉ|ĩ|ị)(a|á|à|ả|ã|ạ|ă|ắ|ặ|ằ|ẳ|ẵ|â|ấ|ầ|ẩ|ẫ|ậ)(o|ó|ò|ỏ|õ|ọ|ô|ố|ồ|ổ|ỗ|ộ|ơ|ớ|ờ|ở|ỡ|ợ)'
OR tb1.author REGEXP 'nh(a|á|à|ả|ã|ạ|ă|ắ|ặ|ằ|ẳ|ẵ|â|ấ|ầ|ẩ|ẫ|ậ) g(i|í|ì|ỉ|ĩ|ị)(a|á|à|ả|ã|ạ|ă|ắ|ặ|ằ|ẳ|ẵ|â|ấ|ầ|ẩ|ẫ|ậ)(o|ó|ò|ỏ|õ|ọ|ô|ố|ồ|ổ|ỗ|ộ|ơ|ớ|ờ|ở|ỡ|ợ)'
OR tb2.bodyhtml REGEXP 'nh(a|á|à|ả|ã|ạ|ă|ắ|ặ|ằ|ẳ|ẵ|â|ấ|ầ|ẩ|ẫ|ậ) g(i|í|ì|ỉ|ĩ|ị)(a|á|à|ả|ã|ạ|ă|ắ|ặ|ằ|ẳ|ẵ|â|ấ|ầ|ẩ|ẫ|ậ)(o|ó|ò|ỏ|õ|ọ|ô|ố|ồ|ổ|ỗ|ộ|ơ|ớ|ờ|ở|ỡ|ợ)'
OR a.alias REGEXP 'nh(a|á|à|ả|ã|ạ|ă|ắ|ặ|ằ|ẳ|ẵ|â|ấ|ầ|ẩ|ẫ|ậ) g(i|í|ì|ỉ|ĩ|ị)(a|á|à|ả|ã|ạ|ă|ắ|ặ|ằ|ẳ|ẵ|â|ấ|ầ|ẩ|ẫ|ậ)(o|ó|ò|ỏ|õ|ọ|ô|ố|ồ|ổ|ỗ|ộ|ơ|ớ|ờ|ở|ỡ|ợ)'
OR a.pseudonym REGEXP 'nh(a|á|à|ả|ã|ạ|ă|ắ|ặ|ằ|ẳ|ẵ|â|ấ|ầ|ẩ|ẫ|ậ) g(i|í|ì|ỉ|ĩ|ị)(a|á|à|ả|ã|ạ|ă|ắ|ặ|ằ|ẳ|ẵ|â|ấ|ầ|ẩ|ẫ|ậ)(o|ó|ò|ỏ|õ|ọ|ô|ố|ồ|ổ|ỗ|ộ|ơ|ớ|ờ|ở|ỡ|ợ)')
OR (tb1.sourceid IN (SELECT sourceid FROM xl_vi_news_sources WHERE title LIKE '%nhà giáo%' OR link LIKE '%nhà giáo%')))
)
)
[2] => Array
(
[file] => /home/tlxuulzx/public_html/index.php
[line] => 364
[args] => Array
(
[0] => /home/tlxuulzx/public_html/modules/news/funcs/search.php
)
[function] => require
)
)
[previous:Exception:private] =>
[errorInfo] => Array
(
[0] => HY000
[1] => 1267
[2] => Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation 'regexp'
)
)
(Code: 42ad79740123d7db3a00ea02fab52b8f)
If you have any questions about this site,
please
contact the site administrator for more information