Simple File Upload to a Blob column in a SQLite DB

[Xenio]

I have a DB that is already populated with data. There is a table
called clubs that has an logo_big field set up as a blob. I have
successfully used send_data to display the jpg pictures as I need them
in the views. I just need to setup the edit/new view to enable me to
upload the files.

I tried paperclip but that requires changing the schema of the
database which is not really an option for me.

I am looking for a simple implementation to change the image file.

I have been hunting around the “to_blob” and “send_data” parameters
with no luck. Any help with this?

[Xenio]

On 9 August 2010 00:15, Xenio [email protected] wrote:

I am looking for a simple implementation to change the image file.
if params[:club][:logo_big] && params[:club][:logo_big].size > 0
format.xml { render :xml => @club.errors, :status
In my edit view I have:

My DB has a table called clubs with a BLOB field called logo_big

When I click update I get an error along the lines of: “private method
`gsub’ called for #Tempfile:0x7213138”

What am i doing wrong? Did I mess up the syntax of the form? I’m
working off the generated views that Rails provides.

The form looks fine, and your use of #read to get the file data looks
right as well.

What file/line are you getting the ‘private method called’ exception on?

Chris

[Xenio]

In my controller I have:

PUT /clubs/1

PUT /clubs/1.xml

def update
@club = Club.find(params[:id])

if params[:club][:logo_big] && params[:club][:logo_big].size > 0
@club.logo_big = params[:club][:logo_big].read
end

respond_to do |format|
  if @club.update_attributes(params[:club])
    flash[:notice] = 'Club was successfully updated.'
    format.html { redirect_to(@club) }
    format.xml  { head :ok }
  else
    format.html { render :action => "edit" }
    format.xml  { render :xml => @club.errors, :status

=> :unprocessable_entity }
end
end
end

def image
data = Club.find(params[:id]).data
send_data data, :disposition => ‘inline’
end

In my edit view I have:

<% form_for (@club, :html => { :multipart => true }) do |f| %>
<%= f.error_messages %>

<%= f.file_field :logo_big %>

<%= f.submit 'Update' %>

<% end %>

My DB has a table called clubs with a BLOB field called logo_big

When I click update I get an error along the lines of: “private method
`gsub’ called for #Tempfile:0x7213138”

What am i doing wrong? Did I mess up the syntax of the form? I’m
working off the generated views that Rails provides.

[Xenio]

Hey Chris,

I think I sent a reply to just you by mistake. Is there anyway you can
post it here? Apparently I do not get copies of messages sent to
author only in google groups.

[Xenio]

Xenio wrote:

I have a DB that is already populated with data. There is a table
called clubs that has an logo_big field set up as a blob. I have
successfully used send_data to display the jpg pictures as I need them
in the views. I just need to setup the edit/new view to enable me to
upload the files.

If you put your image files in the database, you are asking for trouble.
I realize that you’re working with a DB that already does this, but now
would be the time to remove the images from the database, put them in
the filesystem, and do further uploads to the filesystem.

I tried paperclip but that requires changing the schema of the
database which is not really an option for me.

Why not? You have a bad schema in that it is trying to store binary
data that doesn’t really belong there. Change the schema.

Best,

Marnen Laibow-Koser
http://www.marnen.org
[email protected]

[Xenio]

On 10 August 2010 13:18, Xenio [email protected] wrote:

Hey Chris,

I think I sent a reply to just you by mistake. Is there anyway you can
post it here? Apparently I do not get copies of messages sent to
author only in google groups.

It will be in your Sent Items or whatever it is called in your mailer.
Just go there and forward it to the list.

Colin

[Xenio]

So I changed my implentatio so that its set up as so:

The edit view:

<% form_for(@club, :html=>{:multipart=>true}) do |f| %>
<%= f.error_messages %>

<%= f.file_field :logo_bigg %>

<%= f.label :phone %>
<%= f.text_field :phone %>

<%= f.label :shortdesc %>
<%= f.text_area :shortdesc %>

<%= f.submit 'Create' %>

<% end %>

The clubs_controller:

def update
@club = Club.find(params[:id])

#if params[:club][:logo_big] && params[:club][:logo_big].size > 0

@club.logo_big = params[:club][:logo_big].read

end

@club.save

respond_to do |format|
  if @club.update_attributes(params[:club])
    flash[:notice] = 'Club was successfully updated.'
    format.html { redirect_to(@club) }
    format.xml  { head :ok }
  else
    format.html { render :action => "edit" }
    format.xml  { render :xml => @club.errors, :status

=> :unprocessable_entity }
end
end
end

def image
data = Club.find(params[:id]).data
send_data data, :disposition => ‘inline’
end

The club model:

class Club < ActiveRecord::Base
include Magick
belongs_to :admin
set_primary_key “club_id”

def logo_bigg=(input_data)

self.filename = input_data.original_filename

self.content_type = input_data.content_type.chomp

self.logo_big = input_data.read

end

def self.find_clubs
find(:all, :order => “name”, :limit => 10)
end

def self.find_clubs2
find(:all, :order => “name”, :limit => 5)

end

end

The issue is that it works but my rails app freezes for like 30
seconds and I get a loud beeping from my console. When its done all I
see if what looks like binary string data for the logging of the last
few events.

[Xenio]

I removed my previous posts to keep this simple. I have an
implementation as so:

club Model

class Club < ActiveRecord::Base

include Magick

set_primary_key “club_id”

def logo_bigg=(input_data)
self.filename = input_data.original_filename
self.content_type = input_data.content_type.chomp
self.logo_big = input_data.read
end

def self.find_clubs
find(:all, :order => “name”, :limit => 10)
end

def self.find_clubs2
find(:all, :order => “name”, :limit => 5)

end
end

clubs Controller:

def updateIMG
@club = Club.find(params[:id])

 if params[:club][:logo_big] && params[:club][:logo_big].size > 0
  @club.data = params[:club][:logo_big].read

end
@club.save

if @club.update_attributes(params[:club])
redirect_to :action => ‘index’
else
render :action => ‘edit’
end
end

edit club View:
<% form_for @club, :url => { :action =>
‘updateIMG’, :id=>@club}, :html=>{:multipart=>true} do |f| %>

<%= f.error_messages %>

<%= image_tag url_for(:controller => "clubs", :action => "show_pic_big", :id => @club.club_id) %>

<%= f.file_field :logo_bigg %>

<%= f.submit 'Update' %>

<% end %>

This spits out an output that i will show in the following post from
my development log.

[Xenio]

I’m thinking maybe I should treat it as a separate form for just the
picture upload. I think the problems could be when it tries to pass
all those variables at once once I hit submit on the form.

[Xenio]

Processing ClubsController#edit (for 127.0.0.1 at 2010-08-15 20:44:40)
[GET]
Parameters: {“id”=>“22”}
[4;36;1mClub Load (1.0ms) [0m [0;1mSELECT * FROM “clubs” WHERE
(“clubs”.“club_id” = 22) [0m
Rendering template within layouts/clubs
Rendering clubs/edit
Completed in 39ms (View: 29, DB: 1) | 200 OK [http://localhost/clubs/
22/edit]

Processing ClubsController#show_pic_big (for 127.0.0.1 at 2010-08-15
20:44:40) [GET]
Parameters: {“id”=>“22”}
[4;35;1mClub Load (2.0ms) [0m [0mSELECT * FROM “clubs” WHERE
(“clubs”.“club_id” = 22) [0m
Sending data
Completed in 91ms (View: 1, DB: 2) | 200 OK [http://localhost/clubs/
show_pic_big/22]

Processing ClubsController#updateIMG (for 127.0.0.1 at 2010-08-15
20:48:23) [PUT]
Parameters: {“club”=>{“logo_bigg”=>#<File:C:/Users/senyo/AppData/
Local/Temp/RackMultipart20100815-4960-1x37k4w-0>}, “commit”=>“Update”,
“authenticity_token”=>“4gPTrOS2HddOSXM2xqyDKTchGRhQwMeHH2cv/sqFCVw=”,
“id”=>“22”}
[4;36;1mClub Load (1.0ms) [0m [0;1mSELECT * FROM “clubs” WHERE
(“clubs”.“club_id” = 22) [0m
[4;35;1mClub Update (1.0ms) [0m [0mUPDATE “clubs” SET “logo_big”
= '‰PNG

%00%00%00
IHDR%00%00 ,%00%00 , %00%00%00y}Žu%00%00%00 sBIT | dˆ%00%00%00 pHYs
%00%00!›%00%00!› _4½
%00%00%00 tEXtSoftware%00www.inkscape.orgݔ< %00%00
%00IDATxœíÝwX ×Þ ðï²€,–«Òm E£b V:¨¨i £Qß
$7Ý› yM4Í”›bLÞÄhÚ5Åhš17±§˜ØÀÞo, AE £RTH A …÷ À«È»³»sff¿ŸçÉc gçœ
_gÎœ9ÇTUU µ„‡†y%00è  #€ %00­êùÕ¢ZADÔ R%00¹5ÿ ªók&€ ™ÙYVµŠ1¹:°ÂCÃ|%00
p €a%00 ]Ú! ©é€ , °&3;«Ô• ¹$°ÂCÚ ‰ê
À×é ‘Ö”%00X êðZš™ uÞÙ 85°ÂCü%00< à %25%00 Nk˜ˆôæ4€W |’™ Uî¬F Xá¡a£ Ì
%00 î” ‰È 2 LËÌÎZäŒÆ ¬ðаD%00o¡z0 ˆ¨>; < ™ µÁ‘F Vxh˜7€9%00 r¤%00"r+ó
%00LÈÌÎ*Sr²¢À

° @¬’N‰È­m 023;«ÀÞ í ¬ðа %00¬%00ÐÎÞΈˆj p[fvÖ^{Nò°çÃá¡aw : VDäˆv
%00¶ÔdŠÍl ¬ðа©%00¾ çT ‘sø ø¾&[lbÓ-aM
~ À¤¼6"¢zU “™ µ¸¡ 6 X5cV[À++"r %00±
iÉ VÍÓÀ]à ˜ ¹Þq%00}åž JŽaÕ̳Z
†©£ €¥5ÙS/¹A÷9à <+"RW,ª³§^õÞ Ö¼n³Þu5 ÉJªï5 ©+¬·\ ‘œz3èšÀªYu /
2 ‘Hýj²èWÝ Ö¬gu "†ˆÄË ÐõÊõ´ê^a= †iC8ª3é²ËWX5Ë W
%25"í8
 CírËW^a ʈ´%25%00ÕÙ à êÀ ¡~-DD
ºœM¦ªª„‡†YP½] ß $"­) à Ÿ™ UZ{…5 +"Ã’&TgÔå[BÞ ‘– %00%00S‡ëBÍ%00ò%00ø‹­ ‡ˆHÃ’ %00Á %00úƒaEDÚæ  ¿ 8Q”ˆô!Ãœ @ˆè*ˆˆl ÂÀ""½ ñ%00ÐJt DD6hÃ…+,"Ã’ ^a ‘n𠋈t#Ä €Et DD6°Ø¼U= ‘h,“Ã’ é ‹ˆtÆ’ EDºÁÀ”"Ý`` ‘n0°ˆH7 XD¤ ,"Ã’ OÑ h•—— pñâE ¡v‡lú¯¨èh<ÿÒ‹ŠÏÿaùrÌýäS’‘V¤_ 7F«Ö­ „ÀÀ@””” ?? ùyyÈËËCee¥è 5 U£K×® <d0 Ѷ];´lÙ &“ %00P^^Žüü| HOǺ5k‘šš‚¢Â"Á ‹×
´iStéÒEñù;¶mwb5úÓ¶]; : Ƀ“Ñ«wo˜Íæz?wöìY¤¬]‹µk×bÓ†(+
+S¹RípëÀ2™L¸åÖ[ñÄ”)¸.ô:ÉÏyyy¡M›6hÓ¦
†Þx#¬V+Ö¬Z ™o¿…ì¬lõ
&C
Æä’‘ŸÀÈQ£$CêJ~~~ =v,F ‹“’'Obö;ïà ‡å+ÜòªËmÇ°zö쉥+Và Ý Þ—
«ú˜ÍfÃœxóMøuÍ üó•Wñå ´d›q ÿ ëÖ§bô˜16…U]­[·ÆÌY³°âçŸÐ! Üýö qËÀ 1òv|»è{tïÑÝ¡v<==qÏ}÷âûÅ‹ ÂeÅHš··7fΚ…g§Mƒ ÃíuéÒ K–/ CbR’ãÅéˆÛ Ö S¦æ¬YðöövZ›]ºvŲ @D·nNk“Œ£Q£Føê›o0bäíNm·I“&øtÞg¸}
ÔH§¶«en Xwßs &NzÌ%25mûûûcîüy
vIû¤_o¾ý úôíã’¶Íf3f¼ù&úöëë’öµÆm +&6 /ýóŸ.í#00 ŸÌý q¥j NœˆaÇ»´ ///
Ìùø ´nÝÚ¥ýh [ –ÅbÁÌÙ³ö´ Ó^ݺwÇc ?îò~HûÚ¶k‡Ç''ÿ¯*}µh٠Ͻð¼*} ‰ä uÿƒ "00Pµþî{à ~Þ ¦<5 ^^^ªõwãM7á†ÈHÕú Áð Õ¼ys<òèxUûôññÁÿNž¬jŸ¤- ;wÆ- ·Þªz¿ON ¢zŸj2|
½éF4iÒDõ~‡Ý6 5R½_Ò†›o½åò› jŠŠŽ†ŸŸŸêýªÅð •<x° ~- bãb…ôMâ%25 "¤
LN Ò· X ‹ 1±âBcP²˜°$±BBBÐéúNÂú 0p€°¾]ÍÐ &ô¶¬s—ÎÂú&qÚ´m+´ÿv×Ù÷ª™ž :
°‚ ?©
â“Bw¤æ éú íß• XAÁbÿâ à áaè?bª[email protected]€Ðþ[´l¡êt 5 ú§IôS:³§YÑ ù¤oe—Ä®We­°Âjµ ­ÁU XùyùBû/*,Byy¹Ð H} Bû?}ú´a×Ê2tååå‰í?lÿ$ÆéÓ§…öŸoà ï;C Öñœ ¡k±çdg
ë›Ä9vô(***„õŸñ{†°¾]ÍÐ UXXˆ´ýiÂúß º^Xß$Îùóç±sÇ aý¯[»FXß®fèÀ
€µkÄüåUVV"eÝ:!}“x¢¾ïJKK±eó !}«Áð õëÊ•B ·oÛ†³gϪÞ/iÃÊŸ~FiI‰êýþ¸â
\ºtIõ~ÕbøÀ:vì –/[¦z¿³f¾£zŸ¤ gÎœÁÜOçªÚgii)Þ =[Õ>ÕføÀ €Ù3ßQõ _ ù {÷ìQ­?
Ò¦Ïæ~Š3gΨÖßçóæ¡ _ìT Ws‹ÀÊÍÍÅ;oÏT¥¯¢Â"¼1ýuUú"m
+¹P‚)“’‘ÃZáúIœûöîÅ¿>øÐåýˆæ %00ó?ûK /vi ååå˜0þ Å“<yÃ’
¥ý ~lÙ¼ ¯½úªKûÈËÍÃø <l豫Zn X%00ðÂsÓ°mëV—´mµZ1íÙg±kç.—´Oúµà «¯ðáû ¸
¤íü¼<<ôÀýÂ’‘«ªÅ­ «¼¼ Ãœ{ }÷ SÛ-…Æà ò%25K Ú. Ç»³faÊä’‘PVæ¼÷
÷ïÛ ۇ߆C ‡œÖ¦Ö¹U@EE ž{æY¼öÊ+Ny윑‘ Q#ndžõë /ŽmÅòå {Ç Ø·w¯Cí\ºt Ÿ}: wŽ #ü½Eµ¹]Õúòó/001 ß.\¨hP477 OO™Šá7ß‚£™™.¨ Å’(m F ¸ “&N´ûû¦¼¼ K /
FrÒ%00¼9c†[ŒYÕå)º%00‘NŸ> §= ÿ5 C†Eò ÁèÓ§¯äþ…………HMIÁÚÕk°qà ·ü†!
çøåç•øåç•èØ© %25’’#1) ­Z·[email protected]@%00¼½½ %00 þù’‘N à à ƒX³f56m؈ . ®
,· ¬Z’'OžÄçóçãóùóañõEHp0 áïï K—.átA

ŸŸoØe;HŒ#‡ ãÈáÃøxΜ˿׬Y3”––ri¢z0°ê(-)Á±cÇpìØ1Ñ¥ ›:wîœè 4ËmÇ°ˆH y…
eñõE%00|} ‹+¢ª çÏŸG~~>/í ÂÛÛ mÛµCPP ‚‚ƒ Œ&M¯Ø¤·fíµ+×`»úÿqÍïK} h¨­Úã׶yÕÿ_ñ{¥ K‘ŸŸ ü¼| äç £  @wß›º ¬¦M›"iÀ%00 2 »vA ž¥TUU¡°° ùyy8 žŽ”u)ؼy³ 7ùÉ~ ûÛß 4°úû
+11 Ñ%259 µÂŠíÛ·ãו+±zÕ]¬.¢ÛÀêÛ¯/ 8 1±±ðôÔî—a2™à çç ???t ˆÀè
±cQVV†m[·âËÏ¿ÀÆ
D—HõhÕª žœ: Æ—|j¬wfO3bãb ‹W¦¿†;và ½Ù³5ý¶†v Ò%25\ßùzL}úi
8Pt)Šy{{#1) ‰IIØ·o >|ï}¤¦¤ˆ.‹Pý„nü„ ¸ï û…ﺤ& DEG#: ?
ýø#þoÆ ÈÍÍ ]Ö5t3èn2™ðØã“ðãÊ•º «ºzö쉹óçáË $xãWw׳gOüºv
ÿˆ[…U]· †Õ)ëpïý÷‰.å º ¬æ-Zà ³Ïçcò“O vcÒظXüüë/¸ñæ›D—â–n¹õV,üþ;á»6k…
ÅbÁK/¿Œi/< “É$ºœË4ÿÓß´iS|·è{$&%25‰.Ååš7oŽ çÌÁ S¦ˆ.Å­Lxì1¼÷á n}U
%25åÁqã0ë½w5³“´¦ Ël6ã½ [email protected]‡ðpÑ¥¨jâ¤Ç0qÃ’c¢Ëp
#G “Sù „œaÇã ,½¬éÀzvÚsHHL ]†OL™‚q ÿCt †Ö³gOL c†è2táæ[oÁý > º
í Öè1cðÀC ‰.C¨g§MÃ=÷Ý+ºCò÷÷ÇœO>¾ü¢15ìÙiÓ Ù«—Ð 4 X}
úöÁ«¯O ]†&¼ôòË =v¬è2ç‰)SøTÖNžžžxÿ ÂÇÇGX
š¬—^~Y3ƒ|¢™L&¼òÚ«hݺµèR£}ûö¸cÌhÑeèRHH î¼ë.aýk.°ââãÑ5"Bt šâíí ''Ÿš*º
Ãxò©©0› 9{]
?:^ØU–æ kü„GE— IÃo»
ݺ‰.C÷:„‡ãÆ›8×Í Â®²4 X={öDTt´è24Éd2áÙiω.C÷†º C {çÿ éWS uï ÷‹.AÓ
¢cbлO ÑeèZò Á¢K0„ðŽ …Œ«j&°ÌžfC½#èC†]‚n ¢G ¢Ë0Œ
¤ TïS3 Õ¯ 4kÖLt š7(™W Jõ ŠÒÔ{qz—èÎ 50y è t!4, íÛ· ]†.
‰.ÁP:]ßIõ>5 XÉÉÉ¢KÐ AƒùgÂ¥ Wbp. ÕûÔDuìÔ mÛµ ]†nð¶P ÿ€%00Ñ %25 Šš6mªjŸš ¬A¼º²Kd¯H´hÙBt ºãç§þ Ñ©}•¥‰%25’“y‹c ³ÙŒ bé’%25¢KÑ // û¿Ý‹‹‹ëìfó_f 3| ëgSŠÊÊJÙ £ 5jd÷Ëà > ‹£eÙExùùù¡GÏžvŸ—‘‘ …_/¨÷Xï¾}pÛˆ Ž–
æ4 À¿ ~[ï1 ‹ Ó^xÞî6 & b© !&VrcÓ "#±xÙR•+RîÔ©SHŠ‹— <þÔ3Ïà ‘GÇ«X‘ý„ ÖÀAƒ -{¼|éR,üæ›z uï©­¹6þþþ’µ Àè1£Ñ±“}O\ áíí ²²2GË#Ò ácXJŸx¥®“Þe&!!Ai9. „Î ;K O‘ùZ¤ø6öåkLäv„ V£F g÷y9Ù98zôh½Ç:]ßI“ë %25$I¯œšš²NQ›œÞ@îFhÅÄÆ¢Ð.Eæ <>A›K*Ë-õ¼ç·=ø³¨Èî6 b‘{ XJ§3ÈÝ Ækìv°Vï>}$Ÿ(Y­VlP° tpH0× #·",°L&“¢×qŠ‹‹±sÇŽz ùøø o¿¾Ž–
æ ^^^ˆŽ‰‘<ž²VÙm!§„ ; XÝ{tWôªÄ¦
QQQQï±~ýûkzo9¹ÛÂM 7ÂZaµ»MNº%25w",°”¾^²nÝZÉcZß ,Q¦¾sçÎa÷î]v· Ñ­›& 2 IL
€Õ a ¥äv°²² Ö¯—< Ÿ¨Íñ«ZmÚ¶EXX˜äq%25Ó %00Ð ®tAîAHµnÝ ]ºt±û¼½{ö ¨°þ§i­
ZµB‡ -Íåd§7¬ãô "9B KéÚWr ÓZ¿ºª%25wÛzìØ1ädçØÝftLŒ®Þi#RJH) ¿’Ÿ ¥ ÀjèÁ €Ü×(ÅÛÛ ññúøú‰ ¡z5iÃ’ ý£úÛ}Þ‰ ‘‘pøÐáz ™ÍfE3æE°X,²S/”Noà Š­
ä T ¬øÄ E»:ËM ½!2Rõ…Ä !w[¸kçN ÛÝæ€ ½DN¤’‘ª ‡’’+½ ” ÖËí-¹Àª¨¨À¦ ín³eË–ˆìÕË‘²ˆ4OÕÀ2›ÍH d÷y%25 J°cûvÉãz p¯ Þ±#BBB$ + Ç 8‰”äI- D¨''ª V¯Þ½Ñ¼ys»ÏÛ¼y“äºOÍ[´@÷îÝ -MurÓ Ö§¦¢²²Òî6 q ‹NÕÀRúÞ›ÜøU\\Å“.Çnän ‹ ‹°oï^»Ûì ŽëB¯s¤,"MSõ'']Ét†ªª*¤¦È¬Î ³ÛÁZ±qq0{Å¡%25 ¯Sø ´ ;ê ‘© X :[email protected]¨Ýçíß¿ gÎœ‘< /½Fµ–5iÃ’ ½d É•.êÇÕ ÈÈT ,Ã¥K! Kÿà ^ßùz éw7_¹ÛÂC ‡pêÔ)»Ûìݧ ¢qB"=P-° *\ SîÖHoÓ êjhu %25ï šÍf$& %25)¬ˆHÛT ¬ -[ Woûç ååæá÷ƒ %25 k}9™†t ˆ€ŸŸŸäqÅ«7pz ”* 5€²YØ©©Ò?° ‹ }
újsuQ[â„¢L&Ù‡ Û·mCii©Ýí&$%25ÂÓSø nDN§J) ¿’{¯® T”Ý»Ôj‘ÜUâ¥K—°uó »ÛlÒ¤ ¢¢ £ )‹ˆ Gm t%25 ‹ /bÛÖ­’Çõ>~U+>>AöêSn…U9Jlj´Ìå ­h­¦­[¶ââÅ‹’Çõ:ÿª® - [ [÷n’Çק¤*ú—‘‹ú‘ ¹<° ß Ê\Y´iÓ íÛ·WZ’æÈ]- à @zºÝm¶nÝZv·i"=r})¼5IMI•<f”ÛÁZ
=íTü´ WYd0.
¬ˆnÝ bÿŽ. ÒÓ‘Ÿ—’'yÃœ(·ƒµnˆŒD³fÍ$ +ÞÊž¯é Á¸4°”® wEaö4#&6ViIÅ¡d6› '‘ý5¥§
¥£  Àîv•îýH¤U. ,¥·ƒÒW ‘‘‘hÒ¤‰Ò’4KnϪª¬—¹E–b2â„¢0Ð@GÊ"Ò — VpH0"ºI? ý’rúôi¤íO“< Ÿ ïÙíR Çâm!9Æ%00Ó°\ XJ Ûק ¤È>Æ×ûë8R‚‚ƒÑéúN’Ç·lÙ"¹ˆ¡œ˜Ø X, GJ#Ò— –â½ eƯZ ´l ˆn JKÒ<¹0.-)ÁömÛìnÓÇÇGv|ŒHO\ X¾ } c÷yeeeؼy³äñ¸¸x]®.j +WMoHæËÐd .ùé OPôžßömÛPZR"Ý®Á¦3ÔÕ·_?X|¥ß Pº•ý€Aƒ2™”–E¤ . ¬¾ýú):¯¡+ˆ8 ®.j+///D˼´|òäI Ê8dw»þþþ s
¤4"MpIµiÛFÑyrW ]ºtq‹9E .ê§p iH+émňôÂ%25 ÕªU+»Ï9”q ''Ož”<nôÛÁZ® Ç ±ÿï„Hk\ Xr«hJ‘{Ù 0ÞûƒRÚ]w ìV]{÷ìAQa‘Ýí¶hÙ‘²È%00¸ – „ô4ûW X³zµä1‹¯¯îW µ‡ÜUVee%25Ö®‘þ³’²w ýû i K kóæMv}~Ëæ-Ø¿o¿äñ¨¨(xyy9Z– n4t[øñG ÁZaµ¹½ââbìùí7GË" Î%25 µfõjœ;wÎæÏÏzûmÙãîr;X+ª åŸs²s °tÉb›Û[±l ***œQ ‘P. ¬¼Ü<Lžô8*++ üì¿ ~‹}ûöÉ~ƨ¯ãH±å øýwß“]‚§Ö¾} ûðúkÓ U ‘P.›6¾qà L}âIÉeQ*++ñ o¼ ¦M“m§MÛ¶ŠvŒÖ»†B:77 ·ß6 éiÒ/Šo߶ ¯è D"-ré^P?¬X 5«Wãî{þŽ nˆD›¶mpñâ%25lݲ k׬ÁÁ l#ÁÍn k%25$&âÍ 3d? S Ÿ ÿ = £î¸ ‰IIˆìÕ ……gqüøq,úî{¬^µJ¥j‰ÔáòÍëJKKñÙ§s Ÿï.ó¯êêt}'' ‡ #/ Wþ¶ïâÅ‹øfÁ |³ J•éWy¹ýãxÃ¥n4ö§dÅ“Sí±QM¿Ilö4+z‰Ú(Œºö—(99Ùv}¾ ?
_öÝV½©‚ü<‹99öµWU… üáHIvÓtõêÕÛ «‹ÚJn R²ß‘Çíú| FF†‹*ѦÌ#GìúüÉ '' íLî M V‚›Þ ÖŠ‰‹… Ùl ]†aü~ð ]ŸW²½šž É< «Õöù}" ]Ó ånó¯êjÖ¬ nˆŒ ]†aìÞµ Ö¯·é³ áóyó][ Æ”\ (Á ómûš­V+þõÁ .®èZš ¬–-[*Z ÞhÜm š«½8íy”\hx\ê ×g °°P…Š´åÝY³qâĉ ?÷Åüù²{/¸Šf +.>ž‹Î ål§N ÂØÑ £%25× ;wî žž2 K Ûþ& ‘”––⾿ÿ »wí®÷¸ÕjÅÇ }„™oÉ¿ â*.ŸÖ P«uëÞ -[¶tË í]å÷ƒ 1bØ0Œ¼c ºwï ðŽ ‘——‹ß ÄòeËmzƒÀ™***0iÂDÉãñ‰ ¸ëî»U«''''; w ‹‘£F!:& Ý"ð×_ !=- ?,_Þà ›)®¤ÉÀ2™LˆK0öꢶ2™LˆOHÀŠåËE— b(åååøîÛ ã»oÿ-º TVVÊ®V  b5Õ*++±xÑ",^´Hõ¾åhò–°s—.ð÷÷ ]†fðj“¨š& Ëݧ3Ô — Àñ<r ðs wŸÎP—ŸŸ ºF w?F"[i.°| û¢wŸ>¢ËÐ Þ i0°¢¢£ÝjuQ[1°ˆ4 XLCzõê… ¦M›Š.ƒH(Í W(¨ŸÙÓŒ˜ØXÑe ¥©ÀjÛ® ì W…äî4 X¼ ”— ÄÀ"÷¦­Àâ „¬ „wì(º Ò)ÎÃr"OOODÅD‹.Có êäÎ4 X½z÷FãÆ E—¡y,rgš ,¾Žc›~ýûÁb±ˆ.ƒH Í _DZ ··7úGE ‰.ƒH M ß•³ o É]i"°¸ } Xä®4 X œÝn—аP´m×Nt Dª ¾â¨ÖV =yò¤ä±Æ £yóæ*V#-! 1 ß|ýµè2HO0 Kx™Íf<>ñ1§µçåå…/¾þJñù‰±q’Çîºûn¼úútEíþúË/øúKÃ¥uÕ•Ÿ¯îºãDZ <
°*°cûv§µ×¨Q#§µåLy¹yNý:‰Ü‘&Æ°ˆˆlÁÀ""Ý‘n0°ˆH7 XD¤ ,"7Áõ °ˆˆTÄÀ""Ý ‘n0°ˆH7 XD¤ ,“Ã’
é ‹ˆtÆ’ Eä&8q”ˆHE,“Ã’
é ‹ˆtÆ’ EDºÁÀ”“Ý‘n0°ˆÜ„ ¦a1°ˆH? XD¤ ,"Ò é ‹ˆtƒ EDºÁÀ""Ý ¹ ®‡ED¤” é ‹ˆtÆ’ EDºÁÀ”"Ý‘n0°ˆH7 XDn¢ œ‡ED¤ é ‹ˆtƒ EDºÁÀ""Ý ‘n0°ˆH7 XD¤ ,“7Á üˆˆTÄÀ”"Ý‘n0°ˆH7 XD¤ ,"Ò ‘BΚ&ÐP;N›ŽÀi DîëÄ 8¥ ã99òÇ Ë ·UN ýè á «ÂZ ÊÊJeçVT4ضR••VÅç’6 ={ ùyy ·“––&{<=-Ýá> %00 }¿|?z`¸À²VX ÿKrøÐ!ÙãÇŽ UÔ.%00 ;vLñ¹ ¤] t¸ ô 믿þÂ Ç ;ÞO: K“ 8 è¼ éòÿ’ 8pPñÕ›ÒšHÛ6¤¦:t~EE 6oÜÔà çRÖ ¥8ÔOQa öîÙëP Z`ÈÀj(x¤ìß·_öxiI ŽffÚÝ®µÂŠC òWo¤Oß.\ˆÝ»v +>ÿ½ÙïÚtõýÎÌ· 3{éÅ P\\¬ø|­0d`-\ð ݗЙGŽ`ÙÒ¥ ~nö;³ì®ç£9spéÒ%25»Ï#í«¬¬Ä3OMEii©Ýçîݳ Ÿ~ü±MŸ-¹P‚§¦LQt…¿ò§ŸñËÏ+í>O‹ XÅÅŘ<éñ Ñk•••aò¤ÇqñâÅ ?»zÕ*|³` ͵ìùí7|ðþ{6 žô''''; “&LÄÙ³gm>ç?»wãñ ‰ ÁjµýaÌ® »ðÜÓÏà Â… 6Ÿ“²v ^|þy›?¯u†,%00Ø·o ~h\ƒWZÙYÙ ÷ÀƒÈÈÈ °¹í ¯MǼ¹s ÄU¿þŠ‰ N€µ‚O n}j*n < «W­’ý\YY Þœ1 wŽ ‹S§NÙÝÏ’Å‹qËÐ ±cûvÙÏ]¸p Ï=ý 7 ýõ—Ýýh•©Ãu¡úŸM&£Q£FxpÜ8$$&¢c§ŽhÞ¼9Š‹päÈa¬OMÅçó棼¼\QÛíÛ·Çø‰ Ñ í;´‡ÙlÆñœã8t( _}ñeƒßTz7xÈ |ôé''ŠÏÿbþç˜þê«N¬H úöë‡È^‘èÞ½ "ºEà üùóHÛŸ†´´ýزy‹Sæo™L&ÄÆÅ¡ç =ѽG téÚ § ž–†´ýiØ´i òó ðÕh‹á «®Æ ÛuIm+³§ žfO· «jÓ¦ ŸŸ‘‘ ßþó ''VDFçv EDúeØ1,"2 é ‹ˆtƒ EDºÁÀ""Ý ‘n0°ˆH7 XD¤ ,“Ã’
é ‹ˆtÆ’ EDºÁÀ”"Ý`` ‘n0°ˆH7<%004¼ 9 ‘x =%00䊮‚ˆÈ ¹,“Ò‹\ %00öoÝAD
¤¾S¼Â”"½à é ¯°ˆH7r=%00 ] ‘
Žz%00Ø à ¬èJˆˆdœ °Í#3;Ë
à ‘‘ÑÕ Éø)3;ËZûjÃŽ
¡¥ É[ ü÷]ÂU%00JÅÕBD$© Õ U X™ÙY%25%00Öˆ¬ˆˆHššŒºjµ†å‚Š!“’s9›®¬
%25à ÓB” —ˆ’’%00%00 !IDATÒ–³¨Î&%00W VfvÖ9%00ÓETDD$azM6 ¸v ¿9%00²Ô­
‡ˆ¨^Y¨Î¤Ë®
¬Ìì¬2%00/¨Y ‘„ j2é²ú–Hþ ÀoêÔCDT¯ßP EW¹&°2³³ª%00<£FEDD ž©É¢«Ô» EfvÖZ
%00_»¼$"¢k}]“A× Û5ça%00;]S Q½v¢:{êeªªºæªë²ðа %00» ´r~]DDW9  Ofv–ä }
²û Öœ8 Ü
Œˆ\ë"€ ra Ø°‘jfvÖ.%00 9«"¢z<T“5²lÚù93;k!8?‹ˆ\ã…šŒi ì V]á¡aw ˜ À¢°0"¢Z
¥¨¾²ºf¾• » %00ÂCÃz£úíé6öÕFDtÙ T YýÇž“lº%25¼RM }Q½ < ‘½¶ èkoX
%002³³ò%00$ ˜¯ä|"r[ó $ÕdˆÝì¾%25¬+<4, À[%00ú9Ô ÙN%00Ogfgmp¤ ‡ «VxhØh
%003%00„;¥A"2‚L%00Ó2³³ 9£1§ %00„‡†y x ÀK%00 œÖ0 éÍi%00¯ ø$3;«ÜY :5°j…
‡†5 0 Àm%00†ðuz’‘D¤5%25%00V£z ÁÒÌì¬óÎîÀ%25 u¥ðÐ0 %00Æ’Q ^Ã%00 º´C"RÓ
%00?¢:¤Ödfg¹t»@— Ö•ÂCÃ<P=8ß @ ª_ª®û+’‘Â¥ iG)€ÜšÿNÕù5 ÀŽšÝãUñÿýæ¯Ùƒ¦Ž€
%00%00%00%00IEND®B`‚’, “content_type” = ‘image/png’, “filename” =
‘120657211921503826.png’ WHERE “club_id” = 22 [0m
Redirected to http://localhost:3000/clubs
Completed in 131ms (DB: 2) | 302 Found [http://localhost/clubs/
updateIMG/22]