I recently upgraded my site from D5.3 to D6.4. I had subscriptions running on my D5 site before the upgrade and they worked fine. I was running subscriptions-5.x-1.9.

I understand that there was no “uninstall” feature for the subscriptions module for D5. I totally deleted all files for the D5 subscriptions module before upgrading. I did not delete the database tables for subscriptions before upgrading – I am too scared/ignorant to touch any database tables, and besides, I wanted my site to remember who had subscribed to what.

When I first installed the subscriptions module for D6 it would not work – I got those big scary red tables on the subscriptions settings page saying that it was missing some tables. I then ran the uninstall script in D6 (on the modules page). That ran without any errors i.e. no big red warning tables. I then switched the subscriptions module back on. Now everything looks fine, and the module is sending subscriptions, but only to those users who have subscribed to categories SINCE the upgrade.

In other words, during the upgrade the record of who had subscribed to what was lost and the module for D6 is not finding the tables that D5 must have been looking at to remember who had subscribed to what. D6 seems to be creating its own record of who has subscribed to what

Any help on this would be appreciated.

Regards
Michael
www.legaltree.ca

Comments

salvis’s picture

salvis
he/his
commented
Title: D6 installation cannot remember user subscriptions from D5 » When I uninstall, the database tables are removed
Category: bug » support
Status: Active » Closed (works as designed)

When I first installed the subscriptions module for D6 it would not work – I got those big scary red tables on the subscriptions settings page saying that it was missing some tables.

If you want to have any hope for getting help, then you must stop right there, open a support request, and copy/paste "those big scary red tables" in full, along with the path (URL) of the page where you saw that message.

I then ran the uninstall script in D6 (on the modules page). That ran without any errors i.e. no big red warning tables. I then switched the subscriptions module back on. Now everything looks fine, and the module is sending subscriptions, but only to those users who have subscribed to categories SINCE the upgrade.

In other words, during the upgrade the record of who had subscribed to what was lost and the module for D6 is not finding the tables that D5 must have been looking at to remember who had subscribed to what. D6 seems to be creating its own record of who has subscribed to what

Uninstalling does just that: it removes all traces of the module, including all of its tables. When you re-enable the module, you will have a virgin installation.

mike211175’s picture

mike211175 commented

Thanks Salvis, that makes sense i.e. your comment that I would have obliterated the list of who had subscribed to what when I ran the uninstall in D6. I only had about 60 users who had subscribed to stuff, so I just reinstalled the old site on a testsite, looked up in the database (using phpmyadmin) who had subscribed to what and then manually recreated the subscriptions.

salvis’s picture

salvis
he/his
commented

Ok, glad you were able to restore your users' settings.

You didn't happen to retry the upgrade on that test site, did you? The upgrade from 5.x-1.9 should have worked...