Note: You are currently viewing documentation for Moodle 2.9. Up-to-date documentation for the latest stable version of Moodle may be available here: error/moodle/invalidqueryparam.

error/moodle/invalidqueryparam: Difference between revisions

From MoodleDocs
(New page: Amy Stack Page '''interactive Media''')
 
m (added link to spanish translation of page)
 
(3 intermediate revisions by 3 users not shown)
Line 1: Line 1:
[[Amy Stack Page]]
{{stub}}
'''interactive Media'''
 
[[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.