problem

On using the Xliff2 export on tasks where the MatView does not exist the following error can happen:

"Base table or view not found: 1146 Table 'translate5.LEK_segment_view_XXXXX' doesn't exist"

solution

call reInitDb after materialized view check, and not before.

 

trace

exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'translate5.LEK_segment_view_XXXXX' doesn't exist' in /var/www/translate5/library/zend/Zend/Db/Statement/Pdo.php:228
Stack trace:
#0 /var/www/translate5/library/zend/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array)
#1 /var/www/translate5/library/zend/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo->_execute(Array)
#2 /var/www/translate5/library/zend/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#3 /var/www/translate5/library/zend/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('DESCRIBE `LEK_s...', Array)
#4 /var/www/translate5/library/zend/Zend/Db/Adapter/Pdo/Mysql.php(171): Zend_Db_Adapter_Pdo_Abstract->query('DESCRIBE `LEK_s...')
#5 /var/www/translate5/library/zend/Zend/Db/Table/Abstract.php(836): Zend_Db_Adapter_Pdo_Mysql->describeTable('LEK_segment_vie...', NULL)
#6 /var/www/translate5/library/zend/Zend/Db/Table/Abstract.php(858): Zend_Db_Table_Abstract->_setupMetadata()
#7 /var/www/translate5/library/zend/Zend/Db/Table/Abstract.php(898): Zend_Db_Table_Abstract->_getCols()
#8 /var/www/translate5/library/zend/Zend/Db/Table/Abstract.php(983): Zend_Db_Table_Abstract->_setupPrimaryKey()
#9 /var/www/translate5/application/modules/editor/Models/Segment.php(1258): Zend_Db_Table_Abstract->info('name')
#10 /var/www/translate5/application/modules/editor/Models/Segment.php(894): editor_Models_Segment->reInitDb('{XXXXXXXX-XXXX-...')
#11 /var/www/translate5/application/modules/editor/Models/Segment/Iterator.php(104): editor_Models_Segment->loadFirst('{XXXXXXXX-XXXX-...', 803)
#12 /var/www/translate5/application/modules/editor/Models/Segment/Iterator.php(63): editor_Models_Segment_Iterator->rewind()
#13 [internal function]: editor_Models_Segment_Iterator->__construct('

{XXXXXXXX-XXXX-...', 803) #14 /var/www/translate5/library/ZfExtended/Factory.php(51): ReflectionClass->newInstanceArgs(Array) #15 /var/www/translate5/application/modules/editor/Models/Converter/SegmentsToXliffAbstract.php(241): ZfExtended_Factory::get('editor_Models_S...', Array) #16 /var/www/translate5/application/modules/editor/Models/Export/Xliff2Worker.php(106): editor_Models_Converter_SegmentsToXliffAbstract->export(Object(editor_Models_Task)) #17 /var/www/translate5/library/ZfExtended/Worker/Abstract.php(517): editor_Models_Export_Xliff2Worker->work() #18 /var/www/translate5/library/ZfExtended/Worker/Abstract.php(466): ZfExtended_Worker_Abstract->_run() #19 /var/www/translate5/library/ZfExtended/Controllers/WorkerController.php(111): ZfExtended_Worker_Abstract->runQueued() #20 /var/www/translate5/library/zend/Zend/Controller/Action.php(516): ZfExtended_WorkerController->putAction() #21 /var/www/translate5/library/ZfExtended/Controllers/AAARestController.php(275): Zend_Controller_Action->dispatch('putAction') #22 /var/www/translate5/library/zend/Zend/Controller/Dispatcher/Standard.php(308): ZfExtended_RestController->dispatch('putAction') #23 /var/www/translate5/library/zend/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(REST_Controller_Request_Http), Object(Zend_Controller_Response_Http)) #24 /var/www/translate5/library/zend/Zend/Application/Bootstrap/Bootstrap.php(105): Zend_Controller_Front->dispatch() #25 /var/www/translate5/library/zend/Zend/Application.php(382): Zend_Application_Bootstrap_Bootstrap->run() #26 /var/www/translate5/library/ZfExtended/BaseIndex.php(167): Zend_Application->run() #27 /var/www/translate5/public/index.php(35): ZfExtended_BaseIndex->startApplication() #28 \{main}