a big bug in news version...

Discussion in 'aMember Pro v.4' started by fmagusto, Sep 17, 2014.

  1. fmagusto

    fmagusto Guest

    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
  2. caesar

    caesar aMember Pro Developer Staff Member

    Joined:
    Oct 16, 2009
    Messages:
    2,295
    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.

Share This Page