error/moodle/invalidqueryparam: Difference between revisions
From MoodleDocs
(documented cause of my seeing the error) |
Tim Bahula 2 (talk | contribs) (Restored) |
||
(2 intermediate revisions by 2 users not shown) | |||
Line 13: | Line 13: | ||
Check that $params was not created using unexpexted NULL values. | Check that $params was not created using unexpexted NULL values. | ||
get_records_sql() is defined in 'lib/dml/*_native_moodle_database.php', depending on which database you are using. | get_records_sql() is defined in 'lib/dml/*_native_moodle_database.php', depending on which database you are using. | ||
[[es:error/moodle/invalidqueryparam]] |
Latest revision as of 15:28, 24 March 2022
One possible cause of this error is a call like
$DB->get_records_sql($sql, $params)
where the SQL query, $sql, contains several '?' which are to by substituted by $params, but fewer parameters than '?' are supplied. Check that $params was not created using unexpexted NULL values. get_records_sql() is defined in 'lib/dml/*_native_moodle_database.php', depending on which database you are using.