주소록 오류 문의 드립니다. (ㅠㅠ)
안녕하세요 쪽지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
|
댓글 작성
댓글을 작성하시려면 로그인이 필요합니다.
로그인하기
댓글 2개
4.x에서 해당 기능지원을 하기 위해서는 상당히 많은 부분을 다시 코딩해야 되어서 미뤄둔 겁니다.
답변 감사합니다