Title: User import error
Last modified: August 22, 2016

---

# User import error

 *  [gordonium](https://wordpress.org/support/users/gordonium/)
 * (@gordonium)
 * [11 years, 7 months ago](https://wordpress.org/support/topic/user-import-error/)
 * DELETE `__4_usermeta`.* FROM `__4_usermeta`, `__4_users`, `wp_users` WHERE `__4_usermeta`.
   user_id = `__4_users`.ID AND `__4_users`.user_email = `wp_users`.user_email AND`
   __4_usermeta`.meta_key NOT IN (‘wp_4_capabilities’, ‘wp_4_user_level’);
 * #1267 – Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,
   IMPLICIT) for operation ‘=’
 * Any suggestions? Even a point in the right direction (beyond what I found in 
   an initial Google search) would be great. Thanks!
 * [https://wordpress.org/plugins/export-2-multisite/](https://wordpress.org/plugins/export-2-multisite/)

Viewing 1 replies (of 1 total)

 *  Plugin Author [jamiechong](https://wordpress.org/support/users/jamiechong/)
 * (@jamiechong)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/user-import-error/#post-5756215)
 * gordonium – so sorry for the uber late reply. I’m obviously not very active on
   maintenance for this plugin.
 * I’m guessing your multisite install is using a different collation than your 
   single site install. You can try editing the exported SQL file and replace instances
   of `utf8_general_ci` with `utf8_unicode_ci` (or vice-versa).

Viewing 1 replies (of 1 total)

The topic ‘User import error’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/export-2-multisite.svg)
 * [Export 2 Multisite](https://wordpress.org/plugins/export-2-multisite/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/export-2-multisite/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/export-2-multisite/)
 * [Active Topics](https://wordpress.org/support/plugin/export-2-multisite/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/export-2-multisite/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/export-2-multisite/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [jamiechong](https://wordpress.org/support/users/jamiechong/)
 * Last activity: [10 years, 11 months ago](https://wordpress.org/support/topic/user-import-error/#post-5756215)
 * Status: not resolved