sql 버전에 따른 쿼리 오류 ㅜㅜ 정보
sql 버전에 따른 쿼리 오류 ㅜㅜ
본문
"SELECT a.s_point, a.mb_id, {$g4['member_table']}.mb_nick
FROM (SELECT sum(po_point) as s_point, mb_id FROM `g4_point` WHERE po_datetime >= '{$선택기간}' GROUP BY mb_id ORDER BY s_point DESC)a
LEFT JOIN {$g4['member_table']} using(mb_id) WHERE {$g4['member_table']}.mb_datetime <= '{$회원가입얼마이후}' and {$g4['member_table']}.mb_id <> 'admin' LIMIT 0, {$랭킹명수}";
위 쿼리가 테스트 컴쪽에는 실행이 되는데, 다른 웹 계정에는 실행이 안되네요.
이런 에러가 뜨는데 어딜 수정해야 하나요?
g4_member.mb_nick FROM (SELECT sum(po_point) as s_point, mb_id FROM `g4_point` WHERE po_datetime >= '2011-02-25 00:00:00' GROUP BY mb_id ORDER BY s_point DESC)a LEFT JOIN g4_member using(mb_id) WHERE g4_member.mb_datetime <= '2011-02-02 00:00:00' and g4_member.mb_id <> 'admin' LIMIT 0, 10
1064 : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT sum(po_point) as s_point, mb_id FROM `g4_point` WHERE p
error file : /index.php
FROM (SELECT sum(po_point) as s_point, mb_id FROM `g4_point` WHERE po_datetime >= '{$선택기간}' GROUP BY mb_id ORDER BY s_point DESC)a
LEFT JOIN {$g4['member_table']} using(mb_id) WHERE {$g4['member_table']}.mb_datetime <= '{$회원가입얼마이후}' and {$g4['member_table']}.mb_id <> 'admin' LIMIT 0, {$랭킹명수}";
위 쿼리가 테스트 컴쪽에는 실행이 되는데, 다른 웹 계정에는 실행이 안되네요.
이런 에러가 뜨는데 어딜 수정해야 하나요?
g4_member.mb_nick FROM (SELECT sum(po_point) as s_point, mb_id FROM `g4_point` WHERE po_datetime >= '2011-02-25 00:00:00' GROUP BY mb_id ORDER BY s_point DESC)a LEFT JOIN g4_member using(mb_id) WHERE g4_member.mb_datetime <= '2011-02-02 00:00:00' and g4_member.mb_id <> 'admin' LIMIT 0, 10
1064 : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT sum(po_point) as s_point, mb_id FROM `g4_point` WHERE p
error file : /index.php
댓글 전체
둘다 MYSQL 버전을 올려보세요
4.1 이하 버전에서넌 서브쿼리 안될겁니다.
만약 4.0x나 3.x라면 join으로 변경해 보세요.
4.1 이하 버전에서넌 서브쿼리 안될겁니다.
만약 4.0x나 3.x라면 join으로 변경해 보세요.