Convert kunena users to phpBB3

Converting from other board software? Good decision! Need help? Have a question about a convertor? Wish to offer a convertor package? Post here.
Scam Warning
Registered User
Posts: 122
Joined: Fri Jan 27, 2006 6:37 pm

Convert kunena users to phpBB3

Post by ert4 » Tue Sep 24, 2013 4:54 am


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 but is problem:

Code: Select all

SQL ERROR [ mysql4 ]

Duplicate entry 'andrzej' for key 'username_clean' [1062]


UPDATE phpbb_users SET username_clean = 'andrzej' WHERE user_id = 71


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()
I don't want manually to change in my table phpbb_users.
of users is very much.
My table phpbb_users from kunena convert.

Registered User
Posts: 7
Joined: Tue Feb 17, 2015 9:01 am

Re: Convert kunena users to phpBB3

Post by stefandebeer » Tue Feb 17, 2015 9:05 am

From the looks of things, you have a duplicate for 'andrzej' if you remove that entry, you should be able to continue with your import.

Could you please explain to me how you are doing this? I would like to do the same.


Return to “[3.0.x] Convertors”