외부 mysql 서버를 이용할때 접속 불가 정보
외부 mysql 서버를 이용할때 접속 불가본문
해당 서버에 연결된 도메인으로만 접속이 됩니다.
IP로는 접속이 접속이 안되는군요..
해당 mysql 서버에서 접근권한은 '%' 로 되어있습니다.
달리, 무얼 확인해 봐야 할지 도움 주세요 ㅠㅠ
( 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_id = '227758' and wr_id != '2008' ) union ( 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 = '227730' 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