3995

Character set 'utf8mb4_0900_ai_ci' cannot be used in conjunction with 'binary' in call to regexp_like. SQL=SELECT * FROM ( SELECT * FROM #__redj_redirects WHERE ( ( ('/index.php/en/component/mailto/?tmpl=component&template=shaper_helix_ii&link=e9f30b71e46651c1ceaebdfd12840e0fef4d57dc' REGEXP BINARY fromurl)>0 AND (case_sensitive<>0) AND (decode_url<>0) AND (request_only<>0) ) OR ( ('/index.php/en/component/mailto/?tmpl=component&template=shaper_helix_ii&link=e9f30b71e46651c1ceaebdfd12840e0fef4d57dc' REGEXP BINARY fromurl)>0 AND (case_sensitive<>0) AND (decode_url=0) AND (request_only<>0) ) OR ( ('https://arabidopsisresearch.org/index.php/en/component/mailto/?tmpl=component&template=shaper_helix_ii&link=e9f30b71e46651c1ceaebdfd12840e0fef4d57dc' REGEXP BINARY fromurl)>0 AND (case_sensitive<>0) AND (decode_url<>0) AND (request_only=0) ) OR ( ('https://arabidopsisresearch.org/index.php/en/component/mailto/?tmpl=component&template=shaper_helix_ii&link=e9f30b71e46651c1ceaebdfd12840e0fef4d57dc' REGEXP BINARY fromurl)>0 AND (case_sensitive<>0) AND (decode_url=0) AND (request_only=0) ) OR ( ('/index.php/en/component/mailto/?tmpl=component&template=shaper_helix_ii&link=e9f30b71e46651c1ceaebdfd12840e0fef4d57dc' REGEXP fromurl)>0 AND (case_sensitive=0) AND (decode_url<>0) AND (request_only<>0) ) OR ( ('/index.php/en/component/mailto/?tmpl=component&template=shaper_helix_ii&link=e9f30b71e46651c1ceaebdfd12840e0fef4d57dc' REGEXP fromurl)>0 AND (case_sensitive=0) AND (decode_url=0) AND (request_only<>0) ) OR ( ('https://arabidopsisresearch.org/index.php/en/component/mailto/?tmpl=component&template=shaper_helix_ii&link=e9f30b71e46651c1ceaebdfd12840e0fef4d57dc' REGEXP fromurl)>0 AND (case_sensitive=0) AND (decode_url<>0) AND (request_only=0) ) OR ( ('https://arabidopsisresearch.org/index.php/en/component/mailto/?tmpl=component&template=shaper_helix_ii&link=e9f30b71e46651c1ceaebdfd12840e0fef4d57dc' REGEXP fromurl)>0 AND (case_sensitive=0) AND (decode_url=0) AND (request_only=0) ) ) AND published=1 ORDER BY ordering ) AS A WHERE A.skip='' OR ( ('https://arabidopsisresearch.org/index.php/en/component/mailto/?tmpl=component&template=shaper_helix_ii&link=e9f30b71e46651c1ceaebdfd12840e0fef4d57dc' REGEXP BINARY A.skip)=0 AND (case_sensitive<>0) AND (decode_url<>0) ) OR ( ('https://arabidopsisresearch.org/index.php/en/component/mailto/?tmpl=component&template=shaper_helix_ii&link=e9f30b71e46651c1ceaebdfd12840e0fef4d57dc' REGEXP BINARY A.skip)=0 AND (case_sensitive<>0) AND (decode_url=0) ) OR ( ('https://arabidopsisresearch.org/index.php/en/component/mailto/?tmpl=component&template=shaper_helix_ii&link=e9f30b71e46651c1ceaebdfd12840e0fef4d57dc' REGEXP A.skip)=0 AND (case_sensitive=0) AND (decode_url<>0) ) OR ( ('https://arabidopsisresearch.org/index.php/en/component/mailto/?tmpl=component&template=shaper_helix_ii&link=e9f30b71e46651c1ceaebdfd12840e0fef4d57dc' REGEXP A.skip)=0 AND (case_sensitive=0) AND (decode_url=0) )
GO_BACK HOME