During upgrade, the schema doesn't appear to be updated. My "subscriptions" table looks like this:

drupal=# \d subscriptions;
         Table "public.subscriptions"
    Column     |  Type   |     Modifiers
---------------+---------+--------------------
 sid           | integer | not null
 uid           | integer | not null
 stype         | text    | not null
 send_interval | integer | not null default 0

Comments

stefanor’s picture

All the other tables were updated just fine.

salvis’s picture

Status: Active » Postponed (maintainer needs more info)

What version did you have before upgrading?

stefanor’s picture

It was Drupal 5.10, with subscriptions 5.x-2.2. Looking at that, I see that this bug must have been in that version, not 6.x.

salvis’s picture

Status: Postponed (maintainer needs more info) » Closed (won't fix)

The version of subscriptions.install that produced this table was either 1.3.2.1.2.1 or 1.3.2.1.2.2. It was part of an unsuccessful attempt by chx to fix 5.x-1.x, but it was experimental at best and turned out to be a stillbirth. There was never even a hint of support for that version, and you should not have installed it on anything but a short-lived test server.

Version 1.3.2.1.2.3 was 5.x-2.0-BETA1 and I took care to provide an upgrade path from 5.x-1.x upwards, but what you installed is completely unsupported.

I'm sorry to say this, but you're on your own.