Actions
Bug #11667
closedMySQL mariadb-server-10.3: Incorrect datetime value
Status:
Rejected
Priority:
Normal
Assignee:
Carsten Rose
Target version:
-
Start date:
30.11.2020
Due date:
% Done:
0%
Estimated time:
Discuss:
Prio Planung:
No
Vote:
Description
toUser:: SQL error os:: [ mysqli: 1292 ] Incorrect datetime value: '' for column `math`.`ExamStudent`.`examStartEffective` at row 1 Form:: ExamStudent Form Element:: Column: agreedToSurveillance Timestamp:: 2020.11.30 16:57:51 +0100 Code:: 2001 Message:: SQL error Type:: Db Exception SQL final:: UPDATE `ExamStudent` SET `examId` = ?, `examGroupId` = ?, `examStartEffective` = ?, `examEndEffective` = ?, `examInProgress` = ?, `practiceTestPassed` = ?, `surveillance` = ?, `statusImport` = ?, `pIdStudent` = ?, `specialPermission` = ?, `raiseHand` = ?, `internalNote` = ?, `jitsiRoomUrl` = ?, `finalSubmit` = ?, `grade` = ?, `codeOfHonor1` = ?, `codeOfHonor2` = ?, `agreedToSurveillance` = ?, `modified` = ? WHERE id = ? SQL Params:: array ( 0 => '26', 1 => '49', 2 => '', 3 => '', 4 => 'no', 5 => '2020-11-26 12:34:25', 6 => 'deny by student', 7 => 'manual', 8 => '25871', 9 => '', 10 => 'no', 11 => 'h', 12 => 'if5UdrAJyqF1nwcJVrIfGmzLuxuhMteUA26u25871', 13 => '', 14 => '', 15 => '2020-11-26 12:40:12', 16 => '0000-00-00 00:00:00', 17 => '2020-11-26 12:40:12', 18 => '20201130165751', 19 => '2893', ) current sip:: array ( '__dbIndexData' => '1', 'examId' => '26', 'form' => 'ExamStudent', 'r' => '2893', 's' => '5fc511ad19669', 'urlparam' => '__dbIndexData=1&examId=26&form=ExamStudent&r=2893', ) Page Id:: 143 Content Id:: 313 FE User:: pgroeb File:: /var/www/html/exam2/typo3conf/ext/qfq/Classes/Core/Database/Database.php Line:: 407 CWD:: /var/www/html/exam2/typo3conf/ext/qfq/Classes/Api IP Address:: 192.168.133.211 Stacktrace:: #0 /var/www/html/exam2/typo3conf/ext/qfq/Classes/Core/Database/Database.php(208): IMATHUZH\Qfq\Core\Database\Database->prepareExecute() #1 /var/www/html/exam2/typo3conf/ext/qfq/Classes/Core/Save.php(478): IMATHUZH\Qfq\Core\Database\Database->sql() #2 /var/www/html/exam2/typo3conf/ext/qfq/Classes/Core/Save.php(310): IMATHUZH\Qfq\Core\Save->updateRecord() #3 /var/www/html/exam2/typo3conf/ext/qfq/Classes/Core/Save.php(95): IMATHUZH\Qfq\Core\Save->elements() #4 /var/www/html/exam2/typo3conf/ext/qfq/Classes/Core/QuickFormQuery.php(558): IMATHUZH\Qfq\Core\Save->process() #5 /var/www/html/exam2/typo3conf/ext/qfq/Classes/Core/QuickFormQuery.php(1778): IMATHUZH\Qfq\Core\QuickFormQuery->doForm() #6 /var/www/html/exam2/typo3conf/ext/qfq/Classes/Api/save.php(58): IMATHUZH\Qfq\Core\QuickFormQuery->saveForm()
- `webwork20`, MariaDB 10.3
[SQL] SELECT @@sql_mode; STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION # Fail [SQL] Insert into Clipboard (modified) values ('') # OK [SQL] Insert into Clipboard (modified) values ('0000-00-00 00:00:00') # Reduce complain level SET sql_mode='ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' # OK [SQL] Insert into Clipboard (modified) values ('')
Related issues
Updated by Carsten Rose almost 2 years ago
- Related to Bug #9281: Allow STRICT_TRANS_TABLES added
Updated by Carsten Rose about 2 months ago
- Status changed from New to Rejected
- Target version deleted (
next5) - Prio Planung set to No
Vermutlich gefixt.
Actions