Dear friends,
I have tables :
- treatdetail, with fields:
wh_code, inv_code, exp_date - (from view) expinventory, with fields:
wh_code, inv_code, exp_date, quantity
from treatdetail->exp_date, lookup to lookup table expinventory (link field is exp_date)
parent field #1 wh_code
parent field #2 inv_code
But when it runs, it appear error warning (even though we can continue), the error is as below:
...vendor\doctrine\dbal\src\Driver\API\MySQL\ExceptionConverter.php(117): An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1525 Incorrect DATE value: '108305'
(please note that the value of DATE value in error message keep on changing).
Last month -- it works well - without above error. (this program is still in trial phase, I just revisit this again this month)
I don't know how to fix it.
I am using WAMPSERVER 3.3.5
MySQL 8.3.0
Kindly share what to do. Thanks in advanced