영카트 무통장입금 자동취소 왜 작동을 안 할까요?

2025.04.12 06:35:34 조회 287 (112.♡.♡.143)

본문

무통장 입금 신청을 했는데 24시간 내로 입금을 안 할 시 자동으로 주문 취소가 되도록 하려고 합니다.

테스트로 10초 안에 입금 안 될 경우 취소되게 했습니다.

aws lightsail bitnami를 쓰고 있고 다음 코드와 크론을 사용했습니다.

<?php
include_once('../common.php');
 
$sql = "SELECT * FROM g5_shop_order
        WHERE od_status = '주문'
        AND od_settle_case = '무통장'
        AND od_time < NOW() - INTERVAL 10 SECOND";
 
$result = sql_query($sql);
 
sql_query("START TRANSACTION");
 
try {
    while ($row = sql_fetch_array($result)) {
        $update_order = "UPDATE g5_shop_order
                         SET od_status = '취소'
                         WHERE od_id = '{$row['od_id']}'";
        if (!sql_query($update_order)) {
            throw new Exception('주문 테이블 업데이트 실패');
        }
 
        $update_cart = "UPDATE g5_shop_cart
                        SET ct_status = '취소'
                        WHERE od_id = '{$row['od_id']}'";
        if (!sql_query($update_cart)) {
            throw new Exception('카트 테이블 업데이트 실패');
        }
    }
 
    sql_query("COMMIT");
 
} catch (Exception $e) {
    sql_query("ROLLBACK");
    echo $e->getMessage();
}

* * * * * /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