problem

If a task is ended, or if a task is not use a longer time, the LEK_segment_view table to that task is deleted.

Several actions need the existence of the view, so the view is recreated casually.

This recreation (search for createMaterializedView calls) is missing for the XLIFF 2.1 export. (For the default export the recreation is not necessary).

So trying to XLIFF 2.1 export a task without a LEK_segment_view table leads to the following error:

[14-Aug-2018 14:15:19 Europe/Vienna] ZfExtended_Log on translate5.localdev:
Exception: exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'icorrectT5.LEK_segment_view_1b00ff048f11d63c6811c95527b22017' 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(894): editor_Models_Segment->reInitDb('{3bd02e3a-50d2-...')
#11 /home/tlauria/www/translate5-master/application/modules/editor/Models/Segment/Iterator.php(104): editor_Models_Segment->loadFirst('{3bd02e3a-50d2-...', 9938)
#12 /home/tlauria/www/translate5-master/application/modules/editor/Models/Segment/Iterator.php(63): editor_Models_Segment_Iterator->rewind()
#13 [internal function]: editor_Models_Segment_Iterator->__construct('

{3bd02e3a-50d2-...', 9938) #14 /home/tlauria/www/translate5-master/library/ZfExtended/Factory.php(51): ReflectionClass->newInstanceArgs(Array) #15 /home/tlauria/www/translate5-master/application/modules/editor/Models/Converter/SegmentsToXliffAbstract.php(241): ZfExtended_Factory::get('editor_Models_S...', Array) #16 /home/tlauria/www/translate5-master/application/modules/editor/Models/Export/Xliff2Worker.php(106): editor_Models_Converter_SegmentsToXliffAbstract->export(Object(editor_Models_Task)) #17 /home/tlauria/www/translate5-master/library/ZfExtended/Worker/Abstract.php(517): editor_Models_Export_Xliff2Worker->work() #18 /home/tlauria/www/translate5-master/library/ZfExtended/Worker/Abstract.php(466): ZfExtended_Worker_Abstract->_run() #19 /home/tlauria/www/translate5-master/library/ZfExtended/Controllers/WorkerController.php(111): ZfExtended_Worker_Abstract->runQueued() #20 /home/tlauria/libaries/ZendFramework-1.12.20-minimal/library/Zend/Controller/Action.php(516): ZfExtended_WorkerController->putAction() #21 /home/tlauria/www/translate5-master/library/ZfExtended/Controllers/AAARestController.php(275): Zend_Controller_Action->dispatch('putAction') #22 /home/tlauria/libaries/ZendFramework-1.12.20-minimal/library/Zend/Controller/Dispatcher/Standard.php(308): ZfExtended_RestController->dispatch('putAction') #23 /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)) #24 /home/tlauria/libaries/ZendFramework-1.12.20-minimal/library/Zend/Application/Bootstrap/Bootstrap.php(105): Zend_Controller_Front->dispatch() #25 /home/tlauria/libaries/ZendFramework-1.12.20-minimal/library/Zend/Application.php(384): Zend_Application_Bootstrap_Bootstrap->run() #26 /home/tlauria/www/translate5-master/library/ZfExtended/BaseIndex.php(167): Zend_Application->run() #27 /home/tlauria/www/translate5-master/public/index.php(35): ZfExtended_BaseIndex->startApplication() #28 \{main}