[BACK]

데이터베이스 오류 : 체험봉사 정보 리스트
[ERROR MESSAGE] The user specified as a definer ('root'@'%') does not exist
[QUERY] select a.uid, title, appcancnt, appscope, appstart, charge, content, appway_yubi, appway_field
	 		, file2name, file2path, file3name, file3path, file4name, file4path 
	 		, target_00, target_01, target_02, target_03, target_04, target_05, target_all 
	 		, locationcode, price 
	 		, insertdate, appcnt, appcancnt 
		    , fget_program_realstatus(a.uid) realstatus /* return realstatus : 접수중이 1건이라도 있으면 접수중 */ 
			, fget_plan_date(a.uid) plan_s_e
	  from program a 
	  join (select a.uid, 0 di, b.dporder, b.uid suid  
	 		   from program      a  
	 		   join display_item b on (b.buid = a.uid and b.loc = :p_loc ) 
	 		  where a.delyn      = '0' 
			    and a.tempsaveyn = '0' 
			    and a.viewyn     = '1' 
	           and a.adminviewyn = '1' 
	           and a.con_gubun = 'local' 
	and b.kind = :mainKind
			  union all
	select * from (
			 select a.uid, 1 di, 1000 dporder, a.uid suid
			   from program a
	 		  where a.delyn      = '0' 
			    and a.tempsaveyn = '0' 
			    and a.viewyn     = '1' 
	           and a.adminviewyn = '1' 
	           and a.con_gubun = 'local' 
	 		    and not exists (select 'x'  
	 						     from display_item aa   
	 						    where aa.buid = a.uid   
	 						      and aa.loc  = :p_loc   
	         and aa.kind = :mainKind
	 						   )  
	 order by di, dporder, suid desc limit 4 ) b 
	 order by di, dporder, suid desc 
			limit 4
		 ) b on (a.uid = b.uid)
	 order by di, dporder, suid desc 
	
[PARAMS] {isMobile=false, _DEVICE=WEB, _DEVICE_TYPE=WEB, mainKind=best, p_loc=main_bestprogram}

이용에 불편을 드려 죄송합니다.
지금 보신 오류에 대한 모든 내용은 개발자에게 자동 전달 되었으며 신속하게 수정될 수 있도록 노력하겠습니다