View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 2
IDProjectCategoryView StatusDate SubmittedLast Update
09684Bug reportsSurvey editingpublic2015-06-15 10:302015-06-22 10:10
ReporterDenisChenu Assigned Tosammousa  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Summary09684: Unable to create a group or see a survey after creation
Description

After create a survey, trying to create a group goes to a 500 error.

./index.php?r=groups/update&id=4
Property "QuestionGroup.id" is not defined.

After this ; unable to look at survey
./index.php?r=surveys/update&id=644142
Property "QuestionGroup.id" is not defined.

Steps To Reproduce

Create a survey, add a group

Additional Information

Group show "Add question" but this one is an easy fix

TagsNo tags attached.
Attached Files
LimeSurvey_installer_-_2015-06-18_10.31.58.png (984,350 bytes)
Internal Server Error.html (15,850 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>Property "QuestionGroup.id" is not defined.</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-06-18 08:33:34 </div>


<table class="yiiLog" style="border-spacing:1px;font:11px Verdana, Arial, Helvetica, sans-serif;background:#EEEEEE;color:#666666;" width="100%" cellpadding="2">
	<tbody><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">08:33:34.560152</td>
		<td>error</td>
		<td>system.db.CDbCommand</td>
		<td><pre>CDbCommand::execute() failed: SQLSTATE[42S02]: Base table or view not
found: 1146 Table 'lsdev.lime_survey_397449' doesn't exist. The SQL
statement executed was: SELECT 1 FROM lime_survey_397449.</pre></td>
	</tr>	<tr style="background:#FFC0CB">
		<td align="center">08:33:34.583463</td>
		<td>error</td>
		<td>exception.CException</td>
		<td><pre>exception 'CException' with message 'Property "QuestionGroup.id" is not
defined.' in
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/base/CComponent.php:130
Stack trace:
#0
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/db/ar/CActiveRecord.php(145):
CComponent-&gt;__get('id')
#1 /var/www/my_webapp/lsdev/application/models/QuestionGroup.php(76):
CActiveRecord-&gt;__get('id')
#2
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/base/CComponent.php(111):
QuestionGroup-&gt;getQuestionCount()
#3
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/db/ar/CActiveRecord.php(145):
CComponent-&gt;__get('questionCount')
#4 /var/www/my_webapp/lsdev/application/views/global/groupMenu.php(11):
CActiveRecord-&gt;__get('questionCount')
#5 /var/www/my_webapp/lsdev/application/helpers/common_helper.php(68):
require('/var/www/my_web...')
#6 /var/www/my_webapp/lsdev/application/helpers/common_helper.php(71):
Closure-&gt;{closure}('/var/www/my_web...', Array)
#7 /var/www/my_webapp/lsdev/application/views/global/menus.php(25):
requireFile('/var/www/my_web...', Array,
Object(ls\controllers\GroupsController))
#8
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/web/CBaseController.php(126):
require('/var/www/my_web...')
#9
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/web/CBaseController.php(95):
CBaseController-&gt;renderInternal('/var/www/my_web...', NULL, true)
#10
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/web/CController.php(869):
CBaseController-&gt;renderFile('/var/www/my_web...', NULL, true)
#11 /var/www/my_webapp/lsdev/application/views/layouts/survey.php(32):
CController-&gt;renderPartial('/global/menus')
#12
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/web/CBaseController.php(126):
require('/var/www/my_web...')
#13
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/web/CBaseController.php(95):
CBaseController-&gt;renderInternal('/var/www/my_web...', Array, true)
#14
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/web/CController.php(784):
CBaseController-&gt;renderFile('/var/www/my_web...', Array, true)
#15 /var/www/my_webapp/lsdev/application/controllers/Controller.php(212):
CController-&gt;render('update', Array, false)
#16
/var/www/my_webapp/lsdev/application/controllers/GroupsController.php(70):
ls\controllers\Controller-&gt;render('update', Array)
#17 [internal function]: ls\controllers\GroupsController-&gt;actionUpdate('1')
#18
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/web/actions/CAction.php(109):
ReflectionMethod-&gt;invokeArgs(Object(ls\controllers\GroupsController),
Array)
#19
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/web/actions/CInlineAction.php(47):
CAction-&gt;runWithParamsInternal(Object(ls\controllers\GroupsController),
Object(ReflectionMethod), Array)
#20
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/web/CController.php(308):
CInlineAction-&gt;runWithParams(Array)
#21
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/web/filters/CFilterChain.php(133):
CController-&gt;runAction(Object(CInlineAction))
#22
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/web/filters/CFilter.php(40):
CFilterChain-&gt;run()
#23
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/web/CController.php(1145):
CFilter-&gt;filter(Object(CFilterChain))
#24
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/web/filters/CInlineFilter.php(58):
CController-&gt;filterAccessControl(Object(CFilterChain))
#25
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/web/filters/CFilterChain.php(130):
CInlineFilter-&gt;filter(Object(CFilterChain))
#26
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/web/CController.php(291):
CFilterChain-&gt;run()
#27
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/web/CController.php(265):
CController-&gt;runActionWithFilters(Object(CInlineAction), Array)
#28
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/web/CWebApplication.php(282):
CController-&gt;run('update')
#29
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/web/CWebApplication.php(141):
CWebApplication-&gt;runController('groups/update')
#30 /var/www/my_webapp/lsdev/application/core/WebApplication.php(76):
CWebApplication-&gt;processRequest()
#31
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/base/CApplication.php(184):
WebApplication-&gt;processRequest()
#32 /var/www/my_webapp/lsdev/application/entry.php(41): CApplication-&gt;run()
#33 /var/www/my_webapp/lsdev/index.php(2): include('/var/www/my_web...')
#34 {main}
REQUEST_URI=/lsdev/index.php?r=groups/update&amp;id=1
HTTP_REFERER=https://test.shnoulle.net/lsdev/index.php?r=groups/create&amp;surveyId=397449
---</pre></td>
	</tr></tbody></table>
<!-- end of log messages --><!-- start profiling summary -->
<table class="yiiLog" style="border-spacing:1px;font:11px Verdana, Arial, Helvetica, sans-serif;background:#EEEEEE;color:#666666;" width="100%" cellpadding="2">
	<tbody><tr>
		<th style="background:black;color:white;" colspan="6">
			Profiling Summary Report
			(Time: 0.14288s,
			Memory: 5,695KB)
		</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_questions`)</td>
		<td align="center">1</td>
		<td align="center">0.00330</td>
		<td align="center">0.00330</td>
		<td align="center">0.00330</td>
		<td align="center">0.00330</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_translation`)</td>
		<td align="center">1</td>
		<td align="center">0.00203</td>
		<td align="center">0.00203</td>
		<td align="center">0.00203</td>
		<td align="center">0.00203</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SELECT * FROM `lime_groups` `t` WHERE `t`.`gid`=1 LIMIT 1)</td>
		<td align="center">1</td>
		<td align="center">0.00109</td>
		<td align="center">0.00109</td>
		<td align="center">0.00109</td>
		<td align="center">0.00109</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT `translations`.`model_id` AS 
