HostOnNet Blog


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

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

phpbb-upgrade-error

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 install@hostonnet.com


About hostonnet2

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