ISSUE SUMMARY:
It appears that if a user creates a photo_album, and then deletes the same photo_album, the result is that the photo_album database record itself gets deleted, but the global notification database record, pointing toward the now deleted photo_album, stays. So user find themselves clicking on Another User's Pictures from 2 weeks ago, only to find a '0' error awaiting you.

STEPS TO REPLICATE:
1. Click the global notification icon
2. If you click to the known deleted post, images, or albums notification.

RESULT
1. Error 0 comes up with message "null primary key not allowed"

EXPECTED RESULT
1. No results for deleted posts or Jomsocial doesn't completely remove the notifications.

BROWSER
1. All browsers.

MORE INFO
- The photo_album record is correctly deleted from this table: #__community_photos_albums
- The global notification record incorrectly remains in this table: #__community_notifications

According to the profile message these global notifications are supposed to get deleted automatically after 30 days. However, we have global notifications records going back through Dec 2013. And, Jomsocial creates a unique row for each notification per user, so, for every single notification, 4000+ records are instantly created per group. The table currently holds 467,116 notification records. The record id#'s are up in the 4 millions, so maybe some notifications are correctly being deleted and some are not.

Thanks in advance.

Hi,

Thank You for reporting this. please wait for the fix.

Regards

Hi,

here the patch: