04731: Exported/Copied survey structures are lacking type t for subquestions.No activation possible - LimeSurvey bugs, patches and feature requests

Notes
(13478) jelo (reporter) 2010-11-10 12:31 edited on: 2010-11-10 15:37	The mysql database table structure of lime_questions are containing standard values for type = T and other = N when doing a fresh installation. The updated installation still showing the old structure without standard values. Reason might be the broken update routine some builds ago. There might be a mismatch in the dbversion with controls the sql upgrade routines. Version set but structure not changed. Since this is causing a lot of problems (conditions cannot be imported too) this ticket won't be fruitful anymore and can be closed. I am sorry for wasting time.

(13481) c_schmitz (administrator) 2010-11-10 16:43	That is weird. I will schedule another test for update routines from early versions.

(13496) jelo (reporter) 2010-11-10 18:41 edited on: 2010-11-10 18:42	Faulty Import of conditions seem to be a specific problem with certain kind of conditions. I found that a multioption question as trigger for a condition isn't imported. I attached a short survey. Not sure if the export is faulty or the import. I uploaded the demo survey to the demo installation of limesurvey on limesurvey.org and 0 conditions were imported.

(13498) jelo (reporter) 2010-11-10 20:21 edited on: 2010-11-10 20:38	If I remember it right, a few had problems with the update routine "Allowed memory size of xxx bytes exhausted" where a fix was provides to get the comfortupdate running again. I had this on the 7th Oct 2010. Perhaps in the timeframe a few people got a not update dbstructure. I haven't checked if it is possible that the db version update without updating the structure itself and the data. I updated another old installation a few days ago via comfortupdate and the mysql structure was updated correctly. There was no break of the updateroutine. Sorry that I didn't noted the build numbers.

(13501) jelo (reporter) 2010-11-11 00:18	1. Page Yes/No Multiple options 2. Page Condition on Yes/No only -> Condition is successful copied Condition on Yes/No and Multiple options -> Conditions are successful copied Condition on Multiple options only -> Condition is not copied

(13516) c_schmitz (administrator) 2010-11-12 23:59	Checked the upgrade route - in general it was fine. Thibault, can you have a look at the conditions issue, plz?

(13519) lemeur (administrator) 2010-11-13 09:52	Partly fixed in rev 9479. ==> fixed for conditions on single-checkboxes only. I assign this one back to you Carsten, since fixing for conditions set on the set of checkboxes require changes to the createFieldmap function. Thibault

(13567) c_schmitz (administrator) 2010-11-22 13:32	Thibault, can you tell me what exactly you need?

(13573) lemeur (administrator) 2010-11-22 22:11	Conditions not only use true fieldnames, but also meta fieldnames. In the past, conditions for mutliple options were only using an "SGQ" meta fieldname that is representing the group of checkboxes. Thus adding a condition with possible values X,Y and Z for the SGQ meta fieldname really means either SGQX or SGQY or SGQZ is set (ORed conditions). ==> This was how conditions were implemented historically for this kind of questions. CreateFieldmap doesn't return SGQ meta fieldname for multiple options as this is not a true fieldname. Only the full SGQA fieldnames are really used in DB. The importsurvey script uses createFieldmap which explains why some conditions can't be imported.

(13578) c_schmitz (administrator) 2010-11-22 22:48	Ok, thanks. I will have a look.

(13647) c_schmitz (administrator) 2010-11-28 02:24	Fixed in rev. 9543

(13714) c_schmitz (administrator) 2010-12-07 14:14	Released in latest 1.90+ version.

Issue History
Date Modified	Username	Field	Change
2010-11-10 12:04	jelo	New Issue
2010-11-10 12:31	jelo	Note Added: 13478
2010-11-10 15:37	jelo	Note Edited: 13478	View Revisions
2010-11-10 16:42	c_schmitz	Assigned To	=> c_schmitz
2010-11-10 16:42	c_schmitz	Status	new => assigned
2010-11-10 16:43	c_schmitz	Note Added: 13481
2010-11-10 18:41	jelo	Note Added: 13496
2010-11-10 18:41	jelo	File Added: limesurvey_survey_73537.lss
2010-11-10 18:42	jelo	Note Edited: 13496	View Revisions
2010-11-10 20:21	jelo	Note Added: 13498
2010-11-10 20:38	jelo	Note Edited: 13498	View Revisions
2010-11-10 23:05	user4990	Note Added: 13499
2010-11-10 23:05	user4990	Note Deleted: 13499
2010-11-11 00:18	jelo	Note Added: 13501
2010-11-12 23:59	c_schmitz	Assigned To	c_schmitz => lemeur
2010-11-12 23:59	c_schmitz	Note Added: 13516
2010-11-13 09:49	lemeur	Assigned To	lemeur => c_schmitz
2010-11-13 09:52	lemeur	Note Added: 13519
2010-11-22 13:32	c_schmitz	Note Added: 13567
2010-11-22 22:11	lemeur	Note Added: 13573
2010-11-22 22:48	c_schmitz	Note Added: 13578
2010-11-28 02:24	c_schmitz	Note Added: 13647
2010-11-28 02:24	c_schmitz	Status	assigned => resolved
2010-11-28 02:24	c_schmitz	Fixed in Version	=> 1.90+
2010-11-28 02:24	c_schmitz	Resolution	open => fixed
2010-12-07 14:14	c_schmitz	Note Added: 13714
2010-12-07 14:14	c_schmitz	Status	resolved => closed

Relationships