Stars are keyed off username, not userid, so don't survive user renames.

XMLWordPrintable

    • Severity 3 - Minor

      to reproduce:

      1. login as "bob", and star some stuff
      2. rename "bob" to "databasenormalisation101"
      3. relogin as "databasenormalisation101" and notice that there are no starred items

      to fix this:

      1. normalise the CRU_BASE_STAR_MODEL table so that stars are keyed off user ids instead of user names
      2. write a database upgrade script. Will need to cope with the possibility that there are usernames in the CRU_BASE_STAR_MODEL table that don't exist in the CRU_USER table. Can delete row in star table if username no longer exists in CRU_USER table?

            Assignee:
            Unassigned
            Reporter:
            BrendanA
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: