error/moodle/invalidqueryparam: Difference between revisions
From MoodleDocs
Helen Foster (talk | contribs) (stub template, category) |
m (added link to spanish translation of page) |
||
(One intermediate revision by one other user not shown) | |||
Line 2: | Line 2: | ||
[[Category:Error|Invalidqueryparam]] | [[Category:Error|Invalidqueryparam]] | ||
One possible cause of this error is a call like | |||
<code> | |||
$DB->get_records_sql($sql, $params) | |||
</code> | |||
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. | |||
[[es:error/moodle/invalidqueryparam]] |
Latest revision as of 19:17, 10 August 2014
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.