Bug #80566
Updated by Thomas Hohn over 7 years ago
If if a Scheduler Tasks Throws an Exception the Scheduler Tries to log the Exception->code into to sys_log.details_nr which this fails see the following follwoing message: <pre> caller => "TYPO3\CMS\Core\Database\DatabaseConnection::exec_INSERTquery" (60 chars) ERROR => "Out of range value for column 'details_nr' at row 1" (51 chars) lastBuiltQuery => "INSERT INTO sys_log (userid,type,action,error,details_nr,details,log_data,ta blename,recuid,IP,tstamp,event_pid,NEWid,workspace) VALUES ('98','4','0','1' ,'1486473158327','[scheduler]: Task failed to execute successfully. Class: T YPO3\\CMS\\Extbase\\Scheduler\\Task, UID: 8. Required Option apiUrl not set in Mindscreen\\UserKimauth\\Configuration\\AbstractConfigurationOption','a:0 :{}','','0','','1490782502','-1','','0') </pre> details_nr is defined as tinyint(3) which is to short if you exception exeption contains a longer code (like the development timestamp()) Suggested solution: log move the Exception code to the log message.