Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.Steps to repeat:
1. Install fbss and fbss_notifications
2. Create a status, delete it
Results:
user warning: Unknown table 'notifications' in MULTI DELETE query: DELETE notifications, notifications_fields FROM notifications n INNER JOIN notifications_fields f ON n.sid = f.sid WHERE (n.event_type = 'status' AND f.intval = 3336) OR (n.event_type = 'stream' AND f.intval = 371) in /mnt/www/html/i/docroot/profiles/drupal_commons/modules/contrib/facebook_status/submodules/fbss_notifications/fbss_notifications.module on line 77.
Expected results:
The values are deleted.
Patch coming...
| Comment | File | Size | Author |
|---|---|---|---|
| #1 | 1557840_use_aliases_everywhere.patch | 952 bytes | greggles |
Comments
Comment #1
gregglesPatch attached. I changed to use the alias everywhere and to use an alias for notifications that won't be confused for the alias typically used for the node table (e.g. by db_rewrite_sql).
Comment #2
gregglesI hadn't tested the patch in #1, but have done so now and it fixes the bug for me.
Comment #3
icecreamyou commentedCommitted the patch from #1 to dev (and D7 as well). Thanks!