I am running the subscriptions module on Drupal 6,3

I had previously installed an earlier version of Subscription but removed it when it wasn't working properly.

After installing the current version everything seems fine except that I'm getting the message "Database error: user "X" not found in {subscriptions_user} table!"

This message only appears for users that had been created after I uninstalled the old Subscription version.

I have run update php

Comments

salvis’s picture

salvis
he/his
commented
Category: bug » support
Priority: Critical » Normal

Since the earlier version "wasn't working properly" for you, I'd recommend to uninstall (not just disable) Subscriptions and reinstall from scratch. This will create all the required records for you.

If something "wasn't working properly," then I wouldn't want to try to build on it...

Johnbmtl’s picture

Johnbmtl commented

Actually, I thought I had uninstalled by removing all of the components from the Modules folder.

But obviously this did not remove the subscription users in the database.

When I go in the "uninstall" page in the modules section it tells me "No modules are available to uninstall."

How do I clean up the database?

Thanks!

salvis’s picture

salvis
he/his
commented

Disable and then uninstall.

Johnbmtl’s picture

Johnbmtl commented

I did as you said and everything seems to be working fine.

Thanks!

Another quick question.
Everyone is now unsubscribed. Is there a quick way of subscribing everybody?

salvis’s picture

salvis
he/his
commented
Status: Active » Fixed

Great, glad it works now.

No, there's no "quick way of subscribing everybody". There are various types of subscriptions, each with a couple of variations. If you're up to working with the database directly, you can create one subscription of the desired type, look into the {subscriptions} table for what was created, and create similar rows for all other users.

Be sure not to subscribe users who don't want to receive mail!!!

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.