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 '' at line 21
SELECT @a:=@a+1 AS slno,u.id AS userid, CONCAT(u.firstname, ' ', u.lastname) AS userfullname, u.email, u.phone1 AS registerednumber,
DATE_FORMAT(CONVERT_TZ(FROM_UNIXTIME(ue.timecreated, '%Y-%m-%d %H:%i:%s'), @@session.time_zone, 'Asia/Kolkata'), '%d %M %Y %H:%i') AS enrolledon,
IF(lbt.purchase_date IS NULL, 'NA', DATE_FORMAT(CONVERT_TZ(FROM_UNIXTIME(lbt.purchase_date, '%Y-%m-%d %H:%i:%s'), @@session.time_zone, 'Asia/Kolkata'), '%d %M %Y %H:%i')) AS purchaseon,
(
SELECT lsl.timecreated
-- FROM mdl_logstore_standard_log lsl
FROM mdl_local_course_creator lsl
WHERE lsl.userid = ue.userid AND lsl.courseid = c.id
-- lsl.action = 'viewed' AND lsl.target = 'course' AND
ORDER BY lsl.id DESC LIMIT 0, 1
) AS t, IF((SELECT(t)) IS NULL, 'NA', DATE_FORMAT(CONVERT_TZ(FROM_UNIXTIME((SELECT(t)), '%Y-%m-%d %H:%i:%s'), @@session.time_zone, 'Asia/Kolkata'), '%d %M %Y %H:%i')) AS lastaccessedon,
IF (ue.timeend IS NULL OR ue.timeend = 0, 'NA', DATE_FORMAT(CONVERT_TZ(FROM_UNIXTIME(ue.timeend, '%Y-%m-%d %H:%i:%s'), @@session.time_zone, 'Asia/Kolkata'), '%d %M %Y %H:%i')) AS expirydate
FROM mdl_course c
JOIN mdl_enrol e ON e.courseid = c.id
JOIN mdl_user_enrolments ue ON ue.enrolid = e.id
JOIN mdl_user u ON u.id = ue.userid
LEFT JOIN mdl_local_course_creator lcc ON (lcc.userid = ue.userid AND lcc.courseid = c.id)
LEFT JOIN mdl_local_buykart_product lbp ON lbp.course_id = c.id
LEFT JOIN mdl_local_buykart_trans_item lbti ON lbti.product_id = lbp.id
JOIN mdl_local_buykart_transaction lbt ON lbt.id = lbti.transaction_id AND lbt.user_id = ue.userid AND lbt.status = 2, (SELECT @a:= 0) a
WHERE lcc.id IS NULL AND u.deleted = 0 AND c.id =
[array (
)]
Error code: dmlreadexception
SELECT @a:=@a+1 AS slno,u.id AS userid, CONCAT(u.firstname, ' ', u.lastname) AS userfullname, u.email, u.phone1 AS registerednumber,
DATE_FORMAT(CONVERT_TZ(FROM_UNIXTIME(ue.timecreated, '%Y-%m-%d %H:%i:%s'), @@session.time_zone, 'Asia/Kolkata'), '%d %M %Y %H:%i') AS enrolledon,
IF(lbt.purchase_date IS NULL, 'NA', DATE_FORMAT(CONVERT_TZ(FROM_UNIXTIME(lbt.purchase_date, '%Y-%m-%d %H:%i:%s'), @@session.time_zone, 'Asia/Kolkata'), '%d %M %Y %H:%i')) AS purchaseon,
(
SELECT lsl.timecreated
-- FROM mdl_logstore_standard_log lsl
FROM mdl_local_course_creator lsl
WHERE lsl.userid = ue.userid AND lsl.courseid = c.id
-- lsl.action = 'viewed' AND lsl.target = 'course' AND
ORDER BY lsl.id DESC LIMIT 0, 1
) AS t, IF((SELECT(t)) IS NULL, 'NA', DATE_FORMAT(CONVERT_TZ(FROM_UNIXTIME((SELECT(t)), '%Y-%m-%d %H:%i:%s'), @@session.time_zone, 'Asia/Kolkata'), '%d %M %Y %H:%i')) AS lastaccessedon,
IF (ue.timeend IS NULL OR ue.timeend = 0, 'NA', DATE_FORMAT(CONVERT_TZ(FROM_UNIXTIME(ue.timeend, '%Y-%m-%d %H:%i:%s'), @@session.time_zone, 'Asia/Kolkata'), '%d %M %Y %H:%i')) AS expirydate
FROM mdl_course c
JOIN mdl_enrol e ON e.courseid = c.id
JOIN mdl_user_enrolments ue ON ue.enrolid = e.id
JOIN mdl_user u ON u.id = ue.userid
LEFT JOIN mdl_local_course_creator lcc ON (lcc.userid = ue.userid AND lcc.courseid = c.id)
LEFT JOIN mdl_local_buykart_product lbp ON lbp.course_id = c.id
LEFT JOIN mdl_local_buykart_trans_item lbti ON lbti.product_id = lbp.id
JOIN mdl_local_buykart_transaction lbt ON lbt.id = lbti.transaction_id AND lbt.user_id = ue.userid AND lbt.status = 2, (SELECT @a:= 0) a
WHERE lcc.id IS NULL AND u.deleted = 0 AND c.id =
[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 43 of /local/contentprovider/enrolledusers.php: call to mysqli_native_moodle_database->get_records_sql()