Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-23452

Roster throws errors in 2.9 after upgrade (mysql)

    XMLWordPrintable

    Details

    • 2.9 Status:
      Resolved
    • Conversion Script Required:
      Yes

      Description

      The roster tool was throwing stack traces in most sites after an upgrade from 2.8 to 2.9. This is because profile2 adds new tables with defaults but doesn't provide a conversion for old sites. We need to run this conversion. I'm not sure if this is a problem or not for mysql.

      This was briefly discussed on this thread http://permalink.gmane.org/gmane.comp.cms.sakai.devel/49380 But I don't see it fixed anywhere.

      In the database I ran it against we had 1010 rows matched in PROFILE_PRIVACY_T and 1086 rows in PROFILE_PREFERENCES_T

      This should be in the 2.9.2 scripts as there's no harm in running it if there are no nulls in these columns.

      update PROFILE_PREFERENCES_T set USE_GRAVATAR = false where USE_GRAVATAR is null;
      update PROFILE_PREFERENCES_T set EMAIL_WALL_ITEM_NEW = true where EMAIL_WALL_ITEM_NEW is null;
      update PROFILE_PREFERENCES_T set EMAIL_WORKSITE_NEW = true where EMAIL_WORKSITE_NEW is null;
      update PROFILE_PREFERENCES_T set SHOW_ONLINE_STATUS = true where SHOW_ONLINE_STATUS is null;
      update PROFILE_PRIVACY_T set MY_WALL = 0 where MY_WALL is null;
      update PROFILE_PRIVACY_T set ONLINE_STATUS = 0 where ONLINE_STATUS is null;

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  jonespm Matthew Jones
                  Reporter:
                  jonespm Matthew Jones
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Git Source Code