Please Login

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_price_base' in 'ORDER BY'

Database Query Error (1054)

Debug Info:
- Query: 'SELECT * FROM af_private_courses_packages ORDER BY `product_price_base` asc, `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_price_base` asc, `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_price_base` asc, `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_price_base', 1 => 'asc', ), ), '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_price_base', 1 => 'asc', ), ), '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
Page: /errors/admin-403/
# 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