Same named diaries?

Rosebud, you left a support request as a comment. Consider yourself lucky that I’m even looking at it 🙂

There is only one way a diary can have the same name as someone elses, and thats if the first user has requested their account be deleted. It is not possible to have two diaries co-exist on the system with the same username because the database has a unique constraint on that column and trying to add a new user with the same name gives an error at the database level. (Not to mention other things get really weird if someone has the same name).


mysql> insert into users ( user_name, password, real_name, real_email )
-> values
-> ( 'delancie', 'gobbldygook', 'Steve Brown', 'steve@atomic-systems.com' );
ERROR 1062: Duplicate entry 'delancie' for key 2

So, even if the new user signup screen is broken and neglects to check, the database won’t allow the same username anyway.

However, if you’d like me to look into it, please mail me at support@atomic-systems.com (click the address at the bottom if you like) and don’t leave support requests as comments!

Steve.

1 thought on “Same named diaries?”

  1. Oh I didnt know I couldnt ask a question 🙁

    Sorry (seem to say that all the time eh!!)

    Name problem sorted out, the two diarist have a difference of a number in the name and dont wooy its ok

    Sorry to have disturbed you.
    Im off!

    Rosie

Comments are closed.