exception 'Am_Exception_Db' with message 'Unknown column 'sort_order' in 'order clause' at /home/infoconc/www/amember/library/Am/Record.php line 607(1054) in query: SELECT * FROM am_notification WHERE notification_id IN ( SELECT notification_id FROM am_notification_access WHERE ((fn='user_id' AND id = '1344') OR (fn='product_id' AND id IN ('62', '68', '72', '74', '76', '82', '91', '111', '-1')) OR (fn='product_category_id' AND id IN ('-1', '1', '2', '3', '4', '13')) OR (fn='free')) OR (fn='user_group_id' AND id IN ('1', '2', '3', '4', '5', '-1')) ) AND (begin IS NULL OR begin<='2014-09-17') AND (expire IS NULL OR expire>='2014-09-17') AND is_disabled=0 ORDER BY sort_order' in /home/infoconc/www/amember/library/Am/App.php:1130 Stack trace: #0 [internal function]: Am_Db::defaultDatabaseErrorHandler('Unknown column ...', Array) #1 /home/infoconc/www/amember/library/DbSimple/Generic.php(1356): call_user_func(Array, 'Unknown column ...', Array) #2 /home/infoconc/www/amember/library/DbSimple/Generic.php(973): DbSimple_Generic_LastError->_setLastError(1054, 'Unknown column ...', 'SELECT * FROM a...') #3 /home/infoconc/www/amember/library/DbSimple/Generic.php(1593): DbSimple_Generic_Database->_setLastError(1054, 'Unknown column ...', 'SELECT * FROM a...') #4 /home/infoconc/www/amember/library/DbSimple/Generic.php(1553): DbSimple_Mypdo->_setDbError(false, 'SELECT * FROM a...') #5 /home/infoconc/www/amember/library/DbSimple/Generic.php(1617): DbSimple_Mypdo->_performQuery(Array, true) #6 [internal function]: DbSimple_Mypdo->queryResultOnly('SELECT * FROM ?...', 'user_id', 1344, 'product_id', Array, 'product_categor...', Array, 'free', 'user_group_id', Array, '2014-09-17', '2014-09-17') #7 /home/infoconc/www/amember/library/Am/Record.php(607): call_user_func_array(Array, Array) #8 /home/infoconc/www/amember/application/default/plugins/misc/notification.php(568): Am_Table->selectObjects('SELECT * FROM ?...', 'user_id', 1344, 'product_id', Array, 'product_categor...', Array, 'free', 'user_group_id', Array, '2014-09-17', '2014-09-17') #9 /home/infoconc/www/amember/application/default/plugins/misc/notification.php(96): NotificationTable->getNotificationsForUser(Object(User)) #10 [internal function]: Am_Plugin_Notification->renderNotification(Object(Am_View), Object(Am_Block)) #11 /home/infoconc/www/amember/library/Am/App.php(759): call_user_func(Array, Object(Am_View), Object(Am_Block)) #12 /home/infoconc/www/amember/library/Am/App.php(856): Am_Block->render(Object(Am_View)) #13 /home/infoconc/www/amember/library/Am/View.php(792): Am_Blocks->get(Object(Am_View), 'member/main/**') #14 /home/infoconc/www/amember/library/Am/View.php(800): Am_View_Helper_Blocks->render('member/main/**', '%s') #15 [internal function]: Am_View_Helper_Blocks->blocks('member/main/**') #16 /home/infoconc/www/amember/library/Zend/View/Abstract.php(350): call_user_func_array(Array, Array) #17 /home/infoconc/www/amember/application/default/views/member/main.phtml(2): Zend_View_Abstract->__call('blocks', Array) #18 /home/infoconc/www/amember/application/default/views/member/main.phtml(2): Am_View->blocks('member/main/**') #19 /home/infoconc/www/amember/library/Am/View.php(431): include('/home/infoconc/...') #20 /home/infoconc/www/amember/library/Zend/View/Abstract.php(888): Am_View->_run('/home/infoconc/...') #21 /home/infoconc/www/amember/library/Am/View.php(413): Zend_View_Abstract->render('member/main.pht...') #22 /home/infoconc/www/amember/application/default/controllers/MemberController.php(135): Am_View->display('member/main.pht...') #23 /home/infoconc/www/amember/library/Am/Controller.php(139): MemberController->indexAction() #24 /home/infoconc/www/amember/library/Am/Controller.php(116): Am_Controller->_runAction('indexAction') #25 /home/infoconc/www/amember/library/Zend/Controller/Dispatcher/Standard.php(308): Am_Controller->dispatch('indexAction') #26 /home/infoconc/www/amember/library/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Am_Request), Object(Zend_Controller_Response_Http)) #27 /home/infoconc/www/amember/library/Am/App.php(1961): Zend_Controller_Front->dispatch() #28 /home/infoconc/www/amember/index.php(92): Am_App->run() #29 {main}:Unknown column 'sort_order' in 'order clause' at /home/infoconc/www/amember/library/Am/Record.php line 607(1054) in query: SELECT * FROM am_notification WHERE notification_id IN ( SELECT notification_id FROM am_notification_access WHERE ((fn='user_id' AND id = '1344') OR (fn='product_id' AND id IN ('62', '68', '72', '74', '76', '82', '91', '111', '-1')) OR (fn='product_category_id' AND id IN ('-1', '1', '2', '3', '4', '13')) OR (fn='free')) OR (fn='user_group_id' AND id IN ('1', '2', '3', '4', '5', '-1')) ) AND (begin IS NULL OR begin<='2014-09-17') AND (expire IS NULL OR expire>='2014-09-17') AND is_disabled=0 ORDER BY sort_order #0 [internal function]: Am_Db::defaultDatabaseErrorHandler('Unknown column ...', Array) #1 /home/infoconc/www/amember/library/DbSimple/Generic.php(1356): call_user_func(Array, 'Unknown column ...', Array) #2 /home/infoconc/www/amember/library/DbSimple/Generic.php(973): DbSimple_Generic_LastError->_setLastError(10
You need disable notification plugin and then enable it again. You can do it at aMember CP -> Configuration -> Setup/Configuration -> Plugins. It should fix this issue. Otherwise please submit ticket to helspdesk and we will troubleshoot this issue.