error/moodle/invalidqueryparam: Difference between revisions
From MoodleDocs
m added link to spanish translation of page |
Tim Bahula 2 (talk | contribs) <syntaxhighlight lang="PHP"> |
||
| Line 5: | Line 5: | ||
One possible cause of this error is a call like | One possible cause of this error is a call like | ||
< | <syntaxhighlight lang="PHP"> | ||
$DB->get_records_sql($sql, $params) | $DB->get_records_sql($sql, $params) | ||
</ | </syntaxhighlight> | ||
where the SQL query, $sql, contains several '?' which are to | where the SQL query, $sql, contains several '?' which are to be substituted by $params, | ||
but fewer parameters than '?' are supplied. | but fewer parameters than '?' are supplied. | ||
Check that $params was not created using | Check that $params was not created using unexpected 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]] | [[es:error/moodle/invalidqueryparam]] | ||
Latest revision as of 15:45, 22 May 2025
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 be substituted by $params, but fewer parameters than '?' are supplied. Check that $params was not created using unexpected NULL values. get_records_sql() is defined in 'lib/dml/*_native_moodle_database.php', depending on which database you are using.
