mahara-contributors team mailing list archive

[Cecilia Vela Gurovic <1781073@xxxxxxxxxxxxxxxxxx>]

** Description changed:

  In the user menu there is a link to the inbox and it shows a text 'x
  unread', x meaning the number of unread messages we have in the inbox.
  
  This number is saved in the db in the 'usr' table with field name
  'unread'. It gets updated everytime we see a message or we receive it by
  doing -1 / +1.
  
  But this number can get actually out of sync with the real amount of
- unread messages in the 'notification_internal_activity' for that user.
+ unread messages in the db for that user.
+ 
+ The real amount of messages come from tables
+ 'notification_internal_activity' and
+ 'module_multirecipient_userrelation'
  
  Maybe on solution could be checking the numbers match everytime we login
  or access the inbox.

-- 
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/1781073

Title:
  inbox read count could get out of sync

Status in Mahara:
  New

Bug description:
  In the user menu there is a link to the inbox and it shows a text 'x
  unread', x meaning the number of unread messages we have in the inbox.

  This number is saved in the db in the 'usr' table with field name
  'unread'. It gets updated everytime we see a message or we receive it
  by doing -1 / +1.

  But this number can get actually out of sync with the real amount of
  unread messages in the db for that user.

  The real amount of messages come from tables
  'notification_internal_activity' and
  'module_multirecipient_userrelation'

  Maybe on solution could be checking the numbers match everytime we
  login or access the inbox.

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