More information about this error
Debug info: BŁĄD: dla SELECT DISTINCT, ORDER BY wyrażenia muszą występować na liście wyboru
LINE 1: ...mdl_question_answers WHERE question=1865 ORDER BY fraction D...
^
SELECT DISTINCT answer FROM mdl_question_answers WHERE question=1865 ORDER BY fraction DESC
[array (
)]
Error code: dmlreadexception
Stack trace:
line 486 of /lib/dml/moodle_database.php: dml_read_exception thrown
line 242 of /lib/dml/pgsql_native_moodle_database.php: call to moodle_database->query_end()
line 778 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->query_end()
line 233 of /mod/game/check.php: call to pgsql_native_moodle_database->get_records_sql()
line 171 of /mod/game/check.php: call to game_check_common_problems_shortanswer_question()
line 49 of /mod/game/check.php: call to game_check_common_problems_shortanswer()
line 336 of /mod/game/view.php: call to game_check_common_problems()
While entering the cryptex db error occures:
More information about this error Debug info: BŁĄD: dla SELECT DISTINCT, ORDER BY wyrażenia muszą występować na liście wyboru LINE 1: ...mdl_question_answers WHERE question=1865 ORDER BY fraction D... ^ SELECT DISTINCT answer FROM mdl_question_answers WHERE question=1865 ORDER BY fraction DESC [array ( )] Error code: dmlreadexception Stack trace:
We use postgresql db.
Best regards Adam