SMS Marketing

Unsubscribers for message Change of class day - this week only!

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

Database Query Error (1054)

Debug Info:
- Query: 'SELECT * FROM marketing_smsmarketing_unsubscribers WHERE (`sms_id` = 20) ORDER BY `sms_inbound_receipt_datetime` desc, `sms_unsubscriber_datetime` desc LIMIT 0, 26'

in Page /admin/marketing/smsmarketing/unsubscribers/ 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 marketing_smsmarketing_unsubscribers WHERE (`sms_id` = 20) ORDER BY `sms_inbound_receipt_datetime` desc, `sms_unsubscriber_datetime` desc LIMIT 0, 26'*)	#1067 MySQL.inc.php
Framework\Database\Connectors\MySQL	Framework\Database\Connectors\MySQL::queryAllRows('SELECT FROM marketing_smsmarketing_unsubscribers WHERE (`sms_id` = 20) ORDER BY `sms_inbound_receipt_datetime` desc, `sms_unsubscriber_datetime` 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[3])	#2617 DataABC.inc.php
	Framework\Components\DataABC::getAll(Array[3])	Custom PHP
	call_user_func_array(Array[2], Array[1])	#148 FnCall.inc.php
getAll(array ( 'filter' => array ( 0 => array ( 0 => 'sms_id', 1 => '=', 2 => '20', ), ), 'order' => array ( 0 => array ( 0 => 'sms_inbound_receipt_datetime', 1 => 'desc', ), ), 'limit' => 26, ))	Scr\FnCall::evaluate('\Components\Marketing\SMSMarketing\Unsubscribers')	#62 OpStatic.inc.php
\Components\Marketing\SMSMarketing\Unsubscribers::getAll(array ( 'filter' => array ( 0 => array ( 0 => 'sms_id', 1 => '=', 2 => '20', ), ), 'order' => array ( 0 => array ( 0 => 'sms_inbound_receipt_datetime', 1 => 'desc', ), ), 'limit' => 26, ))	Scr\OpStatic::evaluate()	#674 DataControlABC.inc.php
# 4 <data:table>	Framework\DOM\Nodes\NodeABC::initialize()	#456 NodeABC.inc.php
Page: /admin/marketing/smsmarketing/unsubscribers/
<logic:include page="/admin/marketing/smsmarketing/unsubscribers/">	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