nickname / last_name with apostrophes truncated login name removing space

  • I’ve resolved this by deleting the records for anyone with an apostrophe in their surname and recreating.

    I noticed in phpMyAdmin in the usermeta table there seemed to be an extra field (roles – which had Array in the meta_value). This might be a red herring, just thought worth mentioning.

    usermeta table: nickname and last_name retained the apostrophe.
    users table: user_login; apostrophe was stripped out

    Issue
    What was happening is that when we entered a user name in the WordPress login form the space was stripped between the first and last name and then of course we then got an ‘Invalid Username’ error.

    We deleted anyone with an apostrophe in nickname and last_name (there were about 8 in 1,300 odd records) and then recreated their account manually without using the apostrophe anywhere and the login returned to normal.

    I wonder if the single quote should have been wrapped in a double quote in the original CSV file?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Javier Carazo

    (@carazo)

    @lindsay-heydon

    Not sure if I am understanding.

    A well-formed CSV created for example with Libre Office would fix this I think.

    Thread Starter Lindsay Heydon

    (@lindsay-heydon)

    We used Excel > Save As > CSV format. Apostrophes were present.

    After the import the apostrophes were kept in nickname and last_name and removed from user_login. But the apostrophes remaining seemed to cause a login issue.

    It’s not the end of the world, but I did think could be useful for somebody else if they have a similar problem and are trying to problem solve.

    Plugin Author Javier Carazo

    (@carazo)

    @lindsay-heydon,

    This is free software (free with the mean of “libre”).

    Please use LibreOffice better than Microsoft Office.

    This is free and also this is better to create CSV.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘nickname / last_name with apostrophes truncated login name removing space’ is closed to new replies.