Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Installing in moodle 3.0 when adding a use stats block to dashboard I get the following error #8

Open
jrivastorres opened this issue Oct 3, 2016 · 0 comments

Comments

@jrivastorres
Copy link

Debug info: ERROR: la columna «ue.id» debe aparecer en la cláusula GROUP BY o ser usada en una función de agregación
LINE 3: ue.id,
^

SELECT
ue.id,
MIN(timestart) as timestart
FROM
mdl_enrol e,
mdl_user_enrolments ue
WHERE

e.id = ue.enrolid AND
(ue.timeend = 0 OR ue.timeend > 1475507691)
AND userid = 2

[array (
)]
Error code: dmlreadexception
Stack trace:

line 443 of /lib/dml/moodle_database.php: dml_read_exception thrown
line 244 of /lib/dml/pgsql_native_moodle_database.php: call to moodle_database->query_end()
line 785 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->query_end()
line 1480 of /lib/dml/moodle_database.php: call to pgsql_native_moodle_database->get_records_sql()
line 120 of /blocks/use_stats/locallib.php: call to moodle_database->get_record_sql()
line 155 of /blocks/use_stats/block_use_stats.php: call to use_stats_extract_logs()
line 288 of /blocks/moodleblock.class.php: call to block_use_stats->get_content()
line 230 of /blocks/moodleblock.class.php: call to block_base->formatted_contents()
line 973 of /lib/blocklib.php: call to block_base->get_content_for_output()
line 1025 of /lib/blocklib.php: call to block_manager->create_block_contents()
line 476 of /lib/outputrenderers.php: call to block_manager->ensure_content_created()
line 39 of /theme/bootstrapbase/renderers/core_renderer.php: call to core_renderer->standard_head_html()
line 52 of /theme/clean/layout/columns3.php: call to theme_bootstrapbase_core_renderer->standard_head_html()
line 1018 of /lib/outputrenderers.php: call to include()
line 948 of /lib/outputrenderers.php: call to core_renderer->render_page_layout()
line 164 of /my/index.php: call to core_renderer->header()

This happens with postgressql 9.5 but doesn't happen with mysql 14.14.

@jrivastorres jrivastorres changed the title Installing in moodle 3.0 when adding a use stack block to dashboard I get the following error Installing in moodle 3.0 when adding a use stats block to dashboard I get the following error Oct 3, 2016
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant