fix appointment groups on mysql

refs CNVS-7032

use a join instead of a subquery on an update

test plan:
 * regression test that when you change an existing appointment group,
   all appointments in that group update appropriately

Change-Id: Ib05a9edc424a172c81991017c0705566311706a0
Reviewed-on: https://gerrit.instructure.com/27822
Tested-by: Jenkins <jenkins@instructure.com>
Reviewed-by: Jon Jensen <jon@instructure.com>
Product-Review: Cody Cutrer <cody@instructure.com>
QA-Review: Cody Cutrer <cody@instructure.com>
fix notification preferences spec

silly jon and his silly fixtures that are different depending on
spec run order

Change-Id: Ica490540640908058fce670a47bbe810356e84e4
Reviewed-on: https://gerrit.instructure.com/27947
Reviewed-by: Rob Orton <rob@instructure.com>
QA-Review: Rob Orton <rob@instructure.com>
Product-Review: Rob Orton <rob@instructure.com>
Tested-by: Jenkins <jenkins@instructure.com>
spec: pending specs - fixed

Change-Id: I031838a600b858717942ad4da97b57b6fcd3ed3f
Reviewed-on: https://gerrit.instructure.com/27926
Tested-by: Jenkins <jenkins@instructure.com>
Tested-by: Hannah Bottalla <hannah@instructure.com>
Reviewed-by: Hannah Bottalla <hannah@instructure.com>
QA-Review: Hannah Bottalla <hannah@instructure.com>
Product-Review: Hannah Bottalla <hannah@instructure.com>
remove canvas- from production scribd_user

closes CNVS-10190

test plan
 - in production upload a scribdable doc
 - doc should render

Change-Id: I1e6ed767fe9359250e2966bcee34c99ec1548495
Reviewed-on: https://gerrit.instructure.com/27939
Tested-by: Jenkins <jenkins@instructure.com>
Reviewed-by: Jacob Fugal <jacob@instructure.com>
Product-Review: Rob Orton <rob@instructure.com>
QA-Review: Rob Orton <rob@instructure.com>
show uncategorized account groups, fixes CNVS-10188, refs CNVS-1482

when you import groups into an account vis SIS, they are not linked to any
group set. this commit puts them in a new "Uncategorized" tab so you can
still see them and navigate to their home pages. previously you could see
them in the now-retired right sidebar.

note that there is no "Uncategorized" set in the db; we simply display a
synthetic group set that is essentially read-only.

also note that this doesn't apply to course groups, because 1. you can't
SIS import them and 2. canvas won't let you create a course group without
a group set.

test plan:
1.  do a SIS of import of some groups. for bonus points, import some users
    into those groups
2.  go to the manage groups page for the account
3.  you should see an "Uncategorized" tab at the end (always comes last)
4.  click it
5.  you should see a note explaining what these are
6.  you should not be able to delete or edit the group set
7.  you should not be able to add/edit/delete groups in the set
8.  you should be able to see the users in the groups (if any)
9.  you should not be able to reassign users (via menu or drag-and-drop)
    in the group set
10. you should be able to navigate to a given group's home page (via cog)
11. you should be able to filter groups via the search box
12. accounts without Uncategorized group sets should not have an
    Uncategorized tab
13. all other group sets (and their contents) should behave normally in
    this account and in any other course/account (general regression test)

Change-Id: Id0fa8e547bc9274a685c89d70b0cbb54ef3a01d0
Reviewed-on: https://gerrit.instructure.com/27933
Reviewed-by: Landon Wilkins <lwilkins@instructure.com>
Tested-by: Jenkins <jenkins@instructure.com>
QA-Review: Clare Strong <clare@instructure.com>
Product-Review: Jon Jensen <jon@instructure.com>
fix spec deprecation warnings for rails 3

Change-Id: I896138df06b396b495728a6488d9780dec09d85e
Reviewed-on: https://gerrit.instructure.com/27935
Tested-by: Jenkins <jenkins@instructure.com>
Reviewed-by: Cody Cutrer <cody@instructure.com>
QA-Review: James Williams  <jamesw@instructure.com>
Product-Review: James Williams  <jamesw@instructure.com>