Hello,
I have just installed Elgg 2.2.0 on my localhost, running on LAMP, Ubuntu 16.04.
Setup completed perfectly, green light on all prerequisites and no errors of any kind. But, after I clicked finish and got redirected to /admin, I see a heavily damaged page which title is "Fatal Error" containing a rather scary stack trace.
The public website seems to work fine, I get no errors while navigating and also successfully made a post.
The stack trace is really long. Has anybody any idea on how to solve this?
Many thanks in advance
An exception occurred while executing 'SELECT DISTINCT e.* FROM elgg_entities e join elgg_users_entity u on e.guid = u.guid WHERE u.last_action >= 1473091640 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 elgg_entities e join elgg_users_entity u on e.guid = u.guid WHERE u.last_action >= 1473091640 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 elgg_entities e join elgg_users_entity u on e.guid = u.guid WHERE u.last_action >= 1473091640 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 elgg_entities e join elgg_users_entity u on e.guid = u.guid WHERE u.last_action >= 1473091640 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 elgg_entities e join elgg_users_entity u on e.guid = u.guid WHERE u.last_action >= 1473091640 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 elgg_entities e join elgg_users_entity u on e.guid = u.guid WHERE u.last_action >= 1473091640 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 in /var/www/html/elgg/vendor/elgg/elgg/engine/classes/Elgg/Database.php:443
Stack trace:
#0 /var/www/html/elgg/vendor/elgg/elgg/engine/classes/Elgg/Database.php(384): Elgg\Database->executeQuery('SELECT DISTINCT...', Object(Doctrine\DBAL\Connection), Array)
#1 /var/www/html/elgg/vendor/elgg/elgg/engine/classes/Elgg/Database.php(206): Elgg\Database->getResults('SELECT DISTINCT...', NULL, false, Array)
#2 /var/www/html/elgg/vendor/elgg/elgg/engine/classes/Elgg/Database/EntityTable.php(600): Elgg\Database->getData('SELECT DISTINCT...')
#3 /var/www/html/elgg/vendor/elgg/elgg/engine/classes/Elgg/Database/EntityTable.php(472): Elgg\Database\EntityTable->fetchFromSql('SELECT DISTINCT...', NULL)
#4 /var/www/html/elgg/vendor/elgg/elgg/engine/lib/entities.php(317): Elgg\Database\EntityTable->getEntities(Array)
#5 /var/www/html/elgg/vendor/elgg/elgg/engine/classes/Elgg/Database/UsersTable.php(369): elgg_get_entities(Array)
#6 /var/www/html/elgg/vendor/elgg/elgg/engine/lib/users.php(143): Elgg\Database\UsersTable->findActive(Array, 10, 0, false)
#7 /var/www/html/elgg/vendor/elgg/elgg/engine/lib/entities.php(411): find_active_users(Array)
#8 /var/www/html/elgg/vendor/elgg/elgg/engine/lib/statistics.php(94): elgg_list_entities(Array, 'find_active_use...')
#9 /var/www/html/elgg/vendor/elgg/elgg/views/default/widgets/online_users/content.php(14): get_online_users(Array)
#10 /var/www/html/elgg/vendor/elgg/elgg/engine/classes/Elgg/ViewsService.php(362): include('/var/www/html/e...')
#11 /var/www/html/elgg/vendor/elgg/elgg/engine/classes/Elgg/ViewsService.php(300): Elgg\ViewsService->renderViewFile('widgets/online_...', Array, 'default', true)
#12 /var/www/html/elgg/vendor/elgg/elgg/engine/lib/views.php(343): Elgg\ViewsService->renderView('widgets/online_...', Array, false, 'default')
#13 /var/www/html/elgg/vendor/elgg/elgg/views/default/object/widget/elements/content.php(16): elgg_view('widgets/online_...', Array)
#14 /var/www/html/elgg/vendor/elgg/elgg/engine/classes/Elgg/ViewsService.php(362): include('/var/www/html/e...')
#15 /var/www/html/elgg/vendor/elgg/elgg/engine/classes/Elgg/ViewsService.php(300): Elgg\ViewsService->renderViewFile('object/widget/e...', Array, 'default', true)
#16 /var/www/html/elgg/vendor/elgg/elgg/engine/lib/views.php(343): Elgg\ViewsService->renderView('object/widget/e...', Array, false, 'default')
#17 /var/www/html/elgg/vendor/elgg/elgg/views/default/object/widget.php(40): elgg_view('object/widget/e...', Array)
#18 /var/www/html/elgg/vendor/elgg/elgg/engine/classes/Elgg/ViewsService.php(362): include('/var/www/html/e...')
#19 /var/www/html/elgg/vendor/elgg/elgg/engine/classes/Elgg/ViewsService.php(300): Elgg\ViewsService->renderViewFile('object/widget', Array, 'default', true)
#20 /var/www/html/elgg/vendor/elgg/elgg/engine/lib/views.php(343): Elgg\ViewsService->renderView('object/widget', Array, false, 'default')
#21 /var/www/html/elgg/vendor/elgg/elgg/engine/lib/views.php(864): elgg_view('object/widget', Array, false, false)
#22 /var/www/html/elgg/vendor/elgg/elgg/views/default/page/layouts/widgets.php(84): elgg_view_entity(Object(ElggWidget), Array)
#23 /var/www/html/elgg/vendor/elgg/elgg/engine/classes/Elgg/ViewsService.php(362): include('/var/www/html/e...')
#24 /var/www/html/elgg/vendor/elgg/elgg/engine/classes/Elgg/ViewsService.php(300): Elgg\ViewsService->renderViewFile('page/layouts/wi...', Array, 'default', true)
#25 /var/www/html/elgg/vendor/elgg/elgg/engine/lib/views.php(343): Elgg\ViewsService->renderView('page/layouts/wi...', Array, false, 'default')
#26 /var/www/html/elgg/vendor/elgg/elgg/engine/lib/views.php(699): elgg_view('page/layouts/wi...', Array)
#27 /var/www/html/elgg/vendor/elgg/elgg/views/default/admin/dashboard.php(10): elgg_view_layout('widgets', Array)
#28 /var/www/html/elgg/vendor/elgg/elgg/engine/classes/Elgg/ViewsService.php(362): include('/var/www/html/e...')
#29 /var/www/html/elgg/vendor/elgg/elgg/engine/classes/Elgg/ViewsService.php(300): Elgg\ViewsService->renderViewFile('admin/dashboard', Array, 'default', true)
#30 /var/www/html/elgg/vendor/elgg/elgg/engine/lib/views.php(343): Elgg\ViewsService->renderView('admin/dashboard', Array, false, 'default')
#31 /var/www/html/elgg/vendor/elgg/elgg/engine/lib/admin.php(568): elgg_view('admin/dashboard', Array)
#32 [internal function]: _elgg_admin_page_handler(Array, 'admin')
#33 /var/www/html/elgg/vendor/elgg/elgg/engine/classes/Elgg/Router.php(95): call_user_func('_elgg_admin_pag...', Array, 'admin')
#34 /var/www/html/elgg/vendor/elgg/elgg/engine/classes/Elgg/Application.php(429): Elgg\Router->route(Object(Elgg\Http\Request))
#35 /var/www/html/elgg/vendor/elgg/elgg/engine/classes/Elgg/Application.php(377): Elgg\Application->run()
#36 /var/www/html/elgg/index.php(8): Elgg\Application::index()
#37 {main}
[code:protected] => 0
[file:protected] => /var/www/html/elgg/vendor/elgg/elgg/engine/classes/Elgg/Database.php
[line:protected] => 443
[trace:Exception:private] => Array
(
[0] => Array
(
[file] => /var/www/html/elgg/vendor/elgg/elgg/engine/classes/Elgg/Database.php
[line] => 384
[function] => executeQuery
[class] => Elgg\Database
[type] => ->
[args] => Array
(
[0] => SELECT DISTINCT e.* FROM elgg_entities e join elgg_users_entity u on e.guid = u.guid WHERE u.last_action >= 1473091640 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
[1] => Doctrine\DBAL\Connection Object
(
[_conn:protected] => Doctrine\DBAL\Driver\PDOConnection Object
(
)
[_config:protected] => Doctrine\DBAL\Configuration Object
(
[_attributes:protected] => Array
(
)
)
[_eventManager:protected] => Doctrine\Common\EventManager Object
(
[_listeners:Doctrine\Common\EventManager:private] => Array
(
)
)
[_expr:protected] => Doctrine\DBAL\Query\Expression\ExpressionBuilder Object
(
[connection:Doctrine\DBAL\Query\Expression\ExpressionBuilder:private] => Doctrine\DBAL\Connection Object
*RECURSION*
)
[_isConnected:Doctrine\DBAL\Connection:private] => 1
[autoCommit:Doctrine\DBAL\Connection:private] => 1
[_transactionNestingLevel:Doctrine\DBAL\Connection:private] => 0
[_transactionIsolationLevel:Doctrine\DBAL\Connection:private] =>
[_nestTransactionsWithSavepoints:Doctrine\DBAL\Connection:private] =>
[_params:Doctrine\DBAL\Connection:private] => Array
(
[dbname] => elgg
[user] => root
[password] => holdsworth
[host] => localhost
[charset] => utf8
[driver] => pdo_mysql
)
[platform:Doctrine\DBAL\Connection:private] => Doctrine\DBAL\Platforms\MySQL57Platform Object
(
[doctrineTypeMapping:protected] =>
[doctrineTypeComments:protected] =>
[_eventManager:protected] => Doctrine\Common\EventManager Object
(
[_listeners:Doctrine\Common\EventManager:private] => Array
(
)
)
[_keywords:protected] =>
)
[_schemaManager:protected] =>
[_driver:protected] => Doctrine\DBAL\Driver\PDOMySql\Driver Object
(
)
[_isRollbackOnly:Doctrine\DBAL\Connection:private] =>
[defaultFetchMode:protected] => 5
)
[2] => Array
(
)
)
)
[1] => Array
(
[file] => /var/www/html/elgg/vendor/elgg/elgg/engine/classes/Elgg/Database.php
[line] => 206
[function] => getResults
[class] => Elgg\Database
[type] => ->
[args] => Array
(
[0] => SELECT DISTINCT e.* FROM elgg_entities e join elgg_users_entity u on e.guid = u.guid WHERE u.last_action >= 1473091640 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
[1] =>
[2] =>
[3] => Array
(
)
)
)
[2] => Array
(
[file] => /var/www/html/elgg/vendor/elgg/elgg/engine/classes/Elgg/Database/EntityTable.php
[line] => 600
[function] => getData
[class] => Elgg\Database
[type] => ->
[args] => Array
(
[0] => SELECT DISTINCT e.* FROM elgg_entities e join elgg_users_entity u on e.guid = u.guid WHERE u.last_action >= 1473091640 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
)
)
[3] => Array
(
[file] => /var/www/html/elgg/vendor/elgg/elgg/engine/classes/Elgg/Database/EntityTable.php
[line] => 472
[function] => fetchFromSql
[class] => Elgg\Database\EntityTable
[type] => ->
[args] => Array
(
[0] => SELECT DISTINCT e.* FROM elgg_entities e join elgg_users_entity u on e.guid = u.guid WHERE u.last_action >= 1473091640 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
[1] =>
)
)
[4] => Array
(
[file] => /var/www/html/elgg/vendor/elgg/elgg/engine/lib/entities.php
[line] => 317
[function] => getEntities
[class] => Elgg\Database\EntityTable
[type] => ->
[args] => Array
(
[0] => Array
(
[types] => Array
(
[0] => user
)
[subtypes] =>
[type_subtype_pairs] =>
[guids] =>
[owner_guids] =>
[container_guids] =>
[site_guids] => 1
[modified_time_lower] =>
[modified_time_upper] =>
[created_time_lower] =>
[created_time_upper] =>
[reverse_order_by] =>
[order_by] => u.last_action desc
[group_by] =>
[limit] => 8
[offset] => 0
[count] =>
[selects] => Array
(
)
[wheres] => Array
(
[0] => u.last_action >= 1473091640
)
[joins] => Array
(
[0] => join elgg_users_entity u on e.guid = u.guid
)
[preload_owners] =>
[preload_containers] =>
[callback] => entity_row_to_elggstar
[distinct] => 1
[__ElggBatch] =>
)
)
)
[5] => Array
(
[file] => /var/www/html/elgg/vendor/elgg/elgg/engine/classes/Elgg/Database/UsersTable.php
[line] => 369
[function] => elgg_get_entities
[args] => Array
(
[0] => Array
(
[type] => user
[limit] => 8
[offset] => 0
[count] =>
[joins] => Array
(
[0] => join elgg_users_entity u on e.guid = u.guid
)
[wheres] => Array
(
[0] => u.last_action >= 1473091640
)
[order_by] => u.last_action desc
)
)
)
[6] => Array
(
[file] => /var/www/html/elgg/vendor/elgg/elgg/engine/lib/users.php
[line] => 143
[function] => findActive
[class] => Elgg\Database\UsersTable
[type] => ->
[args] => Array
(
[0] => Array
(
[seconds] => 600
[limit] => 8
[offset] => 0
[count] =>
[full_view] =>
[list_type_toggle] =>
[pagination] =>
[no_results] =>
)
[1] => 10
[2] => 0
[3] =>
)
)
[7] => Array
(
[file] => /var/www/html/elgg/vendor/elgg/elgg/engine/lib/entities.php
[line] => 411
[function] => find_active_users
[args] => Array
(
[0] => Array
(
[offset] => 0
[limit] => 8
[full_view] =>
[list_type_toggle] =>
[pagination] =>
[no_results] =>
[seconds] => 600
[count] =>
)
)
)
[8] => Array
(
[file] => /var/www/html/elgg/vendor/elgg/elgg/engine/lib/statistics.php
[line] => 94
[function] => elgg_list_entities
[args] => Array
(
[0] => Array
(
[offset] => 0
[limit] => 8
[full_view] =>
[list_type_toggle] =>
[pagination] =>
[no_results] =>
[seconds] => 600
[count] =>
)
[1] => find_active_users
)
)
[9] => Array
(
[file] => /var/www/html/elgg/vendor/elgg/elgg/views/default/widgets/online_users/content.php
[line] => 14
[function] => get_online_users
[args] => Array
(
[0] => Array
(
[seconds] => 600
[pagination] =>
[limit] => 8
)
)
)
[10] => Array
(
[file] => /var/www/html/elgg/vendor/elgg/elgg/engine/classes/Elgg/ViewsService.php
[line] => 362
[args] => Array
(
[0] => /var/www/html/elgg/vendor/elgg/elgg/views/default/widgets/online_users/content.php
)
[function] => include
)
[11] => Array
(
[file] => /var/www/html/elgg/vendor/elgg/elgg/engine/classes/Elgg/ViewsService.php
[line] => 300
[function] => renderViewFile
[class] => Elgg\ViewsService
[type] => ->
[args] => Array
(
[0] => widgets/online_users/content
[1] => Array
(
[full_view] => 1
[show_access] =>
[entity] => ElggWidget Object
(
[url_override:protected] =>
[temp_metadata:protected] => Array
(
)
[temp_annotations:protected] => Array
(
)
[temp_private_settings:protected] => Array
(
)
[volatile:protected] => Array
(
)
[orig_attributes:protected] => Array
(
)
[attributes:protected] => Array
(
[guid] => 39
[type] => object
[subtype] => 3
[owner_guid] => 36
[site_guid] => 1
[container_guid] => 36
[access_id] => 0
[time_created] => 1473091117
[time_updated] => 1473091117
[last_action] => 1473091117
[enabled] => yes
[title] =>
[description] =>
)
[valid:protected] =>
)
)
[2] => default
[3] => 1
)
)
[12] => Array
(
[file] => /var/www/html/elgg/vendor/elgg/elgg/engine/lib/views.php
[line] => 343
[function] => renderView
[class] => Elgg\ViewsService
[type] => ->
[args] => Array
(
[0] => widgets/online_users/content
[1] => Array
(
[full_view] => 1
[show_access] =>
[entity] => ElggWidget Object
(
[url_override:protected] =>
[temp_metadata:protected] => Array
(
)
[temp_annotations:protected] => Array
(
)
[temp_private_settings:protected] => Array
(
)
[volatile:protected] => Array
(
)
[orig_attributes:protected] => Array
(
)
[attributes:protected] => Array
(
[guid] => 39
[type] => object
[subtype] => 3
[owner_guid] => 36
[site_guid] => 1
[container_guid] => 36
[access_id] => 0
[time_created] => 1473091117
[time_updated] => 1473091117
[last_action] => 1473091117
[enabled] => yes
[title] =>
[description] =>
)
[valid:protected] =>
)
)
[2] =>
[3] => default
)
)
[13] => Array
(
[file] => /var/www/html/elgg/vendor/elgg/elgg/views/default/object/widget/elements/content.php
[line] => 16
[function] => elgg_view
[args] => Array
(
[0] => widgets/online_users/content
[1] => Array
(
[full_view] => 1
[show_access] =>
[entity] => ElggWidget Object
(
[url_override:protected] =>
[temp_metadata:protected] => Array
(
)
[temp_annotations:protected] => Array
(
)
[temp_private_settings:protected] => Array
(
)
[volatile:protected] => Array
(
)
[orig_attributes:protected] => Array
(
)
[attributes:protected] => Array
(
[guid] => 39
[type] => object
[subtype] => 3
[owner_guid] => 36
[site_guid] => 1
[container_guid] => 36
[access_id] => 0
[time_created] => 1473091117
[time_updated] => 1473091117
[last_action] => 1473091117
[enabled] => yes
[title] =>
[description] =>
)
[valid:protected] =>
)
)
)
)
[14] => Array
(
[file] => /var/www/html/elgg/vendor/elgg/elgg/engine/classes/Elgg/ViewsService.php
[line] => 362
[args] => Array
(
[0] => /var/www/html/elgg/vendor/elgg/elgg/views/default/object/widget/elements/content.php
)
[function] => include
)
[15] => Array
(
[file] => /var/www/html/elgg/vendor/elgg/elgg/engine/classes/Elgg/ViewsService.php
[line] => 300
[function] => renderViewFile
[class] => Elgg\ViewsService
[type] => ->
[args] => Array
(
[0] => object/widget/elements/content
[1] => Array
(
[full_view] => 1
[show_access] =>
[entity] => ElggWidget Object
(
[url_override:protected] =>
[temp_metadata:protected] => Array
(
)
[temp_annotations:protected] => Array
(
)
[temp_private_settings:protected] => Array
(
)
[volatile:protected] => Array
(
)
[orig_attributes:protected] => Array
(
)
[attributes:protected] => Array
(
[guid] => 39
[type] => object
[subtype] => 3
[owner_guid] => 36
[site_guid] => 1
[container_guid] => 36
[access_id] => 0
[time_created] => 1473091117
[time_updated] => 1473091117
[last_action] => 1473091117
[enabled] => yes
[title] =>
[description] =>
)
[valid:protected] =>
)
)
[2] => default
[3] => 1
)
)
[16] => Array
(
[file] => /var/www/html/elgg/vendor/elgg/elgg/engine/lib/views.php
[line] => 343
[function] => renderView
[class] => Elgg\ViewsService
[type] => ->
[args] => Array
(
[0] => object/widget/elements/content
[1] => Array
(
[full_view] => 1
[show_access] =>
[entity] => ElggWidget Object
(
[url_override:protected] =>
[temp_metadata:protected] => Array
(
)
[temp_annotations:protected] => Array
(
)
[temp_private_settings:protected] => Array
(
)
[volatile:protected] => Array
(
)
[orig_attributes:protected] => Array
(
)
[attributes:protected] => Array
(
[guid] => 39
[type] => object
[subtype] => 3
[owner_guid] => 36
[site_guid] => 1
[container_guid] => 36
[access_id] => 0
[time_created] => 1473091117
[time_updated] => 1473091117
[last_action] => 1473091117
[enabled] => yes
[title] =>
[description] =>
)
[valid:protected] =>
)
)
[2] =>
[3] => default
)
)
[17] => Array
(
[file] => /var/www/html/elgg/vendor/elgg/elgg/views/default/object/widget.php
[line] => 40
[function] => elgg_view
[args] => Array
(
[0] => object/widget/elements/content
[1] => Array
(
[full_view] => 1
[show_access] =>
[entity] => ElggWidget Object
(
[url_override:protected] =>
[temp_metadata:protected] => Array
(
)
[temp_annotations:protected] => Array
(
)
[temp_private_settings:protected] => Array
(
)
[volatile:protected] => Array
(
)
[orig_attributes:protected] => Array
(
)
[attributes:protected] => Array
(
[guid] => 39
[type] => object
[subtype] => 3
[owner_guid] => 36
[site_guid] => 1
[container_guid] => 36
[access_id] => 0
[time_created] => 1473091117
[time_updated] => 1473091117
[last_action] => 1473091117
[enabled] => yes
[title] =>
[description] =>
)
[valid:protected] =>
)
)
)
)
[18] => Array
(
[file] => /var/www/html/elgg/vendor/elgg/elgg/engine/classes/Elgg/ViewsService.php
[line] => 362
[args] => Array
(
[0] => /var/www/html/elgg/vendor/elgg/elgg/views/default/object/widget.php
)
[function] => include
)
[19] => Array
(
[file] => /var/www/html/elgg/vendor/elgg/elgg/engine/classes/Elgg/ViewsService.php
[line] => 300
[function] => renderViewFile
[class] => Elgg\ViewsService
[type] => ->
[args] => Array
(
[0] => object/widget
[1] => Array
(
[full_view] => 1
[show_access] =>
[entity] => ElggWidget Object
(
[url_override:protected] =>
[temp_metadata:protected] => Array
(
)
[temp_annotations:protected] => Array
(
)
[temp_private_settings:protected] => Array
(
)
[volatile:protected] => Array
(
)
[orig_attributes:protected] => Array
(
)
[attributes:protected] => Array
(
[guid] => 39
[type] => object
[subtype] => 3
[owner_guid] => 36
[site_guid] => 1
[container_guid] => 36
[access_id] => 0
[time_created] => 1473091117
[time_updated] => 1473091117
[last_action] => 1473091117
[enabled] => yes
[title] =>
[description] =>
)
[valid:protected] =>
)
)
[2] => default
[3] => 1
)
)
[20] => Array
(
[file] => /var/www/html/elgg/vendor/elgg/elgg/engine/lib/views.php
[line] => 343
[function] => renderView
[class] => Elgg\ViewsService
[type] => ->
[args] => Array
(
[0] => object/widget
[1] => Array
(
[full_view] => 1
[show_access] =>
[entity] => ElggWidget Object
(
[url_override:protected] =>
[temp_metadata:protected] => Array
(
)
[temp_annotations:protected] => Array
(
)
[temp_private_settings:protected] => Array
(
)
[volatile:protected] => Array
(
)
[orig_attributes:protected] => Array
(
)
[attributes:protected] => Array
(
[guid] => 39
[type] => object
[subtype] => 3
[owner_guid] => 36
[site_guid] => 1
[container_guid] => 36
[access_id] => 0
[time_created] => 1473091117
[time_updated] => 1473091117
[last_action] => 1473091117
[enabled] => yes
[title] =>
[description] =>
)
[valid:protected] =>
)
)
[2] =>
[3] => default
)
)
[21] => Array
(
[file] => /var/www/html/elgg/vendor/elgg/elgg/engine/lib/views.php
[line] => 864
[function] => elgg_view
[args] => Array
(
[0] => object/widget
[1] => Array
(
[full_view] => 1
[show_access] =>
[entity] => ElggWidget Object
(
[url_override:protected] =>
[temp_metadata:protected] => Array
(
)
[temp_annotations:protected] => Array
(
)
[temp_private_settings:protected] => Array
(
)
[volatile:protected] => Array
(
)
[orig_attributes:protected] => Array
(
)
[attributes:protected] => Array
(
[guid] => 39
[type] => object
[subtype] => 3
[owner_guid] => 36
[site_guid] => 1
[container_guid] => 36
[access_id] => 0
[time_created] => 1473091117
[time_updated] => 1473091117
[last_action] => 1473091117
[enabled] => yes
[title] =>
[description] =>
)
[valid:protected] =>
)
)
[2] =>
[3] =>
)
)
[22] => Array
(
[file] => /var/www/html/elgg/vendor/elgg/elgg/views/default/page/layouts/widgets.php
[line] => 84
[function] => elgg_view_entity
[args] => Array
(
[0] => ElggWidget Object
(
[url_override:protected] =>
[temp_metadata:protected] => Array
(
)
[temp_annotations:protected] => Array
(
)
[temp_private_settings:protected] => Array
(
)
[volatile:protected] => Array
(
)
[orig_attributes:protected] => Array
(
)
[attributes:protected] => Array
(
[guid] => 39
[type] => object
[subtype] => 3
[owner_guid] => 36
[site_guid] => 1
[container_guid] => 36
[access_id] => 0
[time_created] => 1473091117
[time_updated] => 1473091117
[last_action] => 1473091117
[enabled] => yes
[title] =>
[description] =>
)
[valid:protected] =>
)
[1] => Array
(
[full_view] => 1
[show_access] =>
[entity] => ElggWidget Object
(
[url_override:protected] =>
[temp_metadata:protected] => Array
(
)
[temp_annotations:protected] => Array
(
)
[temp_private_settings:protected] => Array
(
)
[volatile:protected] => Array
(
)
[orig_attributes:protected] => Array
(
)
[attributes:protected] => Array
(
[guid] => 39
[type] => object
[subtype] => 3
[owner_guid] => 36
[site_guid] => 1
[container_guid] => 36
[access_id] => 0
[time_created] => 1473091117
[time_updated] => 1473091117
[last_action] => 1473091117
[enabled] => yes
[title] =>
[description] =>
)
[valid:protected] =>
)
)
)
)
[23] => Array
(
[file] => /var/www/html/elgg/vendor/elgg/elgg/engine/classes/Elgg/ViewsService.php
[line] => 362
[args] => Array
(
[0] => /var/www/html/elgg/vendor/elgg/elgg/views/default/page/layouts/widgets.php
)
[function] => include
)
[24] => Array
(
[file] => /var/www/html/elgg/vendor/elgg/elgg/engine/classes/Elgg/ViewsService.php
[line] => 300
[function] => renderViewFile
[class] => Elgg\ViewsService
[type] => ->
[args] => Array
(
[0] => page/layouts/widgets
[1] => Array
(
[num_columns] => 2
[exact_match] => 1
[show_access] =>
[layout] => widgets
)
[2] => default
[3] => 1
)
)
[25] => Array
(
[file] => /var/www/html/elgg/vendor/elgg/elgg/engine/lib/views.php
[line] => 343
[function] => renderView
[class] => Elgg\ViewsService
[type] => ->
[args] => Array
(
[0] => page/layouts/widgets
[1] => Array
(
[num_columns] => 2
[exact_match] => 1
[show_access] =>
[layout] => widgets
)
[2] =>
[3] => default
)
)
[26] => Array
(
[file] => /var/www/html/elgg/vendor/elgg/elgg/engine/lib/views.php
[line] => 699
[function] => elgg_view
[args] => Array
(
[0] => page/layouts/widgets
[1] => Array
(
[num_columns] => 2
[exact_match] => 1
[show_access] =>
[layout] => widgets
)
)
)
[27] => Array
(
[file] => /var/www/html/elgg/vendor/elgg/elgg/views/default/admin/dashboard.php
[line] => 10
[function] => elgg_view_layout
[args] => Array
(
[0] => widgets
[1] => Array
(
[num_columns] => 2
[exact_match] => 1
[show_access] =>
)
)
)
[28] => Array
(
[file] => /var/www/html/elgg/vendor/elgg/elgg/engine/classes/Elgg/ViewsService.php
[line] => 362
[args] => Array
(
[0] => /var/www/html/elgg/vendor/elgg/elgg/views/default/admin/dashboard.php
)
[function] => include
)
[29] => Array
(
[file] => /var/www/html/elgg/vendor/elgg/elgg/engine/classes/Elgg/ViewsService.php
[line] => 300
[function] => renderViewFile
[class] => Elgg\ViewsService
[type] => ->
[args] => Array
(
[0] => admin/dashboard
[1] => Array
(
[page] => Array
(
[0] => dashboard
)
)
[2] => default
[3] => 1
)
)
[30] => Array
(
[file] => /var/www/html/elgg/vendor/elgg/elgg/engine/lib/views.php
[line] => 343
[function] => renderView
[class] => Elgg\ViewsService
[type] => ->
[args] => Array
(
[0] => admin/dashboard
[1] => Array
(
[page] => Array
(
[0] => dashboard
)
)
[2] =>
[3] => default
)
)
[31] => Array
(
[file] => /var/www/html/elgg/vendor/elgg/elgg/engine/lib/admin.php
[line] => 568
[function] => elgg_view
[args] => Array
(
[0] => admin/dashboard
[1] => Array
(
[page] => Array
(
[0] => dashboard
)
)
)
)
[32] => Array
(
[function] => _elgg_admin_page_handler
[args] => Array
(
[0] => Array
(
[0] => dashboard
)
[1] => admin
)
)
[33] => Array
(
[file] => /var/www/html/elgg/vendor/elgg/elgg/engine/classes/Elgg/Router.php
[line] => 95
[function] => call_user_func
[args] => Array
(
[0] => _elgg_admin_page_handler
[1] => Array
(
)
[2] => admin
)
)
[34] => Array
(
[file] => /var/www/html/elgg/vendor/elgg/elgg/engine/classes/Elgg/Application.php
[line] => 429
[function] => route
[class] => Elgg\Router
[type] => ->
[args] => Array
(
[0] => Elgg\Http\Request Object
(
[attributes] => Symfony\Component\HttpFoundation\ParameterBag Object
(
[parameters:protected] => Array
(
)
)
[request] => Symfony\Component\HttpFoundation\ParameterBag Object
(
[parameters:protected] => Array
(
)
)
[query] => Symfony\Component\HttpFoundation\ParameterBag Object
(
[parameters:protected] => Array
(
[__elgg_uri] => /admin
)
)
[server] => Symfony\Component\HttpFoundation\ServerBag Object
(
[parameters:protected] => Array
(
[REDIRECT_STATUS] => 200
[HTTP_HOST] => localhost
[HTTP_CONNECTION] => keep-alive
[HTTP_CACHE_CONTROL] => max-age=0
[HTTP_UPGRADE_INSECURE_REQUESTS] => 1
[HTTP_USER_AGENT] => Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/52.0.2743.116 Safari/537.36
[HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8
[HTTP_ACCEPT_ENCODING] => gzip, deflate, sdch
[HTTP_ACCEPT_LANGUAGE] => en-GB,en;q=0.8,en-US;q=0.6,it;q=0.4
[HTTP_COOKIE] => PHPSESSID=p71um5rub6nkkuqcd88adfbgq2; Elgg_install=niu1h3lsb4ph5oeok8b844a084; Elgg=7b1886hjn2434u5lei8mpbc934
[PATH] => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
[SERVER_SIGNATURE] => <address>Apache/2.4.18 (Ubuntu) Server at localhost Port 80</address>
[SERVER_SOFTWARE] => Apache/2.4.18 (Ubuntu)
[SERVER_NAME] => localhost
[SERVER_ADDR] => 127.0.0.1
[SERVER_PORT] => 80
[REMOTE_ADDR] => 127.0.0.1
[DOCUMENT_ROOT] => /var/www/html
[REQUEST_SCHEME] => http
[CONTEXT_PREFIX] =>
[CONTEXT_DOCUMENT_ROOT] => /var/www/html
[SERVER_ADMIN] => webmaster@localhost
[SCRIPT_FILENAME] => /var/www/html/elgg/index.php
[REMOTE_PORT] => 44748
[REDIRECT_URL] => /elgg/admin
[REDIRECT_QUERY_STRING] => __elgg_uri=admin
[GATEWAY_INTERFACE] => CGI/1.1
[SERVER_PROTOCOL] => HTTP/1.1
[REQUEST_METHOD] => GET
[QUERY_STRING] => __elgg_uri=admin
[REQUEST_URI] => /elgg/admin
[SCRIPT_NAME] => /elgg/index.php
[PHP_SELF] => /elgg/index.php
[REQUEST_TIME_FLOAT] => 1473092240.915
[REQUEST_TIME] => 1473092240
)
)
[files] => Symfony\Component\HttpFoundation\FileBag Object
(
[parameters:protected] => Array
(
)
)
[cookies] => Symfony\Component\HttpFoundation\ParameterBag Object
(
[parameters:protected] => Array
(
[PHPSESSID] => p71um5rub6nkkuqcd88adfbgq2
[Elgg_install] => niu1h3lsb4ph5oeok8b844a084
[Elgg] => 7b1886hjn2434u5lei8mpbc934
)
)
[headers] => Symfony\Component\HttpFoundation\HeaderBag Object
(
[headers:protected] => Array
(
[host] => Array
(
[0] => localhost
)
[connection] => Array
(
[0] => keep-alive
)
[cache-control] => Array
(
[0] => max-age=0
)
[upgrade-insecure-requests] => Array
(
[0] => 1
)
[user-agent] => Array
(
[0] => Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/52.0.2743.116 Safari/537.36
)
[accept] => Array
(
[0] => text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8
)
[accept-encoding] => Array
(
[0] => gzip, deflate, sdch
)
[accept-language] => Array
(
[0] => en-GB,en;q=0.8,en-US;q=0.6,it;q=0.4
)
[cookie] => Array
(
[0] => PHPSESSID=p71um5rub6nkkuqcd88adfbgq2; Elgg_install=niu1h3lsb4ph5oeok8b844a084; Elgg=7b1886hjn2434u5lei8mpbc934
)
)
[cacheControl:protected] => Array
(
[max-age] => 0
)
)
[content:protected] =>
[languages:protected] =>
[charsets:protected] =>
[encodings:protected] =>
[acceptableContentTypes:protected] =>
[pathInfo:protected] =>
[requestUri:protected] => /elgg/admin
[baseUrl:protected] =>
[basePath:protected] =>
[method:protected] =>
[format:protected] =>
[session:protected] =>
[locale:protected] =>
[defaultLocale:protected] => en
)
)
)
[35] => Array
(
[file] => /var/www/html/elgg/vendor/elgg/elgg/engine/classes/Elgg/Application.php
[line] => 377
[function] => run
[class] => Elgg\Application
[type] => ->
[args] => Array
(
)
)
[36] => Array
(
[file] => /var/www/html/elgg/index.php
[line] => 8
[function] => index
[class] => Elgg\Application
[type] => ::
[args] => Array
(
)
)
)
[previous:Exception:private] =>
)
info@elgg.org
Security issues should be reported to security@elgg.org!
©2014 the Elgg Foundation
Elgg is a registered trademark of Thematic Networks.
Cover image by Raül Utrera is used under Creative Commons license.
Icons by Flaticon and FontAwesome.
- İşöğüçı@Sinan

İşöğüçı - 0 likes
- Mick@mikamatto

Mick - 0 likes
- iionly@iionly

iionly - 1 like
- Mick@mikamatto

Mick - 1 like
You must log in to post replies.This seems to be the case covered in the thread below which hints Elgg not being fully MySQL 5.7 compatible and a workaround is mentioned:
https://elgg.org/discussion/view/2499115/installation-with-composer-and-problem-with-admin
Thank you, I googled that and couldn't find results, but I should have better checked here as well.
Should I delete this then?
Thanks again
There's a fix waiting to be merged that might be included in the next release of Elgg 2.2. You can try to fix your Elgg installation by making the necessary change in the code manually. It's only one file that needs to be modified. See https://github.com/Elgg/Elgg/pull/10121/files.
Though I can't promise that your Elgg installation will really work without any other issues on MySQL 5.7 with only this change alone.
Thank you!