`t1_c0`, `translations`.`model` AS `t1_c1`, `translations`.`language` AS
 `t1_c2`, `translations`.`data` AS `t1_c3` FROM `lime_translation` 
`translations`  WHERE (model = :class) AND 
(`translations`.`model_id`=:ypl0). Bound with :class='Group', :ypl0='1')</td>
		<td align="center">1</td>
		<td align="center">0.00100</td>
		<td align="center">0.00100</td>
		<td align="center">0.00100</td>
		<td align="center">0.00100</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.execute(SELECT 1 FROM lime_survey_397449)</td>
		<td align="center">1</td>
		<td align="center">0.00091</td>
		<td align="center">0.00091</td>
		<td align="center">0.00091</td>
		<td align="center">0.00091</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT `survey`.`sid` AS `t1_c0`, 
`survey`.`owner_id` AS `t1_c1`, `survey`.`admin` AS `t1_c2`, 
`survey`.`active` AS `t1_c3`, `survey`.`expires` AS `t1_c4`, 
`survey`.`startdate` AS `t1_c5`, `survey`.`adminemail` AS `t1_c6`, 
`survey`.`anonymized` AS `t1_c7`, `survey`.`faxto` AS `t1_c8`, 
`survey`.`format` AS `t1_c9`, `survey`.`savetimings` AS `t1_c10`, 
`survey`.`template` AS `t1_c11`, `survey`.`language` AS `t1_c12`, 
`survey`.`additional_languages` AS `t1_c13`, `survey`.`datestamp` AS 
`t1_c14`, `survey`.`usecookie` AS `t1_c15`, `survey`.`allowregister` AS 
`t1_c16`, `survey`.`allowsave` AS `t1_c17`, `survey`.`autonumber_start` 
AS `t1_c18`, `survey`.`autoredirect` AS `t1_c19`, `survey`.`allowprev` 
AS `t1_c20`, `survey`.`printanswers` AS `t1_c21`, `survey`.`ipaddr` AS 
`t1_c22`, `survey`.`refurl` AS `t1_c23`, `survey`.`datecreated` AS 
`t1_c24`, `survey`.`publicstatistics` AS `t1_c25`, 
`survey`.`publicgraphs` AS `t1_c26`, `survey`.`listpublic` AS `t1_c27`, 
`survey`.`htmlemail` AS `t1_c28`, `survey`.`sendconfirmation` AS 
`t1_c29`, `survey`.`tokenanswerspersistence` AS `t1_c30`, 
`survey`.`assessments` AS `t1_c31`, `survey`.`usecaptcha` AS `t1_c32`, 
`survey`.`usetokens` AS `t1_c33`, `survey`.`bounce_email` AS `t1_c34`, 
`survey`.`attributedescriptions` AS `t1_c35`, `survey`.`emailresponseto`
 AS `t1_c36`, `survey`.`emailnotificationto` AS `t1_c37`, 
