{"id":5755714,"date":"2015-02-05T17:42:15","date_gmt":"2015-02-05T17:42:15","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/user-import-error\/"},"modified":"2016-08-22T16:13:37","modified_gmt":"2016-08-22T16:13:37","slug":"user-import-error","status":"closed","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/user-import-error\/","title":{"rendered":"User import error"},"content":{"rendered":"<p>DELETE <code>__4_usermeta<\/code>.* FROM <code>__4_usermeta<\/code>, <code>__4_users<\/code>, <code>wp_users<\/code> WHERE <code>__4_usermeta<\/code>.user_id = <code>__4_users<\/code>.ID AND <code>__4_users<\/code>.user_email = <code>wp_users<\/code>.user_email AND <code>__4_usermeta<\/code>.meta_key NOT IN (&#8216;wp_4_capabilities&#8217;, &#8216;wp_4_user_level&#8217;);<\/p>\n<p>#1267 &#8211; Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation &#8216;=&#8217; <\/p>\n<p>Any suggestions?  Even a point in the right direction (beyond what I found in an initial Google search) would be great.  Thanks!<\/p>\n<p>https:\/\/wordpress.org\/plugins\/export-2-multisite\/<\/p>\n","protected":false},"template":"","class_list":["post-5755714","topic","type-topic","status-closed","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/5755714","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/5755714\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=5755714"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}