rdp / substruct

Automatically exported from code.google.com/p/substruct
0 stars 0 forks source link

variations_rank column not added to items after running substruct:db:bootstrap #223

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
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.

Original issue reported on code.google.com by enriquet...@gmail.com on 17 Sep 2010 at 2:49

GoogleCodeExporter commented 9 years ago
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>

Original comment by enriquet...@gmail.com on 17 Sep 2010 at 3:08

GoogleCodeExporter commented 9 years ago
This has already been fixed in a newer commit. Either grab the latest SVN 
branch, or wait for the 1.3.2 release.

Original comment by subim...@gmail.com on 17 Sep 2010 at 5:16