View Issue Details

This bug affects 1 person(s).
 22
IDProjectCategoryView StatusLast Update
07071Bug reportsSurvey takingpublic2012-12-22 19:00
Reporterhelper Assigned Toc_schmitz  
PriorityimmediateSeverityblock 
Status closedResolutionfixed 
Product Version2.00+ 
Fixed in Version2.00+ 
Summary07071: DCbException at survey entry - missing survey_timings
Description

The reported missing table is not present in the database. I expired the survey and restarted the survey with no joy. Nothing I can do seems to create the missing table.

This error happens once - will not return on page reload.

TagsNo tags attached.
Attached Files
index.htm (25,237 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">
		The table &quot;{{survey_518477_timings}}&quot; for active record class &quot;Survey_timings&quot; cannot be found in the database.	</p>

	<div class="source">
		<p class="file">C:\etc\Apache\htdocs\MSSQL\framework\db\ar\CActiveRecord.php(2264)</p>
		<div class="code"><pre><span class="ln">2252</span>     private $_model;
<span class="ln">2253</span> 
<span class="ln">2254</span>     /**
<span class="ln">2255</span>      * Constructor.
<span class="ln">2256</span>      * @param CActiveRecord $model the model instance
<span class="ln">2257</span>      */
<span class="ln">2258</span>     public function __construct($model)
<span class="ln">2259</span>     {
<span class="ln">2260</span>         $this-&gt;_model=$model;
<span class="ln">2261</span> 
<span class="ln">2262</span>         $tableName=$model-&gt;tableName();
<span class="ln">2263</span>         if(($table=$model-&gt;getDbConnection()-&gt;getSchema()-&gt;getTable($tableName))===null)
<span class="error"><span class="ln error-ln">2264</span>             throw new CDbException(Yii::t(&#039;yii&#039;,&#039;The table &quot;{table}&quot; for active record class &quot;{class}&quot; cannot be found in the database.&#039;,
</span><span class="ln">2265</span>                 array(&#039;{class}&#039;=&gt;get_class($model),&#039;{table}&#039;=&gt;$tableName)));
<span class="ln">2266</span>         if($table-&gt;primaryKey===null)
<span class="ln">2267</span>         {
<span class="ln">2268</span>             $table-&gt;primaryKey=$model-&gt;primaryKey();
<span class="ln">2269</span>             if(is_string($table-&gt;primaryKey) &amp;&amp; isset($table-&gt;columns[$table-&gt;primaryKey]))
<span class="ln">2270</span>                 $table-&gt;columns[$table-&gt;primaryKey]-&gt;isPrimaryKey=true;
<span class="ln">2271</span>             else if(is_array($table-&gt;primaryKey))
<span class="ln">2272</span>             {
<span class="ln">2273</span>                 foreach($table-&gt;primaryKey as $name)
<span class="ln">2274</span>                 {
<span class="ln">2275</span>                     if(isset($table-&gt;columns[$name]))
<span class="ln">2276</span>                         $table-&gt;columns[$name]-&gt;isPrimaryKey=true;
</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>
										&nbsp;C:\etc\Apache\htdocs\MSSQL\framework\db\ar\CActiveRecord.php(379): <strong>CActiveRecordMetaData</strong>-><strong>__construct</strong>(Survey_timings)				</div>

				<div class="code"><pre><span class="ln">374</span>         if(isset(self::$_models[$className]))
<span class="ln">375</span>             return self::$_models[$className];
<span class="ln">376</span>         else
<span class="ln">377</span>         {
<span class="ln">378</span>             $model=self::$_models[$className]=new $className(null);
<span class="error"><span class="ln error-ln">379</span>             $model-&gt;_md=new CActiveRecordMetaData($model);
</span><span class="ln">380</span>             $model-&gt;attachBehaviors($model-&gt;behaviors());
<span class="ln">381</span>             return $model;
<span class="ln">382</span>         }
<span class="ln">383</span>     }
<span class="ln">384</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>
										&nbsp;C:\etc\Apache\htdocs\MSSQL\framework\db\ar\CActiveRecord.php(394): <strong>CActiveRecord</strong>::<strong>model</strong>(&quot;Survey_timings&quot;)				</div>

				<div class="code"><pre><span class="ln">389</span>     public function getMetaData()
<span class="ln">390</span>     {
<span class="ln">391</span>         if($this-&gt;_md!==null)
<span class="ln">392</span>             return $this-&gt;_md;
<span class="ln">393</span>         else
<span class="error"><span class="ln error-ln">394</span>             return $this-&gt;_md=self::model(get_class($this))-&gt;_md;
</span><span class="ln">395</span>     }
<span class="ln">396</span> 
<span class="ln">397</span>     /**
<span class="ln">398</span>      * Refreshes the meta data for this AR class.
<span class="ln">399</span>      * By calling this method, this AR class will regenerate the meta data needed.
</pre></div>			</td>
		</tr>
						<tr class="trace core collapsed">
			<td class="number">
				#2			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;C:\etc\Apache\htdocs\MSSQL\framework\db\ar\CActiveRecord.php(78): <strong>CActiveRecord</strong>-><strong>getMetaData</strong>()				</div>

				<div class="code"><pre><span class="ln">73</span>         if($scenario===null) // internally used by populateRecord() and model()
<span class="ln">74</span>             return;
<span class="ln">75</span> 
<span class="ln">76</span>         $this-&gt;setScenario($scenario);
<span class="ln">77</span>         $this-&gt;setIsNewRecord(true);
<span class="error"><span class="ln error-ln">78</span>         $this-&gt;_attributes=$this-&gt;getMetaData()-&gt;attributeDefaults;
</span><span class="ln">79</span> 
<span class="ln">80</span>         $this-&gt;init();
<span class="ln">81</span> 
<span class="ln">82</span>         $this-&gt;attachBehaviors($this-&gt;behaviors());
<span class="ln">83</span>         $this-&gt;afterConstruct();
</pre></div>			</td>
		</tr>
						<tr class="trace app expanded">
			<td class="number">
				#3			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;C:\etc\Apache\htdocs\MSSQL\application\helpers\expressions\em_manager_helper.php(4469): <strong>CActiveRecord</strong>-><strong>__construct</strong>()				</div>

				<div class="code"><pre><span class="ln">4464</span>                     $message .= $this-&gt;gT(&quot;Unable to insert record into survey table&quot;); // TODO - add SQL error?
<span class="ln">4465</span>                 }
<span class="ln">4466</span>                 //Insert Row for Timings, if needed
<span class="ln">4467</span>                 if ($this-&gt;surveyOptions[&#039;savetimings&#039;]) {
<span class="ln">4468</span>                     Survey_timings::sid($this-&gt;sid);
<span class="error"><span class="ln error-ln">4469</span>                     $oSurveyTimings = new Survey_timings;
</span><span class="ln">4470</span>                     
<span class="ln">4471</span>                     $tdata = array(
<span class="ln">4472</span>                     &#039;id&#039;=&gt;$srid,
<span class="ln">4473</span>                     &#039;interviewtime&#039;=&gt;0
<span class="ln">4474</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>
										&nbsp;C:\etc\Apache\htdocs\MSSQL\application\helpers\expressions\em_manager_helper.php(4299): <strong>LimeExpressionManager</strong>-><strong>_UpdateValuesInDatabase</strong>(array(), false)				</div>

				<div class="code"><pre><span class="ln">4294</span>                             continue;
<span class="ln">4295</span>                         }
<span class="ln">4296</span>                         else
<span class="ln">4297</span>                         {
<span class="ln">4298</span>                             // display new group
<span class="error"><span class="ln error-ln">4299</span>                             $message .= $LEM-&gt;_UpdateValuesInDatabase($updatedValues,false);
</span><span class="ln">4300</span>                             $LEM-&gt;runtimeTimings[] = array(__METHOD__,(microtime(true) - $now));
<span class="ln">4301</span>                             $LEM-&gt;lastMoveResult = array(
<span class="ln">4302</span>                             &#039;finished&#039;=&gt;false,
<span class="ln">4303</span>                             &#039;message&#039;=&gt;$message,
<span class="ln">4304</span>                             &#039;gseq&#039;=&gt;$LEM-&gt;currentGroupSeq,
</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>
										&nbsp;C:\etc\Apache\htdocs\MSSQL\application\helpers\SurveyRuntimeHelper.php(190): <strong>LimeExpressionManager</strong>::<strong>NavigateForwards</strong>()				</div>

				<div class="code"><pre><span class="ln">185</span>                             unset($moveResult); // so display welcome page again
<span class="ln">186</span>                         }
<span class="ln">187</span>                 }
<span class="ln">188</span>                 if (isset($move) &amp;&amp; $move == &quot;movenext&quot;)
<span class="ln">189</span>                 {
<span class="error"><span class="ln error-ln">190</span>                     $moveResult = LimeExpressionManager::NavigateForwards();
</span><span class="ln">191</span>                 }
<span class="ln">192</span>                 if (isset($move) &amp;&amp; ($move == &#039;movesubmit&#039;))
<span class="ln">193</span>                 {
<span class="ln">194</span>                     if ($surveyMode == &#039;survey&#039;)
<span class="ln">195</span>                     {
</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>
										&nbsp;C:\etc\Apache\htdocs\MSSQL\application\controllers\survey\index.php(662): <strong>SurveyRuntimeHelper</strong>-><strong>run</strong>(&quot;518477&quot;, array(&quot;surveyid&quot; =&gt; &quot;518477&quot;, &quot;thissurvey&quot; =&gt; array(&quot;surveyls_survey_id&quot; =&gt; &quot;518477&quot;, &quot;surveyls_language&quot; =&gt; &quot;en&quot;, &quot;surveyls_title&quot; =&gt; &quot;Patient Connect - PHQ&quot;, &quot;surveyls_description&quot; =&gt; &quot;&quot;, ...), &quot;thisstep&quot; =&gt; &quot;0&quot;, &quot;clienttoken&quot; =&gt; &quot;ngd6ij57qcattj8ixerbmkam2&quot;, ...))				</div>

				<div class="code"><pre><span class="ln">657</span>         //Send local variables to the appropriate survey type
<span class="ln">658</span>         unset($redata);
<span class="ln">659</span>         $redata = compact(array_keys(get_defined_vars()));
<span class="ln">660</span>         Yii::import(&#039;application.helpers.SurveyRuntimeHelper&#039;);
<span class="ln">661</span>         $tmp = new SurveyRuntimeHelper();
<span class="error"><span class="ln error-ln">662</span>         $tmp-&gt;run($surveyid,$redata);
</span><span class="ln">663</span> 
<span class="ln">664</span>         if (isset($_POST[&#039;saveall&#039;]) || isset($flashmessage))
<span class="ln">665</span>         {
<span class="ln">666</span>             echo &quot;&lt;script type=&#039;text/javascript&#039;&gt; $(document).ready( function() { alert(&#039;&quot;.$clang-&gt;gT(&quot;Your responses were successfully saved.&quot;,&quot;js&quot;).&quot;&#039;);}) &lt;/script&gt;&quot;;
<span class="ln">667</span>         }
</pre></div>			</td>
		</tr>
						<tr class="trace app collapsed">
			<td class="number">
				#7			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;C:\etc\Apache\htdocs\MSSQL\application\controllers\survey\index.php(18): <strong>index</strong>-><strong>action</strong>()				</div>

				<div class="code"><pre><span class="ln">13</span> 
<span class="ln">14</span> class index extends CAction {
<span class="ln">15</span> 
<span class="ln">16</span>     public function run()
<span class="ln">17</span>     {
<span class="error"><span class="ln error-ln">18</span>         $this-&gt;action();
</span><span class="ln">19</span>     }
<span class="ln">20</span> 
<span class="ln">21</span>     function action()
<span class="ln">22</span>     {
<span class="ln">23</span>         global $surveyid;
</pre></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>
										&nbsp;C:\etc\Apache\htdocs\MSSQL\framework\web\actions\CAction.php(75): <strong>index</strong>-><strong>run</strong>()				</div>

				<div class="code"><pre><span class="ln">70</span>     {
<span class="ln">71</span>         $method=new ReflectionMethod($this, &#039;run&#039;);
<span class="ln">72</span>         if($method-&gt;getNumberOfParameters()&gt;0)
<span class="ln">73</span>             return $this-&gt;runWithParamsInternal($this, $method, $params);
<span class="ln">74</span>         else
<span class="error"><span class="ln error-ln">75</span>             return $this-&gt;run();
</span><span class="ln">76</span>     }
<span class="ln">77</span> 
<span class="ln">78</span>     /**
<span class="ln">79</span>      * Executes a method of an object with the supplied named parameters.
<span class="ln">80</span>      * This method is internally used.
</pre></div>			</td>
		</tr>
						<tr class="trace core collapsed">
			<td class="number">
				#9			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;C:\etc\Apache\htdocs\MSSQL\framework\web\CController.php(309): <strong>CAction</strong>-><strong>runWithParams</strong>(array())				</div>

				<div class="code"><pre><span class="ln">304</span>     {
<span class="ln">305</span>         $priorAction=$this-&gt;_action;
<span class="ln">306</span>         $this-&gt;_action=$action;
<span class="ln">307</span>         if($this-&gt;beforeAction($action))
<span class="ln">308</span>         {
<span class="error"><span class="ln error-ln">309</span>             if($action-&gt;runWithParams($this-&gt;getActionParams())===false)
</span><span class="ln">310</span>                 $this-&gt;invalidActionParams($action);
<span class="ln">311</span>             else
<span class="ln">312</span>                 $this-&gt;afterAction($action);
<span class="ln">313</span>         }
<span class="ln">314</span>         $this-&gt;_action=$priorAction;
</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>
										&nbsp;C:\etc\Apache\htdocs\MSSQL\framework\web\CController.php(287): <strong>CController</strong>-><strong>runAction</strong>(index)				</div>

				<div class="code"><pre><span class="ln">282</span>      * @see runAction
<span class="ln">283</span>      */
<span class="ln">284</span>     public function runActionWithFilters($action,$filters)
<span class="ln">285</span>     {
<span class="ln">286</span>         if(empty($filters))
<span class="error"><span class="ln error-ln">287</span>             $this-&gt;runAction($action);
</span><span class="ln">288</span>         else
<span class="ln">289</span>         {
<span class="ln">290</span>             $priorAction=$this-&gt;_action;
<span class="ln">291</span>             $this-&gt;_action=$action;
<span class="ln">292</span>             CFilterChain::create($this,$action,$filters)-&gt;run();
</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>
										&nbsp;C:\etc\Apache\htdocs\MSSQL\framework\web\CController.php(266): <strong>CController</strong>-><strong>runActionWithFilters</strong>(index, array())				</div>

				<div class="code"><pre><span class="ln">261</span>         {
<span class="ln">262</span>             if(($parent=$this-&gt;getModule())===null)
<span class="ln">263</span>                 $parent=Yii::app();
<span class="ln">264</span>             if($parent-&gt;beforeControllerAction($this,$action))
<span class="ln">265</span>             {
<span class="error"><span class="ln error-ln">266</span>                 $this-&gt;runActionWithFilters($action,$this-&gt;filters());
</span><span class="ln">267</span>                 $parent-&gt;afterControllerAction($this,$action);
<span class="ln">268</span>             }
<span class="ln">269</span>         }
<span class="ln">270</span>         else
<span class="ln">271</span>             $this-&gt;missingAction($actionID);
</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>
										&nbsp;C:\etc\Apache\htdocs\MSSQL\framework\web\CWebApplication.php(276): <strong>CController</strong>-><strong>run</strong>(&quot;index&quot;)				</div>

				<div class="code"><pre><span class="ln">271</span>         {
<span class="ln">272</span>             list($controller,$actionID)=$ca;
<span class="ln">273</span>             $oldController=$this-&gt;_controller;
<span class="ln">274</span>             $this-&gt;_controller=$controller;
<span class="ln">275</span>             $controller-&gt;init();
<span class="error"><span class="ln error-ln">276</span>             $controller-&gt;run($actionID);
</span><span class="ln">277</span>             $this-&gt;_controller=$oldController;
<span class="ln">278</span>         }
<span class="ln">279</span>         else
<span class="ln">280</span>             throw new CHttpException(404,Yii::t(&#039;yii&#039;,&#039;Unable to resolve the request &quot;{route}&quot;.&#039;,
<span class="ln">281</span>                 array(&#039;{route}&#039;=&gt;$route===&#039;&#039;?$this-&gt;defaultController:$route)));
</pre></div>			</td>
		</tr>
						<tr class="trace core collapsed">
			<td class="number">
				#13			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;C:\etc\Apache\htdocs\MSSQL\framework\web\CWebApplication.php(135): <strong>CWebApplication</strong>-><strong>runController</strong>(&quot;survey/index&quot;)				</div>

				<div class="code"><pre><span class="ln">130</span>             foreach(array_splice($this-&gt;catchAllRequest,1) as $name=&gt;$value)
<span class="ln">131</span>                 $_GET[$name]=$value;
<span class="ln">132</span>         }
<span class="ln">133</span>         else
<span class="ln">134</span>             $route=$this-&gt;getUrlManager()-&gt;parseUrl($this-&gt;getRequest());
<span class="error"><span class="ln error-ln">135</span>         $this-&gt;runController($route);
</span><span class="ln">136</span>     }
<span class="ln">137</span> 
<span class="ln">138</span>     /**
<span class="ln">139</span>      * Registers the core application components.
<span class="ln">140</span>      * This method overrides the parent implementation by registering additional core components.
</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>
										&nbsp;C:\etc\Apache\htdocs\MSSQL\framework\base\CApplication.php(162): <strong>CWebApplication</strong>-><strong>processRequest</strong>()				</div>

				<div class="code"><pre><span class="ln">157</span>      */
<span class="ln">158</span>     public function run()
<span class="ln">159</span>     {
<span class="ln">160</span>         if($this-&gt;hasEventHandler(&#039;onBeginRequest&#039;))
<span class="ln">161</span>             $this-&gt;onBeginRequest(new CEvent($this));
<span class="error"><span class="ln error-ln">162</span>         $this-&gt;processRequest();
</span><span class="ln">163</span>         if($this-&gt;hasEventHandler(&#039;onEndRequest&#039;))
<span class="ln">164</span>             $this-&gt;onEndRequest(new CEvent($this));
<span class="ln">165</span>     }
<span class="ln">166</span> 
<span class="ln">167</span>     /**
</pre></div>			</td>
		</tr>
						<tr class="trace app collapsed">
			<td class="number">
				#15			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;C:\etc\Apache\htdocs\MSSQL\index.php(178): <strong>CApplication</strong>-><strong>run</strong>()				</div>

				<div class="code"><pre><span class="ln">173</span>  *
<span class="ln">174</span>  */
<span class="ln">175</span> require_once BASEPATH . &#039;yii&#039; . EXT;
<span class="ln">176</span> require_once APPPATH . &#039;core/LSYii_Application&#039; . EXT;
<span class="ln">177</span> 
<span class="error"><span class="ln error-ln">178</span> Yii::createApplication(&#039;LSYii_Application&#039;, APPPATH . &#039;config/config&#039; . EXT)-&gt;run();
</span><span class="ln">179</span> 
<span class="ln">180</span> /* End of file index.php */
<span class="ln">181</span> /* Location: ./index.php */
</pre></div>			</td>
		</tr>
				</table>
	</div>

	<div class="version">
		2012-12-12 13:44:19 Apache/2.4.3 (Win32) OpenSSL/0.9.8x PHP/5.4.8 <a href="http://www.yiiframework.com/">Yii Framework</a>/1.1.10	</div>
</div>

<script type="text/javascript">
/*<![CDATA[*/
var traceReg = new RegExp("(^|\\s)trace-file(\\s|$)");
var collapsedReg = new RegExp("(^|\\s)collapsed(\\s|$)");

var e = document.getElementsByTagName("div");
for(var j=0,len=e.length;j<len;j++){
	if(traceReg.test(e[j].className)){
		e[j].onclick = function(){
			var trace = this.parentNode.parentNode;
			if(collapsedReg.test(trace.className))
				trace.className = trace.className.replace("collapsed", "expanded");
			else
				trace.className = trace.className.replace("expanded", "collapsed");
		}
	}
}
/*]]>*/
</script>

</body>
</html>
index.htm (25,237 bytes)   
Bug heat22
Complete LimeSurvey version number (& build)121211
I will donate to the project if issue is resolvedNo
BrowserChrome
Database type & versionMicrosoft SQL Server 2008
Server OS (if known)Windows 2008
Webserver software & version (if known)Apache 2.4
PHP Version3.4

Relationships

has duplicate 07072 closedc_schmitz Surveys no longer shown in Default Admin page 
has duplicate 07113 closedc_schmitz Data consistency check destroys survey 

Users monitoring this issue

There are no users monitoring this issue.

Activities

helper

helper

2012-12-12 20:58

reporter   ~23185

Also, with these tables missing the following stats page is failing:

admin -> Responses & statistics -> Get time statistics from these responses

helper

helper

2012-12-12 20:59

reporter   ~23186

Occurs in both MySQL and Microsoft SQL Server 2008.

c_schmitz

c_schmitz

2012-12-12 21:04

administrator   ~23187

Most probably the table is missing. This results from a bug in early 2.0 version.
The only way to fix it is to deactivate the survey and acitvate it again.

helper

helper

2012-12-12 21:07

reporter   ~23189

The issue is the Database Integrity check is showing all surveys as orphaned - if you take the recommended action the timings tables are gone...

c_schmitz

c_schmitz

2012-12-12 21:44

administrator   ~23191

Thank you - it's even worse. Just visiting the integrity check is causing the timing tables to be renamed.

c_schmitz

c_schmitz

2012-12-12 21:47

administrator   ~23192

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&amp;id=10888

c_schmitz

c_schmitz

2012-12-12 22:23

administrator   ~23195

Fix committed to 2.1 branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&amp;id=10890

c_schmitz

c_schmitz

2012-12-13 09:24

administrator   ~23203

2.00+ Build 121213 released

c_schmitz

c_schmitz

2012-12-19 18:01

administrator   ~23284

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&amp;id=10957

c_schmitz

c_schmitz

2012-12-22 19:00

administrator   ~23356

Fix committed to 2.1 branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&amp;id=11000

Related Changesets

LimeSurvey: master ae53492c

2012-12-12 20:47:23

c_schmitz

Details Diff
Fixed issue 07071: Survey timing tables are archived and offered for deletion when visiting the integrity check Affected Issues
07071
mod - application/controllers/admin/checkintegrity.php Diff File

LimeSurvey: 2.1 0d432b0f

2012-12-12 21:22:38

c_schmitz

Details Diff
Fixed issue 07071: Survey timing tables are archived and offered for deletion when visiting the integrity check Affected Issues
07071
mod - application/controllers/admin/checkintegrity.php Diff File

LimeSurvey: master 227acbbd

2012-12-19 17:00:43

c_schmitz

Details Diff
Fixed issue 07071: Survey timing tables are archived and offered for deletion when visiting the integrity check Affected Issues
07071
mod - application/controllers/admin/checkintegrity.php Diff File

LimeSurvey: 2.1 0601d283

2012-12-22 17:58:27

c_schmitz

Details Diff
Fixed issue 07071: Survey timing tables are archived and offered for deletion when visiting the integrity check Affected Issues
07071
mod - application/controllers/admin/checkintegrity.php Diff File

Issue History

Date Modified Username Field Change
2012-12-12 20:25 helper New Issue
2012-12-12 20:25 helper File Added: index.htm
2012-12-12 20:26 helper File Added: limesurvey_survey_518477.lss
2012-12-12 20:58 helper Note Added: 23185
2012-12-12 20:59 helper Note Added: 23186
2012-12-12 21:04 c_schmitz Note Added: 23187
2012-12-12 21:04 c_schmitz Status new => closed
2012-12-12 21:04 c_schmitz Assigned To => c_schmitz
2012-12-12 21:04 c_schmitz Resolution open => fixed
2012-12-12 21:07 helper Note Added: 23189
2012-12-12 21:07 helper Status closed => feedback
2012-12-12 21:07 helper Resolution fixed => reopened
2012-12-12 21:44 c_schmitz Note Added: 23191
2012-12-12 21:47 c_schmitz Changeset attached => LimeSurvey master ae53492c
2012-12-12 21:47 c_schmitz Note Added: 23192
2012-12-12 21:56 c_schmitz Priority high => immediate
2012-12-12 21:56 c_schmitz Status feedback => resolved
2012-12-12 21:56 c_schmitz Fixed in Version => 2.00+
2012-12-12 21:56 c_schmitz Resolution reopened => fixed
2012-12-12 22:23 c_schmitz Changeset attached => LimeSurvey 2.1 0d432b0f
2012-12-12 22:23 c_schmitz Note Added: 23195
2012-12-13 09:24 c_schmitz Note Added: 23203
2012-12-13 09:24 c_schmitz Status resolved => closed
2012-12-13 09:46 c_schmitz Relationship added has duplicate 07072
2012-12-19 18:01 c_schmitz Changeset attached => LimeSurvey master 227acbbd
2012-12-19 18:01 c_schmitz Note Added: 23284
2012-12-20 23:39 c_schmitz Relationship added has duplicate 07113
2012-12-22 19:00 c_schmitz Changeset attached => LimeSurvey 2.1 0601d283
2012-12-22 19:00 c_schmitz Note Added: 23356
2021-08-03 00:57 guest Bug heat 20 => 22