Error reading from database
Debug info: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND
(lc.partner_name=''
OR lc.partner_name' at line 3
SELECT c.id,c.fullname,sm.cpid FROM mdl_course c JOIN mdl_center_status cs ON c.id=cs.courseid JOIN
mdl_schememangement_mapping sm ON sm.courseid=cs.courseid join mdl_local_course_partners lc
on sm.cpid=lc.id WHERE sm.schemeid='' AND c.id= AND
(lc.partner_name=''
OR lc.partner_name = ' ') ORDER BY c.fullname ASC
[array (
)]
Error code: dmlreadexception
(lc.partner_name=''
OR lc.partner_name' at line 3
SELECT c.id,c.fullname,sm.cpid FROM mdl_course c JOIN mdl_center_status cs ON c.id=cs.courseid JOIN
mdl_schememangement_mapping sm ON sm.courseid=cs.courseid join mdl_local_course_partners lc
on sm.cpid=lc.id WHERE sm.schemeid='' AND c.id= AND
(lc.partner_name=''
OR lc.partner_name = ' ') ORDER BY c.fullname ASC
[array (
)]
Error code: dmlreadexception
Stack trace:
- line 486 of /lib/dml/moodle_database.php: dml_read_exception thrown
- line 1247 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
- line 23 of /local/schememanagement/create_center.php: call to mysqli_native_moodle_database->get_records_sql()
- line 206 of /lib/formslib.php: call to Create_center->definition()
- line 34 of /local/schememanagement/coursecenter.php: call to moodleform->__construct()