View Issue Details

Jump to NotesJump to History
This issue affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
10224Bug reportsOtherpublic2016-01-13 14:522016-02-06 00:35
Reporterspycomb Assigned Toollehar  
PriorityhighSeverityblock 
Status closedResolutionunable to reproduce 
Fixed in Version2.50.x 
Summary10224: Unable to add second and thrid and so on for subquestions
Description

When i try to add more subquestions, it crash but it works for a single subquestion

Steps To Reproduce
  1. create a survey
  2. create a question group
  3. create a question with the type "multiple choises with comments"
  4. add a subquestions
  5. add a subquestion again
Additional Information

log :
2016/01/13 13:45:16 [trace] [system.CModule] Loading "log" application component
2016/01/13 13:45:16 [trace] [system.CModule] Loading "request" application component
2016/01/13 13:45:16 [trace] [system.CModule] Loading "urlManager" application component
2016/01/13 13:45:16 [trace] [system.CModule] Loading "cache" application component
2016/01/13 13:45:16 [trace] [system.CModule] Loading "assetManager" application component
2016/01/13 13:45:16 [trace] [system.CModule] Loading "session" application component
2016/01/13 13:45:16 [trace] [system.CModule] Loading "db" application component
2016/01/13 13:45:16 [trace] [system.db.CDbConnection] Opening DB connection
2016/01/13 13:45:16 [trace] [system.db.CDbCommand] Querying SQL: SHOW FULL COLUMNS FROM lime_settings_global
2016/01/13 13:45:16 [trace] [system.db.CDbCommand] Querying SQL: SHOW CREATE TABLE lime_settings_global
2016/01/13 13:45:16 [trace] [system.db.ar.CActiveRecord] SettingGlobal.findAll()
2016/01/13 13:45:16 [trace] [system.db.CDbCommand] Querying SQL: SELECT FROM lime_settings_global t
2016/01/13 13:45:16 [trace] [system.CModule] Loading "bootstrap" application component
2016/01/13 13:45:16 [trace] [system.CModule] Loading "messages" application component
2016/01/13 13:45:16 [trace] [system.CModule] Loading "clientScript" application component
2016/01/13 13:45:16 [trace] [system.CModule] Loading "user" application component
2016/01/13 13:45:16 [trace] [system.db.CDbCommand] Querying SQL: SHOW FULL COLUMNS FROM lime_templates
2016/01/13 13:45:16 [trace] [system.db.CDbCommand] Querying SQL: SHOW CREATE TABLE lime_templates
2016/01/13 13:45:16 [trace] [system.db.CDbCommand] Querying SQL: SHOW FULL COLUMNS FROM lime_surveys
2016/01/13 13:45:16 [trace] [system.db.CDbCommand] Querying SQL: SHOW CREATE TABLE lime_surveys
2016/01/13 13:45:16 [trace] [system.db.CDbCommand] Querying SQL: SHOW FULL COLUMNS FROM lime_permissions
2016/01/13 13:45:16 [trace] [system.db.CDbCommand] Querying SQL: SHOW CREATE TABLE lime_permissions
2016/01/13 13:45:16 [trace] [system.CModule] Loading "pluginManager" application component
2016/01/13 13:45:16 [trace] [system.db.ar.CActiveRecord] Plugin.findAllByAttributes()
2016/01/13 13:45:16 [trace] [system.db.CDbCommand] Querying SQL: SHOW FULL COLUMNS FROM lime_plugins
2016/01/13 13:45:16 [trace] [system.db.CDbCommand] Querying SQL: SHOW CREATE TABLE lime_plugins
2016/01/13 13:45:16 [trace] [system.db.CDbCommand] Querying SQL: SELECT FROM lime_plugins t WHERE t.active=:yp0. Bound with :yp0=1
2016/01/13 13:45:16 [trace] [system.db.ar.CActiveRecord] Permission.findByAttributes()
2016/01/13 13:45:16 [trace] [system.db.CDbCommand] Querying SQL: 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'
2016/01/13 13:45:16 [trace] [system.db.ar.CActiveRecord] Survey.findByPk()
2016/01/13 13:45:16 [trace] [system.db.CDbCommand] Querying SQL: SELECT FROM lime_surveys t WHERE t.sid=687414 LIMIT 1
2016/01/13 13:45:16 [trace] [application]
2016/01/13 13:45:16 [trace] [application]
2016/01/13 13:45:16 [trace] [application]
2016/01/13 13:45:16 [trace] [system.db.CDbCommand] Querying SQL: SHOW FULL COLUMNS FROM lime_questions
2016/01/13 13:45:16 [trace] [system.db.CDbCommand] Querying SQL: SHOW CREATE TABLE lime_questions
2016/01/13 13:45:16 [trace] [system.db.ar.CActiveRecord] Question.findByAttributes()
2016/01/13 13:45:16 [trace] [system.db.CDbCommand] Querying SQL: SELECT FROM lime_questions t WHERE t.qid=:yp0 LIMIT 1. Bound with :yp0='1'
2016/01/13 13:45:16 [trace] [system.db.CDbCommand] Querying SQL: SELECT DISTINCT c., q.sid, q.type
FROM lime_conditions AS c
LEFT JOIN lime_questions q ON c.cqid=q.qid
LEFT JOIN lime_questions qa ON c.qid=qa.qid
WHERE qa.sid = 687414 AND 1=1
UNION
SELECT DISTINCT c., q.sid, NULL AS TYPE
FROM lime_conditions AS c
LEFT JOIN lime_questions q ON c.cqid=q.qid
LEFT JOIN lime_questions qa ON c.qid=qa.qid
WHERE qa.sid = 687414 AND c.cqid = 0 order by qid, sid, scenario, cqid, cfieldname, value
2016/01/13 13:45:16 [trace] [system.db.ar.CActiveRecord] Question.find()
2016/01/13 13:45:16 [trace] [system.db.CDbCommand] Querying SQL: SELECT FROM lime_questions t WHERE qid=:qid AND language=:language LIMIT 1. Bound with :qid=2, :language='en'
2016/01/13 13:45:16 [trace] [application]
2016/01/13 13:45:16 [trace] [application]
2016/01/13 13:45:16 [trace] [application]
2016/01/13 13:45:16 [trace] [application]
2016/01/13 13:45:16 [trace] [application]
2016/01/13 13:45:16 [trace] [system.db.ar.CActiveRecord] Question.findByPk()
2016/01/13 13:45:16 [trace] [system.db.CDbCommand] Querying SQL: SELECT FROM lime_questions t WHERE t.qid=1 AND t.language='en' LIMIT 1
2016/01/13 13:45:16 [trace] [system.db.ar.CActiveRecord] Question.findByPk()
2016/01/13 13:45:16 [trace] [system.db.CDbCommand] Querying SQL: SELECT FROM lime_questions t WHERE t.qid=2 AND t.language='en' LIMIT 1
2016/01/13 13:45:16 [trace] [system.db.ar.CActiveRecord] Question.findAll()
2016/01/13 13:45:16 [trace] [system.db.CDbCommand] Querying SQL: SELECT FROM lime_questions t WHERE (language=:language) AND (t.qid=:ycp0) LIMIT 2. Bound with :language='en', :ycp0='2'
2016/01/13 13:45:16 [trace] [system.db.ar.CActiveRecord] Question.findAll()
2016/01/13 13:45:16 [trace] [system.db.CDbCommand] Querying SQL: SELECT FROM lime_questions t WHERE (language=:language AND sid=:sid AND parent_qid=:parent_qid and scale_id=:scale_id) AND (LOWER(t.title)=LOWER(:ycp1)) LIMIT 2. Bound with :language='en', :sid='687414', :parent_qid='1', :scale_id=0, :ycp1='SQ001'
2016/01/13 13:45:16 [trace] [system.db.ar.CActiveRecord] Question.update()
2016/01/13 13:45:16 [trace] [system.db.ar.CActiveRecord] Question.updateByPk()
2016/01/13 13:45:16 [trace] [system.db.CDbCommand] Executing SQL: UPDATE lime_questions SET qid=:yp0, parent_qid=:yp1, sid=:yp2, gid=:yp3, type=:yp4, title=:yp5, question=:yp6, preg=:yp7, help=:yp8, other=:yp9, mandatory=:yp10, question_order=:yp11, language=:yp12, scale_id=:yp13, same_default=:yp14, relevance=:yp15, modulename=:yp16 WHERE lime_questions.qid=2 AND lime_questions.language='en'. Bound with :yp0=2, :yp1=1, :yp2=687414, :yp3=1, :yp4='T', :yp5='SQ001', :yp6='True', :yp7=NULL, :yp8=NULL, :yp9='N', :yp10=NULL, :yp11=1, :yp12='en', :yp13=0, :yp14=0, :yp15='1', :yp16=''
2016/01/13 13:45:16 [trace] [system.db.ar.CActiveRecord] Question.find()
2016/01/13 13:45:16 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM lime_questions t WHERE qid=:qid AND language=:language LIMIT 1. Bound with :qid=3, :language='en'
2016/01/13 13:45:16 [error] [php] Creating default object from empty value (/vagrant/new_lime/application/controllers/admin/database.php:282)
Stack trace:
#0 /vagrant/new_lime/application/core/Survey_Common_Action.php(101): database->runWithParamsInternal()
#1 /vagrant/new_lime/framework/web/CController.php(308): database->runWithParams()
#2 /vagrant/new_lime/framework/web/CController.php(286): AdminController->runAction()
#3 /vagrant/new_lime/framework/web/CController.php(265): AdminController->runActionWithFilters()
#4 /vagrant/new_lime/application/controllers/AdminController.php(165): AdminController->run()
#5 /vagrant/new_lime/framework/web/CWebApplication.php(282): AdminController->run()
#6 /vagrant/new_lime/framework/web/CWebApplication.php(141): LSYii_Application->runController()
#7 /vagrant/new_lime/framework/base/CApplication.php(184): LSYii_Application->processRequest()
#8 /vagrant/new_lime/index.php(211): LSYii_Application->run()
REQUEST_URI=/new_lime/index.php/admin/database
2016/01/13 13:45:16 [trace] [system.CModule] Loading "errorHandler" application component

