newby stuck on tutorial PGError: ERROR: column

rubyonrails-talk
#1

macpro:photos peterr$ rake photos:reset
(in /Development/photos)
== CreatePhotos: migrating

#2

Peter Ritchie wrote:
[...]

rake aborted!
PGError: ERROR: column "postion" of relation "slides" does not exist
LINE 1: ..., "slideshow_id", "updated_at", "id", "photo_id",
"postion")...

Fixtures .yml file:

<% 1.upto(9) do |i| %>
slide_<%=i%>:
    id: <%=i%>
    postion: <%=i%>
    photo_id: <%=i%>
    slideshow_id: 1
    <% end %>

Snow Leopard, Rails 2.3.4, psql 8.3 gem 1.3.4

Help would be appreciated

Looks like you have a typo in your fixtures file. Is the column really
called "postion", or did you mean "position"?

BTW, fixtures are not good for most testing. Try Machinist or something
similar instead.

Peter

Best,

#3

Marnen Laibow-Koser wrote:

Looks like you have a typo in your fixtures file. Is the column really
called "postion", or did you mean "position"?

BTW, fixtures are not good for most testing. Try Machinist or something
similar instead.

How embarrassing! Although 'postions' are not bad really. Thanks for the
tip on Machinist.