In /administrator/components/com_menus/model/items.php, function:
protected function getListQuery()
// Filter the items over the parent id if set.
$parentId = $this->getState('filter.parent_id');
if (!empty($parentId))
{
$query->where('p.id = ' . (int) $parentId);
}
But p.id causes an SQL error (there is no table with p alias in the query build. Probably it should be:
// Filter the items over the parent id if set.
$parentId = $this->getState('filter.parent_id');
if (!empty($parentId))
{
//$query->where('p.id = ' . (int) $parentId);
$query->where('a.parent_id = ' . (int) $parentId);
}
The issue was detected in Joomla 3.5.1
And the award for the longest lived bug in what has to be the biggest edge case in Joomla goes to...
Status | New | ⇒ | Closed |
Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2016-05-25 09:28:17 |
Closed_By | ⇒ | brianteeman |
Closed as we have a PR #10618 thanks
Regression due to commit on Jan 5, 2010 by Hackwar
Removing the table with p alias but not changing references!