WisdmLabs / moodle-local_edwiserreports-free

GNU General Public License v3.0
4 stars 7 forks source link

Error reading from database #3

Open mudrd8mz opened 4 years ago

mudrd8mz commented 4 years ago

Attempting to display more info gives me fatal SQL error on PostgreSQL

Debug info: ERROR: argument of WHERE must be type boolean, not type bigint
LINE 1: SELECT * FROM m_course_categories WHERE id
^
SELECT * FROM m_course_categories WHERE id
[array (
)]
Error code: dmlreadexception
Stack trace:

    line 486 of /lib/dml/moodle_database.php: dml_read_exception thrown
    line 329 of /lib/dml/pgsql_native_moodle_database.php: call to moodle_database->query_end()
    line 920 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->query_end()
    line 1453 of /lib/dml/moodle_database.php: call to pgsql_native_moodle_database->get_records_sql()
    line 202 of /local/edwiserreports/locallib.php: call to moodle_database->get_records_select()
    line 299 of /local/edwiserreports/classes/output/renderable.php: call to local_edwiserreports_get_cohort_filter()
    line 238 of /lib/outputrenderers.php: call to local_edwiserreports\output\coursereport_renderable->export_for_template()
    line 481 of /lib/outputrenderers.php: call to renderer_base->render()
    line 65 of /local/edwiserreports/coursereport.php: call to plugin_renderer_base->render()
abhishekkaradbhuje commented 3 years ago

Fixed in all blocks and more pages. Compatible with MySql, Mariadb, PostgreSQL, Oracle and MSSQL.