구매하기 클릭시 발생하는 오류 - SQLSTATE[HY000]: General error: 1364 Field 'purdate' doesn't have a default value
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
SELECT TABLE_NAME, COLUMN_NAME, DATA_TYPE, IS_NULLABLE, COLUMN_DEFAULT
FROM INFORMATION_SCHEMA.COLUMNS
WHERE 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 |
+------------------------+-------------+-----------+-------------+---------------------+