Project

General

Profile

Support #11667

MySQL mariadb-server-10.3: Incorrect datetime value

Added by Carsten Rose 5 months ago.

Status:
New
Priority:
Normal
Assignee:
Target version:
Start date:
30.11.2020
Due date:
% Done:

0%

Estimated time:
Discuss:

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 ('')
    
    

No data to display

Also available in: Atom PDF