Not sure if this is an issue with Messaging 6.x.-4.0-beta8 or Notifications 6.x.-4.0-beta7... but I cannot subscribe to simple notifications either logged in or anonymously. Get this error for every type of subscription.

Ran update php, cleared caches, set all settings to default, still no luck. All other modules are up to date... possibly a conflict with another module??

Anyone seen this? I cannot find an answer anywhere.

user warning: Unknown column 's.mdid' in 'where clause' query: SELECT DISTINCT s.* FROM notifications s INNER JOIN notifications_fields f0 ON f0.sid = s.sid WHERE (s.mdid = 1) AND (s.type = 'author') AND (s.event_type = 'node') AND (s.module = 'notifications_content') AND (s.send_interval = 86400) AND (s.conditions = 1) AND ((f0.field = 'author' AND f0.intval = 2)) in /home/di/public_html/_testing/sites/all/modules/messaging/messaging.module on line 954.
user warning: Unknown column 'mdid' in 'field list' query: INSERT INTO notifications (uid, mdid, type, event_type, conditions, send_interval, language, send_method, cron, module, status, destination) VALUES (1, 1, 'author', 'node', 1, 86400, 'en', 'mail', 1, 'notifications_content', 1, 'ja09@testing.com') in /home/di/public_html/_testing/includes/common.inc on line 3538.

Comments

l0rne’s picture

l0rne commented

I ran into the same issue. In my case, I had upgraded from an earlier version, and some new database fields had not been created in the "notifications" table ("mdid" and "language"). I created these fields myself using the information in "notifications.install"