`survey`.`tokenlength` AS `t1_c38`, `survey`.`showxquestions` AS 
`t1_c39`, `survey`.`showgroupinfo` AS `t1_c40`, `survey`.`shownoanswer` 
AS `t1_c41`, `survey`.`showqnumcode` AS `t1_c42`, `survey`.`bouncetime` 
AS `t1_c43`, `survey`.`bounceprocessing` AS `t1_c44`, 
`survey`.`bounceaccounttype` AS `t1_c45`, `survey`.`bounceaccounthost` 
AS `t1_c46`, `survey`.`bounceaccountpass` AS `t1_c47`, 
`survey`.`bounceaccountencryption` AS `t1_c48`, 
`survey`.`bounceaccountuser` AS `t1_c49`, `survey`.`showwelcome` AS 
`t1_c50`, `survey`.`showprogress` AS `t1_c51`, `survey`.`questionindex` 
AS `t1_c52`, `survey`.`navigationdelay` AS `t1_c53`, 
`survey`.`nokeyboard` AS `t1_c54`, `survey`.`alloweditaftercompletion` 
AS `t1_c55`, `survey`.`googleanalyticsstyle` AS `t1_c56`, 
`survey`.`googleanalyticsapikey` AS `t1_c57`, `survey`.`use_series` AS 
`t1_c58` FROM `lime_surveys` `survey`  WHERE (`survey`.`sid`=:ypl0). 
Bound with :ypl0='397449')</td>
		<td align="center">1</td>
		<td align="center">0.00054</td>
		<td align="center">0.00054</td>
		<td align="center">0.00054</td>
		<td align="center">0.00054</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SHOW CREATE TABLE `lime_questions`)</td>
		<td align="center">1</td>
		<td align="center">0.00054</td>
		<td align="center">0.00054</td>
		<td align="center">0.00054</td>
		<td align="center">0.00054</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT * FROM `lime_surveys` `t`)</td>
		<td align="center">1</td>
		<td align="center">0.00049</td>
		<td align="center">0.00049</td>
		<td align="center">0.00049</td>
		<td align="center">0.00049</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SHOW CREATE TABLE `lime_translation`)</td>
		<td align="center">1</td>
		<td align="center">0.00048</td>
		<td align="center">0.00048</td>
		<td align="center">0.00048</td>
		<td align="center">0.00048</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT 
