Configuration

Configuration New Package View Online Categories

Create and modify private tuition packages of hours. When these packages are sold, private courses are created and have hours allocated to them.

Exception: Unknown column 'product_is_offline' in 'ORDER BY'

Database Query Error (1054)

Debug Info:
- Query: 'SELECT * FROM af_private_courses_packages ORDER BY `product_is_offline` desc, `package_order` asc, `package_is_remote` asc, `package_hours` asc LIMIT 0, 26'

in Page /admin/af/courses/configuration/packages/ line 4

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_private_courses_packages ORDER BY `product_is_offline` desc, `package_order` asc, `package_is_remote` asc, `package_hours` asc LIMIT 0, 26'*)	#1067 MySQL.inc.php
Framework\Database\Connectors\MySQL	Framework\Database\Connectors\MySQL::queryAllRows('SELECT FROM af_private_courses_packages ORDER BY `product_is_offline` desc, `package_order` asc, `package_is_remote` asc, `package_hours` asc 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[2])	#2617 DataABC.inc.php
	Framework\Components\DataABC::getAll(Array[2])	#403 Packages.inc.php
	Components\AF\Courses\PrivateCourses\Packages::getAll(Array[2])	Custom PHP
	call_user_func_array(Array[2], Array[1])	#148 FnCall.inc.php
getAll(array ( 'order' => array ( 0 => array ( 0 => 'product_is_offline', 1 => 'desc', ), ), 'limit' => 26, ))	Scr\FnCall::evaluate('\Components\AF\Courses\PrivateCourses\Packages')	#62 OpStatic.inc.php
\Components\AF\Courses\PrivateCourses\Packages::getAll(array ( 'order' => array ( 0 => array ( 0 => 'product_is_offline', 1 => 'desc', ), ), 'limit' => 26, ))	Scr\OpStatic::evaluate()	#674 DataControlABC.inc.php
# 4 <data:table>	Controls\Data\DataControlWithColumnsABC::initialize()	#456 NodeABC.inc.php
# 31 <ajax:region>	Framework\DOM\Nodes\NodeABC::initialize()	#456 NodeABC.inc.php
Page: /admin/af/courses/configuration/packages/
<logic:include page="/admin/af/courses/configuration/packages/">	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