Beginners: File uploads and rendering images to the database (Page 3 of 3)

I did just notice that the last line above returns a 200 status, however the URL is [http://localhost/pictures/code_picture?id=3] rather than [http://localhost:3000/pictures/code_picture?id=3] *the port number changed*.... Is this significant?

Thanks,
B.

Final note (I hope)

With higher resolution cameras, and thus larger files, changing just the :limit value may not be enough.  mySQL has a default packet limitation (the size of a single, entire query) of 1Mb.  A simple change to the mySQL configuration file changes the client side value.  I changed mine to 8Mb and everything worked again for larger pictures.

See: http://dev.mysql.com/doc/refman/5.0/en/ … large.html

for more info.

Is there any way to use RMagick to resize these photo uploads on the way to the database?  I've been spending hours trying but can't seem to figure it out.

Something like this, although it doesn't work:

require 'RMagick'

class Photo < ActiveRecord::Base
  belongs_to :user
     
  def image_file=(input_data)
    self.filename = input_data.original_filename
    self.content_type = input_data.content_type.chomp
    self.full = input_data.read   
    img = Magick::Image.read(input_data).first
    self.thumbnail = img.thumbnail(125,125)
  end

end

Last edited by bensie (2007-11-23 20:07:25)

Hi bensie.

Try this.

picture = Magick::Image.from_blob(input_data.read).first

Last edited by andy_dick (2007-12-13 13:37:30)

Same here, fell totally apart around "Creating a new photo".

Would be nice to redo the index for rails 2.

Anyone have a link to a rails 2 tutorial?

I am currently on a windows machine with netbeans (did the one tut for rails 2 on their site)

hi all I am a newbie to RoR , i have tried out this tutorial but got stuck.
the "ruby script/generate scaffold photo photo_admin" didn't create any method in my photo_admin contoller. i'm using rails 2.0. Is there any sintax difference in rails 2.0

pls tell me what "ruby script/generate scaffold photo photo_admin" does ? will it create two controllers -> photo and photo_admin??!!

Last edited by jerinantony1 (2008-10-10 03:18:08)

When i tried doing the first steps, this happened

class CreatePhotos < ActiveRecord::Migration  
   def self.up    
      create_table :photos do |t|      
         t.column :description, :string    
         t.column :content_type, :string 
         t.column :filename, :string 
         t.column :binary_data, :binary  
   end

C:\rails\rails_apps\home>rake db:migrate
(in C:/rails/rails_apps/home)
rake aborted!
./db/migrate//001_create_photos.rb:8: syntax error, unexpected $end, expecting k
END

(See full trace by running task with --trace)

i also tried putting another 'end' but it's another issue:

class CreatePhotos < ActiveRecord::Migration  
   def self.up    
      create_table :photos do |t|      
         t.column :description, :string    
         t.column :content_type, :string 
         t.column :filename, :string 
         t.column :binary_data, :binary  
   end
end


C:\rails\rails_apps\home>rake db:migrate
(in C:/rails/rails_apps/home)
rake aborted!
./db/migrate//001_create_photos.rb:9: syntax error, unexpected $end, expecting k
END

(See full trace by running task with --trace)

Please help me out, I'm stuck on this issue thanks.