koninklijke-collective / my_user_management

TYPO3 Extension: User Management
https://typo3.org/extensions/repository/view/my_user_management
7 stars 20 forks source link

SQL error when comparing users #37

Closed jp1987 closed 7 years ago

jp1987 commented 7 years ago

SQL error when comparing users:

   caller => 'TYPO3\CMS\Core\Database\DatabaseConnection::exec_SELECTquery' (60 chars)
   ERROR => 'You have an error in your SQL syntax; check the manual that corresponds to y
      our MySQL server version for the right syntax to use near ') GROUP BY uid AS
      C' at line 1' (164 chars)
   lastBuiltQuery => 'SELECT uid, title FROM pages WHERE uid IN () GROUP BY uid ASC' (61 chars)

Tracked this down to vendor/typo3/cms/typo3/sysext/beuser/Resources/Private/Templates/BackendUser/Compare.html, line 160.

In the core backend module, when comparing users, {compareUser.dbMountPoints} is a string. In my_user_management {compareUser.dbMountPoints} is an array, so $GLOBALS['TYPO3_DB']->cleanIntList($uids) fails in vendor/typo3/cms/typo3/sysext/beuser/Classes/ViewHelpers/Display/PagesViewHelper.php