oohoo / moodle-block_course_search Goto Github PK

This error consistently occurs with the latest version of Moodle 2.4.
Using postgres 9.1

Debug info: ERROR: argument of OR must be type boolean, not type integer
LINE 1: SELECT * FROM mdl_assign WHERE course=$1 AND (0 OR name LIK...
^

SELECT * FROM mdl_assign WHERE course=$1 AND (0 OR name LIKE $2 OR intro LIKE $3)
[array (
0 => 1,
1 => '%test%',
2 => '%test%',
)]

Error code: dmlreadexception

Stack trace:
line 426 of /lib/dml/moodle_database.php: dml_read_exception thrown
line 248 of /lib/dml/pgsql_native_moodle_database.php: call to moodle_database->query_end()
line 753 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->query_end()
line 72 of /blocks/course_search/lib.php: call to pgsql_native_moodle_database->get_records_sql()
line 60 of /blocks/course_search/results.php: call to block_course_search_search_module()

Postgres specific fix:

diff --git a/blocks/course_search/lib.php b/blocks/course_search/lib.php
index 5a1aac1..7ce837d 100644
--- a/blocks/course_search/lib.php
+++ b/blocks/course_search/lib.php
@@ -31,7 +31,7 @@ function block_course_search_search_module($courseid, $module, $q)
global $CFG, $DB, $OUTPUT;

     $ret = '';
-    $sqlWere = 'course=? AND (0';
+    $sqlWere = 'course=? AND (false';
     $sqlParams = array($courseid);
     //At least one search field is needed
     $onefield = false;

Error reading from database

More information about this error
Debug info: Unknown column 'mdl_tab.intro' in 'field list'
SELECT mdl_tab_content.id as tabcontentid, mdl_tab.id as id,mdl_tab.name, mdl_tab.intro, mdl_tab.course, mdl_tab_content.tabname, mdl_tab_content.tabcontent
FROM mdl_tab_content
INNER JOIN mdl_tab ON mdl_tab_content.tabid = mdl_tab.id AND mdl_tab.course = ?
WHERE mdl_tab.name LIKE ? OR mdl_tab.intro LIKE ?
OR mdl_tab_content.tabname LIKE ? OR mdl_tab_content.tabcontent LIKE ?
[array (
0 => 1,
1 => '%lookup%',
2 => '%lookup%',
3 => '%lookup%',
4 => '%lookup%',
)]
Error code: dmlreadexception
Stack trace:

line 426 of \lib\dml\moodle_database.php: dml_read_exception thrown
line 1023 of \lib\dml\mysqli_native_moodle_database.php: call to moodle_database->query_end()
line 196 of \blocks\course_search\lib.php: call to mysqli_native_moodle_database->get_records_sql()
line ? of unknownfile: call to block_course_search_search_module_tab()
line 56 of \blocks\course_search\results.php: call to call_user_func()

Hi,

I was just wondering if you have any plans or interest in updating this plugin?

Best regards,

Michael