TagsNo tags attached.
Attached Files
note-1.png (71,129 bytes)   
note-1.png (71,129 bytes)   
Bug heat4
Complete LimeSurvey version number (& build)
I will donate to the project if issue is resolved
Browser
Database type & version
Server OS (if known)
Webserver software & version (if known)
PHP Version

Users monitoring this issue

There are no users monitoring this issue.

Activities

ollehar

ollehar

2016-02-05 16:07

administrator   ~34631

This bug is probably already fixed (I can't reproduce it). Please try again with newer version.
c_schmitz

c_schmitz

2016-02-06 00:35

administrator   ~34652

2.50+ Build 160206 released

Issue History

Date Modified Username Field Change
2016-01-13 14:52 spycomb New Issue
2016-01-13 14:52 spycomb File Added: note-1.png
2016-02-05 08:33 DenisChenu Project Development => Bug reports
2016-02-05 08:33 DenisChenu Category Survey Design => Other issues
2016-02-05 16:01 ollehar Assigned To => ollehar
2016-02-05 16:01 ollehar Status new => assigned
2016-02-05 16:07 ollehar Note Added: 34631
2016-02-05 16:07 ollehar Status assigned => resolved
2016-02-05 16:07 ollehar Fixed in Version => 2.5
2016-02-05 16:07 ollehar Resolution open => unable to reproduce
2016-02-06 00:35 c_schmitz Note Added: 34652
2016-02-06 00:35 c_schmitz Status resolved => closed