problem

Deleting a task proofreader user association which then triggers a finish all (because the remaining proofreaders are already finished) throws an error if the materialized view does not exist.

trace

exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'icorrectT5.LEK_segment_view_e8a9e28d95749e3f8900e0b45f1622f3' doesn't exist' in /home/tlauria/libaries/ZendFramework-1.12.20-minimal/library/Zend/Db/Statement/Pdo.php:228
Stack trace:
#0 /home/tlauria/libaries/ZendFramework-1.12.20-minimal/library/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array)
#1 /home/tlauria/libaries/ZendFramework-1.12.20-minimal/library/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo->_execute(Array)
#2 /home/tlauria/libaries/ZendFramework-1.12.20-minimal/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#3 /home/tlauria/libaries/ZendFramework-1.12.20-minimal/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('DESCRIBE `LEK_s...', Array)
#4 /home/tlauria/libaries/ZendFramework-1.12.20-minimal/library/Zend/Db/Adapter/Pdo/Mysql.php(171): Zend_Db_Adapter_Pdo_Abstract->query('DESCRIBE `LEK_s...')
#5 /home/tlauria/libaries/ZendFramework-1.12.20-minimal/library/Zend/Db/Table/Abstract.php(836): Zend_Db_Adapter_Pdo_Mysql->describeTable('LEK_segment_vie...', NULL)
#6 /home/tlauria/libaries/ZendFramework-1.12.20-minimal/library/Zend/Db/Table/Abstract.php(858): Zend_Db_Table_Abstract->_setupMetadata()
#7 /home/tlauria/libaries/ZendFramework-1.12.20-minimal/library/Zend/Db/Table/Abstract.php(898): Zend_Db_Table_Abstract->_getCols()
#8 /home/tlauria/libaries/ZendFramework-1.12.20-minimal/library/Zend/Db/Table/Abstract.php(983): Zend_Db_Table_Abstract->_setupPrimaryKey()
#9 /home/tlauria/www/translate5-master/application/modules/editor/Models/Segment.php(1258): Zend_Db_Table_Abstract->info('name')
#10 /home/tlauria/www/translate5-master/application/modules/editor/Models/Segment.php(1054): editor_Models_Segment->reInitDb('{51f7bbe6-01d0-...')
#11 /home/tlauria/www/translate5-master/application/modules/editor/Workflow/Notification.php(82): editor_Models_Segment->loadByWorkflowStep('

