search for: mediumblob

...ver. First, the included migration is an ugly hack def self.up create_table :super_images, :force => true do |t| t.column :data, :binary, :size => 10000000, :null => false t.column :created_at, :datetime end execute "ALTER TABLE `super_images` MODIFY `data` MEDIUMBLOB" end I just could not get the ruby definition for :data to create a MEDIUMBLOB on mysql. The size parameter seems to have been completely disregarded. The clomun sets up as BLOB with a size limit of 16K, which is far to small for most image uploading needs. Second, the "show_im...

I''m struggling with activerecord and mysql blobs (uploading files)... blobs over 400K-ish cause the below exception... ActiveRecord::StatementInvalid in File#upload Mysql::Error: Lost connection to MySQL server during query: I''ve tried blob, mediumblob, and longblob... I''m using windows xp for development - and have not installed the mysql gem... simlar google postings/solutions have not worked thoughts/suggestions? -- Posted via http://www.ruby-forum.com/.

Is there a way to specify not not use schema.rb but instead using a native sql file to clone structure to the test db? Schema.rb doesn''t really work that well for mediumblobs ... Thanks. -- Posted via http://www.ruby-forum.com/.

...:type => @photo.content_type, :file_name => @photo.filename, :disposition => ''inline'') end The images I''m saving are less than 100kb and easily handled by my mysql column of db_file.data which is declared MEDIUMBLOB. My problem is that the view works perfectly in production but not at all in development -- in development I just get a broken image graphic with a box and a red x. Any ideas on how to troubleshoot this? Since it doesn''t seem to be my code (it works fine in production) I''m at a...

I''m uploading files to a mysql database, using a mediumblob size. Following the wiki here: http://wiki.rubyonrails.org/rails/pages/HowtoUploadFiles , I got past the first mysql 500kb limitation with the max_allowed_packet = xM trick, setting it to 1000M. However, as the person at the very bottom of the wiki notes, I too cannot upload more than around 10mb....

...oad files (images) greater than 500KB. the largest file i could upload was 493KB and i''ve uploaded a bunch files under 490KB and they all worked. the smallest file which i failed to upload is 500KB so i guess that''s where the "limit" is. my data field in mysql is set to mediumblob, inevitably, i tried changing it to longblob which didn''t work. i''m running the webrick server. Any help would be greatly appreciated... thx -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you...