itsmejomijohn

how to solve this error

Here’s the query that causing the High CPU Usage

i find the query using ” ?Index WP MySQL For Speed” Plugin

SELECT DISTINCT quiz_attempts.*, quiz.post_title, users.user_email, users.user_login, users.display_name
FROM fgt_tutor_quiz_attempts quiz_attempts
INNER JOIN fgt_posts quiz ON quiz_attempts.quiz_id = quiz.ID
INNER JOIN fgt_users AS users ON quiz_attempts.user_id = users.ID
INNER JOIN fgt_posts AS course ON course.ID = quiz_attempts.course_id
INNER JOIN fgt_tutor_quiz_attempt_answers AS ans ON quiz_attempts.attempt_id = ans.quiz_attempt_id
WHERE quiz_attempts.attempt_ended_at IS NOT NULL
AND ( users.user_email = '' OR users.display_name LIKE '%%' OR quiz.post_title LIKE '%%' OR course.post_title LIKE '%%' )
AND quiz_attempts.attempt_ended_at IS NOT NULL
ORDER BY quiz_attempts.attempt_ended_at DESC
LIMIT 20 OFFSET 0

• This reply was modified 12 months ago by itsmejomijohn.

also created a chat and no response

i raised email to themium support but no response

Is this option available soon,
Because now when students even failed a quiz his course is shown as complete

So in the feature is this option will implement

Or any other solution

can student retake course if he failed first quiz

after adding the CSS it is not working

Issue Image

any course progress reset option available?

but after adding this CSS , user can view the next lesson without completing the quiz

so what to do if quiz reattempt limit reached, like i set quiz reattempt limit 4 and the student failed 4 times, then how he move to the next lesson without completing the quiz