Project

General

Profile

Actions

Bug #68564

closed

Epic #68397: Make TYPO3 work with MySQL strict mode

Data too long for column 'NEWid' at row 1

Added by Morton Jonuschat over 9 years ago. Updated about 7 years ago.

Status:
Closed
Priority:
Should have
Category:
Database API (Doctrine DBAL)
Target version:
Start date:
2015-07-27
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
7
PHP Version:
5.6
Tags:
Complexity:
Is Regression:
No
Sprint Focus:

Description

Inserting records into sys_log fails with the following error:

array(4 items)
   caller => "TYPO3\CMS\Core\Database\DatabaseConnection::exec_INSERTquery" (60 chars)
   ERROR => "Data too long for column 'NEWid' at row 1" (41 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 ('1','1','1','0',
      '10','Record \'%s\' (%s) was inserted on page \'%s\' (%s)','a:4:{i:0;s:4:\"T
      est\";i:1;s:16:\"backend_layout:1\";i:2;s:4:\"Root\";i:3;s:1:\"1\";}','backe
      nd_layout','1','::1','1438021446','1','NEW55b677382adb74.33276945','0')" (375 chars)
Actions #1

Updated by Morton Jonuschat over 9 years ago

  • Status changed from New to In Progress

On MySQL without strict mode silent data truncation is happening, instead of NEW55b677382adb74.33276945 the value being stored is NEW55b677382adb74.33

Actions #2

Updated by Gerrit Code Review over 9 years ago

  • Status changed from In Progress to Under Review

Patch set 1 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/41996

Actions #3

Updated by Morton Jonuschat over 9 years ago

  • Status changed from Under Review to Resolved
  • % Done changed from 0 to 100
Actions #4

Updated by Riccardo De Contardi about 7 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF