Instructions:
  1. 1) Create Account
  2. 2) Course Enrollment
  3. 3) Access Course
  4. 4) Course Rating
  • user warning: 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 'OPTION SQL_BIG_SELECTS=1' at line 1 query: SET OPTION SQL_BIG_SELECTS=1 in /home2/psilearn/public_html/sites/all/modules/customsqlview/customsqlview.module on line 291.
  • user warning: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay query: SELECT COUNT(*) FROM (SELECT node.nid AS nid, node.title AS node_title, votingapi_cache_node_percent_vote_average.value AS votingapi_cache_node_percent_vote_average_value, node_data_field_category.field_category_value AS node_data_field_category_field_category_value, node.type AS node_type, node.vid AS node_vid, node_data_field_category.field_course_level_value AS node_data_field_category_field_course_level_value, node_data_field_category.field_hours_value AS node_data_field_category_field_hours_value, node.created AS node_created ,CASE WHEN drup_enrolment.stract_status IS NOT NULL THEN 'completed' WHEN drup_enrolment.review_status IS NOT NULL THEN 'enrolled_completed' WHEN drup_enrolment.tract_status IS NOT NULL THEN 'enrolled_tcompleted' WHEN drup_enrolment.content_status IS NOT NULL THEN 'enrolled_rated' WHEN drup_enrolment.enrol_id IS NOT NULL AND drup_enrolment.content_status IS NULL THEN 'enrolled_started' WHEN drup_enrolment.enrol_id IS NULL AND eligibility.status = 0 THEN 'eligible' ELSE 'ineligible' END AS enrollment_status, drup_enrolment.enrol_id, UNIX_TIMESTAMP(drup_enrolment.content_complete_date) AS date_complete, node_data_field_category.field_ccode_value as course_code,node_data_field_category.field_rosetta_value as rosetta,node_data_field_category.field_ecornell_value as ecornel FROM drup_node node LEFT JOIN drup_votingapi_cache votingapi_cache_node_percent_vote_average ON node.nid = votingapi_cache_node_percent_vote_average.content_id AND (votingapi_cache_node_percent_vote_average.content_type = 'node' AND votingapi_cache_node_percent_vote_average.value_type = 'percent' AND votingapi_cache_node_percent_vote_average.tag = 'vote' AND votingapi_cache_node_percent_vote_average.function = 'average') LEFT JOIN drup_content_type_course node_data_field_category ON node.vid = node_data_field_category.vid LEFT JOIN drup_enrolment ON drup_enrolment.courseid = node_data_field_category.field_ccode_value AND drup_enrolment.username = '' INNER JOIN ( SELECT COUNT(*) AS 'status' FROM drup_enrolment WHERE review_status IS NULL AND username='') eligibility WHERE (node.type in ('course')) AND (node.status <> 0) ) count_alias in /home2/psilearn/public_html/sites/all/modules/views/includes/view.inc on line 745.
  • user warning: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay query: SELECT node.nid AS nid, node.title AS node_title, votingapi_cache_node_percent_vote_average.value AS votingapi_cache_node_percent_vote_average_value, node_data_field_category.field_category_value AS node_data_field_category_field_category_value, node.type AS node_type, node.vid AS node_vid, node_data_field_category.field_course_level_value AS node_data_field_category_field_course_level_value, node_data_field_category.field_hours_value AS node_data_field_category_field_hours_value, node.created AS node_created ,CASE WHEN drup_enrolment.stract_status IS NOT NULL THEN 'completed' WHEN drup_enrolment.review_status IS NOT NULL THEN 'enrolled_completed' WHEN drup_enrolment.tract_status IS NOT NULL THEN 'enrolled_tcompleted' WHEN drup_enrolment.content_status IS NOT NULL THEN 'enrolled_rated' WHEN drup_enrolment.enrol_id IS NOT NULL AND drup_enrolment.content_status IS NULL THEN 'enrolled_started' WHEN drup_enrolment.enrol_id IS NULL AND eligibility.status = 0 THEN 'eligible' ELSE 'ineligible' END AS enrollment_status, drup_enrolment.enrol_id, UNIX_TIMESTAMP(drup_enrolment.content_complete_date) AS date_complete, node_data_field_category.field_ccode_value as course_code,node_data_field_category.field_rosetta_value as rosetta,node_data_field_category.field_ecornell_value as ecornel FROM drup_node node LEFT JOIN drup_votingapi_cache votingapi_cache_node_percent_vote_average ON node.nid = votingapi_cache_node_percent_vote_average.content_id AND (votingapi_cache_node_percent_vote_average.content_type = 'node' AND votingapi_cache_node_percent_vote_average.value_type = 'percent' AND votingapi_cache_node_percent_vote_average.tag = 'vote' AND votingapi_cache_node_percent_vote_average.function = 'average') LEFT JOIN drup_content_type_course node_data_field_category ON node.vid = node_data_field_category.vid LEFT JOIN drup_enrolment ON drup_enrolment.courseid = node_data_field_category.field_ccode_value AND drup_enrolment.username = '' INNER JOIN ( SELECT COUNT(*) AS 'status' FROM drup_enrolment WHERE review_status IS NULL AND username='') eligibility WHERE (node.type in ('course')) AND (node.status <> 0) ORDER BY CASE enrollment_status WHEN 'eligible' THEN 1 WHEN 'enrolled_started' THEN 2 WHEN 'enrolled_rated' THEN 3 WHEN 'enrolled_completed' THEN 4 WHEN 'enrolled_tcompleted' THEN 5 WHEN 'completed' THEN 6 WHEN 'ineligible' THEN 7 ELSE 99 END, node_created DESC LIMIT 0, 10 in /home2/psilearn/public_html/sites/all/modules/views/includes/view.inc on line 771.

Catalog of Courses