I have problem in my database forum phpBB3.
In table phpbb_users username is "alex" but in username_clean is "alex000".
How Can I change for all users username_clean?
I use tool https://www.phpbb.com/support/stk/ but is problem:
Code: Select all
SQL ERROR [ mysql4 ] Duplicate entry 'andrzej' for key 'username_clean'  SQL UPDATE phpbb_users SET username_clean = 'andrzej' WHERE user_id = 71 BACKTRACE FILE: (not given by php) LINE: (not given by php) CALL: stk_msg_handler() FILE: [ROOT]/includes/db/dbal.php LINE: 757 CALL: trigger_error() FILE: [ROOT]/includes/db/mysql.php LINE: 175 CALL: dbal->sql_error() FILE: [ROOT]/stk/tools/support/reclean_usernames.php LINE: 53 CALL: dbal_mysql->sql_query() FILE: [ROOT]/stk/index.php LINE: 376 CALL: reclean_usernames->run_tool()
of users is very much.
My table phpbb_users from kunena convert.