7:44 am CST would be 13:44 UTC, and I got this for that time:
[23-Jan-2023 13:44:07 UTC] PHP Fatal error: Uncaught PDOException: SQLSTATE[22007]:
Invalid datetime format: 1366 Incorrect integer value: '' for column
`chessvariants`.`Item`.`BoardRows` at row 1 in /home/chessvariants/public_html/index/membersubmission2.php:385
Stack trace:
#0 /home/chessvariants/public_html/index/membersubmission2.php(385): PDOStatement->execute()
#1 {main}
thrown in /home/chessvariants/public_html/index/membersubmission2.php on line 385
Instead of using replace, I should probably use insert if the row doesn't exist and update if it does, as I have already fixed this problem for the update_row function. Since BoardRows is not even a datetime field, this is a weird message, but the underlying problem is that replace is getting an empty string instead of whatever it is expecting.
7:44 am CST would be 13:44 UTC, and I got this for that time:
Instead of using
replace
, I should probably useinsert
if the row doesn't exist andupdate
if it does, as I have already fixed this problem for theupdate_row
function. Since BoardRows is not even a datetime field, this is a weird message, but the underlying problem is thatreplace
is getting an empty string instead of whatever it is expecting.