XF 1.2 Make username not unique?

Yikes...

I would have thought that's a pretty extensive change...

But one thing you could try in a completely isolated test board is removing the unique index on the username field with this query:

Code:
ALTER TABLE `xf_user` 
DROP INDEX `username`

I haven't even begun to think about the problems this could cause, though, so please do proceed with caution.

There's quite a few cases, I think, where XenForo assumes the username is unique so I think this could require some pretty extensive development. I know why you want to do it though... Just a big task, I think.
 
Yeah, bad idea. Think about conversations, user searches, tagging, find by user, etc. Everything user facing in XF is geared around usernames.
 
Yikes...

I would have thought that's a pretty extensive change...

But one thing you could try in a completely isolated test board is removing the unique index on the username field with this query:

Code:
ALTER TABLE `xf_user`
DROP INDEX `username`

I haven't even begun to think about the problems this could cause, though, so please do proceed with caution.

There's quite a few cases, I think, where XenForo assumes the username is unique so I think this could require some pretty extensive development. I know why you want to do it though... Just a big task, I think.


Revisiting this as I finally got around to this project idea again.. Trying to create a second user with same username it says User names must be unique. The specified user name is already in use. I did the alter you gave me to drop the index.
 
Frankly, no.

We're still of the opinion that this is a pretty bad idea from a technical point of view. And this issue you're experiencing now is just one of the problems you will face.

The system is designed to expect that usernames are unique. If you remove that constraint then you're going to find numerous things that stop working as expected.
 
Top Bottom