So many broken users due to corrupt database

[hosna]

btw with help of @RGJ we nailed the problem down to this two condisions:

@RGJ

there are two different problems:

• users that cannot be found by username but can be found by id (like mojtaba11)
• users that cannot be found by username_lower but can be found by username (like alireza6)

see:

irb(main):002:0> User.username_available?('Alireza6')                                                                                                              
=> true
irb(main):004:0> User.username_exists?('alireza6')                                                                                                                 
=> false
irb(main):006:0> DB.exec(User::USERNAME_EXISTS_SQL, username: 'alireza6')                                                                                         
=> 0
discourse=> select username, username_lower from users where username_lower='alireza6';                                                                           
 username | username_lower 
----------+----------------
(0 rows)

discourse=> select username, username_lower from users where username='Alireza6';
 username | username_lower 
----------+----------------
 Alireza6 | alireza6
(1 row)