# Can't login to airtime

**URL:** <https://discourse.libretime.org/t/cant-login-to-airtime/498>\
**Category:** Get Help\
**Created:** [March 21, 2020, 9:51am UTC](https://discourse.libretime.org/t/cant-login-to-airtime/498 "2020-03-21T09:51:42Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![expert-geeks](https://yyz2.discourse-cdn.com/flex036/user_avatar/discourse.libretime.org/expert-geeks/32/272_2.png) [@expert-geeks](https://discourse.libretime.org/u/expert-geeks)\
**Post date:** [March 21, 2020, 9:51am UTC](https://discourse.libretime.org/t/cant-login-to-airtime/498/1 "2020-03-21T09:51:43Z")

</div>

Just upgraded to the latest git pull and now I can’t login… Here’s the errors appearing in the zendphp.log;

2020-03-21T09:40:33+00:00 ERR (3): airtime.dirtybass.fm [ErrorController.php:54 - errorAction()] - An internal application error has occurred.: PDOException: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation “cc\_track\_types” does not exist

any ideas how to rescue this database ? Thanks!

* * *

tail -n 200 /var/log/airtime/zendphp.log  
#4 /usr/share/airtime/php/airtime\_mvc/application/controllers/plugins/PageLayoutInitPlugin.php(85): PageLayoutInitPlugin-\>\_initTranslationGlobals(Object(Zend\_View))  
#5 /usr/share/airtime/php/airtime\_mvc/application/controllers/plugins/PageLayoutInitPlugin.php(47): PageLayoutInitPlugin-\>\_initGlobals()  
#6 /usr/share/airtime/php/vendor/zf1s/zend-controller/library/Zend/Controller/Plugin/Broker.php(260): PageLayoutInitPlugin-\>routeShutdown(Object(Zend\_Controller\_Request\_Http))  
#7 /usr/share/airtime/php/vendor/zf1s/zend-controller/library/Zend/Controller/Front.php(923): Zend\_Controller\_Plugin\_Broker-\>routeShutdown(Object(Zend\_Controller\_Request\_Http))  
#8 /usr/share/airtime/php/vendor/zf1s/zend-application/library/Zend/Application/Bootstrap/Bootstrap.php(105): Zend\_Controller\_Front-\>dispatch()  
#9 /usr/share/airtime/php/vendor/zf1s/zend-application/library/Zend/Application.php(384): Zend\_Application\_Bootstrap\_Bootstrap-\>run()  
#10 /usr/share/airtime/php/airtime\_mvc/application/airtime-boot.php(84): Zend\_Application-\>run()  
#11 /usr/share/airtime/php/airtime\_mvc/public/index.php(68): require\_once(’/usr/share/airt…’)  
#12 {main}  
2020-03-21T09:40:33+00:00 ERR (3): airtime.dirtybass.fm [ErrorController.php:54 - errorAction()] - An internal application error has occurred.: PDOException: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation “cc\_track\_types” does not exist  
LINE 1: SELECT id, code, type\_name, description FROM cc\_track\_types …  
^ in /usr/share/airtime/php/airtime\_mvc/application/common/Database.php:24  
Stack trace:  
#0 /usr/share/airtime/php/airtime\_mvc/application/common/Database.php(24): PDOStatement-\>execute()  
#1 /usr/share/airtime/php/airtime\_mvc/application/models/Tracktype.php(124): Application\_Common\_Database::prepareAndExecute(‘SELECT id, code…’, Array, ‘all’)  
#2 /usr/share/airtime/php/airtime\_mvc/application/models/Tracktype.php(98): Application\_Model\_Tracktype::getTracktypesData(Array, NULL)  
#3 /usr/share/airtime/php/airtime\_mvc/application/controllers/plugins/PageLayoutInitPlugin.php(146): Application\_Model\_Tracktype::getTracktypes()  
#4 /usr/share/airtime/php/airtime\_mvc/application/controllers/plugins/PageLayoutInitPlugin.php(85): PageLayoutInitPlugin-\>\_initTranslationGlobals(Object(Zend\_View))  
#5 /usr/share/airtime/php/airtime\_mvc/application/controllers/plugins/PageLayoutInitPlugin.php(47): PageLayoutInitPlugin-\>\_initGlobals()  
#6 /usr/share/airtime/php/vendor/zf1s/zend-controller/library/Zend/Controller/Plugin/Broker.php(260): PageLayoutInitPlugin-\>routeShutdown(Object(Zend\_Controller\_Request\_Http))  
#7 /usr/share/airtime/php/vendor/zf1s/zend-controller/library/Zend/Controller/Front.php(923): Zend\_Controller\_Plugin\_Broker-\>routeShutdown(Object(Zend\_Controller\_Request\_Http))  
#8 /usr/share/airtime/php/vendor/zf1s/zend-application/library/Zend/Application/Bootstrap/Bootstrap.php(105): Zend\_Controller\_Front-\>dispatch()  
#9 /usr/share/airtime/php/vendor/zf1s/zend-application/library/Zend/Application.php(384): Zend\_Application\_Bootstrap\_Bootstrap-\>run()  
#10 /usr/share/airtime/php/airtime\_mvc/application/airtime-boot.php(84): Zend\_Application-\>run()  
#11 /usr/share/airtime/php/airtime\_mvc/public/index.php(68): require\_once(’/usr/share/airt…’)  
#12 {main}  
2020-03-21T09:40:33+00:00 ERR (3): airtime.dirtybass.fm [ErrorController.php:26 - errorAction()] - SQLSTATE[42P01]: Undefined table: 7 ERROR: relation “cc\_track\_types” does not exist  
LINE 1: SELECT id, code, type\_name, description FROM cc\_track\_types …  
^  
2020-03-21T09:40:33+00:00 ERR (3): airtime.dirtybass.fm [ErrorController.php:27 - errorAction()] - #0 /usr/share/airtime/php/airtime\_mvc/application/common/Database.php(24): PDOStatement-\>execute()  
#1 /usr/share/airtime/php/airtime\_mvc/application/models/Tracktype.php(124): Application\_Common\_Database::prepareAndExecute(‘SELECT id, code…’, Array, ‘all’)  
#2 /usr/share/airtime/php/airtime\_mvc/application/models/Tracktype.php(98): Application\_Model\_Tracktype::getTracktypesData(Array, NULL)  
#3 /usr/share/airtime/php/airtime\_mvc/application/controllers/plugins/PageLayoutInitPlugin.php(146): Application\_Model\_Tracktype::getTracktypes()  
#4 /usr/share/airtime/php/airtime\_mvc/application/controllers/plugins/PageLayoutInitPlugin.php(85): PageLayoutInitPlugin-\>\_initTranslationGlobals(Object(Zend\_View))  
#5 /usr/share/airtime/php/airtime\_mvc/application/controllers/plugins/PageLayoutInitPlugin.php(47): PageLayoutInitPlugin-\>\_initGlobals()  
#6 /usr/share/airtime/php/vendor/zf1s/zend-controller/library/Zend/Controller/Plugin/Broker.php(260): PageLayoutInitPlugin-\>routeShutdown(Object(Zend\_Controller\_Request\_Http))  
#7 /usr/share/airtime/php/vendor/zf1s/zend-controller/library/Zend/Controller/Front.php(923): Zend\_Controller\_Plugin\_Broker-\>routeShutdown(Object(Zend\_Controller\_Request\_Http))  
#8 /usr/share/airtime/php/vendor/zf1s/zend-application/library/Zend/Application/Bootstrap/Bootstrap.php(105): Zend\_Controller\_Front-\>dispatch()  
#9 /usr/share/airtime/php/vendor/zf1s/zend-application/library/Zend/Application.php(384): Zend\_Application\_Bootstrap\_Bootstrap-\>run()  
#10 /usr/share/airtime/php/airtime\_mvc/application/airtime-boot.php(84): Zend\_Application-\>run()  
#11 /usr/share/airtime/php/airtime\_mvc/public/index.php(68): require\_once(’/usr/share/airt…’)  
#12 {main}  
2020-03-21T09:40:33+00:00 ERR (3): airtime.dirtybass.fm [ErrorController.php:54 - errorAction()] - An internal application error has occurred.: PDOException: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation “cc\_track\_types” does not exist  
LINE 1: SELECT id, code, type\_name, description FROM cc\_track\_types …  
^ in /usr/share/airtime/php/airtime\_mvc/application/common/Database.php:24  
Stack trace:  
#0 /usr/share/airtime/php/airtime\_mvc/application/common/Database.php(24): PDOStatement-\>execute()  
#1 /usr/share/airtime/php/airtime\_mvc/application/models/Tracktype.php(124): Application\_Common\_Database::prepareAndExecute(‘SELECT id, code…’, Array, ‘all’)  
#2 /usr/share/airtime/php/airtime\_mvc/application/models/Tracktype.php(98): Application\_Model\_Tracktype::getTracktypesData(Array, NULL)  
#3 /usr/share/airtime/php/airtime\_mvc/application/controllers/plugins/PageLayoutInitPlugin.php(146): Application\_Model\_Tracktype::getTracktypes()  
#4 /usr/share/airtime/php/airtime\_mvc/application/controllers/plugins/PageLayoutInitPlugin.php(85): PageLayoutInitPlugin-\>\_initTranslationGlobals(Object(Zend\_View))  
#5 /usr/share/airtime/php/airtime\_mvc/application/controllers/plugins/PageLayoutInitPlugin.php(47): PageLayoutInitPlugin-\>\_initGlobals()  
#6 /usr/share/airtime/php/vendor/zf1s/zend-controller/library/Zend/Controller/Plugin/Broker.php(260): PageLayoutInitPlugin-\>routeShutdown(Object(Zend\_Controller\_Request\_Http))  
#7 /usr/share/airtime/php/vendor/zf1s/zend-controller/library/Zend/Controller/Front.php(923): Zend\_Controller\_Plugin\_Broker-\>routeShutdown(Object(Zend\_Controller\_Request\_Http))  
#8 /usr/share/airtime/php/vendor/zf1s/zend-application/library/Zend/Application/Bootstrap/Bootstrap.php(105): Zend\_Controller\_Front-\>dispatch()  
#9 /usr/share/airtime/php/vendor/zf1s/zend-application/library/Zend/Application.php(384): Zend\_Application\_Bootstrap\_Bootstrap-\>run()  
#10 /usr/share/airtime/php/airtime\_mvc/application/airtime-boot.php(84): Zend\_Application-\>run()  
#11 /usr/share/airtime/php/airtime\_mvc/public/index.php(68): require\_once(’/usr/share/airt…’)  
#12 {main}  
2020-03-21T09:40:33+00:00 ERR (3): airtime.dirtybass.fm [ErrorController.php:26 - errorAction()] - SQLSTATE[42P01]: Undefined table: 7 ERROR: relation “cc\_track\_types” does not exist  
LINE 1: SELECT id, code, type\_name, description FROM cc\_track\_types …  
^  
2020-03-21T09:40:33+00:00 ERR (3): airtime.dirtybass.fm [ErrorController.php:27 - errorAction()] - #0 /usr/share/airtime/php/airtime\_mvc/application/common/Database.php(24): PDOStatement-\>execute()  
#1 /usr/share/airtime/php/airtime\_mvc/application/models/Tracktype.php(124): Application\_Common\_Database::prepareAndExecute(‘SELECT id, code…’, Array, ‘all’)  
#2 /usr/share/airtime/php/airtime\_mvc/application/models/Tracktype.php(98): Application\_Model\_Tracktype::getTracktypesData(Array, NULL)  
#3 /usr/share/airtime/php/airtime\_mvc/application/controllers/plugins/PageLayoutInitPlugin.php(146): Application\_Model\_Tracktype::getTracktypes()  
#4 /usr/share/airtime/php/airtime\_mvc/application/controllers/plugins/PageLayoutInitPlugin.php(85): PageLayoutInitPlugin-\>\_initTranslationGlobals(Object(Zend\_View))  
#5 /usr/share/airtime/php/airtime\_mvc/application/controllers/plugins/PageLayoutInitPlugin.php(47): PageLayoutInitPlugin-\>\_initGlobals()  
#6 /usr/share/airtime/php/vendor/zf1s/zend-controller/library/Zend/Controller/Plugin/Broker.php(260): PageLayoutInitPlugin-\>routeShutdown(Object(Zend\_Controller\_Request\_Http))  
#7 /usr/share/airtime/php/vendor/zf1s/zend-controller/library/Zend/Controller/Front.php(923): Zend\_Controller\_Plugin\_Broker-\>routeShutdown(Object(Zend\_Controller\_Request\_Http))  
#8 /usr/share/airtime/php/vendor/zf1s/zend-application/library/Zend/Application/Bootstrap/Bootstrap.php(105): Zend\_Controller\_Front-\>dispatch()  
#9 /usr/share/airtime/php/vendor/zf1s/zend-application/library/Zend/Application.php(384): Zend\_Application\_Bootstrap\_Bootstrap-\>run()  
#10 /usr/share/airtime/php/airtime\_mvc/application/airtime-boot.php(84): Zend\_Application-\>run()  
#11 /usr/share/airtime/php/airtime\_mvc/public/index.php(68): require\_once(’/usr/share/airt…’)  
#12 {main}  
2020-03-21T09:40:33+00:00 ERR (3): airtime.dirtybass.fm [ErrorController.php:54 - errorAction()] - An internal application error has occurred.: PDOException: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation “cc\_track\_types” does not exist  
LINE 1: SELECT id, code, type\_name, description FROM cc\_track\_types …  
^ in /usr/share/airtime/php/airtime\_mvc/application/common/Database.php:24  
Stack trace:  
#0 /usr/share/airtime/php/airtime\_mvc/application/common/Database.php(24): PDOStatement-\>execute()  
#1 /usr/share/airtime/php/airtime\_mvc/application/models/Tracktype.php(124): Application\_Common\_Database::prepareAndExecute(‘SELECT id, code…’, Array, ‘all’)  
#2 /usr/share/airtime/php/airtime\_mvc/application/models/Tracktype.php(98): Application\_Model\_Tracktype::getTracktypesData(Array, NULL)  
#3 /usr/share/airtime/php/airtime\_mvc/application/controllers/plugins/PageLayoutInitPlugin.php(146): Application\_Model\_Tracktype::getTracktypes()  
#4 /usr/share/airtime/php/airtime\_mvc/application/controllers/plugins/PageLayoutInitPlugin.php(85): PageLayoutInitPlugin-\>\_initTranslationGlobals(Object(Zend\_View))  
#5 /usr/share/airtime/php/airtime\_mvc/application/controllers/plugins/PageLayoutInitPlugin.php(47): PageLayoutInitPlugin-\>\_initGlobals()  
#6 /usr/share/airtime/php/vendor/zf1s/zend-controller/library/Zend/Controller/Plugin/Broker.php(260): PageLayoutInitPlugin-\>routeShutdown(Object(Zend\_Controller\_Request\_Http))  
#7 /usr/share/airtime/php/vendor/zf1s/zend-controller/library/Zend/Controller/Front.php(923): Zend\_Controller\_Plugin\_Broker-\>routeShutdown(Object(Zend\_Controller\_Request\_Http))  
#8 /usr/share/airtime/php/vendor/zf1s/zend-application/library/Zend/Application/Bootstrap/Bootstrap.php(105): Zend\_Controller\_Front-\>dispatch()  
#9 /usr/share/airtime/php/vendor/zf1s/zend-application/library/Zend/Application.php(384): Zend\_Application\_Bootstrap\_Bootstrap-\>run()  
#10 /usr/share/airtime/php/airtime\_mvc/application/airtime-boot.php(84): Zend\_Application-\>run()  
#11 /usr/share/airtime/php/airtime\_mvc/public/index.php(68): require\_once(’/usr/share/airt…’)  
#12 {main}  
2020-03-21T09:43:51+00:00 ERR (3): airtime.dirtybass.fm [ErrorController.php:26 - errorAction()] - SQLSTATE[42P01]: Undefined table: 7 ERROR: relation “cc\_track\_types” does not exist  
LINE 1: SELECT id, code, type\_name, description FROM cc\_track\_types …  
^  
2020-03-21T09:43:51+00:00 ERR (3): airtime.dirtybass.fm [ErrorController.php:27 - errorAction()] - #0 /usr/share/airtime/php/airtime\_mvc/application/common/Database.php(24): PDOStatement-\>execute()  
#1 /usr/share/airtime/php/airtime\_mvc/application/models/Tracktype.php(124): Application\_Common\_Database::prepareAndExecute(‘SELECT id, code…’, Array, ‘all’)  
#2 /usr/share/airtime/php/airtime\_mvc/application/models/Tracktype.php(98): Application\_Model\_Tracktype::getTracktypesData(Array, NULL)  
#3 /usr/share/airtime/php/airtime\_mvc/application/controllers/plugins/PageLayoutInitPlugin.php(146): Application\_Model\_Tracktype::getTracktypes()  
#4 /usr/share/airtime/php/airtime\_mvc/application/controllers/plugins/PageLayoutInitPlugin.php(85): PageLayoutInitPlugin-\>\_initTranslationGlobals(Object(Zend\_View))  
#5 /usr/share/airtime/php/airtime\_mvc/application/controllers/plugins/PageLayoutInitPlugin.php(47): PageLayoutInitPlugin-\>\_initGlobals()  
#6 /usr/share/airtime/php/vendor/zf1s/zend-controller/library/Zend/Controller/Plugin/Broker.php(260): PageLayoutInitPlugin-\>routeShutdown(Object(Zend\_Controller\_Request\_Http))  
#7 /usr/share/airtime/php/vendor/zf1s/zend-controller/library/Zend/Controller/Front.php(923): Zend\_Controller\_Plugin\_Broker-\>routeShutdown(Object(Zend\_Controller\_Request\_Http))  
#8 /usr/share/airtime/php/vendor/zf1s/zend-application/library/Zend/Application/Bootstrap/Bootstrap.php(105): Zend\_Controller\_Front-\>dispatch()  
#9 /usr/share/airtime/php/vendor/zf1s/zend-application/library/Zend/Application.php(384): Zend\_Application\_Bootstrap\_Bootstrap-\>run()  
#10 /usr/share/airtime/php/airtime\_mvc/application/airtime-boot.php(84): Zend\_Application-\>run()  
#11 /usr/share/airtime/php/airtime\_mvc/public/index.php(68): require\_once(’/usr/share/airt…’)  
#12 {main}  
2020-03-21T09:43:51+00:00 ERR (3): airtime.dirtybass.fm [ErrorController.php:54 - errorAction()] - An internal application error has occurred.: PDOException: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation “cc\_track\_types” does not exist  
LINE 1: SELECT id, code, type\_name, description FROM cc\_track\_types …  
^ in /usr/share/airtime/php/airtime\_mvc/application/common/Database.php:24  
Stack trace:  
#0 /usr/share/airtime/php/airtime\_mvc/application/common/Database.php(24): PDOStatement-\>execute()  
#1 /usr/share/airtime/php/airtime\_mvc/application/models/Tracktype.php(124): Application\_Common\_Database::prepareAndExecute(‘SELECT id, code…’, Array, ‘all’)  
#2 /usr/share/airtime/php/airtime\_mvc/application/models/Tracktype.php(98): Application\_Model\_Tracktype::getTracktypesData(Array, NULL)  
#3 /usr/share/airtime/php/airtime\_mvc/application/controllers/plugins/PageLayoutInitPlugin.php(146): Application\_Model\_Tracktype::getTracktypes()  
#4 /usr/share/airtime/php/airtime\_mvc/application/controllers/plugins/PageLayoutInitPlugin.php(85): PageLayoutInitPlugin-\>\_initTranslationGlobals(Object(Zend\_View))  
#5 /usr/share/airtime/php/airtime\_mvc/application/controllers/plugins/PageLayoutInitPlugin.php(47): PageLayoutInitPlugin-\>\_initGlobals()  
#6 /usr/share/airtime/php/vendor/zf1s/zend-controller/library/Zend/Controller/Plugin/Broker.php(260): PageLayoutInitPlugin-\>routeShutdown(Object(Zend\_Controller\_Request\_Http))  
#7 /usr/share/airtime/php/vendor/zf1s/zend-controller/library/Zend/Controller/Front.php(923): Zend\_Controller\_Plugin\_Broker-\>routeShutdown(Object(Zend\_Controller\_Request\_Http))  
#8 /usr/share/airtime/php/vendor/zf1s/zend-application/library/Zend/Application/Bootstrap/Bootstrap.php(105): Zend\_Controller\_Front-\>dispatch()  
#9 /usr/share/airtime/php/vendor/zf1s/zend-application/library/Zend/Application.php(384): Zend\_Application\_Bootstrap\_Bootstrap-\>run()  
#10 /usr/share/airtime/php/airtime\_mvc/application/airtime-boot.php(84): Zend\_Application-\>run()  
#11 /usr/share/airtime/php/airtime\_mvc/public/index.php(68): require\_once(’/usr/share/airt…’)  
#12 {main}  
2020-03-21T09:43:55+00:00 WARN (4): airtime.dirtybass.fm SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”  
2020-03-21T09:43:55+00:00 INFO (6): airtime.dirtybass.fm Notifying RabbitMQ to send message to pypo  
2020-03-21T09:44:04+00:00 INFO (6): airtime.dirtybass.fm Registered Component: [pypo@144.76.62.34](mailto:pypo@144.76.62.34)  
2020-03-21T09:44:04+00:00 WARN (4): airtime.dirtybass.fm SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”  
2020-03-21T09:44:04+00:00 INFO (6): airtime.dirtybass.fm Registered Component: [show-recorder@144.76.62.34](mailto:show-recorder@144.76.62.34)  
2020-03-21T09:44:04+00:00 WARN (4): airtime.dirtybass.fm SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”  
2020-03-21T09:44:04+00:00 WARN (4): airtime.dirtybass.fm SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”  
2020-03-21T09:44:04+00:00 WARN (4): airtime.dirtybass.fm SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”  
2020-03-21T09:44:57+00:00 ERR (3): airtime.dirtybass.fm [ErrorController.php:26 - errorAction()] - SQLSTATE[42P01]: Undefined table: 7 ERROR: relation “cc\_track\_types” does not exist  
LINE 1: SELECT id, code, type\_name, description FROM cc\_track\_types …  
^  
2020-03-21T09:44:57+00:00 ERR (3): airtime.dirtybass.fm [ErrorController.php:27 - errorAction()] - #0 /usr/share/airtime/php/airtime\_mvc/application/common/Database.php(24): PDOStatement-\>execute()  
#1 /usr/share/airtime/php/airtime\_mvc/application/models/Tracktype.php(124): Application\_Common\_Database::prepareAndExecute(‘SELECT id, code…’, Array, ‘all’)  
#2 /usr/share/airtime/php/airtime\_mvc/application/models/Tracktype.php(98): Application\_Model\_Tracktype::getTracktypesData(Array, NULL)  
#3 /usr/share/airtime/php/airtime\_mvc/application/controllers/plugins/PageLayoutInitPlugin.php(146): Application\_Model\_Tracktype::getTracktypes()  
#4 /usr/share/airtime/php/airtime\_mvc/application/controllers/plugins/PageLayoutInitPlugin.php(85): PageLayoutInitPlugin-\>\_initTranslationGlobals(Object(Zend\_View))  
#5 /usr/share/airtime/php/airtime\_mvc/application/controllers/plugins/PageLayoutInitPlugin.php(47): PageLayoutInitPlugin-\>\_initGlobals()  
#6 /usr/share/airtime/php/vendor/zf1s/zend-controller/library/Zend/Controller/Plugin/Broker.php(260): PageLayoutInitPlugin-\>routeShutdown(Object(Zend\_Controller\_Request\_Http))  
#7 /usr/share/airtime/php/vendor/zf1s/zend-controller/library/Zend/Controller/Front.php(923): Zend\_Controller\_Plugin\_Broker-\>routeShutdown(Object(Zend\_Controller\_Request\_Http))  
#8 /usr/share/airtime/php/vendor/zf1s/zend-application/library/Zend/Application/Bootstrap/Bootstrap.php(105): Zend\_Controller\_Front-\>dispatch()  
#9 /usr/share/airtime/php/vendor/zf1s/zend-application/library/Zend/Application.php(384): Zend\_Application\_Bootstrap\_Bootstrap-\>run()  
#10 /usr/share/airtime/php/airtime\_mvc/application/airtime-boot.php(84): Zend\_Application-\>run()  
#11 /usr/share/airtime/php/airtime\_mvc/public/index.php(68): require\_once(’/usr/share/airt…’)  
#12 {main}  
2020-03-21T09:44:57+00:00 ERR (3): airtime.dirtybass.fm [ErrorController.php:54 - errorAction()] - An internal application error has occurred.: PDOException: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation “cc\_track\_types” does not exist  
LINE 1: SELECT id, code, type\_name, description FROM cc\_track\_types …  
^ in /usr/share/airtime/php/airtime\_mvc/application/common/Database.php:24  
Stack trace:  
#0 /usr/share/airtime/php/airtime\_mvc/application/common/Database.php(24): PDOStatement-\>execute()  
#1 /usr/share/airtime/php/airtime\_mvc/application/models/Tracktype.php(124): Application\_Common\_Database::prepareAndExecute(‘SELECT id, code…’, Array, ‘all’)  
#2 /usr/share/airtime/php/airtime\_mvc/application/models/Tracktype.php(98): Application\_Model\_Tracktype::getTracktypesData(Array, NULL)  
#3 /usr/share/airtime/php/airtime\_mvc/application/controllers/plugins/PageLayoutInitPlugin.php(146): Application\_Model\_Tracktype::getTracktypes()  
#4 /usr/share/airtime/php/airtime\_mvc/application/controllers/plugins/PageLayoutInitPlugin.php(85): PageLayoutInitPlugin-\>\_initTranslationGlobals(Object(Zend\_View))  
#5 /usr/share/airtime/php/airtime\_mvc/application/controllers/plugins/PageLayoutInitPlugin.php(47): PageLayoutInitPlugin-\>\_initGlobals()  
#6 /usr/share/airtime/php/vendor/zf1s/zend-controller/library/Zend/Controller/Plugin/Broker.php(260): PageLayoutInitPlugin-\>routeShutdown(Object(Zend\_Controller\_Request\_Http))  
#7 /usr/share/airtime/php/vendor/zf1s/zend-controller/library/Zend/Controller/Front.php(923): Zend\_Controller\_Plugin\_Broker-\>routeShutdown(Object(Zend\_Controller\_Request\_Http))  
#8 /usr/share/airtime/php/vendor/zf1s/zend-application/library/Zend/Application/Bootstrap/Bootstrap.php(105): Zend\_Controller\_Front-\>dispatch()  
#9 /usr/share/airtime/php/vendor/zf1s/zend-application/library/Zend/Application.php(384): Zend\_Application\_Bootstrap\_Bootstrap-\>run()  
#10 /usr/share/airtime/php/airtime\_mvc/application/airtime-boot.php(84): Zend\_Application-\>run()  
#11 /usr/share/airtime/php/airtime\_mvc/public/index.php(68): require\_once(’/usr/share/airt…’)  
#12 {main}  
2020-03-21T09:45:15+00:00 ERR (3): airtime.dirtybass.fm [ErrorController.php:26 - errorAction()] - SQLSTATE[42P01]: Undefined table: 7 ERROR: relation “cc\_track\_types” does not exist  
LINE 1: SELECT id, code, type\_name, description FROM cc\_track\_types …  
^  
2020-03-21T09:45:15+00:00 ERR (3): airtime.dirtybass.fm [ErrorController.php:27 - errorAction()] - #0 /usr/share/airtime/php/airtime\_mvc/application/common/Database.php(24): PDOStatement-\>execute()  
#1 /usr/share/airtime/php/airtime\_mvc/application/models/Tracktype.php(124): Application\_Common\_Database::prepareAndExecute(‘SELECT id, code…’, Array, ‘all’)  
#2 /usr/share/airtime/php/airtime\_mvc/application/models/Tracktype.php(98): Application\_Model\_Tracktype::getTracktypesData(Array, NULL)  
#3 /usr/share/airtime/php/airtime\_mvc/application/controllers/plugins/PageLayoutInitPlugin.php(146): Application\_Model\_Tracktype::getTracktypes()  
#4 /usr/share/airtime/php/airtime\_mvc/application/controllers/plugins/PageLayoutInitPlugin.php(85): PageLayoutInitPlugin-\>\_initTranslationGlobals(Object(Zend\_View))  
#5 /usr/share/airtime/php/airtime\_mvc/application/controllers/plugins/PageLayoutInitPlugin.php(47): PageLayoutInitPlugin-\>\_initGlobals()  
#6 /usr/share/airtime/php/vendor/zf1s/zend-controller/library/Zend/Controller/Plugin/Broker.php(260): PageLayoutInitPlugin-\>routeShutdown(Object(Zend\_Controller\_Request\_Http))  
#7 /usr/share/airtime/php/vendor/zf1s/zend-controller/library/Zend/Controller/Front.php(923): Zend\_Controller\_Plugin\_Broker-\>routeShutdown(Object(Zend\_Controller\_Request\_Http))  
#8 /usr/share/airtime/php/vendor/zf1s/zend-application/library/Zend/Application/Bootstrap/Bootstrap.php(105): Zend\_Controller\_Front-\>dispatch()  
#9 /usr/share/airtime/php/vendor/zf1s/zend-application/library/Zend/Application.php(384): Zend\_Application\_Bootstrap\_Bootstrap-\>run()  
#10 /usr/share/airtime/php/airtime\_mvc/application/airtime-boot.php(84): Zend\_Application-\>run()  
#11 /usr/share/airtime/php/airtime\_mvc/public/index.php(68): require\_once(’/usr/share/airt…’)  
#12 {main}  
2020-03-21T09:45:15+00:00 ERR (3): airtime.dirtybass.fm [ErrorController.php:54 - errorAction()] - An internal application error has occurred.: PDOException: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation “cc\_track\_types” does not exist  
LINE 1: SELECT id, code, type\_name, description FROM cc\_track\_types …  
^ in /usr/share/airtime/php/airtime\_mvc/application/common/Database.php:24  
Stack trace:  
#0 /usr/share/airtime/php/airtime\_mvc/application/common/Database.php(24): PDOStatement-\>execute()  
#1 /usr/share/airtime/php/airtime\_mvc/application/models/Tracktype.php(124): Application\_Common\_Database::prepareAndExecute(‘SELECT id, code…’, Array, ‘all’)  
#2 /usr/share/airtime/php/airtime\_mvc/application/models/Tracktype.php(98): Application\_Model\_Tracktype::getTracktypesData(Array, NULL)  
#3 /usr/share/airtime/php/airtime\_mvc/application/controllers/plugins/PageLayoutInitPlugin.php(146): Application\_Model\_Tracktype::getTracktypes()  
#4 /usr/share/airtime/php/airtime\_mvc/application/controllers/plugins/PageLayoutInitPlugin.php(85): PageLayoutInitPlugin-\>\_initTranslationGlobals(Object(Zend\_View))  
#5 /usr/share/airtime/php/airtime\_mvc/application/controllers/plugins/PageLayoutInitPlugin.php(47): PageLayoutInitPlugin-\>\_initGlobals()  
#6 /usr/share/airtime/php/vendor/zf1s/zend-controller/library/Zend/Controller/Plugin/Broker.php(260): PageLayoutInitPlugin-\>routeShutdown(Object(Zend\_Controller\_Request\_Http))  
#7 /usr/share/airtime/php/vendor/zf1s/zend-controller/library/Zend/Controller/Front.php(923): Zend\_Controller\_Plugin\_Broker-\>routeShutdown(Object(Zend\_Controller\_Request\_Http))  
#8 /usr/share/airtime/php/vendor/zf1s/zend-application/library/Zend/Application/Bootstrap/Bootstrap.php(105): Zend\_Controller\_Front-\>dispatch()  
#9 /usr/share/airtime/php/vendor/zf1s/zend-application/library/Zend/Application.php(384): Zend\_Application\_Bootstrap\_Bootstrap-\>run()  
#10 /usr/share/airtime/php/airtime\_mvc/application/airtime-boot.php(84): Zend\_Application-\>run()  
#11 /usr/share/airtime/php/airtime\_mvc/public/index.php(68): require\_once(’/usr/share/airt…’)  
#12 {main}  
2020-03-21T09:46:04+00:00 WARN (4): airtime.dirtybass.fm SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation “cc\_pref”

---

<div class="post-metadata">

**Author:** ![robbt](https://yyz2.discourse-cdn.com/flex036/user_avatar/discourse.libretime.org/robbt/32/15_2.png) [@robbt](https://discourse.libretime.org/u/robbt)\
**Post date:** [March 21, 2020, 11:24am UTC](https://discourse.libretime.org/t/cant-login-to-airtime/498/2 "2020-03-21T11:24:42Z")

</div>

Yeah it looks like there was an issue updating the database automatically. You will need to manually apply the database changes to add the cc\_track\_type that was just added. Specifically [https://github.com/LibreTime/libretime/blob/master/airtime\_mvc/application/controllers/upgrade\_sql/airtime\_3.0.0-alpha.9.2/upgrade.sql](https://github.com/LibreTime/libretime/blob/master/airtime_mvc/application/controllers/upgrade_sql/airtime_3.0.0-alpha.9.2/upgrade.sql)

Do you know what got commit you were running off of before the upgrade ? I want to try to figure out why this happened so we can prevent it for others.

---

<div class="post-metadata">

**Author:** ![expert-geeks](https://yyz2.discourse-cdn.com/flex036/user_avatar/discourse.libretime.org/expert-geeks/32/272_2.png) [@expert-geeks](https://discourse.libretime.org/u/expert-geeks)\
**Post date:** [March 21, 2020, 11:32am UTC](https://discourse.libretime.org/t/cant-login-to-airtime/498/3 "2020-03-21T11:32:18Z")

</div>

Here’s the git pull;

> git pull origin master  
> remote: Enumerating objects: 248, done.  
> remote: Counting objects: 100% (248/248), done.  
> remote: Total 342 (delta 248), reused 248 (delta 248), pack-reused 94  
> Receiving objects: 100% (342/342), 84.52 KiB | 0 bytes/s, done.  
> Resolving deltas: 100% (259/259), completed with 102 local objects.  
> From [GitHub - libretime/libretime: LibreTime: Radio Broadcast & Automation Platform](https://github.com/LibreTime/libretime)

- branch master → FETCH\_HEAD  
024dbb8…34d46e4 master → origin/master  
Updating 024dbb8…34d46e4  
Fast-forward  
airtime\_mvc/application/common/FileDataHelper.php | 16 +  
airtime\_mvc/application/configs/ACL.php | 4 ±  
…/application/configs/classmap-airtime-conf.php | 7 +  
airtime\_mvc/application/configs/constants.php | 1 +  
airtime\_mvc/application/configs/navigation.php | 8 ±  
…/application/controllers/ApiController.php | 17 +  
…/controllers/TracktypeController.php | 109 ++  
…/airtime\_3.0.0-alpha.9.2/downgrade.sql | 3 +  
…/controllers/plugins/PageLayoutInitPlugin.php | 8 +  
…/airtime\_3.0.0-alpha.9.2/upgrade.sql | 27 +  
airtime\_mvc/application/forms/AddTracktype.php | 79 ++  
airtime\_mvc/application/forms/EditAudioMD.php | 13 +  
…/application/forms/SmartBlockCriteria.php | 104 ±  
…/application/layouts/scripts/layout.phtml | 9 ±  
airtime\_mvc/application/models/Block.php | 75 ±  
airtime\_mvc/application/models/StoredFile.php | 5 ±  
airtime\_mvc/application/models/Tracktype.php | 173 ++++  
airtime\_mvc/application/models/airtime/CcFiles.php | 2 +  
…/application/models/airtime/CcTracktypes.php | 16 +  
…/models/airtime/CcTracktypesPeer.php | 18 +  
…/models/airtime/CcTracktypesQuery.php | 18 +  
…/models/airtime/map/CcFilesTableMap.php | 1 +  
…/models/airtime/map/CcTracktypesTableMap.php | 56 ++  
…/application/models/airtime/om/BaseCcFiles.php | 55 ++  
…/models/airtime/om/BaseCcFilesPeer.php | 27 ±  
…/models/airtime/om/BaseCcFilesQuery.php | 35 ±  
…/models/airtime/om/BaseCcTracktypes.php | 1037 ++++++++++++++++++++  
…/models/airtime/om/BaseCcTracktypesPeer.php | 780 +++++++++++++++  
…/models/airtime/om/BaseCcTracktypesQuery.php | 407 ++++++++  
…/application/services/HistoryService.php | 43 ±  
airtime\_mvc/application/upgrade/Upgrades.php | 11 +  
…/scripts/library/get-file-metadata.ajax.phtml | 1 +  
…/application/views/scripts/plupload/index.phtml | 55 ±  
…/views/scripts/tracktype/add-tracktype.phtml | 36 +  
…/tracktype/get-tracktype-data-table-info.phtml | 0  
…/scripts/tracktype/get-tracktype-data.phtml | 3 +  
…/views/scripts/tracktype/index.phtml | 0  
…/views/scripts/tracktype/remove-tracktype.phtml | 3 +  
airtime\_mvc/build/schema.xml | 14 +  
airtime\_mvc/build/sql/schema.sql | 19 +  
airtime\_mvc/public/css/addmedia.css | 6 +  
airtime\_mvc/public/css/media\_library.css | 48 ±  
airtime\_mvc/public/css/styles.css | 72 ±  
airtime\_mvc/public/css/tracktypes.css | 9 +  
airtime\_mvc/public/js/airtime/library/library.js | 89 ±  
airtime\_mvc/public/js/airtime/library/plupload.js | 13 +  
…/js/airtime/playlist/smart\_blockbuilder.js | 169 ++±  
…/public/js/airtime/tracktype/tracktype.js | 151 +++  
docs/manual/host-configuration/index.md | 37 ±  
docs/manual/howtos/index.md | 3 +  
docs/manual/howtos/track-types.md | 42 +  
docs/manual/troubleshooting/index.md | 31 ±  
install | 4 ±  
installer/lib/requirements-debian-buster.apt | 2 ±  
python\_apps/pypo/pypo/mime.types | 1 +  
55 files changed, 3752 insertions(+), 220 deletions(-)  
create mode 100644 airtime\_mvc/application/controllers/TracktypeController.php  
create mode 100644 airtime\_mvc/application/controllers/downgrade\_sql/airtime\_3.0.0-alpha.9.2/downgrade.sql  
create mode 100644 airtime\_mvc/application/controllers/upgrade\_sql/airtime\_3.0.0-alpha.9.2/upgrade.sql  
create mode 100644 airtime\_mvc/application/forms/AddTracktype.php  
create mode 100644 airtime\_mvc/application/models/Tracktype.php  
create mode 100644 airtime\_mvc/application/models/airtime/CcTracktypes.php  
create mode 100644 airtime\_mvc/application/models/airtime/CcTracktypesPeer.php  
create mode 100644 airtime\_mvc/application/models/airtime/CcTracktypesQuery.php  
create mode 100644 airtime\_mvc/application/models/airtime/map/CcTracktypesTableMap.php  
create mode 100644 airtime\_mvc/application/models/airtime/om/BaseCcTracktypes.php  
create mode 100644 airtime\_mvc/application/models/airtime/om/BaseCcTracktypesPeer.php  
create mode 100644 airtime\_mvc/application/models/airtime/om/BaseCcTracktypesQuery.php  
create mode 100644 airtime\_mvc/application/views/scripts/tracktype/add-tracktype.phtml  
create mode 100644 airtime\_mvc/application/views/scripts/tracktype/get-tracktype-data-table-info.phtml  
create mode 100644 airtime\_mvc/application/views/scripts/tracktype/get-tracktype-data.phtml  
create mode 100644 airtime\_mvc/application/views/scripts/tracktype/index.phtml  
create mode 100644 airtime\_mvc/application/views/scripts/tracktype/remove-tracktype.phtml  
create mode 100644 airtime\_mvc/public/css/tracktypes.css  
create mode 100644 airtime\_mvc/public/js/airtime/tracktype/tracktype.js  
create mode 100644 docs/manual/howtos/track-types.md

---

<div class="post-metadata">

**Author:** ![expert-geeks](https://yyz2.discourse-cdn.com/flex036/user_avatar/discourse.libretime.org/expert-geeks/32/272_2.png) [@expert-geeks](https://discourse.libretime.org/u/expert-geeks)\
**Post date:** [March 21, 2020, 11:40am UTC](https://discourse.libretime.org/t/cant-login-to-airtime/498/4 "2020-03-21T11:40:08Z")

</div>

Running; ALTER TABLE cc\_files ADD COLUMN track\_type VARCHAR(16);

ERROR: column “track\_type” of relation “cc\_files” already exists

Running;  
CREATE TABLE IF NOT EXISTS “cc\_track\_types”  
(  
“id” integer DEFAULT nextval(‘cc\_track\_types\_id\_seq’::regclass) NOT NULL,  
“code” VARCHAR(16) NOT NULL,  
“type\_name” VARCHAR(64),  
“description” VARCHAR(255),  
“visibility” boolean DEFAULT true NOT NULL,  
CONSTRAINT “cc\_track\_types\_pkey” PRIMARY KEY (“id”),  
CONSTRAINT “cc\_track\_types\_code\_key” UNIQUE (“code”)  
);

gives; ERROR: relation “cc\_track\_types\_id\_seq” does not exist  
SQL state: 42P01

---

<div class="post-metadata">

**Author:** ![codenift](https://yyz2.discourse-cdn.com/flex036/user_avatar/discourse.libretime.org/codenift/32/165_2.png) [@codenift](https://discourse.libretime.org/u/codenift)\
**Post date:** [March 21, 2020, 3:01pm UTC](https://discourse.libretime.org/t/cant-login-to-airtime/498/5 "2020-03-21T15:01:31Z")

</div>

I thought it was ready to update the database automatically, I will look into this as well. In case you want to do it manually, I uploaded an SQL file you can download and import to phpPgAdmin. That will add the missing table and also the column inside cc\_files.

> **[codenift/TracktypeSQLforLibreTime](https://github.com/codenift/TracktypeSQLforLibreTime)**
>
> Contribute to codenift/TracktypeSQLforLibreTime development by creating an account on GitHub.

Always make sure to backup your database.

---

<div class="post-metadata">

**Author:** ![expert-geeks](https://yyz2.discourse-cdn.com/flex036/user_avatar/discourse.libretime.org/expert-geeks/32/272_2.png) [@expert-geeks](https://discourse.libretime.org/u/expert-geeks)\
**Post date:** [March 21, 2020, 3:18pm UTC](https://discourse.libretime.org/t/cant-login-to-airtime/498/6 "2020-03-21T15:18:39Z")

</div>

I’m having problems with ‘cc\_track\_types\_id\_seq’… the original code failed on this and I get errors with yours at the same point;

ERROR: syntax error at or near “AS”  
LINE 43: AS integer  
^  
SQL state: 42601  
Character: 1176

CREATE SEQUENCE public.cc\_track\_types\_id\_seq  
AS integer  
START WITH 1

---

<div class="post-metadata">

**Author:** ![codenift](https://yyz2.discourse-cdn.com/flex036/user_avatar/discourse.libretime.org/codenift/32/165_2.png) [@codenift](https://discourse.libretime.org/u/codenift)\
**Post date:** [March 21, 2020, 3:28pm UTC](https://discourse.libretime.org/t/cant-login-to-airtime/498/7 "2020-03-21T15:28:36Z")

</div>

I just tested it on a live server that had an old version and it seemed to update fine. Did you import the file instead of copy and pasting the contents of the sql file? I noticed errors if trying to copy and paste. Try to import it instead.

---

<div class="post-metadata">

**Author:** ![expert-geeks](https://yyz2.discourse-cdn.com/flex036/user_avatar/discourse.libretime.org/expert-geeks/32/272_2.png) [@expert-geeks](https://discourse.libretime.org/u/expert-geeks)\
**Post date:** [March 21, 2020, 3:39pm UTC](https://discourse.libretime.org/t/cant-login-to-airtime/498/8 "2020-03-21T15:39:41Z")

</div>

To be fair, I’ve not used pgadmin before today so I might be getting this wrong… I did copy paste, but I have downloaded and imported as you suggested and I get the same error at the same point;

ERROR: syntax error at or near “AS”  
LINE 43: AS integer  
^  
SQL state: 42601  
Character: 1176

 ![Capture](https://canada1.discourse-cdn.com/flex036/uploads/libretime/original/1X/1920d0cc167739b0bb6b70d6161c61341bba0630.jpeg)

---

<div class="post-metadata">

**Author:** ![expert-geeks](https://yyz2.discourse-cdn.com/flex036/user_avatar/discourse.libretime.org/expert-geeks/32/272_2.png) [@expert-geeks](https://discourse.libretime.org/u/expert-geeks)\
**Post date:** [March 21, 2020, 3:45pm UTC](https://discourse.libretime.org/t/cant-login-to-airtime/498/9 "2020-03-21T15:45:31Z")

</div>

As a workaround I have created the missing table which has allowed me back into libretime at least, but there are no constraints around the id sequence;

CREATE TABLE IF NOT EXISTS “cc\_track\_types”  
(  
“id” integer NOT NULL,  
“code” VARCHAR(16) NOT NULL,  
“type\_name” VARCHAR(64),  
“description” VARCHAR(255),  
“visibility” boolean DEFAULT true NOT NULL,  
CONSTRAINT “cc\_track\_types\_pkey” PRIMARY KEY (“id”),  
CONSTRAINT “cc\_track\_types\_code\_key” UNIQUE (“code”)  
);

INSERT INTO cc\_track\_types VALUES (1, ‘MUS’, ‘Music’, ‘This is used for tracks containing music.’, true);  
INSERT INTO cc\_track\_types VALUES (2, ‘SID’, ‘Station ID’, ‘This is used for Station IDs’, true);  
INSERT INTO cc\_track\_types VALUES (3, ‘INT’, ‘Show Intro’, ‘This can be used for organizing all the show introductions.’, true);  
INSERT INTO cc\_track\_types VALUES (4, ‘OUT’, ‘Show Outro’, ‘This can be used for organizing all the show outroductions.’, true);  
INSERT INTO cc\_track\_types VALUES (5, ‘SWP’, ‘Sweeper’, ‘This is used for segues between songs.’, true);  
INSERT INTO cc\_track\_types VALUES (6, ‘JIN’, ‘Jingle’, ‘A short song or tune, normally played during commercial breaks. Contains one or more hooks.’, true);  
INSERT INTO cc\_track\_types VALUES (7, ‘PRO’, ‘Promo’, ‘For promotional use.’, true);  
INSERT INTO cc\_track\_types VALUES (8, ‘SHO’, ‘Shout Out’, 'A message of congratulation, greeting. support, or appreciation. ', true);  
INSERT INTO cc\_track\_types VALUES (9, ‘NWS’, ‘News’, ‘This is used for noteworthy information, announcements.’, true);  
INSERT INTO cc\_track\_types VALUES (10, ‘COM’, ‘Commercial’, ‘This is used for commerical advertising.’, true);  
INSERT INTO cc\_track\_types VALUES (11, ‘ITV’, ‘Interview’, ‘This is used for radio interviews’, true);  
INSERT INTO cc\_track\_types VALUES (12, ‘VTR’, ‘Voice Tracking’, ‘Also referred as robojock or taped. Make announcements without actually being in the station.’, true);