Bug #18866
closed
Epic #68397: Make TYPO3 work with MySQL strict mode
Cannot create page with Mysl in strict mode (STRICT_TRANS_TABLES)
Added by Martin Kutschker over 16 years ago.
Updated over 9 years ago.
Description
When I want to create a page I get an Mysql error saying that it has an inavlid value for an integer field. The problem is that "storage_pid" is when not set initially an empty string. It seems that I get only default values in strict mode for NULL, but no type conversion from empty string to 0 occurs.
A possible solution would be to use 0 as TCA default, but I think it is more proper to make the conversion in TCEmain if necessary.
(issue imported from #M8542)
Files
confirming this bug. seems to be related with 0004693
No, the definition of "storage_pid" has not been changed.
yes of course. my comment was missleading.I mean: both bug come from mysql-5 strictmode and could alternatively (at least for me) be solved by changing sql-mode to MYSQL40 in my.ini.
The attached diff file seems to fix the problem. Can you give me some feedback about it?
The diff file fix the problem for me too.
Good work.
- Status changed from New to Under Review
- Assignee set to Alexander Opitz
- Target version deleted (
0)
- Status changed from Under Review to Resolved
- Status changed from Resolved to Under Review
Patch was reverted again since, after some discussion, this was not the right place to add the additional check. Will need a follow-up. The general idea itself however was okay.
- Status changed from Under Review to Resolved
- Status changed from Resolved to New
- Status changed from New to Rejected
Making TYPO3 work with script mode is at least a year of work.
We have this on our agenda, but since this touches a wider aspect of the code I'm closing these tickets down.
- Parent task set to #68397
- Is Regression set to No
Also available in: Atom
PDF