undefined 질문입니다 정보

undefined 질문입니다

• 껨보이 홈페이지 자기소개 아이디로 검색 회원게시물
• 2013.05.04 19:49:51
• 조회 867
• 댓글 4

• 이전 게시글
• 다음 게시글

• 목록

본문

1박2일님의 포인트쿠폰을 사용하는데요

http://sir.co.kr/bbs/board.php?bo_table=g4_skin&wr_id=87105&sca=&sfl=wr_subject%7C%7Cwr_content&stx=%ED%8F%AC%EC%9D%B8%ED%8A%B8%EC%BF%A0%ED%8F%B0


회원 검색은 잘되는데 검색 결과 클릭시 입력난에 undefined라고 출력됩니다.

조언부탁드려요(_ _)

( select a.* , ( select sum(co_count) as co_count from g4_qa_choose where mb_id=a.mb_id and bo_table = 'g4_qa' ) as q_co_count from `g4_write_g4_qa` a where wr_parent = '263547' and wr_8 != '' and wr_is_comment = 1 and CONVERT(wr_7, UNSIGNED) >= 5 group by wr_content having max(wr_7) order by CONVERT(wr_7, UNSIGNED) desc limit 3 )

1055 : Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'sir.a.wr_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

error file : /15sir/bbs/board.php