[DRE-maint] [Bug 691747] Re: after upgrade: column issues.lft does not exist

[Florian W.]

Calling
RAILS_ENV=production rake db:migrate

brought my database schema into a correct state.
(I guess that should have been called by a package upgrade script?)

-- 
You received this bug notification because you are subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/691747

Title:
  after upgrade: column issues.lft does not exist

Status in “redmine” package in Ubuntu:
  New

Bug description:
  Binary package hint: redmine

I'm on Ubuntu 10.10 and installed redmine and redmine-pgsql via Synaptic some time ago.
I remember there was an upgrade a few weeks later. Currently, 1.0.0-4 packages are installed for both, redmine and redmine-pgsql.

When trying to add a ticket, this SQL error appears after submit of the "new ticket" form:
PGError: FEHLER:  Spalte issues.lft existiert nicht ("column issues.lft does not exist")

I expected the package upgrade to update the database schema as well, however that obviously didn't work.

http://www.redmine.org/boards/1/topics/16785?r=16832 suggests that the same issue exists/existed in Debian.