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://www.ads-software.com/plugins/export-2-multisite/

Viewing 1 replies (of 1 total)
  • Plugin Author jamiechong

    (@jamiechong)

    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.