I get the following error under the admin/manage subscriptions/administer (a tab created by notifications)

user warning: Table 'zowdacom_drupal.messaging_destination' doesn't exist query: SELECT COUNT(*) FROM notifications n INNER JOIN messaging_destination d ON n.mdid = d.mdid INNER JOIN users u ON n.uid = u.uid in /home/mydomain/public_html/sites/all/modules/notifications/notifications.manage.inc on line 58.
user warning: Table 'zowdacom_drupal.messaging_destination' doesn't exist query: SELECT n.*, d.address, u.name AS user_name FROM notifications n INNER JOIN messaging_destination d ON n.mdid = d.mdid INNER JOIN users u ON n.uid = u.uid ORDER BY n.sid DESC LIMIT 0, 50 in /home/mydomain/public_html/sites/all/modules/notifications/notifications.manage.inc on line 58.

Ive tried disabling and reenabling the module but it hasn't helped. It looks like this is a necessary database table that is not being created. Any thoughts?

Comments

StratisFear’s picture

StratisFear commented

I had this issue after multiple installs removals of various messaging modules and versions.

I ended up installing on a fresh database, but I think the problem occurs when the system table makes messaging think the destinations table already exists, even though it doesn't. Its missing from the uninstal perhaps.

Try removing all messaging/notifications lines from the system table and reinstalling with the dev version. Or install on a clean install and copy and paste the missing table via phpmyadmin.

knic’s picture

knic commented

Can't stop that clock, but maybe save someone a bit o' time: Isn't this just the same as: node/930534? I just got rid of this error by manually inserting a pair of brackets into line 443 of messaging.install file. Took a minute. Seems it never got committed.