http://forge.typo3.org/http://forge.typo3.org/themes/typo3_forge/favicon/favicon.png?17058661692015-08-03T15:20:34ZTYPO3 ForgeTYPO3 Core - Feature #68704: Set MySQL sql_modehttp://forge.typo3.org/issues/68704?journal_id=2694302015-08-03T15:20:34ZMarkus Blaschke
<ul></ul><p>For more informations see<br /><a class="external" href="https://dev.mysql.com/doc/refman/5.5/en/sql-mode.html">https://dev.mysql.com/doc/refman/5.5/en/sql-mode.html</a></p> TYPO3 Core - Feature #68704: Set MySQL sql_modehttp://forge.typo3.org/issues/68704?journal_id=2694312015-08-03T15:25:16ZWouter Wolterstypo3@wouterwolters.nl
<ul><li><strong>Status</strong> changed from <i>New</i> to <i>Needs Feedback</i></li></ul><p>This can be done with [SYS][setDBinit] in the Install Tool already. Please try this first.</p> TYPO3 Core - Feature #68704: Set MySQL sql_modehttp://forge.typo3.org/issues/68704?journal_id=2694322015-08-03T15:32:39ZDaniel Goerz
<ul><li><strong>Tracker</strong> changed from <i>Bug</i> to <i>Feature</i></li><li><strong>Target version</strong> set to <i>7.5</i></li></ul><p>Recategorized on demand of Markus.</p> TYPO3 Core - Feature #68704: Set MySQL sql_modehttp://forge.typo3.org/issues/68704?journal_id=2694332015-08-03T15:34:38ZMarkus Blaschke
<ul></ul><p>I know that it can be done with setDbInit but most devs don't know this MySQL feature.</p>
<p>Maybe TYPO3 should set this value for it's own database connection because most devs are removing this setting from the global MySQL/MariaDB configuration which is not a good idea.<br />Also TYPO3 could set tighter default values for the next Version (eg. 8) to prevent common sql errors.</p>
<p>With the sql mode you can prevent setting too big values for fields or setting wrong values into ENUM/SET fields. Also wrong GROUP BY usage can be prevented which is an error.</p> TYPO3 Core - Feature #68704: Set MySQL sql_modehttp://forge.typo3.org/issues/68704?journal_id=2695632015-08-04T19:36:32ZMorton Jonuschatm.jonuschat@mojocode.de
<ul><li><strong>Category</strong> set to <i>Install Tool</i></li><li><strong>Status</strong> changed from <i>Needs Feedback</i> to <i>Closed</i></li><li><strong>Assignee</strong> set to <i>Morton Jonuschat</i></li></ul><p>After discussing this in #typo3-cms-coredev we decided to close this in favor of a more generic solution. At the moment setting SQLmodes, especially the STRICT_* modes, will result in lots of errors in the core as running MySQL strict mode is not supported.<br />There is currently a check for the install tool under review that will warn the user about incompatible modes. These can either be fixed on the server (globally) or by using .</p>
<p>In the long run MySQL strict mode will be supported in the core, then the main reason to remove the SQLmode setting from the DB configuration should be null and void. For the few remaining edge cases DBinit should be good enough. There have already been some discussions about modifying the SQLmode in the past and the outcome has always been that it undesirable for TYPO3 to modify these setting on it's own.</p>