I installed into a new machine ubuntu server 16.04, with PHP 7.0 and Mysql 5.7.12.

Installation finished but have a Fatal Error into admin Page and blog pages.

This is a piece of this error:

Fatal Error.

An exception occurred while executing 'SELECT DISTINCT e.* FROM elg_entities e join elg_users_entity u on e.guid = u.guid WHERE u.last_action >= 1464095396 AND ((e.type = 'user')) AND (e.site_guid IN (1)) AND ((1 = 1) AND (e.enabled = 'yes')) ORDER BY u.last_action desc LIMIT 0, 8':

SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'elgg.u.last_action' which is not in SELECT list; this is incompatible with DISTINCT

QUERY: SELECT DISTINCT e.* FROM elg_entities e join elg_users_entity u on e.guid = u.guid WHERE u.last_action >= 1464095396 AND ((e.type = 'user')) AND (e.site_guid IN (1)) AND ((1 = 1) AND (e.enabled = 'yes')) ORDER BY u.last_action desc LIMIT 0, 8

DatabaseException Object
(
[message:protected] => An exception occurred while executing 'SELECT DISTINCT e.* FROM elg_entities e join elg_users_entity u on e.guid = u.guid WHERE u.last_action >= 1464095396 AND ((e.type = 'user')) AND (e.site_guid IN (1)) AND ((1 = 1) AND (e.enabled = 'yes')) ORDER BY u.last_action desc LIMIT 0, 8':

SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'elgg.u.last_action' which is not in SELECT list; this is incompatible with DISTINCT

QUERY: SELECT DISTINCT e.* FROM elg_entities e join elg_users_entity u on e.guid = u.guid WHERE u.last_action >= 1464095396 AND ((e.type = 'user')) AND (e.site_guid IN (1)) AND ((1 = 1) AND (e.enabled = 'yes')) ORDER BY u.last_action desc LIMIT 0, 8
[string:Exception:private] => DatabaseException: An exception occurred while executing 'SELECT DISTINCT e.* FROM elg_entities e join elg_users_entity u on e.guid = u.guid WHERE u.last_action >= 1464095396 AND ((e.type = 'user')) AND (e.site_guid IN (1)) AND ((1 = 1) AND (e.enabled = 'yes')) ORDER BY u.last_action desc LIMIT 0, 8':

SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'elgg.u.last_action' which is not in SELECT list; this is incompatible with DISTINCT