Ather Shiraz
2008-May-29 05:58 UTC
Attempting to Insert File into DB But MYSQL "Goes away"
I am trying to upload a file to the DB but I am apparently unable to do so for the following reason : ActiveRecord::StatementInvalid in StoragesController#create Mysql::Error: MySQL server has gone away: INSERT INTO `storages` (`content_type`, `name`, `updated_at`, `created_at`, `data`) VALUES(''application/pdf'', ''Err'', ''2008-05-29 01:39:35'', ''2008-05-29 01:39:35'', x''255044462d312e340a25c7ec8fa20a352030206f626a0a.... If I try to upload a file like a pdf or word or excel document it does not upload. I do get to upload small text files. This is my view : <%= error_messages_for :storage %> <%= form_tag ({:action=>''create''}, :multipart=>true) %> <p> <label for="storage_name">Name</b><br /> <%= text_field ''storage'' ,''name'' %> </p> <label for="storage_data">File</b><br /> <%= file_field ''storage'' ,''data'' %> <%= submit_tag "Create" %> </p> <%= form_tag %> This is my controller def create @storage = Storage.new(params[:storage]) logger.debug(">>> storage #{@storage.name}") logger.debug(">>> storage #{@storage.data.content_type.chomp}") @storage.content_type = @storage.data.content_type.chomp @storage.data = @storage.data.read respond_to do |format| if @storage.save flash[:notice] = ''Storage was successfully created.'' format.html { redirect_to(@storage) } format.xml { render :xml => @storage, :status => :created, :location => @storage } else format.html { render :action => "new" } format.xml { render :xml => @storage.errors, :status => :unprocessable_entity } end end end Do tell me if I am doing anything wrong please. -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---