Unable to log into AirTime 2.2 after database restore
  • I am having issues with logging into AirTime after restoring the database. I am unable to log in and when I click reset password, I receive the following error.

    Unable to execute SELECT statement [SELECT cc_subjs.ID, cc_subjs.LOGIN, cc_subjs.PASS, cc_subjs.TYPE, cc_subjs.FIRST_NAME, cc_subjs.LAST_NAME, cc_subjs.LASTLOGIN, cc_subjs.LASTFAIL, cc_subjs.SKYPE_CONTACT, cc_subjs.JABBER_CONTACT, cc_subjs.EMAIL, cc_subjs.CELL_PHONE, cc_subjs.LOGIN_ATTEMPTS FROM cc_subjs WHERE cc_subjs.EMAIL=:p1 AND cc_subjs.LOGIN=:p2 LIMIT 1] [wrapped: SQLSTATE[42703]: Undefined column: 7 ERROR: column cc_subjs.cell_phone does not exist LINE 1: ...CONTACT, cc_subjs.JABBER_CONTACT, cc_subjs.EMAIL, cc_subjs.C... ^]
    #0 /usr/share/airtime/library/propel/runtime/lib/query/ModelCriteria.php(927): ModelCriteria->getSelectStatement(NULL)
    #1 /usr/share/airtime/application/controllers/LoginController.php(121): ModelCriteria->findOne()
    #2 /usr/share/php/libzend-framework-php/Zend/Controller/Action.php(516): LoginController->passwordRestoreAction()
    #3 /usr/share/php/libzend-framework-php/Zend/Controller/Dispatcher/Standard.php(295): Zend_Controller_Action->dispatch('passwordRestore...')
    #4 /usr/share/php/libzend-framework-php/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
    #5 /usr/share/php/libzend-framework-php/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch()
    #6 /usr/share/php/libzend-framework-php/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
    #7 /usr/share/airtime/public/index.php(64): Zend_Application->run()
    #8 {main}
    Post edited by Dustin Page at 2012-10-27 19:17:57
  • 2 Comments sorted by
  • Vote Up0Vote Down Cliff WangCliff Wang
    Posts: 339Member, Sourcefabric Team
    Please check your database, esp the cc_subjs table to see if it's correctly restored
    Cloud Radio -> http://airtime.pro
  • Hi Dustin,

    What do you mean by you restored database? Did you back up your 2.1.3 DB and restored it after you did fresh install of 2.2?