-
Bug
-
Resolution: Fixed
-
High
-
3.1
LDAP users with uppercase usernames cannot add favorites after upgrading to Confluence v3.1. The error message is similar to:
You are not permitted to add the label(s) ~admin@admin.com:favourite to this page.
Could replicate on MySQL with both case sensitive and in-sensitive collation.
The external_entities table stores the usernames correctly preserving the case.
Lower case LDAP usernames do not experience this problem. Cannot be replicated with local users.
No errors logged into the log files. This is not related to the upgrade task as it can be replicated in a brand new 3.1 instance.
- relates to
-
-
- Closed
-
-
CONFSERVER-19132 PageOperationsAcceptanceTest - run as test user, not admin user
- Closed
[CONFSERVER-18218] LDAP users with uppercase usernames cannot add favourites
I have a ms sql statement but it did not work because of the constraints. When I tried to remove the constraint and then redo the query, I got addtional errors. We upgraded to 3.1.1 and now not only do the favorites not work.. we have a whole new set of issues to deal with
Stacy Shenker
added a comment - - edited I have a ms sql statement but it did not work because of the constraints. When I tried to remove the constraint and then redo the query, I got addtional errors. We upgraded to 3.1.1 and now not only do the favorites not work.. we have a whole new set of issues to deal with The old patch still had problems with starring spaces for certain users.
To apply the new patch
0) Make a backup of your database.
1) Shutdown confluence
2) Delete your existing <CONFLUENCE_INSTALL>/confluence/WEB-INF/classes/com/atlassian/confluence/labels directory (to remove the old patch)
3) Unzip the attached labels.zip file into your <CONFLUENCE_INSTALL>/confluence/WEB-INF/classes/com/atlassian/confluence directory
4) Restart and test your instance.
Stacy Shenker
added a comment - is there anyone who can give me the correct syntax for the above query for MS SQL
Stacy Shenker
added a comment - is there anyone who can give me the correct syntax for the above query for MS SQL 
Patrick Bennett
added a comment - When can we expect a fix for this!?
Favorites don't work at all for our site.
Patrick Bennett
added a comment - When can we expect a fix for this!?
Favorites don't work at all for our site. Patrick Bennett
added a comment - fyi: Just so this doesn't slide, the patch doesn't work for me - it makes it so the error doesn't appear when I favorite a page but the page never actually gets favorited. It doesn't show up as a favorite in the dashboard.
Patrick Bennett
added a comment - fyi: Just so this doesn't slide, the patch doesn't work for me - it makes it so the error doesn't appear when I favorite a page but the page never actually gets favorited. It doesn't show up as a favorite in the dashboard. Unfortunately, testing the patch further indicates that though the favorites can now be added successfully, refreshing the page makes it again appear as not a favorite. Though please note that the favorite is added to the user profile. Visiting the dashboard will list this page as a favorite.
But now there is no indication that the page has already been added to the favorite list and no means to remove it from the Tools menu either. As a workaround, please use the Favorite list on the Dashboard to manage your favorites.
When logged in as user 'HAN', the error message is "You are not permitted to add the label(s) ~han:favourite to this page".
Our DBA and I have tried to rewrite the update query to work in Oracle, but due to constraints and a many to one relationship, we haven't been successful. We understand what needs to be done, but we don't want to force things as it may cause a problem down the line. So here is my plea... please post a fix for those using Oracle.