Actions
Bug #68564
closedEpic #68397: Make TYPO3 work with MySQL strict mode
Data too long for column 'NEWid' at row 1
Status:
Closed
Priority:
Should have
Assignee:
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)
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
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
Updated by Morton Jonuschat over 9 years ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset 73ed7fd70a9933c876dd6c6f33acce556784b2ac.
Updated by Riccardo De Contardi about 7 years ago
- Status changed from Resolved to Closed
Actions