Project

General

Profile

Actions

Bug #80035

closed

Strict MySQL sql_mode breaks workspaces

Added by Christian Weiske over 7 years ago. Updated about 6 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Workspaces
Target version:
-
Start date:
2017-02-27
Due date:
% Done:

0%

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

Description

Using TYPO3 7.6.15 and its workspace extension with MySQL 5.7 is broken.

When switching to a non-live workspace the page tree does not get printed anymore, and the exception panel pops up:

exec_SELECTquery
array(4 items)
   caller => 'TYPO3\CMS\Core\Database\DatabaseConnection::exec_SELECTquery' (60 chars)
   ERROR => 'Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre
      gated column 'TYPO3.B.uid' which is not functionally dependent on columns in
       GROUP BY clause; this is incompatible with sql_mode=only_full_group_by' (223 chars)
   lastBuiltQuery => 'SELECT B.uid as live_uid, B.pid as live_pid, A.uid as offline_uid FROM sys_c
      ategory A,sys_category B WHERE A.pid=-1 AND A.t3ver_wsid=1 AND (A.t3ver_oid=
      B.uid AND A.t3ver_state<>4 OR A.t3ver_oid=B.t3ver_move_id AND A.t3ver_
      state=4) AND A.deleted=0 AND B.deleted=0 GROUP BY live_pid' (280 chars)
   debug_backtrace => '{closure}#21 // TYPO3\CMS\Backend\Http\Application->run#20 // TYPO3\CMS\C
      ore\Core\Bootstrap->handleRequest#94 // TYPO3\CMS\Backend\Http\AjaxReques
      tHandler->handleRequest#302 // TYPO3\CMS\Backend\Http\AjaxRequestHandler-
      >dispatch#88 // TYPO3\CMS\Backend\Http\RouteDispatcher->dispatch#170 /
      / call_user_func_array#54 // TYPO3\CMS\Core\ExtDirect\ExtDirectRouter->ro
      uteAction# // TYPO3\CMS\Core\ExtDirect\ExtDirectRouter->processRpc#87 // 
      call_user_func_array#139 // TYPO3\CMS\Backend\Tree\Pagetree\ExtdirectTreeDat
      aProvider->getNextTreeLevel# // TYPO3\CMS\Backend\Tree\Pagetree\DataProvi
      der->getTreeMounts#84 // TYPO3\CMS\Backend\Tree\Pagetree\DataProvider->
      ;getNodes#405 // TYPO3\CMS\Backend\Tree\Pagetree\DataProvider->getNodes#1
      69 // TYPO3\CMS\Backend\Tree\Pagetree\DataProvider->getNodes#169 // TYPO3
      \CMS\Backend\Tree\Pagetree\DataProvider->getNodes#169 // TYPO3\CMS\Worksp
      aces\ExtDirect\PagetreeCollectionsProcessor->postProcessGetNodes#183 // T
      YPO3\CMS\Workspaces\ExtDirect\PagetreeCollectionsProcessor->highlightVers
      ionizedElements#42 // TYPO3\CMS\Workspaces\Service\WorkspaceService->hasP
      ageRecordVersions#85 // TYPO3\CMS\Core\Database\DatabaseConnection->exec_
      SELECTgetRows#757 // TYPO3\CMS\Core\Database\DatabaseConnection->exec_SEL
      ECTquery#377 // TYPO3\CMS\Core\Database\DatabaseConnection->debug#314' (1307 chars)

Related issues 3 (0 open3 closed)

Related to TYPO3 Core - Bug #70629: Bug with MySQL mode STRICT_TRANS_TABLESClosed2015-10-12

Actions
Related to TYPO3 Core - Feature #68704: Set MySQL sql_modeClosedMorton Jonuschat2015-08-03

Actions
Related to TYPO3 Core - Bug #17968: Strict sql-mode setting prevents creation of admin user in install toolClosedDmitry Dulepov2008-01-06

Actions
Actions #1

Updated by Christian Weiske over 7 years ago

Default sql_mode setting in MySQL 5.7 (https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html):

$ SELECT @@GLOBAL.sql_mode

ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

Actions #2

Updated by Georg Ringer about 7 years ago

  • Status changed from New to Resolved

this has been resolved in 8 with migrating to doctrine with #76626 and a followup #80898

Actions #3

Updated by Benni Mack about 6 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF