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?
on 2006-03-21 19:53
on 2006-03-21 21:09
Suggestion to use file_column.. Sorry if you can't do this.. I'm pretty sure any DB expert will say you storing blobs in database must suck.
on 2006-03-21 21:13
I'm fighting the exact same issue right now myself - so very interested in seeing if someone comes back with an answer for it. I did find some old posts here in the mailing list that suggest that error has to do with some buggy mysql bindings in windows and pointed to this page http://wiki.rubyonrails.org/rails/pages/HowToUseMy... i installed the dll bu haven't gotten it to work yet. Was also going to try porting the code over to my linux webserver either tonight / tommorow to see if the problem does go away once it's off of XP.
on 2006-03-22 22:22
Update - looks like I was able to solve my issue by merely increasing the mysql max_allowed_packet parameter. hopefully that'll solve yours too -Eldon
on 2006-03-23 16:06
very cool - that worked... - Barinek