Bug #254

Feature #36: associate publications with projects

Feature #221: Publication Detail view

crash when clicking on publication name in pubs list

Added by Chris Cannam about 8 years ago. Updated about 8 years ago.

Status:ClosedStart date:2011-08-08
Priority:ImmediateDue 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 about 8 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

Also available in: Atom PDF