16225: Unable to VV export - LimeSurvey bugs and feature requests

This bug affects 1 person(s).

ID	Project	Category	View Status	Date Submitted	Last Update

16225	Bug reports	Import/Export	public	2020-05-05 09:30	2020-12-30 19:27

Reporter	DenisChenu	Assigned To	DenisChenu
Priority	none	Severity	minor
Status	closed	Resolution	fixed
Product Version	4.2.2
Fixed in Version	4.2.2

Summary	16225: Unable to VV export
Description	When trying to export survey without token : receive a 500 error.
Steps To Reproduce	Import included survey, try to VV export
Tags	No tags attached.
Attached Files	survey_archive_624189.lsa (4,304 bytes) Capture d’écran du 2020-05-05 09-26-36.png (87,429 bytes) Capture d’écran du 2020-05-05 09-26-36.png (87,429 bytes)

Bug heat	6
Complete LimeSurvey version number (& build)	4.2.2 github
I will donate to the project if issue is resolved	No
Browser	ff
Database type & version	mariadb
Server OS (if known)	fedora/linux
Webserver software & version (if known)	nginx
PHP Version	php7.3

User List	There are no users monitoring this issue.

ollehar 2020-05-05 18:02 administrator ~57553	Can you enable debug = 2 in application/config/config.php and try again, please? Paste the complete error message here.

