Bug #79309: Deleting of a page by a non-admin user throws exception - TYPO3 Core - TYPO3 Forge

Actions

Copy link

Bug #79309

closed

Deleting of a page by a non-admin user throws exception

Added by Philipp Faber over 7 years ago. Updated over 5 years ago.

Status:

Closed

Priority:

Must have

Assignee:

Category:

Target version:

Start date:

2017-01-13

Due date:

% Done:

100%

Estimated time:

TYPO3 Version:

PHP Version:

7.0

Tags:

Complexity:

Is Regression:

Sprint Focus:

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

screen_1484311125.jpg (48 KB) screen_1484311125.jpg

Philipp Faber, 2017-01-13 13:40

Related issues 1 (0 open — 1 closed)

Actions

Copy link

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)':

Actions

Copy link

Updated by Mona Muzaffar over 7 years ago

Status changed from New to Accepted

Actions

Copy link

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

Actions

Copy link

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

Actions

Copy link

Updated by Gerrit Code Review about 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

Actions

Copy link