WordPress database error: [Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_unicode_520_ci,IMPLICIT) for operation '='](
SELECT 0 AS is_personal, 1 AS is_ip, status, country_code, network1, network2, network3, network4, mask1, mask2, mask3, mask4
FROM wpf9_spbc_firewall_data_v6
WHERE
network1 IN (0,704643072,704774144,704790528,704791552,704792064,704792320,704792448)
AND network2 IN (0,1114112,1118208,1118720,1118752,1118768,1118772)
AND network3 IN (0,0)
AND network4 IN (0,148,150)
AND country_code = "0"
) UNION (
SELECT 1 AS is_personal, 1 AS is_ip, status, 0 AS country_code, network1, network2, network3, network4, mask1, mask2, mask3, mask4
FROM wpf9_spbc_firewall__personal_ips_v6
WHERE
network1 IN (0,704643072,704774144,704790528,704791552,704792064,704792320,704792448)
AND network2 IN (0,1114112,1118208,1118720,1118752,1118768,1118772)
AND network3 IN (0,0)
AND network4 IN (0,148,150)
) UNION (
SELECT 1 AS is_personal, 0 AS is_ip, tbl_private.status, country_code, network1, network2, network3, network4, mask1, mask2, mask3, mask4
FROM wpf9_spbc_firewall__personal_countries AS tbl_private
RIGHT JOIN wpf9_spbc_firewall_data_v6 AS tbl_common USING(country_code)
WHERE
network1 IN (0,704643072,704774144,704790528,704791552,704792064,704792320,704792448)
AND network2 IN (0,1114112,1118208,1118720,1118752,1118768,1118772)
AND network3 IN (0,0)
AND network4 IN (0,148,150)
AND tbl_private.status IS NOT NULL
AND 53665 <> 0
)
Get Social