mahara-contributors team mailing list archive

[Kristina Hoeppner <1656715@xxxxxxxxxxxxxxxxxx>]

** Changed in: mahara
       Status: New => Confirmed

** Changed in: mahara
   Importance: Undecided => Medium

** Tags added: mobile

-- 
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
Matching subscriptions: Subscription for all Mahara Contributors -- please ask on #mahara-dev or mahara.org forum before editing or unsubscribing it!
https://bugs.launchpad.net/bugs/1656715

Title:
  Mahara mobile WS syncing notifications fails to sync 'ALL'
  notifications( e.g. user to user)

Status in Mahara:
  Confirmed

Bug description:
  Related to  #1656151.

  function get_notifications in module_mobileapi_sync.php file uses following query to get notifications:
  SELECT n.id, n.subject, n.message FROM {notification_internal_activity} n INNER JOIN {activity_type} a ON n.type=a.id WHERE FLOOR(EXTRACT(EPOCH FROM ctime AT TIME ZONE CURRENT_SETTING('TIMEZONE'))) BETWEEN ? AND ? AND n.usr= ? AND n.read = 0.

  Query doesn't include notifications from user to user ...

To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1656715/+subscriptions