Error reading from database Debug: ORA-00907: missing right parenthesis
SELECT COUNT(quizid) FROM ((SELECT qz.id as quizid,
                           qz.name as modulename,
                           qz.course as courseid
                      FROM b1quiz as qz
                      JOIN b1quiz_attempts qa ON qa.quiz = qz.id
                      JOIN b1question_usages qu ON qu.id = qa.uniqueid
                      JOIN b1question_attempts qatt ON qatt.questionusageid = qu.id
                      JOIN b1question q ON q.id = qatt.questionid
                      WHERE qa.preview = 0
                        AND q.id = :o_param1)
                    UNION
                    (SELECT qz.id as quizid,
                           qz.name as modulename,
                           qz.course as courseid
                      FROM b1quiz_slots slot
                      JOIN b1quiz qz ON qz.id = slot.quizid
                     WHERE slot.questionid = :o_param2)) AS quizid
[array (
  'o_param1' => '1',
  'o_param2' => '1',
)]
Error code: dmlreadexception
* line 486 of /lib/dml/moodle_database.php: dml_read_exception thrown
* line 277 of /lib/dml/oci_native_moodle_database.php: call to moodle_database->query_end()
* line 1156 of /lib/dml/oci_native_moodle_database.php: call to oci_native_moodle_database->query_end()
* line 1671 of /lib/dml/moodle_database.php: call to oci_native_moodle_database->get_records_sql()
* line 1086 of /lib/dml/oci_native_moodle_database.php: call to moodle_database->get_record_sql()
* line 1744 of /lib/dml/moodle_database.php: call to oci_native_moodle_database->get_record_sql()
* line 1954 of /lib/dml/moodle_database.php: call to moodle_database->get_field_sql()
* line 40 of /question/bank/usage/classes/helper.php: call to moodle_database->count_records_sql()
* line 41 of /question/bank/usage/classes/question_usage_column.php: call to qbank_usage\\helper::get_question_entry_usage_count()
* line 207 of /question/classes/local/bank/column_base.php: call to qbank_usage\\question_usage_column->display_content()
* line 1163 of /question/classes/local/bank/view.php: call to core_question\\local\\bank\\column_base->display()
* line 1083 of /question/classes/local/bank/view.php: call to core_question\\local\\bank\\view->print_table_row()
* line 1059 of /question/classes/local/bank/view.php: call to core_question\\local\\bank\\view->print_table()
* line 941 of /question/classes/local/bank/view.php: call to core_question\\local\\bank\\view->display_questions()
* line 711 of /question/classes/local/bank/view.php: call to core_question\\local\\bank\\view->display_question_list()
* line 55 of /question/edit.php: call to core_question\\local\\bank\\view->display()
, referer: http://webserver47c3e0b7b7113b09/behatrun1/mod/quiz/view.php?id=1