구매하기 클릭시 발생하는 오류 - SQLSTATE[HY000]: General error: 1364 Field 'purdate' doesn't have a default value
이온디
2024.08.05 00:38
조회 528
SQLSTATE[HY000]: General error: 1364 Field 'purdate' doesn't have a default value
장바구니 혹은 바로 결제 화면에서 '구매하기' 버튼 클릭시 발생함.
참조
https://xetown.com/questions/1283829
https://github.com/bjrambo/nurigo/issues/26#issuecomment-190987269
댓글 1
댓글을 작성하려면 로그인이 필요합니다.
SELECT TABLE_NAME, COLUMN_NAME, DATA_TYPE, IS_NULLABLE, COLUMN_DEFAULTFROM INFORMATION_SCHEMA.COLUMNSWHERE COLUMN_NAME = 'purdate'AND TABLE_SCHEMA = 'oracall_dev';MariaDB [oracall_dev]> SELECT TABLE_NAME, COLUMN_NAME, DATA_TYPE, IS_NULLABLE, COLUMN_DEFAULT -> -> FROM INFORMATION_SCHEMA.COLUMNS -> -> WHERE COLUMN_NAME = 'purdate' -> -> AND TABLE_SCHEMA = 'oracall_dev';+------------------------+-------------+-----------+-------------+---------------------+| TABLE_NAME | COLUMN_NAME | DATA_TYPE | IS_NULLABLE | COLUMN_DEFAULT |+------------------------+-------------+-----------+-------------+---------------------+| rx_nstore_digital_cart | purdate | char | NO | NULL || rx_ncart | purdate | char | YES | current_timestamp() || rx_nstore_cart | purdate | char | NO | NULL |+------------------------+-------------+-----------+-------------+---------------------+