구매하기 클릭시 발생하는 오류 - 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

이온디 2024.08.05 03:14

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                |+------------------------+-------------+-----------+-------------+---------------------+

댓글을 작성하려면 로그인이 필요합니다.