주소록 오류 문의 드립니다. (ㅠㅠ) 정보
주소록 오류 문의 드립니다. (ㅠㅠ)본문
안녕하세요 쪽지4로 업데이트 된 것을 확인하고 쪽지2 에서 쪽지4로 이번에
업데이트를 하였습니다.
주소록을 누르면 아래아 같이 오류가 나네요 (ㅠㅠ)
PHP ver 4.4.1
mysql ver : 3.23.57
select 'recv' as type, a.me_send_mb_id as mb_id, count(*) as cnt, b.mb_name, b.mb_nick, b.mb_email, b.mb_homepage from g4_memo_recv a left join g4_member b on a.me_send_mb_id = b.mb_id where a.me_recv_mb_id = 'admin' group by a.me_send_mb_id union all select 'send' as type, a.me_recv_mb_id as mb_id, count(*) as cnt, b.mb_name, b.mb_nick, b.mb_email, b.mb_homepage from g4_memo_send a left join g4_member b on a.me_recv_mb_id = b.mb_id where a.me_send_mb_id = 'admin' group by a.me_recv_mb_id union all select 'save_send' as type, a.me_recv_mb_id as mb_id, count(*) as cnt, b.mb_name, b.mb_nick, b.mb_email, b.mb_homepage from g4_memo_save a left join g4_member b on a.me_recv_mb_id = b.mb_id where a.memo_owner = 'admin' and memo_type='send' group by a.me_recv_mb_id union all select 'save_recv' as type, a.me_send_mb_id as mb_id, count(*) as cnt, b.mb_name, b.mb_nick, b.mb_email, b.mb_homepage from g4_memo_save a left join g4_member b on a.me_send_mb_id = b.mb_id where a.memo_owner = 'admin' and memo_type='recv' group by a.me_send_mb_id
1064 : You have an error in your SQL syntax near 'union all select 'send' as type, a.me_recv_mb_id as mb_id, count(*' at line 3
error file : /bbs/memo.php
업데이트를 하였습니다.
주소록을 누르면 아래아 같이 오류가 나네요 (ㅠㅠ)
PHP ver 4.4.1
mysql ver : 3.23.57
select 'recv' as type, a.me_send_mb_id as mb_id, count(*) as cnt, b.mb_name, b.mb_nick, b.mb_email, b.mb_homepage from g4_memo_recv a left join g4_member b on a.me_send_mb_id = b.mb_id where a.me_recv_mb_id = 'admin' group by a.me_send_mb_id union all select 'send' as type, a.me_recv_mb_id as mb_id, count(*) as cnt, b.mb_name, b.mb_nick, b.mb_email, b.mb_homepage from g4_memo_send a left join g4_member b on a.me_recv_mb_id = b.mb_id where a.me_send_mb_id = 'admin' group by a.me_recv_mb_id union all select 'save_send' as type, a.me_recv_mb_id as mb_id, count(*) as cnt, b.mb_name, b.mb_nick, b.mb_email, b.mb_homepage from g4_memo_save a left join g4_member b on a.me_recv_mb_id = b.mb_id where a.memo_owner = 'admin' and memo_type='send' group by a.me_recv_mb_id union all select 'save_recv' as type, a.me_send_mb_id as mb_id, count(*) as cnt, b.mb_name, b.mb_nick, b.mb_email, b.mb_homepage from g4_memo_save a left join g4_member b on a.me_send_mb_id = b.mb_id where a.memo_owner = 'admin' and memo_type='recv' group by a.me_send_mb_id
1064 : You have an error in your SQL syntax near 'union all select 'send' as type, a.me_recv_mb_id as mb_id, count(*' at line 3
error file : /bbs/memo.php
추천
0
0
댓글 전체
4.x에서는 union all이 지원되지 않기 때문에 해당 기능을 쓸 수 없습니다.
4.x에서 해당 기능지원을 하기 위해서는 상당히 많은 부분을 다시 코딩해야 되어서 미뤄둔 겁니다.
4.x에서 해당 기능지원을 하기 위해서는 상당히 많은 부분을 다시 코딩해야 되어서 미뤄둔 겁니다.
일단은 주석처리해서 막아놔야겠네요 ㅠㅠ
답변 감사합니다
답변 감사합니다