Discussions
Activity
Sign In
How it works
Airtime Support
Unable to log into AirTime 2.2 after database restore
Vote Up
0
Vote Down
Dustin Page
October 2012
Posts: 55
Member
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
Votes
Date Added
Vote Up
0
Vote Down
Cliff Wang
October 2012
Posts: 339
Member, Sourcefabric Team
Please check your database, esp the cc_subjs table to see if it's correctly restored
Cloud Radio ->
http://airtime.pro
Vote Up
0
Vote Down
James Moon
October 2012
Posts: 197
Member
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?
Add a Comment
Start a New Discussion
Howdy, Stranger!
It looks like you're new here. If you want to get involved, click one of these buttons!
Sign In
Apply for Membership
Categories
All Discussions
8,397
Sourcefabric
↳
Announcements
25
Newscoop
↳
Newscoop Support
2,189
↳
Newscoop Development
722
↳
Newscoop Security
13
↳
Newscoop Documentation
17
↳
Newscoop Themes
69
Airtime
↳
Airtime Support
3,139
↳
Airtime Development
1,286
↳
Airtime Français
146
↳
Airtime Documentation
14
↳
Airtime Hacks
102
↳
Promote your station!
37
↳
Airtime Security
11
Booktype
↳
Booktype Support
277
↳
Booktype Development
55
↳
Booktype Documentation
7
Superdesk
↳
Superdesk Development
264
↳
Web Publisher
21
Poll
No poll attached to this discussion.
Top Posters
Albert FR
1978
Martin Konecny
1860
Andrey Podshivalov
1526
Voisses Tech
1423
John Chewter
899
Daniel James
844
Roger Wilco
784
hoerich
627
Paul Baranowski
389
Cliff Wang
339