Privatemsg upgrade from 4.7.6 to 5.1 fails due to sequences.
PMunn - February 27, 2007 - 03:16
| Project: | Privatemsg |
| Version: | 5.x-1.4 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | duplicate |
Jump to:
Description
Note that this is a PostgreSQL install.
When activating Privatemsg on my 5.1 upgrade of my 4.7.6 install, the privatemsg module attempts and fails to do this:
* ALTER TABLE {privatemsg} ALTER COLUMN id SET DEFAULT NULL
* Failed: CREATE SEQUENCE privatemsg_id_seq INCREMENT 1 START 143
* ALTER TABLE {privatemsg_folder} ALTER COLUMN fid SET DEFAULT NULL
* Failed: CREATE SEQUENCE privatemsg_folder_fid_seq INCREMENT 1 START 1
* ALTER TABLE {privatemsg_archive} ALTER COLUMN id SET DEFAULT NULLThe existing sequences prevent modification of those columns. It also fails to create new sequences:
* warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "privatemsg_id_seq" already exists in /www/drupal/live-5.1/includes/database.pgsql.inc on line 125.
* user warning: query: CREATE SEQUENCE privatemsg_id_seq INCREMENT 1 START 143 in /www/drupal/live-5.1/includes/database.pgsql.inc on line 144.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "privatemsg_folder_fid_seq" already exists in /www/drupal/live-5.1/includes/database.pgsql.inc on line 125.
* user warning: query: CREATE SEQUENCE privatemsg_folder_fid_seq INCREMENT 1 START 1 in /www/drupal/live-5.1/includes/database.pgsql.inc on line 144.
#1
I think you meant version 5.x-1.4, since 5.x-1.1 didn't use sequences.
I'm pretty sure this is a duplicate of #122703 regarding db_prefix. I've just fixed that bug and will release a new version. If you still see this problem trying to upgrade to 5.x-1.5 then you can reopen this. If so, please provide much more detail.. OS, drupal and php versions, privatemsg version before and after upgrade, what order/steps you took to upgrade, what db_prefix you are using, whether you have multiple installs with different prefixes in this database and if those other installs use privatemsg module.