Bug #254
Feature #36: associate publications with projects
Feature #221: Publication Detail view
crash when clicking on publication name in pubs list
| Status: | Closed | Start date: | 2011-08-08 | |
|---|---|---|---|---|
| Priority: | Immediate | Due date: | ||
| Assignee: |  Luis Figueira | % Done: | 0% | |
| Category: | - | |||
| Target version: | Bibliography Alpha |
Description
Just pulled and merged from feature_36 into my integration branch; migrated; restarted.
Now if I navigate to
http://test.soundsoftware.ac.uk/cannam/publications?project_id=weevilmatic
and click on either of the publication names, I get
ActiveRecord::StatementInvalid in Publications#show
Showing vendor/plugins/redmine_bibliography/app/views/publications/show.html.erb where line #11 raised:
Mysql::Error: Unknown column 'auth_order' in 'order clause': SELECT * FROM `authorships` WHERE (`authorships`.publication_id = 1) ORDER BY auth_order
Extracted source (around line #11):
8:
9: <h4><%= l(:authors) %></h4>
10: <ul id="authorships">
11: <% for authorship in @publication.authorships.find(:all, :order => :auth_order) %>
12: <% content_tag_for :li, authorship do %>
13: <span class="handle">[drag to reorder]</span>
14: <%= h authorship.name_on_paper %> <br />
RAILS_ROOT: /var/www/test-cannam
Application Trace | Framework Trace | Full Trace
Request
Parameters:
{"project_id"=>"weevilmatic",
"id"=>"1"}
Show session dump
Response
Headers:
{"Content-Type"=>"text/html",
"Cache-Control"=>"no-cache"}
History
#1
Updated by Chris Cannam over 12 years ago
- Status changed from New to Closed
OK, this is a change in a past migration (which we permit since we're churning in development at the moment I guess) occasioned by ca9e8e562ea7. To fix either we can tweak the DB by hand, or go the long way around and recreate the tables -- I did this by
RAILS_ENV=development rake db:migrate:plugin NAME=redmine_bibliography VERSION=0 RAILS_ENV=development rake db:migrate:plugins rake redmine:plugins:redmine_bibliography:seed_bibtex_entry_types