Enrollments

Waiting List Statistics Configuration

This page allows you to manage the enrollments of your students.

Exception: Column 'contact_last_name' in ORDER BY is ambiguous

Database Query Error (1052)

Debug Info:
- Query: 'SELECT * FROM af_enrollments LEFT JOIN `commerce_sales_items` USING(`sale_item_id`) LEFT JOIN `commerce_sales` USING(`sale_id`) LEFT JOIN `customers_contacts` ON (`af_enrollments`.`contact_id` = `customers_contacts`.`contact_id`) LEFT JOIN `af_courses` USING(`course_id`) WHERE `course_id` IN ( SELECT course_id FROM af_courses WHERE `course_id` IN ( SELECT `course_id` FROM `af_courses` WHERE (`course_end_date` >= \'2026-11-04\') ) ) ORDER BY `contact_last_name` desc, `enrollment_id` desc LIMIT 0, 26'

in Page /admin/af/enrollments/ line 3

in /usr/lib/php/Oncord/beta/Framework/Database/Connectors/MySQL/MySQL.inc.php line 1040

Call Stack

Tag / Object	Function	Called From
		#1040 MySQL.inc.php
Framework\Database\Connectors\MySQL	Framework\Database\Connectors\MySQL::query('SELECT * FROM af_enrollments LEFT JOIN `commerce_sales_items` USING(`sale_item_id`) LEFT JOIN `commerce_sales` USING(`sale_id`) LEFT JOIN `customers_contacts` ON (`af_enrollments`.`contact_id` = `customers_contacts`.`contact_id`) LEFT JOIN `af_courses` USING(`course_id`) WHERE `course_id` IN ( SELECT course_id FROM af_courses WHERE `course_id` IN ( SELECT `course_id` FROM `af_courses` WHERE (`course_end_date` >= '2026-11-04') ) ) ORDER BY `contact_last_name` desc, `enrollment_id` desc LIMIT 0, 26')	#1067 MySQL.inc.php
Framework\Database\Connectors\MySQL	Framework\Database\Connectors\MySQL::queryAllRows('SELECT * FROM af_enrollments LEFT JOIN `commerce_sales_items` USING(`sale_item_id`) LEFT JOIN `commerce_sales` USING(`sale_id`) LEFT JOIN `customers_contacts` ON (`af_enrollments`.`contact_id` = `customers_contacts`.`contact_id`) LEFT JOIN `af_courses` USING(`course_id`) WHERE `course_id` IN ( SELECT course_id FROM af_courses WHERE `course_id` IN ( SELECT `course_id` FROM `af_courses` WHERE (`course_end_date` >= '2026-11-04') ) ) ORDER BY `contact_last_name` desc, `enrollment_id` desc LIMIT 0, 26')	#2765 DataABC.inc.php
	Framework\Components\DataABC::{closure:Framework\Components\DataABC::dbGetAll():2765}()	#2839 DataABC.inc.php
Framework\Database\Connectors\MySQL	Framework\Components\DataABC::dbGetAllRun(Object:Closure)	#2765 DataABC.inc.php
	Framework\Components\DataABC::dbGetAll(Array[5])	#2617 DataABC.inc.php
	Framework\Components\DataABC::getAll(Array[4])	#548 Enrollments.inc.php
	Components\AF\Enrollments::getAll(Array[4])	Custom PHP
	call_user_func_array(Array[2], Array[1])	#148 FnCall.inc.php
getAll(array ( 'joins' => array ( 0 => array ( 0 => 'commerce_sales_items', 1 => 'sale_item_id', ), 1 => array ( 0 => 'commerce_sales', 1 => 'sale_id', ), 2 => array ( 0 => 'customers_contacts', 1 => array ( 0 => 'contact_id', 1 => 'contact_id', ), ), 3 => array ( 0 => 'af_courses', 1 => 'course_id', ), ), 'condition' => array ( 0 => array ( 'class' => '\\Framework\\Database\\FieldMatchInSubQuery', 'args' => array ( 'class' => '\\Components\\AF\\Courses', 'field' => 'course_id', 'query' => array ( 'class' => '\\Framework\\Database\\FieldTest', 'args' => array ( 'value' => '2026-11-04', 'operator' => '>=', 'field' => 'course_end_date', ), ), ), ), ), 'order' => array ( 0 => array ( 0 => 'contact_last_name', 1 => 'desc', ), ), 'limit' => 26, ))	Scr\FnCall::evaluate('\Components\AF\Enrollments')	#62 OpStatic.inc.php
\Components\AF\Enrollments::getAll(array ( 'joins' => array ( 0 => array ( 0 => 'commerce_sales_items', 1 => 'sale_item_id', ), 1 => array ( 0 => 'commerce_sales', 1 => 'sale_id', ), 2 => array ( 0 => 'customers_contacts', 1 => array ( 0 => 'contact_id', 1 => 'contact_id', ), ), 3 => array ( 0 => 'af_courses', 1 => 'course_id', ), ), 'condition' => array ( 0 => array ( 'class' => '\\Framework\\Database\\FieldMatchInSubQuery', 'args' => array ( 'class' => '\\Components\\AF\\Courses', 'field' => 'course_id', 'query' => array ( 'class' => '\\Framework\\Database\\FieldTest', 'args' => array ( 'value' => '2026-11-04', 'operator' => '>=', 'field' => 'course_end_date', ), ), ), ), ), 'order' => array ( 0 => array ( 0 => 'contact_last_name', 1 => 'desc', ), ), 'limit' => 26, ))	Scr\OpStatic::evaluate()	#674 DataControlABC.inc.php
# 3 <data:table>	Controls\Data\DataControlWithColumnsABC::initialize()	#456 NodeABC.inc.php
# 12 <ajax:region>	Framework\DOM\Nodes\NodeABC::initialize()	#456 NodeABC.inc.php
Page: /admin/af/enrollments/
<logic:include page="/admin/af/enrollments/">	Controls\Logic\SSInclude::initialize()	#141 Content.inc.php
# 51 <regions:content>	Controls\Regions\Content::initialize()	#456 NodeABC.inc.php
# 79 <ajax:region>	Controls\AJAX\Region::initialize()	#456 NodeABC.inc.php
# 35 <logic:else>	Controls\Logic\SSIfElse::initialize()	#456 NodeABC.inc.php
# 33 <logic:if>	Controls\Logic\SSIf::initialize()	#456 NodeABC.inc.php
Design: Website Management Console
#document	Framework\DOM\Nodes\NodeABC::initialize()	#1404 functions.inc.php

	Enrollment	Student	Course	Payment	Assessment
No enrollments found.

Export Data