You''ll need to increase the max_allowed_packet size in your
initialization file. Here is what I changed mine to in my.ini:
max_allowed_packet=32M
The default is only 1M. I''m guessing this is a pretty common error in
this day and age of huge files, so it is unfortunate that the error
message really doesn''t give any indication of what the actual problem
is, and makes it much harder to track down that it needs to be. I
wasted hours trying to figure it out. Hopefully I saved you a few ;)
Brad
-----Original Message-----
From: rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
[mailto:rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org] On Behalf Of
Starni
Sent: Tuesday, August 22, 2006 9:20 AM
To: rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
Subject: [Rails] How to load the big picture
Do you know how i can load a big image in Mysql with rails?
I make a application like "Agile web application" book and with the
small image it''s all ok but with the heavy image Mysql give me this
error:
Mysql::Error: Lost connection to MySQL server during query: INSERT INTO
pictures (`content_type`, `name`, `comment`, `data`)
VALUES(''image/bmp'',
''1-1.bmp'', ''Speriamo2'',
x''424d26bc0a00000
Please help me. thx
--
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@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk
-~----------~----~----~----~------~----~------~--~---