DenisChenu 2020-05-05 18:30 developer ~57556 Last edited: 2020-05-05 18:30	debug 2 set, can not really get the error … (copy/paste from console) VVEror.html (24,197 bytes) <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/> <title>CDbException</title> <style type="text/css"> /<![CDATA[/ html,body,div,span,applet,object,iframe,h1,h2,h3,h4,h5,h6,p,blockquote,pre,a,abbr,acronym,address,big,cite,code,del,dfn,em,font,img,ins,kbd,q,s,samp,small,strike,strong,sub,sup,tt,var,b,u,i,center,dl,dt,dd,ol,ul,li,fieldset,form,label,legend,table,caption,tbody,tfoot,thead,tr,th,td{border:0;outline:0;font-size:100%;vertical-align:baseline;background:transparent;margin:0;padding:0;} body{line-height:1;} ol,ul{list-style:none;} blockquote,q{quotes:none;} blockquote:before,blockquote:after,q:before,q:after{content:none;} :focus{outline:0;} ins{text-decoration:none;} del{text-decoration:line-through;} table{border-collapse:collapse;border-spacing:0;} body { font: normal 9pt "Verdana"; color: #000; background: #fff; } h1 { font: normal 18pt "Verdana"; color: #f00; margin-bottom: .5em; } h2 { font: normal 14pt "Verdana"; color: #800000; margin-bottom: .5em; } h3 { font: bold 11pt "Verdana"; } pre { font: normal 11pt Menlo, Consolas, "Lucida Console", Monospace; } pre span.error { display: block; background: #fce3e3; } pre span.ln { color: #999; padding-right: 0.5em; border-right: 1px solid #ccc; } pre span.error-ln { font-weight: bold; } .container { margin: 1em 4em; } .version { color: gray; font-size: 8pt; border-top: 1px solid #aaa; padding-top: 1em; margin-bottom: 1em; } .message { color: #000; padding: 1em; font-size: 11pt; background: #f3f3f3; -webkit-border-radius: 10px; -moz-border-radius: 10px; border-radius: 10px; margin-bottom: 1em; line-height: 160%; } .source { margin-bottom: 1em; } .code pre { background-color: #ffe; margin: 0.5em 0; padding: 0.5em; line-height: 125%; border: 1px solid #eee; } .source .file { margin-bottom: 1em; font-weight: bold; } .traces { margin: 2em 0; } .trace { margin: 0.5em 0; padding: 0.5em; } .trace.app { border: 1px dashed #c00; } .trace .number { text-align: right; width: 2em; padding: 0.5em; } .trace .content { padding: 0.5em; } .trace .plus, .trace .minus { display:inline; vertical-align:middle; text-align:center; border:1px solid #000; color:#000; font-size:10px; line-height:10px; margin:0; padding:0 1px; width:10px; height:10px; } .trace.collapsed .minus, .trace.expanded .plus, .trace.collapsed pre { display: none; } .trace-file { cursor: pointer; padding: 0.2em; } .trace-file:hover { background: #f0ffff; } /]]>/ </style> </head> <body> <div class="container"> <h1>CDbException</h1> <p class="message"> La table « {{tokens_624189}} » associée à la classe Active record « Token_624189 » est introuvable dans la base de données. </p> <div class="source"> <p class="file">/mnt/data/shnoulle/nginx/www/master/framework/db/ar/CActiveRecord.php(2390)</p> <div class="code"><pre><span class="ln">2378</span> <span class="ln">2379</span> /** <span class="ln">2380</span> * Constructor. <span class="ln">2381</span> * @param CActiveRecord $model the model instance <span class="ln">2382</span> * @throws CDbException if specified table for active record class cannot be found in the database <span class="ln">2383</span> / <span class="ln">2384</span> public function __construct($model) <span class="ln">2385</span> { <span class="ln">2386</span> $this->_modelClassName=get_class($model); <span class="ln">2387</span> <span class="ln">2388</span> $tableName=$model->tableName(); <span class="ln">2389</span> if(($table=$model->getDbConnection()->getSchema()->getTable($tableName))===null) <span class="error"><span class="ln error-ln">2390</span> throw new CDbException(Yii::t('yii','The table "{table}" for active record class "{class}" cannot be found in the database.', </span><span class="ln">2391</span> array('{class}'=>$this->_modelClassName,'{table}'=>$tableName))); <span class="ln">2392</span> <span class="ln">2393</span> if(($modelPk=$model->primaryKey())!==null \|\| $table->primaryKey===null) <span class="ln">2394</span> { <span class="ln">2395</span> $table->primaryKey=$modelPk; <span class="ln">2396</span> if(is_string($table->primaryKey) && isset($table->columns[$table->primaryKey])) <span class="ln">2397</span> $table->columns[$table->primaryKey]->isPrimaryKey=true; <span class="ln">2398</span> elseif(is_array($table->primaryKey)) <span class="ln">2399</span> { <span class="ln">2400</span> foreach($table->primaryKey as $name) <span class="ln">2401</span> { <span class="ln">2402</span> if(isset($table->columns[$name])) </pre></div> </div> <div class="traces"> <h2>Stack Trace</h2> <table style="width:100%;"> <tr class="trace core collapsed"> <td class="number"> #0 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div>  /mnt/data/shnoulle/nginx/www/master/framework/db/ar/CActiveRecord.php(413): <strong>CActiveRecordMetaData</strong>-><strong>__construct</strong>(Token_624189) </div> <div class="code"><pre><span class="ln">408</span> { <span class="ln">409</span> $className=get_class($this); <span class="ln">410</span> if(!array_key_exists($className,self::$_md)) <span class="ln">411</span> { <span class="ln">412</span> self::$_md[$className]=null; // preventing recursive invokes of {@link getMetaData()} via {@link __get()} <span class="error"><span class="ln error-ln">413</span> self::$_md[$className]=new CActiveRecordMetaData($this); </span><span class="ln">414</span> } <span class="ln">415</span> return self::$_md[$className]; <span class="ln">416</span> } <span class="ln">417</span> <span class="ln">418</span> /* </pre></div> </td> </tr> <tr class="trace core collapsed"> <td class="number"> #1 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div>  /mnt/data/shnoulle/nginx/www/master/framework/db/ar/CActiveRecord.php(682): <strong>CActiveRecord</strong>-><strong>getMetaData</strong>() </div> <div class="code"><pre><span class="ln">677</span> * @param string $name attribute name <span class="ln">678</span> * @return boolean whether this AR has the named attribute (table column). <span class="ln">679</span> / <span class="ln">680</span> public function hasAttribute($name) <span class="ln">681</span> { <span class="error"><span class="ln error-ln">682</span> return isset($this->getMetaData()->columns[$name]); </span><span class="ln">683</span> } <span class="ln">684</span> <span class="ln">685</span> /* <span class="ln">686</span> * Returns the named attribute value. <span class="ln">687</span> * If this is a new record and the attribute is not set before, </pre></div> </td> </tr> <tr class="trace app expanded"> <td class="number"> #2 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div>  /mnt/data/shnoulle/nginx/www/master/application/models/LSActiveRecord.php(35): <strong>CActiveRecord</strong>-><strong>hasAttribute</strong>("created") </div> <div class="code"><pre><span class="ln">30</span> * @return array <span class="ln">31</span> / <span class="ln">32</span> public function behaviors() <span class="ln">33</span> { <span class="ln">34</span> $aBehaviors = array(); <span class="error"><span class="ln error-ln">35</span> $sCreateFieldName = ($this->hasAttribute('created') ? 'created' : null); </span><span class="ln">36</span> $sUpdateFieldName = ($this->hasAttribute('modified') ? 'modified' : null); <span class="ln">37</span> $sDriverName = Yii::app()->db->getDriverName(); <span class="ln">38</span> if ($sDriverName == 'sqlsrv' \|\| $sDriverName == 'dblib') { <span class="ln">39</span> $sTimestampExpression = new CDbExpression('GETDATE()'); <span class="ln">40</span> } else { </pre></div> </td> </tr> <tr class="trace core collapsed"> <td class="number"> #3 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div>  /mnt/data/shnoulle/nginx/www/master/framework/db/ar/CActiveRecord.php(398): <strong>LSActiveRecord</strong>-><strong>behaviors</strong>() </div> <div class="code"><pre><span class="ln">393</span> if(isset(self::$_models[$className])) <span class="ln">394</span> return self::$_models[$className]; <span class="ln">395</span> else <span class="ln">396</span> { <span class="ln">397</span> $model=self::$_models[$className]=new $className(null); <span class="error"><span class="ln error-ln">398</span> $model->attachBehaviors($model->behaviors()); </span><span class="ln">399</span> return $model; <span class="ln">400</span> } <span class="ln">401</span> } <span class="ln">402</span> <span class="ln">403</span> /* </pre></div> </td> </tr> <tr class="trace app expanded"> <td class="number"> #4 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div>  /mnt/data/shnoulle/nginx/www/master/application/models/Dynamic.php(38): <strong>CActiveRecord</strong>::<strong>model</strong>("Token_624189") </div> <div class="code"><pre><span class="ln">33</span> $className = get_called_class(); <span class="ln">34</span> } elseif (is_numeric($className)) { <span class="ln">35</span> $className = get_called_class().'_'.$className; <span class="ln">36</span> } <span class="ln">37</span> /** @var self $model / <span class="error"><span class="ln error-ln">38</span> $model = parent::model($className); </span><span class="ln">39</span> return $model; <span class="ln">40</span> } <span class="ln">41</span> <span class="ln">42</span> /* <span class="ln">43</span> * @param string $scenario </pre></div> </td> </tr> <tr class="trace app expanded"> <td class="number"> #5 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div>  /mnt/data/shnoulle/nginx/www/master/application/models/Token.php(338): <strong>Dynamic</strong>::<strong>model</strong>("Token_624189") </div> <div class="code"><pre><span class="ln">333</span> * @return Token <span class="ln">334</span> / <span class="ln">335</span> public static function model($className = null) <span class="ln">336</span> { <span class="ln">337</span> /* @var self $model / <span class="error"><span class="ln error-ln">338</span> $model = parent::model($className); </span><span class="ln">339</span> return $model; <span class="ln">340</span> } <span class="ln">341</span> <span class="ln">342</span> /* <span class="ln">343</span> * @param int $surveyId </pre></div> </td> </tr> <tr class="trace app collapsed"> <td class="number"> #6 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div>  /mnt/data/shnoulle/nginx/www/master/application/controllers/admin/export.php(686): <strong>Token</strong>::<strong>model</strong>("624189") </div> <div class="code"><pre><span class="ln">681</span> <span class="ln">682</span> <span class="ln">683</span> foreach ($result as $row) { <span class="ln">684</span> <span class="ln">685</span> // prepare the data for decryption <span class="error"><span class="ln error-ln">686</span> $oToken = Token::model($iSurveyId); </span><span class="ln">687</span> $oToken->setAttributes($row, false); <span class="ln">688</span> $oToken->decrypt(); <span class="ln">689</span> <span class="ln">690</span> $oResponse = Response::model($iSurveyId); <span class="ln">691</span> $oResponse->setAttributes($row, false); </pre></div> </td> </tr> <tr class="trace core collapsed"> <td class="number"> #7 </td> <td class="content"> <div class="trace-file">  unknown(0): <strong>export</strong>-><strong>vvexport</strong>() </div> </td> </tr> <tr class="trace core collapsed"> <td class="number"> #8 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div>  /mnt/data/shnoulle/nginx/www/master/framework/web/actions/CAction.php(109): <strong>ReflectionMethod</strong>-><strong>invokeArgs</strong>(export, array()) </div> <div class="code"><pre><span class="ln">104</span> elseif($param->isDefaultValueAvailable()) <span class="ln">105</span> $ps[]=$param->getDefaultValue(); <span class="ln">106</span> else <span class="ln">107</span> return false; <span class="ln">108</span> } <span class="error"><span class="ln error-ln">109</span> $method->invokeArgs($object,$ps); </span><span class="ln">110</span> return true; <span class="ln">111</span> } <span class="ln">112</span> } </pre></div> </td> </tr> <tr class="trace app collapsed"> <td class="number"> #9 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div>  /mnt/data/shnoulle/nginx/www/master/application/core/Survey_Common_Action.php(86): <strong>CAction</strong>-><strong>runWithParamsInternal</strong>(export, ReflectionMethod, array("surveyid" => "624189", "sa" => "vvexport", "iSurveyId" => "624189", "iSurveyID" => "624189", ...)) </div> <div class="code"><pre><span class="ln">81</span> $oMethod = new ReflectionMethod($this, $sDefault); <span class="ln">82</span> } <span class="ln">83</span> <span class="ln">84</span> // We're all good to go, let's execute it <span class="ln">85</span> // runWithParamsInternal would automatically get the parameters of the method and populate them as required with the params <span class="error"><span class="ln error-ln">86</span> return parent::runWithParamsInternal($this, $oMethod, $params); </span><span class="ln">87</span> } <span class="ln">88</span> <span class="ln">89</span> /** <span class="ln">90</span> * Some functions have different parameters, which are just an alias of the <span class="ln">91</span> * usual parameters we're getting in the url. This function just populates </pre></div> </td> </tr> <tr class="trace core collapsed"> <td class="number"> #10 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div>  /mnt/data/shnoulle/nginx/www/master/framework/web/CController.php(308): <strong>Survey_Common_Action</strong>-><strong>runWithParams</strong>(array("surveyid" => "624189", "sa" => "vvexport", "iSurveyId" => "624189", "iSurveyID" => "624189", ...)) </div> <div class="code"><pre><span class="ln">303</span> { <span class="ln">304</span> $priorAction=$this->_action; <span class="ln">305</span> $this->_action=$action; <span class="ln">306</span> if($this->beforeAction($action)) <span class="ln">307</span> { <span class="error"><span class="ln error-ln">308</span> if($action->runWithParams($this->getActionParams())===false) </span><span class="ln">309</span> $this->invalidActionParams($action); <span class="ln">310</span> else <span class="ln">311</span> $this->afterAction($action); <span class="ln">312</span> } <span class="ln">313</span> $this->_action=$priorAction; </pre></div> </td> </tr> <tr class="trace core collapsed"> <td class="number"> #11 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div>  /mnt/data/shnoulle/nginx/www/master/framework/web/CController.php(286): <strong>CController</strong>-><strong>runAction</strong>(export) </div> <div class="code"><pre><span class="ln">281</span> * @see runAction <span class="ln">282</span> / <span class="ln">283</span> public function runActionWithFilters($action,$filters) <span class="ln">284</span> { <span class="ln">285</span> if(empty($filters)) <span class="error"><span class="ln error-ln">286</span> $this->runAction($action); </span><span class="ln">287</span> else <span class="ln">288</span> { <span class="ln">289</span> $priorAction=$this->_action; <span class="ln">290</span> $this->_action=$action; <span class="ln">291</span> CFilterChain::create($this,$action,$filters)->run(); </pre></div> </td> </tr> <tr class="trace core collapsed"> <td class="number"> #12 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div>  /mnt/data/shnoulle/nginx/www/master/framework/web/CController.php(265): <strong>CController</strong>-><strong>runActionWithFilters</strong>(export, array()) </div> <div class="code"><pre><span class="ln">260</span> { <span class="ln">261</span> if(($parent=$this->getModule())===null) <span class="ln">262</span> $parent=Yii::app(); <span class="ln">263</span> if($parent->beforeControllerAction($this,$action)) <span class="ln">264</span> { <span class="error"><span class="ln error-ln">265</span> $this->runActionWithFilters($action,$this->filters()); </span><span class="ln">266</span> $parent->afterControllerAction($this,$action); <span class="ln">267</span> } <span class="ln">268</span> } <span class="ln">269</span> else <span class="ln">270</span> $this->missingAction($actionID); </pre></div> </td> </tr> <tr class="trace app collapsed"> <td class="number"> #13 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div>  /mnt/data/shnoulle/nginx/www/master/application/controllers/AdminController.php(180): <strong>CController</strong>-><strong>run</strong>("export") </div> <div class="code"><pre><span class="ln">175</span> } <span class="ln">176</span> <span class="ln">177</span> $this->runModuleController($action); <span class="ln">178</span> <span class="ln">179</span> <span class="error"><span class="ln error-ln">180</span> return parent::run($action); </span><span class="ln">181</span> } <span class="ln">182</span> <span class="ln">183</span> /* <span class="ln">184</span> * Starting with LS4, 3rd party developper can extends any of the LimeSurve controllers. <span class="ln">185</span> * </pre></div> </td> </tr> <tr class="trace core collapsed"> <td class="number"> #14 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div>  /mnt/data/shnoulle/nginx/www/master/framework/web/CWebApplication.php(282): <strong>AdminController</strong>-><strong>run</strong>("export") </div> <div class="code"><pre><span class="ln">277</span> { <span class="ln">278</span> list($controller,$actionID)=$ca; <span class="ln">279</span> $oldController=$this->_controller; <span class="ln">280</span> $this->_controller=$controller; <span class="ln">281</span> $controller->init(); <span class="error"><span class="ln error-ln">282</span> $controller->run($actionID); </span><span class="ln">283</span> $this->_controller=$oldController; <span class="ln">284</span> } <span class="ln">285</span> else <span class="ln">286</span> throw new CHttpException(404,Yii::t('yii','Unable to resolve the request "{route}".', <span class="ln">287</span> array('{route}'=>$route===''?$this->defaultController:$route))); </pre></div> </td> </tr> <tr class="trace core collapsed"> <td class="number"> #15 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div>  /mnt/data/shnoulle/nginx/www/master/framework/web/CWebApplication.php(141): <strong>CWebApplication</strong>-><strong>runController</strong>("admin/export/sa/vvexport") </div> <div class="code"><pre><span class="ln">136</span> foreach(array_splice($this->catchAllRequest,1) as $name=>$value) <span class="ln">137</span> $_GET[$name]=$value; <span class="ln">138</span> } <span class="ln">139</span> else <span class="ln">140</span> $route=$this->getUrlManager()->parseUrl($this->getRequest()); <span class="error"><span class="ln error-ln">141</span> $this->runController($route); </span><span class="ln">142</span> } <span class="ln">143</span> <span class="ln">144</span> /** <span class="ln">145</span> * Registers the core application components. <span class="ln">146</span> * This method overrides the parent implementation by registering additional core components. </pre></div> </td> </tr> <tr class="trace core collapsed"> <td class="number"> #16 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div>  /mnt/data/shnoulle/nginx/www/master/framework/base/CApplication.php(185): <strong>CWebApplication</strong>-><strong>processRequest</strong>() </div> <div class="code"><pre><span class="ln">180</span> public function run() <span class="ln">181</span> { <span class="ln">182</span> if($this->hasEventHandler('onBeginRequest')) <span class="ln">183</span> $this->onBeginRequest(new CEvent($this)); <span class="ln">184</span> register_shutdown_function(array($this,'end'),0,false); <span class="error"><span class="ln error-ln">185</span> $this->processRequest(); </span><span class="ln">186</span> if($this->hasEventHandler('onEndRequest')) <span class="ln">187</span> $this->onEndRequest(new CEvent($this)); <span class="ln">188</span> } <span class="ln">189</span> <span class="ln">190</span> /** </pre></div> </td> </tr VVEror.html (24,197 bytes)

DenisChenu 2020-05-05 18:34 developer ~57558	Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=29959

cdorin 2020-12-30 19:27 reporter ~61359	fixed in 4.4.0 rc1

Date Modified	Username	Field	Change
2020-05-05 09:30	DenisChenu	New Issue
2020-05-05 09:30	DenisChenu	File Added: survey_archive_624189.lsa
2020-05-05 09:30	DenisChenu	File Added: Capture d’écran du 2020-05-05 09-26-36.png
2020-05-05 18:02	ollehar	Note Added: 57553
2020-05-05 18:02	ollehar	Status	new => feedback
2020-05-05 18:30	DenisChenu	Note Added: 57556
2020-05-05 18:30	DenisChenu	File Added: VVEror.html
2020-05-05 18:30	DenisChenu	Status	feedback => new
2020-05-05 18:30	DenisChenu	Note Edited: 57556
2020-05-05 18:30	DenisChenu	Assigned To	=> DenisChenu
2020-05-05 18:30	DenisChenu	Status	new => assigned
2020-05-05 18:34	DenisChenu	Changeset attached	=> LimeSurvey master dabfe290
2020-05-05 18:34	DenisChenu	Note Added: 57558
2020-05-05 18:34	DenisChenu	Resolution	open => fixed
2020-05-05 18:36	DenisChenu	Status	assigned => resolved
2020-05-05 18:36	DenisChenu	Fixed in Version	=> 4.2.2
2020-12-30 19:27	cdorin	Note Added: 61359
2020-12-30 19:27	cdorin	Status	resolved => closed

LimeSurvey: master dabfe290 2020-05-05 20:34 DenisChenu Details Diff	Fixed issue 16225: Unable to VV export if no token table Dev: VV never export token table		Affected Issues 16225
	mod - application/controllers/admin/export.php		Diff File

View Issue Details

Users monitoring this issue

Activities

Related Changesets

Issue History