- Confluence 5.4.3
- PostgreSQL 8.4.13
An entry in the user_mapping table has a null value for the lower_username field, which causes users to be shown as 'unknown user' when searching.
Your database may look like this:
Remove the user mappings with null values from the database. See
CONF-36018 for the set of SQL queries to achieve this.
Is it possible to add a constraint to lower_username to prevent null values?