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 'th(o|ó|ò|ỏ|õ|ọ|ô|ố|ồ|ổ|ỗ|ộ|ơ|ớ|ờ|ở|ỡ|ợ)(i|í|ì|ỉ|ĩ|ị) kh(o|ó|ò|ỏ|õ|ọ|ô|ố|ồ|ổ|ỗ|ộ|ơ|ớ|ờ|ở|ỡ|ợ)(a|á|à|ả|ã|ạ|ă|ắ|ặ|ằ|ẳ|ẵ|â|ấ|ầ|ẩ|ẫ|ậ) b(i|í|ì|ỉ|ĩ|ị)(e|é|è|ẻ|ẽ|ẹ|ê|ế|ề|ể|ễ|ệ)(u|ú|ù|ủ|ũ|ụ|ư|ứ|ừ|ử|ữ|ự)' OR tb1.hometext REGEXP 'th(o|ó|ò|ỏ|õ|ọ|ô|ố|ồ|ổ|ỗ|ộ|ơ|ớ|ờ|ở|ỡ|ợ)(i|í|ì|ỉ|ĩ|ị) kh(o|ó|ò|ỏ|õ|ọ|ô|ố|ồ|ổ|ỗ|ộ|ơ|ớ|ờ|ở|ỡ|ợ)(a|á|à|ả|ã|ạ|ă|ắ|ặ|ằ|ẳ|ẵ|â|ấ|ầ|ẩ|ẫ|ậ) b(i|í|ì|ỉ|ĩ|ị)(e|é|è|ẻ|ẽ|ẹ|ê|ế|ề|ể|ễ|ệ)(u|ú|ù|ủ|ũ|ụ|ư|ứ|ừ|ử|ữ|ự)' OR tb1.author REGEXP 'th(o|ó|ò|ỏ|õ|ọ|ô|ố|ồ|ổ|ỗ|ộ|ơ|ớ|ờ|ở|ỡ|ợ)(i|í|ì|ỉ|ĩ|ị) kh(o|ó|ò|ỏ|õ|ọ|ô|ố|ồ|ổ|ỗ|ộ|ơ|ớ|ờ|ở|ỡ|ợ)(a|á|à|ả|ã|ạ|ă|ắ|ặ|ằ|ẳ|ẵ|â|ấ|ầ|ẩ|ẫ|ậ) b(i|í|ì|ỉ|ĩ|ị)(e|é|è|ẻ|ẽ|ẹ|ê|ế|ề|ể|ễ|ệ)(u|ú|ù|ủ|ũ|ụ|ư|ứ|ừ|ử|ữ|ự)' OR tb2.bodyhtml REGEXP 'th(o|ó|ò|ỏ|õ|ọ|ô|ố|ồ|ổ|ỗ|ộ|ơ|ớ|ờ|ở|ỡ|ợ)(i|í|ì|ỉ|ĩ|ị) kh(o|ó|ò|ỏ|õ|ọ|ô|ố|ồ|ổ|ỗ|ộ|ơ|ớ|ờ|ở|ỡ|ợ)(a|á|à|ả|ã|ạ|ă|ắ|ặ|ằ|ẳ|ẵ|â|ấ|ầ|ẩ|ẫ|ậ) b(i|í|ì|ỉ|ĩ|ị)(e|é|è|ẻ|ẽ|ẹ|ê|ế|ề|ể|ễ|ệ)(u|ú|ù|ủ|ũ|ụ|ư|ứ|ừ|ử|ữ|ự)' OR a.alias REGEXP 'th(o|ó|ò|ỏ|õ|ọ|ô|ố|ồ|ổ|ỗ|ộ|ơ|ớ|ờ|ở|ỡ|ợ)(i|í|ì|ỉ|ĩ|ị) kh(o|ó|ò|ỏ|õ|ọ|ô|ố|ồ|ổ|ỗ|ộ|ơ|ớ|ờ|ở|ỡ|ợ)(a|á|à|ả|ã|ạ|ă|ắ|ặ|ằ|ẳ|ẵ|â|ấ|ầ|ẩ|ẫ|ậ) b(i|í|ì|ỉ|ĩ|ị)(e|é|è|ẻ|ẽ|ẹ|ê|ế|ề|ể|ễ|ệ)(u|ú|ù|ủ|ũ|ụ|ư|ứ|ừ|ử|ữ|ự)' OR a.pseudonym REGEXP 'th(o|ó|ò|ỏ|õ|ọ|ô|ố|ồ|ổ|ỗ|ộ|ơ|ớ|ờ|ở|ỡ|ợ)(i|í|ì|ỉ|ĩ|ị) kh(o|ó|ò|ỏ|õ|ọ|ô|ố|ồ|ổ|ỗ|ộ|ơ|ớ|ờ|ở|ỡ|ợ)(a|á|à|ả|ã|ạ|ă|ắ|ặ|ằ|ẳ|ẵ|â|ấ|ầ|ẩ|ẫ|ậ) b(i|í|ì|ỉ|ĩ|ị)(e|é|è|ẻ|ẽ|ẹ|ê|ế|ề|ể|ễ|ệ)(u|ú|ù|ủ|ũ|ụ|ư|ứ|ừ|ử|ữ|ự)') OR (tb1.sourceid IN (SELECT sourceid FROM xl_vi_news_sources WHERE title LIKE '%thời khóa biểu%' OR link LIKE '%thời khóa biểu%'))) ) ) [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 'th(o|ó|ò|ỏ|õ|ọ|ô|ố|ồ|ổ|ỗ|ộ|ơ|ớ|ờ|ở|ỡ|ợ)(i|í|ì|ỉ|ĩ|ị) kh(o|ó|ò|ỏ|õ|ọ|ô|ố|ồ|ổ|ỗ|ộ|ơ|ớ|ờ|ở|ỡ|ợ)(a|á|à|ả|ã|ạ|ă|ắ|ặ|ằ|ẳ|ẵ|â|ấ|ầ|ẩ|ẫ|ậ) b(i|í|ì|ỉ|ĩ|ị)(e|é|è|ẻ|ẽ|ẹ|ê|ế|ề|ể|ễ|ệ)(u|ú|ù|ủ|ũ|ụ|ư|ứ|ừ|ử|ữ|ự)' OR tb1.hometext REGEXP 'th(o|ó|ò|ỏ|õ|ọ|ô|ố|ồ|ổ|ỗ|ộ|ơ|ớ|ờ|ở|ỡ|ợ)(i|í|ì|ỉ|ĩ|ị) kh(o|ó|ò|ỏ|õ|ọ|ô|ố|ồ|ổ|ỗ|ộ|ơ|ớ|ờ|ở|ỡ|ợ)(a|á|à|ả|ã|ạ|ă|ắ|ặ|ằ|ẳ|ẵ|â|ấ|ầ|ẩ|ẫ|ậ) b(i|í|ì|ỉ|ĩ|ị)(e|é|è|ẻ|ẽ|ẹ|ê|ế|ề|ể|ễ|ệ)(u|ú|ù|ủ|ũ|ụ|ư|ứ|ừ|ử|ữ|ự)' OR tb1.author REGEXP 'th(o|ó|ò|ỏ|õ|ọ|ô|ố|ồ|ổ|ỗ|ộ|ơ|ớ|ờ|ở|ỡ|ợ)(i|í|ì|ỉ|ĩ|ị) kh(o|ó|ò|ỏ|õ|ọ|ô|ố|ồ|ổ|ỗ|ộ|ơ|ớ|ờ|ở|ỡ|ợ)(a|á|à|ả|ã|ạ|ă|ắ|ặ|ằ|ẳ|ẵ|â|ấ|ầ|ẩ|ẫ|ậ) b(i|í|ì|ỉ|ĩ|ị)(e|é|è|ẻ|ẽ|ẹ|ê|ế|ề|ể|ễ|ệ)(u|ú|ù|ủ|ũ|ụ|ư|ứ|ừ|ử|ữ|ự)' OR tb2.bodyhtml REGEXP 'th(o|ó|ò|ỏ|õ|ọ|ô|ố|ồ|ổ|ỗ|ộ|ơ|ớ|ờ|ở|ỡ|ợ)(i|í|ì|ỉ|ĩ|ị) kh(o|ó|ò|ỏ|õ|ọ|ô|ố|ồ|ổ|ỗ|ộ|ơ|ớ|ờ|ở|ỡ|ợ)(a|á|à|ả|ã|ạ|ă|ắ|ặ|ằ|ẳ|ẵ|â|ấ|ầ|ẩ|ẫ|ậ) b(i|í|ì|ỉ|ĩ|ị)(e|é|è|ẻ|ẽ|ẹ|ê|ế|ề|ể|ễ|ệ)(u|ú|ù|ủ|ũ|ụ|ư|ứ|ừ|ử|ữ|ự)' OR a.alias REGEXP 'th(o|ó|ò|ỏ|õ|ọ|ô|ố|ồ|ổ|ỗ|ộ|ơ|ớ|ờ|ở|ỡ|ợ)(i|í|ì|ỉ|ĩ|ị) kh(o|ó|ò|ỏ|õ|ọ|ô|ố|ồ|ổ|ỗ|ộ|ơ|ớ|ờ|ở|ỡ|ợ)(a|á|à|ả|ã|ạ|ă|ắ|ặ|ằ|ẳ|ẵ|â|ấ|ầ|ẩ|ẫ|ậ) b(i|í|ì|ỉ|ĩ|ị)(e|é|è|ẻ|ẽ|ẹ|ê|ế|ề|ể|ễ|ệ)(u|ú|ù|ủ|ũ|ụ|ư|ứ|ừ|ử|ữ|ự)' OR a.pseudonym REGEXP 'th(o|ó|ò|ỏ|õ|ọ|ô|ố|ồ|ổ|ỗ|ộ|ơ|ớ|ờ|ở|ỡ|ợ)(i|í|ì|ỉ|ĩ|ị) kh(o|ó|ò|ỏ|õ|ọ|ô|ố|ồ|ổ|ỗ|ộ|ơ|ớ|ờ|ở|ỡ|ợ)(a|á|à|ả|ã|ạ|ă|ắ|ặ|ằ|ẳ|ẵ|â|ấ|ầ|ẩ|ẫ|ậ) b(i|í|ì|ỉ|ĩ|ị)(e|é|è|ẻ|ẽ|ẹ|ê|ế|ề|ể|ễ|ệ)(u|ú|ù|ủ|ũ|ụ|ư|ứ|ừ|ử|ữ|ự)') OR (tb1.sourceid IN (SELECT sourceid FROM xl_vi_news_sources WHERE title LIKE '%thời khóa biểu%' OR link LIKE '%thời khóa biểu%'))) ) ) [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: 24c47384023f9b285553e9370765424b)
If you have any questions about this site,
please contact the site administrator for more information