My favorites | Sign in
Project Home Downloads Wiki Issues Source
READ-ONLY: This project has been archived. For more information see this post.
Search
for
  Advanced search   Search tips   Subscriptions
Issue 223: variations_rank column not added to items after running substruct:db:bootstrap
1 person starred this issue and may be notified of changes. Back to list
Status:  Fixed
Owner:  ----
Closed:  Sep 2010


 
Reported by enriquet...@gmail.com, Sep 17, 2010
What steps will reproduce the problem?
1. Download Tar.gz
2. Unzip
3. run db:create
4. run substruct:db:bootstrap
5. check the items table the variant_rank column is not there, it is like the migration was not introduces in the schema file.

The app crashes when checking the products view due to the missing column

What is the expected output? What do you see instead?


What version of the product are you using? On what operating system?
1.3.1
Windows 7 64 bits
rails version 2.3.1


Please provide any additional information below.


Sep 17, 2010
#1 enriquet...@gmail.com
This is the exception message

Showing app/views/store/_product.rhtml where line #25 raised:

Mysql::Error: Unknown column 'variation_rank' in 'order clause': SELECT * FROM `items` WHERE (`items`.product_id = 1) AND ( (`items`.`type` = 'Variation' ) )  ORDER BY price ASC, -variation_rank DESC
Extracted source (around line #25):

22:     <div class="product_title">
23:       <%= link_to(product.name, :controller=>'store', :action=>'show', :id => product.code) %>
24:     </div>
25:     <% if product.display_price? %>
26:       <span class="money"><%= sub_number_to_currency(product.display_price) %></span>
27:     <% end %>
28:   </div>
Sep 17, 2010
Project Member #2 subim...@gmail.com
This has already been fixed in a newer commit. Either grab the latest SVN branch, or wait for the 1.3.2 release.
Status: Fixed

Powered by Google Project Hosting