Can't login to airtime

Get Help
1

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
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
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”

2

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

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.

3

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

  • 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
4

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

5

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.

Always make sure to backup your database.

6

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

7

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.

8

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
Capture912×359 31.1 KB

9

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);