Installation failed on my site
| Project: | Subscriptions |
| Version: | 5.x-2.1 |
| Component: | Code |
| Category: | support request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed |
Jump to:
When I go to Subscriptions/User Defaults, I get this rather worrying warning message:
# user warning: Unknown column 'module' in 'field list' query: SELECT module, field, count(1) as number FROM subscriptions WHERE recipient_uid = -2 GROUP BY module, field in /Users/Zubin/MAMP/GDP22/includes/database.mysql.inc on line 172.
# user warning: Table 'gdp22.subscriptions_user' doesn't exist query: SELECT uid, digest, send_interval, send_updates, send_comments, send_interval_visible, send_updates_visible, send_comments_visible, autosub_on_post, autosub_on_update, autosub_on_comment, send_self FROM subscriptions_user WHERE uid in (-2, -2) ORDER BY uid in /Users/Zubin/MAMP/GDP22/includes/database.mysql.inc on line 172.
# warning: Invalid argument supplied for foreach() in /Users/Zubin/MAMP/GDP22/sites/all/modules/subscriptions/subscriptions.module on line 500.
# user warning: Table 'gdp22.subscriptions_user' doesn't exist query: SELECT uid, digest, send_interval, send_updates, send_comments, send_interval_visible, send_updates_visible, send_comments_visible, autosub_on_post, autosub_on_update, autosub_on_comment, send_self FROM subscriptions_user WHERE uid in (-2, -2) ORDER BY uid in /Users/Zubin/MAMP/GDP22/includes/database.mysql.inc on line 172.
It goes on, repeating the last warning.
Any ideas?

#1
On uninstalling, I also get this:
user warning: Table 'gdp22.subscriptions_queue' doesn't exist query: DELETE FROM subscriptions_queue WHERE load_function LIKE 'subscriptions_content_%' in /Users/Zubin/MAMP/GDP22/includes/database.mysql.inc on line 172.
#2
Uninstalling is what I was going to suggest. Then reinstall and check whether the errors are still there. Look for the tables in your database.
Subscriptions works like any other contrib module that installs its own tables.
#3
Feel free to reopen, if you have something to add.
#4
Automatically closed -- issue fixed for two weeks with no activity.