0009700: Bad sequence after an upgrade - MantisBT - Signup temporarily disabled due to spam

ID	Project	Category	View Status	Date Submitted	Last Update

0009700	mantisbt	upgrade	public	2008-10-15 20:54	2009-06-26 12:02

Reporter	olegos	Assigned To	grangeway
Priority	normal	Severity	minor	Reproducibility	have not tried
Status	closed	Resolution	duplicate
Product Version	1.1.3

Summary	0009700: Bad sequence after an upgrade
Description	Using PosgreSQL database. Upgrading from 1.0.0 to 1.1.3. Unpacked 1.1.3, ran admin/install.php, all checks passed. Trying to update an issue, getting this error: APPLICATION ERROR 401 Database query failed. Error received from database was #-1: ERROR: relation "mantis_email_table_id_seq" does not exist for the query: SELECT currval('mantis_email_table_id_seq') Looking in the database, this sequence is called "mantis_email_table_email_id_seq". Renamed it in the database, and the problem is gone.
Additional Information	Fixed with these SQL commands: mantis=# ALTER TABLE mantis_email_table ALTER COLUMN email_id DROP DEFAULT; mantis=# ALTER SEQUENCE mantis_email_table_email_id_seq RENAME TO mantis_email_table_id_seq; mantis=# ALTER TABLE mantis_email_table ALTER COLUMN email_id SET DEFAULT nextval('mantis_email_table_id_seq'::regclass);
Tags	No tags attached.

olegos 2008-10-16 14:34 reporter ~0019578	Sorry, made a typo in the description. I was upgrading 1.0.8->1.1.3.

jreese 2008-10-20 11:31 reporter ~0019605	1.1.x has known issues with database schemas for Postgresql; last I knew, Paul was the one dealing with trying to port the fixes from trunk back to 1.1.x.

olegos 2008-11-17 18:43 reporter ~0019922	This issue can be duped to 0007616. In particular, note 0007616:0013946 and following ones address this issue.