{51f7bbe6-01d0-...', 'lectoring', '2') #12 /home/tlauria/www/translate5-master/application/modules/editor/Workflow/Notification.php(186): editor_Workflow_Notification->getStepSegments('lectoring') #13 [internal function]: editor_Workflow_Notification->notifyAllFinishOfARole() #14 /home/tlauria/www/translate5-master/application/modules/editor/Workflow/Abstract.php(821): call_user_func(Array) #15 /home/tlauria/www/translate5-master/application/modules/editor/Workflow/Default.php(91): editor_Workflow_Abstract->callActions('handleAllFinish...', 'translatorCheck', 'lector', 'finished') #16 /home/tlauria/www/translate5-master/application/modules/editor/Workflow/Abstract.php(1056): editor_Workflow_Default->handleAllFinishOfARole() #17 /home/tlauria/www/translate5-master/application/modules/editor/Workflow/Abstract.php(271): editor_Workflow_Abstract->doUserAssociationDelete(Object(editor_Models_TaskUserAssoc)) #18 [internal function]: editor_Workflow_Abstract->\{closure}

(Object(Zend_EventManager_Event))
#19 /home/tlauria/libaries/ZendFramework-1.12.20-minimal/library/Zend/EventManager/EventManager.php(469): call_user_func(Object(Closure), Object(Zend_EventManager_Event))
#20 /home/tlauria/libaries/ZendFramework-1.12.20-minimal/library/Zend/EventManager/EventManager.php(208): Zend_EventManager_EventManager->triggerListeners('afterDeleteActi...', Object(Zend_EventManager_Event), NULL)
#21 /home/tlauria/www/translate5-master/library/ZfExtended/EventManager.php(68): Zend_EventManager_EventManager->trigger('afterDeleteActi...', Object(Editor_TaskuserassocController), Array, NULL)
#22 /home/tlauria/www/translate5-master/library/ZfExtended/Controllers/AAARestController.php(203): ZfExtended_EventManager->trigger('afterDeleteActi...', Object(Editor_TaskuserassocController), Array)
#23 /home/tlauria/www/translate5-master/library/ZfExtended/Controllers/AAARestController.php(166): ZfExtended_RestController->afterActionEvent('delete')
#24 /home/tlauria/www/translate5-master/application/modules/editor/Controllers/TaskuserassocController.php(62): ZfExtended_RestController->postDispatch()
#25 /home/tlauria/libaries/ZendFramework-1.12.20-minimal/library/Zend/Controller/Action.php(521): Editor_TaskuserassocController->postDispatch()
#26 /home/tlauria/www/translate5-master/library/ZfExtended/Controllers/AAARestController.php(287): Zend_Controller_Action->dispatch('deleteAction')
#27 /home/tlauria/libaries/ZendFramework-1.12.20-minimal/library/Zend/Controller/Dispatcher/Standard.php(308): ZfExtended_RestController->dispatch('deleteAction')
#28 /home/tlauria/libaries/ZendFramework-1.12.20-minimal/library/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(REST_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#29 /home/tlauria/libaries/ZendFramework-1.12.20-minimal/library/Zend/Application/Bootstrap/Bootstrap.php(105): Zend_Controller_Front->dispatch()
#30 /home/tlauria/libaries/ZendFramework-1.12.20-minimal/library/Zend/Application.php(384): Zend_Application_Bootstrap_Bootstrap->run()
#31 /home/tlauria/www/translate5-master/library/ZfExtended/BaseIndex.php(167): Zend_Application->run()
#32 /home/tlauria/www/translate5-master/public/index.php(35): ZfExtended_BaseIndex->startApplication()
#33 {main}

Next exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'icorrectT5.LEK_segment_view_e8a9e28d95749e3f8900e0b45f1622f3' doesn't exist, query was: DESCRIBE `LEK_segment_view_e8a9e28d95749e3f8900e0b45f1622f3`' in /home/tlauria/libaries/ZendFramework-1.12.20-minimal/library/Zend/Db/Statement/Pdo.php:235
Stack trace:
#0 /home/tlauria/libaries/ZendFramework-1.12.20-minimal/library/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/tlauria/libaries/ZendFramework-1.12.20-minimal/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#2 /home/tlauria/libaries/ZendFramework-1.12.20-minimal/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('DESCRIBE `LEK_s...', Array)
#3 /home/tlauria/libaries/ZendFramework-1.12.20-minimal/library/Zend/Db/Adapter/Pdo/Mysql.php(171): Zend_Db_Adapter_Pdo_Abstract->query('DESCRIBE `LEK_s...')
#4 /home/tlauria/libaries/ZendFramework-1.12.20-minimal/library/Zend/Db/Table/Abstract.php(836): Zend_Db_Adapter_Pdo_Mysql->describeTable('LEK_segment_vie...', NULL)
#5 /home/tlauria/libaries/ZendFramework-1.12.20-minimal/library/Zend/Db/Table/Abstract.php(858): Zend_Db_Table_Abstract->_setupMetadata()
#6 /home/tlauria/libaries/ZendFramework-1.12.20-minimal/library/Zend/Db/Table/Abstract.php(898): Zend_Db_Table_Abstract->_getCols()
#7 /home/tlauria/libaries/ZendFramework-1.12.20-minimal/library/Zend/Db/Table/Abstract.php(983): Zend_Db_Table_Abstract->_setupPrimaryKey()
#8 /home/tlauria/www/translate5-master/application/modules/editor/Models/Segment.php(1258): Zend_Db_Table_Abstract->info('name')
#9 /home/tlauria/www/translate5-master/application/modules/editor/Models/Segment.php(1054): editor_Models_Segment->reInitDb('{51f7bbe6-01d0-...')
#10 /home/tlauria/www/translate5-master/application/modules/editor/Workflow/Notification.php(82): editor_Models_Segment->loadByWorkflowStep('

{51f7bbe6-01d0-...', 'lectoring', '2') #11 /home/tlauria/www/translate5-master/application/modules/editor/Workflow/Notification.php(186): editor_Workflow_Notification->getStepSegments('lectoring') #12 [internal function]: editor_Workflow_Notification->notifyAllFinishOfARole() #13 /home/tlauria/www/translate5-master/application/modules/editor/Workflow/Abstract.php(821): call_user_func(Array) #14 /home/tlauria/www/translate5-master/application/modules/editor/Workflow/Default.php(91): editor_Workflow_Abstract->callActions('handleAllFinish...', 'translatorCheck', 'lector', 'finished') #15 /home/tlauria/www/translate5-master/application/modules/editor/Workflow/Abstract.php(1056): editor_Workflow_Default->handleAllFinishOfARole() #16 /home/tlauria/www/translate5-master/application/modules/editor/Workflow/Abstract.php(271): editor_Workflow_Abstract->doUserAssociationDelete(Object(editor_Models_TaskUserAssoc)) #17 [internal function]: editor_Workflow_Abstract->\{closure}

(Object(Zend_EventManager_Event))
#18 /home/tlauria/libaries/ZendFramework-1.12.20-minimal/library/Zend/EventManager/EventManager.php(469): call_user_func(Object(Closure), Object(Zend_EventManager_Event))
#19 /home/tlauria/libaries/ZendFramework-1.12.20-minimal/library/Zend/EventManager/EventManager.php(208): Zend_EventManager_EventManager->triggerListeners('afterDeleteActi...', Object(Zend_EventManager_Event), NULL)
#20 /home/tlauria/www/translate5-master/library/ZfExtended/EventManager.php(68): Zend_EventManager_EventManager->trigger('afterDeleteActi...', Object(Editor_TaskuserassocController), Array, NULL)
#21 /home/tlauria/www/translate5-master/library/ZfExtended/Controllers/AAARestController.php(203): ZfExtended_EventManager->trigger('afterDeleteActi...', Object(Editor_TaskuserassocController), Array)
#22 /home/tlauria/www/translate5-master/library/ZfExtended/Controllers/AAARestController.php(166): ZfExtended_RestController->afterActionEvent('delete')
#23 /home/tlauria/www/translate5-master/application/modules/editor/Controllers/TaskuserassocController.php(62): ZfExtended_RestController->postDispatch()
#24 /home/tlauria/libaries/ZendFramework-1.12.20-minimal/library/Zend/Controller/Action.php(521): Editor_TaskuserassocController->postDispatch()
#25 /home/tlauria/www/translate5-master/library/ZfExtended/Controllers/AAARestController.php(287): Zend_Controller_Action->dispatch('deleteAction')
#26 /home/tlauria/libaries/ZendFramework-1.12.20-minimal/library/Zend/Controller/Dispatcher/Standard.php(308): ZfExtended_RestController->dispatch('deleteAction')
#27 /home/tlauria/libaries/ZendFramework-1.12.20-minimal/library/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(REST_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#28 /home/tlauria/libaries/ZendFramework-1.12.20-minimal/library/Zend/Application/Bootstrap/Bootstrap.php(105): Zend_Controller_Front->dispatch()
#29 /home/tlauria/libaries/ZendFramework-1.12.20-minimal/library/Zend/Application.php(384): Zend_Application_Bootstrap_Bootstrap->run()
#30 /home/tlauria/www/translate5-master/library/ZfExtended/BaseIndex.php(167): Zend_Application->run()
#31 /home/tlauria/www/translate5-master/public/index.php(35): ZfExtended_BaseIndex->startApplication()
#32 {main} Attachment Size: 158