View Issue Details

Jump to NotesJump to History
This issue affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
09805Bug reportsSurvey participants (Tokens)public2015-07-31 12:242015-11-10 12:28
ReporterDenisChenu Assigned Tosammousa  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Summary09805: Unable to manage token before activate survey
Description

When try to manage token before survey is activated :
Internal Server Error
The table "{{survey_242275}}" for active record class "Response_242275" cannot be found in the database.

Steps To Reproduce

Activate token (in survey settings), create one token and look

TagsNo tags attached.
Attached Files
Internal Server Error.html (13,193 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>Internal Server Error</title>

<style type="text/css">
/*<![CDATA[*/
body {font-family:"Verdana";font-weight:normal;color:black;background-color:white;}
h1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red }
h2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon }
h3 {font-family:"Verdana";font-weight:bold;font-size:11pt}
p {font-family:"Verdana";font-weight:normal;color:black;font-size:9pt;margin-top: -5px}
.version {color: gray;font-size:8pt;border-top:1px solid #aaaaaa;}
/*]]>*/
</style>
</head>

<body>
<h1>Internal Server Error</h1>
<h2>The table &quot;{{survey_242275}}&quot; for active record class &quot;Response_242275&quot; cannot be found in the database.</h2>
<p>
An internal error occurred while the Web server was processing your request.
Please contact the webmaster to report this problem.
</p>
<p>
Thank you.
</p>
<div class="version">
2015-07-31 10:17:22 </div>
</body>
</html><!-- start log messages -->
<table class="yiiLog" width="100%" cellpadding="2" style="border-spacing:1px;font:11px Verdana, Arial, Helvetica, sans-serif;background:#EEEEEE;color:#666666;">
	<tr>
		<th style="background:black;color:white;" colspan="5">
			Application Log
		</th>
	</tr>
	<tr style="background-color: #ccc;">
	    <th style="width:120px">Timestamp</th>
		<th>Level</th>
		<th>Category</th>
		<th>Message</th>
	</tr>
	<tr style="background:#FFC0CB">
		<td align="center">10:17:22.234596</td>
		<td>error</td>
		<td>system.db.CDbCommand</td>
		<td><pre>CDbCommand::fetchAll() failed: SQLSTATE[42S02]: Base table or view not
found: 1146 Table &#039;lsdev.lime_survey_242275&#039; doesn&#039;t exist. The SQL
statement executed was: SHOW FULL COLUMNS FROM `lime_survey_242275`.</pre></td>
	</tr>	<tr style="background:#FFC0CB">
		<td align="center">10:17:22.236527</td>
		<td>error</td>
		<td>exception.CDbException</td>
		<td><pre>exception &#039;CDbException&#039; with message &#039;The table &quot;{{survey_242275}}&quot; for
active record class &quot;Response_242275&quot; cannot be found in the database.&#039; in
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/db/ar/CActiveRecord.php:2385
Stack trace:
#0
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/db/ar/CActiveRecord.php(411):
CActiveRecordMetaData-&gt;__construct(Object(Response_242275))
#1
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/db/ar/CActiveRecord.php(680):
CActiveRecord-&gt;getMetaData()
#2 /var/www/my_webapp/lsdev/application/models/LSActiveRecord.php(28):
CActiveRecord-&gt;hasAttribute(&#039;created&#039;)
#3
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/db/ar/CActiveRecord.php(396):
LSActiveRecord-&gt;behaviors()
#4 /var/www/my_webapp/lsdev/application/models/LSActiveRecord.php(170):
CActiveRecord::model(&#039;Response_242275&#039;)
#5 /var/www/my_webapp/lsdev/application/models/Dynamic.php(46):
LSActiveRecord::model(&#039;Response_242275&#039;)
#6 /var/www/my_webapp/lsdev/application/models/Response.php(71):
Dynamic::model(&#039;242275&#039;)
#7 /var/www/my_webapp/lsdev/application/models/Token.php(277):
Response::model(&#039;242275&#039;)
#8
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/base/CComponent.php(111):
Token-&gt;getResponseCount()
#9
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/db/ar/CActiveRecord.php(145):
CComponent-&gt;__get(&#039;responseCount&#039;)
#10 /var/www/my_webapp/lsdev/application/views/tokens/index.php(56):
CActiveRecord-&gt;__get(&#039;responseCount&#039;)
#11 [internal function]: CBaseController-&gt;{closure}(Object(Token_242275),
0, Object(WhRelationalColumn))
#12
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/base/CComponent.php(617):
call_user_func_array(Object(Closure), Array)
#13
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/zii/widgets/grid/CDataColumn.php(142):
CComponent-&gt;evaluateExpression(Object(Closure), Array)
#14
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/zii/widgets/grid/CGridColumn.php(231):
CDataColumn-&gt;getDataCellContent(0)
#15
/var/www/my_webapp/lsdev/application/vendor/2amigos/yiiwheels/widgets/grid/WhRelationalColumn.php(96):
CGridColumn-&gt;renderDataCellContent(0, Object(Token_242275))
#16
/var/www/my_webapp/lsdev/application/vendor/2amigos/yiiwheels/widgets/grid/WhGridView.php(273):
WhRelationalColumn-&gt;renderDataCell(0)
#17
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/zii/widgets/grid/CGridView.php(578):
WhGridView-&gt;renderTableRow(0)
#18
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/zii/widgets/grid/CGridView.php(488):
CGridView-&gt;renderTableBody()
#19
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/zii/widgets/CBaseListView.php(181):
CGridView-&gt;renderItems()
#20 [internal function]: CBaseListView-&gt;renderSection(Array)
#21
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/zii/widgets/CBaseListView.php(164):
preg_replace_callback(&#039;/{(\\w+)}/&#039;, Array, &#039;{summary}\n{item...&#039;)
#22
/var/www/my_webapp/lsdev/application/vendor/2amigos/yiiwheels/widgets/grid/WhGridView.php(155):
CBaseListView-&gt;renderContent()
#23
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/zii/widgets/CBaseListView.php(149):
WhGridView-&gt;renderContent()
#24
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/web/CBaseController.php(181):
CBaseListView-&gt;run()
#25 /var/www/my_webapp/lsdev/application/views/tokens/index.php(95):
CBaseController-&gt;widget(&#039;WhGridView&#039;, Array)
#26
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/web/CBaseController.php(126):
require(&#039;/var/www/my_web...&#039;)
#27
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/web/CBaseController.php(95):
CBaseController-&gt;renderInternal(&#039;/var/www/my_web...&#039;, Array, true)
#28
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/web/CController.php(869):
CBaseController-&gt;renderFile(&#039;/var/www/my_web...&#039;, Array, true)
#29
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/web/CController.php(782):
CController-&gt;renderPartial(&#039;index&#039;, Array, true)
#30 /var/www/my_webapp/lsdev/application/controllers/Controller.php(199):
CController-&gt;render(&#039;index&#039;, Array, false)
#31
/var/www/my_webapp/lsdev/application/controllers/TokensController.php(128):
ls\controllers\Controller-&gt;render(&#039;index&#039;, Array)
#32 [internal function]:
ls\controllers\TokensController-&gt;actionIndex(&#039;242275&#039;)
#33
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/web/actions/CAction.php(109):
ReflectionMethod-&gt;invokeArgs(Object(ls\controllers\TokensController),
Array)
#34
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/web/actions/CInlineAction.php(47):
CAction-&gt;runWithParamsInternal(Object(ls\controllers\TokensController),
Object(ReflectionMethod), Array)
#35
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/web/CController.php(308):
CInlineAction-&gt;runWithParams(Array)
#36
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/web/filters/CFilterChain.php(133):
CController-&gt;runAction(Object(CInlineAction))
#37
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/web/filters/CFilter.php(40):
CFilterChain-&gt;run()
#38
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/web/CController.php(1145):
CFilter-&gt;filter(Object(CFilterChain))
#39
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/web/filters/CInlineFilter.php(58):
CController-&gt;filterAccessControl(Object(CFilterChain))
#40
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/web/filters/CFilterChain.php(130):
CInlineFilter-&gt;filter(Object(CFilterChain))
#41
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/web/CController.php(291):
CFilterChain-&gt;run()
#42
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/web/CController.php(265):
CController-&gt;runActionWithFilters(Object(CInlineAction), Array)
#43
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/web/CWebApplication.php(282):
CController-&gt;run(&#039;index&#039;)
#44
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/web/CWebApplication.php(141):
CWebApplication-&gt;runController(&#039;tokens/index&#039;)
#45 /var/www/my_webapp/lsdev/application/core/WebApplication.php(77):
CWebApplication-&gt;processRequest()
#46
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/base/CApplication.php(184):
WebApplication-&gt;processRequest()
#47 /var/www/my_webapp/lsdev/application/entry.php(41): CApplication-&gt;run()
#48 /var/www/my_webapp/lsdev/index.php(2): include(&#039;/var/www/my_web...&#039;)
#49 {main}
REQUEST_URI=/lsdev/index.php?r=tokens/index&amp;surveyId=242275
HTTP_REFERER=https://test.shnoulle.net/lsdev/index.php?r=tokens/create&amp;surveyId=242275
---</pre></td>
	</tr></table>
<!-- end of log messages --><!-- start profiling summary -->
<table class="yiiLog" width="100%" cellpadding="2" style="border-spacing:1px;font:11px Verdana, Arial, Helvetica, sans-serif;background:#EEEEEE;color:#666666;">
	<tr>
		<th style="background:black;color:white;" colspan="6">
			Profiling Summary Report
			(Time: 0.11926s,
			Memory: 5,722KB)
		</th>
	</tr>
	<tr style="background-color: #ccc;">
	    <th>Procedure</th>
		<th>Count</th>
		<th>Total (s)</th>
		<th>Avg. (s)</th>
		<th>Min. (s)</th>
		<th>Max. (s)</th>
	</tr>
	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_survey_242275`)</td>
		<td align="center">1</td>
		<td align="center">0.00193</td>
		<td align="center">0.00193</td>
		<td align="center">0.00193</td>
		<td align="center">0.00193</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT * FROM `lime_surveys` `t` WHERE `t`.`sid`=242275 LIMIT 1)</td>
		<td align="center">1</td>
		<td align="center">0.00056</td>
		<td align="center">0.00056</td>
		<td align="center">0.00056</td>
		<td align="center">0.00056</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SELECT * FROM `lime_permissions` `t` WHERE `t`.`entity_id`=:yp0 AND `t`.`entity`=:yp1 AND `t`.`uid`=:yp2 AND `t`.`permission`=:yp3 LIMIT 1. Bound with :yp0=0, :yp1=&#039;global&#039;, :yp2=&#039;1&#039;, :yp3=&#039;superadmin&#039;)</td>
		<td align="center">1</td>
		<td align="center">0.00036</td>
		<td align="center">0.00036</td>
		<td align="center">0.00036</td>
		<td align="center">0.00036</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT * FROM `lime_settings_global` `t` WHERE `t`.`stg_name`=&#039;authorizationPlugin&#039; LIMIT 1)</td>
		<td align="center">1</td>
		<td align="center">0.00035</td>
		<td align="center">0.00035</td>
		<td align="center">0.00035</td>
		<td align="center">0.00035</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SELECT * FROM `lime_token_242275` `t` LIMIT 50)</td>
		<td align="center">1</td>
		<td align="center">0.00035</td>
		<td align="center">0.00035</td>
		<td align="center">0.00035</td>
		<td align="center">0.00035</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT * FROM `lime_settings_global` `t` WHERE `t`.`stg_name`=&#039;authenticationPlugins&#039; LIMIT 1)</td>
		<td align="center">1</td>
		<td align="center">0.00035</td>
		<td align="center">0.00035</td>
		<td align="center">0.00035</td>
		<td align="center">0.00035</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SELECT * FROM `lime_settings_global` `t` WHERE `t`.`stg_name`=&#039;sitename&#039; LIMIT 1)</td>
		<td align="center">1</td>
		<td align="center">0.00033</td>
		<td align="center">0.00033</td>
		<td align="center">0.00033</td>
		<td align="center">0.00033</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT COUNT(*) FROM `lime_token_242275` `t`)</td>
		<td align="center">1</td>
		<td align="center">0.00032</td>
		<td align="center">0.00032</td>
		<td align="center">0.00032</td>
		<td align="center">0.00032</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.execute(SELECT 1 FROM lime_token_242275)</td>
		<td align="center">1</td>
		<td align="center">0.00032</td>
		<td align="center">0.00032</td>
		<td align="center">0.00032</td>
		<td align="center">0.00032</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT * FROM `lime_settings_global` `t` WHERE `t`.`stg_name`=&#039;force_ssl&#039; LIMIT 1)</td>
		<td align="center">1</td>
		<td align="center">0.00031</td>
		<td align="center">0.00031</td>
		<td align="center">0.00031</td>
		<td align="center">0.00031</td>
	</tr></table>
<!-- end of profiling summary -->
Internal Server Error.html (13,193 bytes)   
Bug heat4
Complete LimeSurvey version number (& build)150731
I will donate to the project if issue is resolvedNo
Browsernot relevant
Database type & versionnot relevant
Server OS (if known)not relevant
Webserver software & version (if known)not relevant
PHP Versionnot relevant

Users monitoring this issue

aesteban

Activities

sammousa

sammousa

2015-10-05 14:50

reporter   ~33311

The token table now gets autocreated.

Issue History

Date Modified Username Field Change
2015-07-31 12:24 DenisChenu New Issue
2015-07-31 12:24 DenisChenu File Added: Internal Server Error.html
2015-08-19 00:48 aesteban Issue Monitored: aesteban
2015-08-22 18:05 aesteban Assigned To => aesteban
2015-08-22 18:05 aesteban Status new => feedback
2015-08-22 18:33 aesteban Assigned To aesteban =>
2015-08-22 18:34 aesteban Assigned To => aesteban
2015-08-22 18:34 aesteban Status feedback => new
2015-09-02 01:08 aesteban Assigned To aesteban =>
2015-10-05 14:50 sammousa Note Added: 33311
2015-10-05 14:50 sammousa Status new => resolved
2015-10-05 14:50 sammousa Resolution open => fixed
2015-10-05 14:50 sammousa Assigned To => sammousa
2015-11-10 12:28 c_schmitz Status resolved => closed
2016-12-08 10:39 c_schmitz Category Tokens => Survey participants (Tokens)
2021-09-03 03:09 guest Bug heat 2 => 4