Issue Bug Closed

#79577Non admin BE user can not delete pages and some other records

Pixelant Developer 02/01/17, 10:58 updated 02/01/17, 11:30

Description

When trying to delete page when logged in as BE non admin user – getting exception

An exception occurred while executing 'SELECT COUNT(`uid`) FROM `be_groups` WHERE (`pid` IN (?)) AND (`be_groups`.`deleted` = 0)

Looks like it fails when check if there are records from disallowed tables in “sysext/core/Classes/DataHandling/DataHandler.php” when building query on line 8032.

$count = $query->count('uid')
                    ->from($table)
                    ->where($query->expr()->in(
                        'pid',
                        $query->createNamedParameter($inList, Connection::PARAM_INT_ARRAY)
                    ))
                    ->execute()
                    ->fetchColumn(0);

$inList is string, but expected parameter is array

$query->createNamedParameter([$inList], Connection::PARAM_INT_ARRAY)

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.