영카트 무통장입금 자동취소 왜 작동을 안 할까요? 채택완료
하호헤하
7개월 전
조회 1,966
무통장 입금 신청을 했는데 24시간 내로 입금을 안 할 시 자동으로 주문 취소가 되도록 하려고 합니다.
테스트로 10초 안에 입금 안 될 경우 취소되게 했습니다.
aws lightsail bitnami를 쓰고 있고 다음 코드와 크론을 사용했습니다.
</p>
<p><?php</p>
<p>include_once('../common.php');</p>
<p> </p>
<p>$sql = "SELECT * FROM g5_shop_order</p>
<p> WHERE od_status = '주문'</p>
<p> AND od_settle_case = '무통장'</p>
<p> AND od_time < NOW() - INTERVAL 10 SECOND";</p>
<p> </p>
<p>$result = sql_query($sql);</p>
<p> </p>
<p>sql_query("START TRANSACTION");</p>
<p> </p>
<p>try {</p>
<p> while ($row = sql_fetch_array($result)) {</p>
<p> $update_order = "UPDATE g5_shop_order</p>
<p> SET od_status = '취소'</p>
<p> WHERE od_id = '{$row['od_id']}'";</p>
<p> if (!sql_query($update_order)) {</p>
<p> throw new Exception('주문 테이블 업데이트 실패');</p>
<p> }</p>
<p> </p>
<p> $update_cart = "UPDATE g5_shop_cart</p>
<p> SET ct_status = '취소'</p>
<p> WHERE od_id = '{$row['od_id']}'";</p>
<p> if (!sql_query($update_cart)) {</p>
<p> throw new Exception('카트 테이블 업데이트 실패');</p>
<p> }</p>
<p> }</p>
<p> </p>
<p> sql_query("COMMIT");</p>
<p> </p>
<p>} catch (Exception $e) {</p>
<p> sql_query("ROLLBACK");</p>
<p> echo $e->getMessage();</p>
<p>}
* * * * * /opt/bitnami/php/bin/php /opt/bitnami/apache2/htdocs/cron/auto_cancel_order.php >> /opt/bitnami/apache2/logs/auto_cancel.log 2>&1
그런데 아래 오류 메세지가 뜨네요 ㅜㅜ
PHP Warning: Undefined array key "SERVER_PORT" in /opt/bitnami/apache/htdocs/common.php on
line 47
PHP Warning: Undefined array key "SERVER_NAME" in /opt/bitnami/apache/htdocs/common.php on
line 50
PHP Warning: Undefined array key "REQUEST_URI" in /opt/bitnami/apache/htdocs/common.php on
line 511
PHP Warning: Undefined array key "REMOTE_ADDR" in /opt/bitnami/apache/htdocs/bbs/visit_ins
ert.inc.php on line 5
PHP Warning: Undefined array key "SERVER_PORT" in /opt/bitnami/apache/htdocs/common.php on
line 47
PHP Warning: Undefined array key "SERVER_PORT" in /opt/bitnami/apache/htdocs/common.php on
line 47
PHP Warning: Undefined array key "SERVER_PORT" in /opt/bitnami/apache/htdocs/common.php on
line 47
PHP Warning: Undefined array key "SERVER_NAME" in /opt/bitnami/apache/htdocs/common.php on
line 50
PHP Warning: Undefined array key "REQUEST_URI" in /opt/bitnami/apache/htdocs/common.php on
line 511
PHP Warning: Undefined array key "REMOTE_ADDR" in /opt/bitnami/apache/htdocs/bbs/visit_ins
ert.inc.php on line 5
PHP Warning: Undefined array key "SERVER_PORT" in /opt/bitnami/apache/htdocs/common.php on
line 47
PHP Warning: Undefined array key "SERVER_PORT" in /opt/bitnami/apache/htdocs/common.php on
line 47
PHP Warning: Undefined array key "SERVER_PORT" in /opt/bitnami/apache/htdocs/common.php on
line 47
PHP Warning: Undefined array key "SERVER_NAME" in /opt/bitnami/apache/htdocs/common.php on
line 50
PHP Warning: Undefined array key "REQUEST_URI" in /opt/bitnami/apache/htdocs/common.php on
line 511
PHP Warning: Undefined array key "REMOTE_ADDR" in /opt/bitnami/apache/htdocs/bbs/visit_ins
ert.inc.php on line 5
PHP Warning: Undefined array key "SERVER_PORT" in /opt/bitnami/apache/htdocs/common.php on
line 47
PHP Warning: Undefined array key "SERVER_PORT" in /opt/bitnami/apache/htdocs/common.php on
line 47
PHP Warning: Undefined array key "SERVER_PORT" in /opt/bitnami/apache/htdocs/common.php on
line 47
PHP Warning: Undefined array key "SERVER_NAME" in /opt/bitnami/apache/htdocs/common.php on
line 50
PHP Warning: Undefined array key "REQUEST_URI" in /opt/bitnami/apache/htdocs/common.php on
line 511
PHP Warning: Undefined array key "REMOTE_ADDR" in /opt/bitnami/apache/htdocs/bbs/visit_ins
ert.inc.php on line 5
어떻게 해결을 해야할까요?ㅜㅜ
댓글을 작성하려면 로그인이 필요합니다.
답변 2개
답변을 작성하려면 로그인이 필요합니다.
로그인