Debug info: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND start_date = "2021-03-28" AND ((start_time between 1616524200 AND 1616610540' at line 1
SELECT * FROM mdl_course_schedule WHERE cohortid = 2 AND room_no = AND start_date = "2021-03-28" AND ((start_time between 1616524200 AND 1616610540) OR (end_time between 1616524200 AND 1616610540)) AND start_time <> 1616610540 AND end_time <> 1616524200
[array (
)]
Error code: dmlreadexception
Stack trace: - line 423 of /lib/dml/moodle_database.php: dml_read_exception thrown
- line 1005 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
- line 329 of /schedule/view_schedule.php: call to mysqli_native_moodle_database->get_records_sql()
Output buffer: <option value="928">DF-2204-CM</option><option value="927">Coursewise Recordings</option><option value="839">DP-2111-OM</option><option value="622">Alumni Students</option><option value="613">DP-2109-OM</option><option value="595">DF-2109-CM</option><option value="594">CF-2106-CM</option><option value="593">DP-2104-OM</option><option value="574">DF-2103-CM</option><option value="537">CF-2010-CM</option><option value="536">CP-2010-OM</option><option value="514">DP-2009-OM</option><option value="513">CF-2009-CM</option><option value="512">DF-2009-CM</option><option value="506">DP-2008-OM</option><option value="494">CP-2006-OM</option><option value="400">DP-2005-OM</option><option value="387">AF-2002-CM</option><option value="376">CF-2001-CB</option><option value="375">CF-2001-CM</option><option value="374">DF-2002-CB</option><option value="373">DP-2001-HM</option><option value="365">DF-2002-CM</option><option value="289">DP-2001-CP</option><option value="286">CF-1909-CM</option><option value="285">DP-1909-HM</option><option value="284">DF-1909-CB</option><option value="279">DF1909-CM</option><option value="272">CP-2002-HB</option><option value="271">CF-1908-CB</option><option value="235">DP2001-CB</option><option value="233">DP1904-HM </option><option value="229">CP-1901-CB</option><option value="227">AF-1902-CM</option><option value="226">DF1903-CM</option><option value="222">CF-1809-CB</option><option value="220">DP1812-CP</option><option value="219">DP1812-HM</option><option value="155">DF1809-CM</option><option value="116">DP1812-CB</option><option value="115">DP1806-CP</option><option value="114">DP1806-HM</option><option value="83">DP1712-CB</option><option value="82">DP1801-CP</option><option value="81">DP1801-HM</option><option value="80">DF1803-CM</option><option value="28">DP1507-HM</option><option value="27">DP1709-CP</option><option value="26">DP1709-CB</option><option value="25">DP1709-HM</option><option value="24">DF1709-CM</option><option value="23">DP1505-HM</option><option value="22">DF1501-CM</option><option value="21">DF1504-CM</option><option value="20">DP1509-HM</option><option value="18">DP1704-HM</option><option value="17">DP1704-CB</option><option value="16">DP1702-HP</option><option value="15">DP1612-HM</option><option value="14">DP1501-OM</option><option value="13">Demo Batch</option><option value="12">DP1512-HM</option><option value="10">DF1703-CM</option><option value="9">DF1509-CM</option><option value="8">DF1602-CM</option><option value="7">DP1609-CP</option><option value="6">DP1607-HM</option><option value="5">DF1609-CM</option><option value="3">DP1604-HM</option></select></div>
<div class="col-sm-2" style="padding:0px 15px 10px 0px;">
<a class="form-control" href="javascript:void();" onClick="clearFilter();" >Clear Filter</a>
</div>
</div>