Bug #79309
closedDeleting of a page by a non-admin user throws exception
100%
Description
Somehow only admins can delete pages. I checked access module and pages can be modified (created, moved, renamed, etc.). Everything works, except deleting the page.
This exception is thrown:
Exception An exception occurred while executing 'SELECT COUNT(`uid`) FROM `be_groups` WHERE (`pid` IN (:dcValue1)) AND (`be_groups`.`deleted` = 0)' with params ["40"]: PHP Warning: Invalid argument supplied for foreach() in E:\xampp\htdocs\site.com\web\typo3_src-8.5.1\vendor\doctrine\dbal\lib\Doctrine\DBAL\SQLParserUtils.php line 178
Files
Updated by Riccardo De Contardi over 7 years ago
I can confirm it with the latest master 8.6-dev
Steps to reproduce
1) create a "editors" group and give full ACL privileges
2) add an "editor" user to "editors"
3) create a page; In access module > give the page:
- owner: admin
- group:editors and full privileges (also delete)
3.1) try to delete the page
RESULT: you obtain the error:
An exception occurred while executing 'SELECT COUNT(`uid`) FROM `be_groups` WHERE (`pid` IN (?)) AND (`be_groups`.`deleted` = 0)':
4) create a page; In access module > give it:
- owner:editor and full privileges
- group: editors, without delete privilege
4.1) try to delete the page
RESULT: you obtain the error:
An exception occurred while executing 'SELECT COUNT(`uid`) FROM `be_groups` WHERE (`pid` IN (?)) AND (`be_groups`.`deleted` = 0)':
Updated by Gerrit Code Review over 7 years ago
- Status changed from Accepted 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 https://review.typo3.org/51342
Updated by Gerrit Code Review over 7 years ago
Patch set 2 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/51342
Updated by Gerrit Code Review over 7 years ago
Patch set 3 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/51342
Updated by Mona Muzaffar over 7 years ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset fdd4e3021b558cb4bfe009aee1ad43af2b0798b0.