`languagesettings`.`surveyls_survey_id` AS `t1_c0`, 
`languagesettings`.`surveyls_language` AS `t1_c1`, 
`languagesettings`.`surveyls_title` AS `t1_c2`, 
`languagesettings`.`surveyls_description` AS `t1_c3`, 
`languagesettings`.`surveyls_welcometext` AS `t1_c4`, 
`languagesettings`.`surveyls_endtext` AS `t1_c5`, 
`languagesettings`.`surveyls_url` AS `t1_c6`, 
`languagesettings`.`surveyls_urldescription` AS `t1_c7`, 
`languagesettings`.`surveyls_email_invite_subj` AS `t1_c8`, 
`languagesettings`.`surveyls_email_invite` AS `t1_c9`, 
`languagesettings`.`surveyls_email_remind_subj` AS `t1_c10`, 
`languagesettings`.`surveyls_email_remind` AS `t1_c11`, 
`languagesettings`.`surveyls_email_register_subj` AS `t1_c12`, 
`languagesettings`.`surveyls_email_register` AS `t1_c13`, 
`languagesettings`.`surveyls_email_confirm_subj` AS `t1_c14`, 
`languagesettings`.`surveyls_email_confirm` AS `t1_c15`, 
`languagesettings`.`surveyls_dateformat` AS `t1_c16`, 
`languagesettings`.`surveyls_attributecaptions` AS `t1_c17`, 
`languagesettings`.`email_admin_notification_subj` AS `t1_c18`, 
`languagesettings`.`email_admin_notification` AS `t1_c19`, 
`languagesettings`.`email_admin_responses_subj` AS `t1_c20`, 
`languagesettings`.`email_admin_responses` AS `t1_c21`, 
`languagesettings`.`surveyls_numberformat` AS `t1_c22`, 
`languagesettings`.`attachments` AS `t1_c23` FROM 
`lime_surveys_languagesettings` `languagesettings`  WHERE 
(`languagesettings`.`surveyls_survey_id`=:ypl0). Bound with 
:ypl0='397449')</td>
		<td align="center">1</td>
		<td align="center">0.00043</td>
		<td align="center">0.00043</td>
		<td align="center">0.00043</td>
		<td align="center">0.00043</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='global', 
:yp2='1', :yp3='superadmin')</td>
		<td align="center">1</td>
		<td align="center">0.00040</td>
		<td align="center">0.00040</td>
		<td align="center">0.00040</td>
		<td align="center">0.00040</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT * FROM `lime_settings_global` `t` WHERE `t`.`stg_name`='sitename' 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`='authenticationPlugins' LIMIT 1)</td>
		<td align="center">1</td>
		<td align="center">0.00034</td>
		<td align="center">0.00034</td>
		<td align="center">0.00034</td>
		<td align="center">0.00034</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT * FROM `lime_settings_global` `t` WHERE `t`.`stg_name`='authorizationPlugin' LIMIT 1)</td>
		<td align="center">1</td>
		<td align="center">0.00030</td>
		<td align="center">0.00030</td>
		<td align="center">0.00030</td>
		<td align="center">0.00030</td>
	</tr></tbody></table>
<!-- end of profiling summary --></body></html>
<!-- start log messages -->
Internal Server Error.html (15,850 bytes)   
Bug heat2
Complete LimeSurvey version number (& build)150615 (7a24413)
I will donate to the project if issue is resolvedNo
Browsernot relevant
Database type & version5.5.43-0+deb8u1
Server OS (if known)debian 8/linux
Webserver software & version (if known)nginx
PHP VersionPHP 5.6.7

Users monitoring this issue

There are no users monitoring this issue.

Activities

DenisChenu

DenisChenu

2015-06-16 11:15

developer   ~32380

IRC log ;) other bug and same for old surveys (create in ls3, before this fix)
DenisChenu

DenisChenu

2015-06-18 10:37

developer   ~32410

Confirm issue in migration.

We rename Question.qid to Question.id but not Group.gid to Group.id

Denis
DenisChenu

DenisChenu

2015-06-22 10:10

developer   ~32470

Last commit fix it . And all directory too (actually)

Issue History

Date Modified Username Field Change
2015-06-15 10:30 DenisChenu New Issue
2015-06-16 11:06 sammousa Status new => resolved
2015-06-16 11:06 sammousa Resolution open => fixed
2015-06-16 11:06 sammousa Assigned To => sammousa
2015-06-16 11:15 DenisChenu Note Added: 32380
2015-06-16 11:15 DenisChenu Status resolved => feedback
2015-06-16 11:15 DenisChenu Resolution fixed => reopened
2015-06-18 10:36 DenisChenu File Added: LimeSurvey_installer_-_2015-06-18_10.31.58.png
2015-06-18 10:36 DenisChenu File Added: Internal Server Error.html
2015-06-18 10:37 DenisChenu Note Added: 32410
2015-06-18 10:37 DenisChenu Status feedback => assigned
2015-06-18 10:37 DenisChenu Status assigned => confirmed
2015-06-22 10:10 DenisChenu Note Added: 32470
2015-06-22 10:10 DenisChenu Status confirmed => closed
2015-06-22 10:10 DenisChenu Resolution reopened => fixed
2015-06-22 10:10 DenisChenu Fixed in Version => 3.0
2019-11-01 17:25 c_schmitz Category Survey design => Survey editing