error/moodle/invalidqueryparam: Difference between revisions
From MoodleDocs
m (added link to spanish translation of page) |
Tim Bahula 2 (talk | contribs) m (→top: clean up, typos fixed: , $ → $,) |
||
Line 9: | Line 9: | ||
</code> | </code> | ||
where the SQL query, | where the SQL query$, sql, contains several '?' which are to by substituted by $params, | ||
but fewer parameters than '?' are supplied. | but fewer parameters than '?' are supplied. | ||
Check that $params was not created using unexpexted NULL values. | Check that $params was not created using unexpexted NULL values. |
Revision as of 15:24, 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.