I install the plugin on the site for registration in Russian(Allow Cyrillic Usernames) and now I need to change in the sql database, in the table wp_users, in the column user_nicename permission to write more characters from by default 50 to 255. How to do this? Tried, did not work: ALTER TABLE wp_users ALTER COLUMN user_nicename varchar(200) NOT NULL -error

ALTER TABLE wp_users CHANGE user_nicename user_nicename VARCHAR(255) NOT NULL DEFAULT ''; -error #1067 Found in net tip: show variables like 'sql_mode' ; And remove the sql_mode "NO_ZERO_IN_DATE,NO_ZERO_DATE" to make it work. How to do this one?

  • 1
    It's not a good idea to alter the WordPress core. I recommand you to store the long username in a user meta and then you use this filter to authenticate the user : codex.wordpress.org/Plugin_API/Filter_Reference/authenticate – mmm Jan 14 '18 at 8:59
  • Thank you for the answer but it's too difficult for me. If you are developing a Wordpress engine is it possible to simplify registration in non-English languages? I have been trying for 3 days! to solve this problem unsuccessfully. – Ann Jan 14 '18 at 9:23

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.