FireStats error processing pending hits: Błąd bazy danych: Illegal mix of collations (latin2_general_ci,COERCIBLE) and (latin1_swedish_ci,IMPLICIT) for operation 'regexp'

MySQL Version: 5.7.22-22-log
SQL Query:
SELECT url,count(url_pattern) c FROM blcpl_firestats_excluded_urls right join (SELECT 'http://blog.louiscypherr.pl/wp-admin/admin.php?page=wassup&wmark=1&wip=188.128.208.194&deleteMARKED=1&dip=188.128.208.194' AS url UNION SELECT 'http://www.google.pl/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&ved=0CC8QFjAA&url=http%3A%2F%2Fblog.louiscypherr.pl%2F%3Fp%3D24&ei=aLrRUr-pKevCygOKxoHIDQ&usg=AFQjCNFN8Kl8pkUFFOtnOAIDelHIY7SeCw&sig2=wp7rvIkEQHbgy9D8Tg0Sfw&bvm=bv.59026428,d.bGQ' AS url UNION SELECT 'http://blog.louiscypherr.pl/wp-admin/admin.php?page=wps_settings' AS url UNION SELECT 'http://blog.louiscypherr.pl/wp-admin/index.php' AS url UNION SELECT 'http://www.google.pl/url?sa=t&rct=j&q=&esrc=s&frm=1&source=web&cd=17&cad=rja&ved=0CFoQFjAGOAo&url=http%3A%2F%2Fblog.louiscypherr.pl%2F%3Fp%3D24&ei=SNrSUr6-INC0hAe464DoCg&usg=AFQjCNFN8Kl8pkUFFOtnOAIDelHIY7SeCw&bvm=bv.59026428,d.bGE' AS url UNION SELECT 'http://www.google.pl/url?sa=t&rct=j&q=&esrc=s&source=web&cd=10&ved=0CHMQFjAJ&url=http%3A%2F%2Fblog.louiscypherr.pl%2F%3Fp%3D24&ei=yQ7TUr6yA8qAhAfXy4DwBA&usg=AFQjCNFN8Kl8pkUFFOtnOAIDelHIY7SeCw&bvm=bv.59026428,d.bGE' AS url UNION SELECT 'http://www.google.pl/url?sa=t&rct=j&q=&esrc=s&source=web&cd=4&sqi=2&ved=0CEYQFjAD&url=http%3A%2F%2Fblog.louiscypherr.pl%2F%3Fp%3D24&ei=LADUUseMDYia7Qah2oCQDw&usg=AFQjCNFN8Kl8pkUFFOtnOAIDelHIY7SeCw&bvm=bv.59026428,d.bGE' AS url UNION SELECT 'http://www.google.pl/url?sa=t&rct=j&q=zerowa%20konfiguracja%20sieci%20bezprzewodowej%20windows%207&source=web&cd=7&ved=0CEIQFjAG&url=http%3A%2F%2Fblog.louiscypherr.pl%2F%3Fp%3D24&ei=SBzUUqPPGsKitAaQs4CADw&usg=AFQjCNFN8Kl8pkUFFOtnOAIDelHIY7SeCw' AS url UNION SELECT 'http://www.google.pl/search?ei=VzzUUpKCHIrB7AbS1YCIBg&q=przemys%C5%82aw+rejf&oq=przemys%C5%82aw+rejf&gs_l=mobile-gws-serp.12..0j0i22i30l3.35963.52597.0.53707.45.37.3.3.3.9.810.8529.7j9j13j2j2j1j2.36.49166....0...1c.1j5.32.mobile-gws-serp..21.24.3241.p_aCzWN8RNw' AS url UNION SELECT 'http://www.google.pl/url?sa=t&rct=j&q=&esrc=s&source=web&cd=7&ved=0CGIQFjAG&url=http%3A%2F%2Fblog.louiscypherr.pl%2F%3Fp%3D24&ei=pSvVUpqlDuiO7QbvuYCIAw&usg=AFQjCNFN8Kl8pkUFFOtnOAIDelHIY7SeCw&bvm=bv.59378465,d.bGE' AS url) urls ON url regexp url_pattern GROUP BY url

58 słowa

Speedtest

Podziel się na:
  • Facebook
  • Add to favorites
  • co-robie
  • email
  • Gadu-Gadu Live
  • MySpace
  • RSS
  • Twitter
  • Śledzik
  • PDF
  • Google Bookmarks
  • Blogger.com
  • Kciuk.pl
  • Reddit
  • Wykop
FireStats icon Działa dzięki FireStats