Can't add files to shows - saying 'Processing...' in Add Content window - Airtime Support Discussions on Sourcefabric Forum

Tim RadioClash · Post edited by Tim RadioClash at 2013-07-18 15:03:06

Again working fine a few days ago added a load of shows...had to reboot remotely due to some problem with Liquidsoap (monit alerted me to:

Connection failed Service airtime-liquidsoap

    Date:        Tue, 16 Jul 2013 23:32:22
    Action:      restart
    Host:        listen.radioclash.com
    Description: failed protocol test [generic] at INET[localhost:1234] via TCP -- GENERIC: receiving unexpected data [] -- No match

and then connection succeeded, but stream wasn't playing despite the monit emails - so restarted it over SSH.

Come to add some files now, everything is working/streaming but the Add Content window in Firefox and Safari is always saying 'Processing' regardless of what you select/reload page etc. Really strange. A reboot doesn't fix it, neither restarting the services.

Checking with airtime-log -t liquidsoap I get:

2013/07/18 19:51:35 [stdout:3] #########################################
2013/07/18 19:51:35 [stdout:3] #           *** pypo ***               #
2013/07/18 19:51:35 [stdout:3] #     pypo notification gateway         #
2013/07/18 19:51:35 [stdout:3] #########################################
2013/07/18 19:51:42 [server:3] New client: localhost.localdomain.
2013/07/18 19:51:42 [server:3] Client localhost.localdomain disconnected.
2013/07/18 19:51:52 [server:3] New client: localhost.localdomain.
2013/07/18 19:51:52 [server:3] Client localhost.localdomain disconnected.

repeatedly - is that normal? For localhost to be disconnecting and reconnecting like that?

Also checked my media folder setting is in place...and the files are there.

Does this in Library too - it's like it can't 'connect' to the folder...and via Schedule - and also View Users - it's like the user is corrupted BUT this is the main admin user, and if I delete it then I'll obviously I'll be locked out, and lose any playlists/smart blocks created by that user.

Any idea what it can be?

Naomi

I think I've seen this bug before, but couldn't see at a glance how it could be caused (the value is probably NULL)

if you run

sudo -u postgres psql airtime -c "DELETE from cc_pref where keystr = 'library_datatable' and subjid = 1"

This should make that admin user useable again at least.

Tim RadioClash · Post edited by Tim RadioClash at 2013-07-18 15:07:08

I can add files and use the UI properly with the Program Manager user, but not the admin user - I get 'Processing' whenever the admin user tries to do anything with files, users etc. I readded the watched folder, that didn't fix it for admin but the PM user is working, so at least I can add files for now.

Problem is I don't think I can 'promote' or change users without that admin access...?

EDIT: Managed to create a new admin user even though the "Processing" was going on in the View User window. New temp admin user is fine, no problems at all...

Naomi

Is there anything showing in /var/log/airtime/zendphp.log around the time you try to do something with the admin user?

Tim RadioClash

Yes there is: a sample:

2013-07-18T19:58:03+01:00 INFO (6): [index.php : () : line 71] - array_key_exists() expects parameter 2 to be array, null given
2013-07-18T19:58:03+01:00 INFO (6): [index.php : () : line 73] - #0 [internal function]: exception_error_handler(2, 'array_key_exist...', '/usr/share/airt...', 1270, Array)
#1 /usr/share/airtime/application/models/Preference.php(1270): array_key_exists('ColReorder', NULL)
#2 /usr/share/airtime/application/models/Preference.php(1290): Application_Model_Preference::getOrderingMap('library_datatab...')
#3 /usr/share/airtime/application/models/Datatables.php(62): Application_Model_Preference::getCurrentLibraryTableColumnMap()
#4 /usr/share/airtime/application/models/User.php(329): Application_Model_Datatables::findEntries(Object(PropelPDO), Array, 'cc_subjs', Array)
#5 /usr/share/airtime/application/controllers/UserController.php(111): Application_Model_User::getUsersDataTablesInfo(Array)
#6 /usr/share/php/libzend-framework-php/Zend/Controller/Action.php(516): UserController->getUserDataTableInfoAction()
#7 /usr/share/php/libzend-framework-php/Zend/Controller/Dispatcher/Standard.php(295): Zend_Controller_Action->dispatch('getUserDataTabl...')
#8 /usr/share/php/libzend-framework-php/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Contr$
#9 /usr/share/php/libzend-framework-php/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch()
#10 /usr/share/php/libzend-framework-php/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
#11 /usr/share/airtime/public/index.php(64): Zend_Application->run()
#12 {main}
2013-07-18T20:03:40+01:00 INFO (6): [index.php : () : line 71] - array_key_exists() expects parameter 2 to be array, null given
2013-07-18T20:03:40+01:00 INFO (6): [index.php : () : line 73] - #0 [internal function]: exception_error_handler(2, 'array_key_exist...', '/usr/share/airt...', 1270, Array)
#1 /usr/share/airtime/application/models/Preference.php(1270): array_key_exists('ColReorder', NULL)
#2 /usr/share/airtime/application/models/Preference.php(1290): Application_Model_Preference::getOrderingMap('library_datatab...')
#3 /usr/share/airtime/application/models/Datatables.php(62): Application_Model_Preference::getCurrentLibraryTableColumnMap()
#4 /usr/share/airtime/application/models/StoredFile.php(776): Application_Model_Datatables::findEntries(Object(PropelPDO), Array, '((SELECT PL.id ...', Array)
#5 /usr/share/airtime/application/controllers/LibraryController.php(414): Application_Model_StoredFile::searchLibraryFiles(Array)
#6 /usr/share/php/libzend-framework-php/Zend/Controller/Action.php(516): LibraryController->contentsFeedAction()
#7 /usr/share/php/libzend-framework-php/Zend/Controller/Dispatcher/Standard.php(295): Zend_Controller_Action->dispatch('contentsFeedAct...')
#8 /usr/share/php/libzend-framework-php/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Contr$
#9 /usr/share/php/libzend-framework-php/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch()
#10 /usr/share/php/libzend-framework-php/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
#11 /usr/share/airtime/public/index.php(64): Zend_Application->run()
#12 {main}
2013-07-18T20:03:40+01:00 INFO (6): [index.php : () : line 71] - array_key_exists() expects parameter 2 to be array, null given
2013-07-18T20:03:40+01:00 INFO (6): [index.php : () : line 73] - #0 [internal function]: exception_error_handler(2, 'array_key_exist...', '/usr/share/airt...', 1270, Array)
#1 /usr/share/airtime/application/models/Preference.php(1270): array_key_exists('ColReorder', NULL)
#2 /usr/share/airtime/application/models/Preference.php(1290): Application_Model_Preference::getOrderingMap('library_datatab...')
#3 /usr/share/airtime/application/models/Datatables.php(62): Application_Model_Preference::getCurrentLibraryTableColumnMap()
#4 /usr/share/airtime/application/models/StoredFile.php(776): Application_Model_Datatables::findEntries(Object(PropelPDO), Array, '((SELECT PL.id ...', Array)
#5 /usr/share/airtime/application/controllers/LibraryController.php(414): Application_Model_StoredFile::searchLibraryFiles(Array)
#6 /usr/share/php/libzend-framework-php/Zend/Controller/Action.php(516): LibraryController->contentsFeedAction()
#7 /usr/share/php/libzend-framework-php/Zend/Controller/Dispatcher/Standard.php(295): Zend_Controller_Action->dispatch('contentsFeedAct...')
#8 /usr/share/php/libzend-framework-php/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Contr$
#9 /usr/share/php/libzend-framework-php/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch()
#10 /usr/share/php/libzend-framework-php/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
#11 /usr/share/airtime/public/index.php(64): Zend_Application->run()
#12 {main}
2013-07-18T20:03:40+01:00 INFO (6): [index.php : () : line 71] - array_key_exists() expects parameter 2 to be array, null given
2013-07-18T20:03:40+01:00 INFO (6): [index.php : () : line 73] - #0 [internal function]: exception_error_handler(2, 'array_key_exist...', '/usr/share/airt...', 1270, Array)
#1 /usr/share/airtime/application/models/Preference.php(1270): array_key_exists('ColReorder', NULL)
#2 /usr/share/airtime/application/models/Preference.php(1290): Application_Model_Preference::getOrderingMap('library_datatab...')
#3 /usr/share/airtime/application/models/Datatables.php(62): Application_Model_Preference::getCurrentLibraryTableColumnMap()
#4 /usr/share/airtime/application/models/StoredFile.php(776): Application_Model_Datatables::findEntries(Object(PropelPDO), Array, '((SELECT PL.id ...', Array)
#5 /usr/share/airtime/application/controllers/LibraryController.php(414): Application_Model_StoredFile::searchLibraryFiles(Array)
#6 /usr/share/php/libzend-framework-php/Zend/Controller/Action.php(516): LibraryController->contentsFeedAction()
#7 /usr/share/php/libzend-framework-php/Zend/Controller/Dispatcher/Standard.php(295): Zend_Controller_Action->dispatch('contentsFeedAct...')
#8 /usr/share/php/libzend-framework-php/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Contr$
#9 /usr/share/php/libzend-framework-php/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch()
#10 /usr/share/php/libzend-framework-php/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
#11 /usr/share/airtime/public/index.php(64): Zend_Application->run()
#12 {main}
2013-07-18T20:03:56+01:00 INFO (6): [index.php : () : line 71] - array_key_exists() expects parameter 2 to be array, null given
2013-07-18T20:03:56+01:00 INFO (6): [index.php : () : line 73] - #0 [internal function]: exception_error_handler(2, 'array_key_exist...', '/usr/share/airt...', 1270, Array)
#1 /usr/share/airtime/application/models/Preference.php(1270): array_key_exists('ColReorder', NULL)
#2 /usr/share/airtime/application/models/Preference.php(1290): Application_Model_Preference::getOrderingMap('library_datatab...')
#3 /usr/share/airtime/application/models/Datatables.php(62): Application_Model_Preference::getCurrentLibraryTableColumnMap()
#4 /usr/share/airtime/application/models/User.php(329): Application_Model_Datatables::findEntries(Object(PropelPDO), Array, 'cc_subjs', Array)
#5 /usr/share/airtime/application/controllers/UserController.php(111): Application_Model_User::getUsersDataTablesInfo(Array)
#6 /usr/share/php/libzend-framework-php/Zend/Controller/Action.php(516): UserController->getUserDataTableInfoAction()
#7 /usr/share/php/libzend-framework-php/Zend/Controller/Dispatcher/Standard.php(295): Zend_Controller_Action->dispatch('getUserDataTabl...')
#8 /usr/share/php/libzend-framework-php/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Contr$
#9 /usr/share/php/libzend-framework-php/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch()
#10 /usr/share/php/libzend-framework-php/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
#11 /usr/share/airtime/public/index.php(64): Zend_Application->run()
#12 {main}

Denise Rigato

@Tim You have 2.4 installed, correct?

What is the output of:

sudo -u postgres psql airtime -c "select valstr from cc_pref where keystr = 'library_datatable' and subjid = 1"

Ronald Abbring

The solution in http://forum.sourcefabric.org/discussion/comment/28178#Comment_28178 worked for me.

Select the column 'Owner' in show/hide columns.

Howdy, Stranger!

Categories

Poll

Top Posters