HostOnNet Blog

Colliding usernames were found on your old board – PhpBB upgrade error

Looking for Linux Server Admin or WordPress Expert? We can help.

I got the following error message while trying to upgrade PhpBB 2 to PhpBB 3

Colliding usernames were found on your old board. In order to complete the conversion please delete or rename these users so that there is only one user on your old board for each clean username.

See the screenshot below


We have fixed the error by run the below SQL Query to PhpBB 2 Database

update phpbb_users set username='553' where user_id=553;
update phpbb_users set username='554' where user_id=554;
update phpbb_users set username='555' where user_id=555;
update phpbb_users set username='575' where user_id=575;
update phpbb_users set username='563' where user_id=563;
update phpbb_users set username='574' where user_id=574;

Are you using older version of phpBB ? Then, we will help you to upgrade your forum.

Through the Forum Upgrade service From HostOnNet guarantees you a smooth application upgrade with absolutely no risk on your side.

We take all the necessary security measure to make sure your data is kept safe and your forum application won’t break for any predictable or unpredictable reasons.

Avoid potential upgrade failure frustrations/headaches – let us keep your data safe!

We offer the following phpBB services

phpBB installations
Upgrades from phpBB 3.0.x or 2.x
phpBB MOD installation
phpBB Template design
Bug fixes
phpBB Hosting

If you have any requirement in phpBB, please email your requirement to [email protected]

About Sibi Antony

Bootstrap and Android LOVER. I've been creating things for the web for over 10 years, from the period of flash and table based layout web sites till mobile and tab friendly web sites.
Posted in Installation

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.