View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 0
IDProjectCategoryView StatusDate SubmittedLast Update
13717Bug reportsImport/Exportpublic2018-05-26 16:312018-05-28 15:32
ReporterDenisChenu Assigned ToDenisChenu  
PrioritynoneSeverityminor 
Status closedResolutionduplicate 
Product Version3.8.x 
Fixed in Version3.8.x 
Summary13717: Survey with quota (from 2.64) broke on import
Description

When import this survey (simple : one equation, one single choice + on free text) with quote : it's broke with Error: Failed to insert data even with debug=2

Steps To Reproduce

Import included lss

Additional Information

Remove quota fix the issue
See quota.html for result with debug+debugsql

TagsNo tags attached.
Attached Files
QUOTAS_V2.64_limesurvey_survey_741337.lss (26,361 bytes)
QUOTAS_V2.64_SANS_QUOTAS_limesurvey_survey_741337.lss (24,597 bytes)
copy.html (70,806 bytes)    
<html><head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8"></head><body>Error: Failed to insert data<br><!-- 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.59971s,
			Memory: 13,879KB)
		</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 `limeliste_surveys`)</td>
		<td align="center">1</td>
		<td align="center">0.00391</td>
		<td align="center">0.00391</td>
		<td align="center">0.00391</td>
		<td align="center">0.00391</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `limeliste_surveys_languagesettings`)</td>
		<td align="center">1</td>
		<td align="center">0.00324</td>
		<td align="center">0.00324</td>
		<td align="center">0.00324</td>
		<td align="center">0.00324</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `limeliste_questions`)</td>
		<td align="center">1</td>
		<td align="center">0.00307</td>
		<td align="center">0.00307</td>
		<td align="center">0.00307</td>
		<td align="center">0.00307</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT *  FROM limeliste_questions as 
questions, limeliste_groups as question_groups WHERE 
questions.gid=question_groups.gid AND  questions.sid=741337 AND  
questions.language='fr' AND  questions.parent_qid=0 AND  
question_groups.language='fr'  ORDER BY group_order, question_order)</td>
		<td align="center">1</td>
		<td align="center">0.00307</td>
		<td align="center">0.00307</td>
		<td align="center">0.00307</td>
		<td align="center">0.00307</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `limeliste_templates`)</td>
		<td align="center">1</td>
		<td align="center">0.00303</td>
		<td align="center">0.00303</td>
		<td align="center">0.00303</td>
		<td align="center">0.00303</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `limeliste_settings_global`)</td>
		<td align="center">1</td>
		<td align="center">0.00302</td>
		<td align="center">0.00302</td>
		<td align="center">0.00302</td>
		<td align="center">0.00302</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `limeliste_permissions`)</td>
		<td align="center">1</td>
		<td align="center">0.00290</td>
		<td align="center">0.00290</td>
		<td align="center">0.00290</td>
		<td align="center">0.00290</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `limeliste_groups`)</td>
		<td align="center">1</td>
		<td align="center">0.00286</td>
		<td align="center">0.00286</td>
		<td align="center">0.00286</td>
		<td align="center">0.00286</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `limeliste_answers`)</td>
		<td align="center">1</td>
		<td align="center">0.00286</td>
		<td align="center">0.00286</td>
		<td align="center">0.00286</td>
		<td align="center">0.00286</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `limeliste_question_attributes`)</td>
		<td align="center">1</td>
		<td align="center">0.00284</td>
		<td align="center">0.00284</td>
		<td align="center">0.00284</td>
		<td align="center">0.00284</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `limeliste_defaultvalues`)</td>
		<td align="center">1</td>
		<td align="center">0.00284</td>
		<td align="center">0.00284</td>
		<td align="center">0.00284</td>
		<td align="center">0.00284</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `limeliste_plugins`)</td>
		<td align="center">1</td>
		<td align="center">0.00283</td>
		<td align="center">0.00283</td>
		<td align="center">0.00283</td>
		<td align="center">0.00283</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `limeliste_quota`)</td>
		<td align="center">1</td>
		<td align="center">0.00282</td>
		<td align="center">0.00282</td>
		<td align="center">0.00282</td>
		<td align="center">0.00282</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `limeliste_quota_members`)</td>
		<td align="center">1</td>
		<td align="center">0.00280</td>
		<td align="center">0.00280</td>
		<td align="center">0.00280</td>
		<td align="center">0.00280</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `limeliste_quota_languagesettings`)</td>
		<td align="center">1</td>
		<td align="center">0.00279</td>
		<td align="center">0.00279</td>
		<td align="center">0.00279</td>
		<td align="center">0.00279</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SHOW TABLES)</td>
		<td align="center">1</td>
		<td align="center">0.00164</td>
		<td align="center">0.00164</td>
		<td align="center">0.00164</td>
		<td align="center">0.00164</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SELECT * FROM `limeliste_questions` `t`
 WHERE parent_qid=:parent_qid and LOWER(title)='other' LIMIT 1. Bound 
with :parent_qid=NULL)</td>
		<td align="center">4</td>
		<td align="center">0.00148</td>
		<td align="center">0.00037</td>
		<td align="center">0.00036</td>
		<td align="center">0.00038</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT * FROM `limeliste_surveys` `t` WHERE `t`.`sid`=741337 LIMIT 1)</td>
		<td align="center">2</td>
		<td align="center">0.00112</td>
		<td align="center">0.00056</td>
		<td align="center">0.00053</td>
		<td align="center">0.00059</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SELECT * FROM `limeliste_settings_global` `t`)</td>
		<td align="center">1</td>
		<td align="center">0.00071</td>
		<td align="center">0.00071</td>
		<td align="center">0.00071</td>
		<td align="center">0.00071</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.execute(INSERT INTO 
`limeliste_surveys_languagesettings` (`surveyls_dateformat`, 
`surveyls_numberformat`, `surveyls_survey_id`, `surveyls_language`, 
`surveyls_title`, `surveyls_description`, `surveyls_welcometext`, 
`surveyls_endtext`, `surveyls_url`, `surveyls_urldescription`, 
`surveyls_email_invite_subj`, `surveyls_email_invite`, 
`surveyls_email_remind_subj`, `surveyls_email_remind`, 
`surveyls_email_register_subj`, `surveyls_email_register`, 
`surveyls_email_confirm_subj`, `surveyls_email_confirm`, 
`surveyls_attributecaptions`, `email_admin_notification_subj`, 
`email_admin_notification`, `email_admin_responses_subj`, 
`email_admin_responses`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, 
:yp6, :yp7, :yp8, :yp9, :yp10, :yp11, :yp12, :yp13, :yp14, :yp15, :yp16,
 :yp17, :yp18, :yp19, :yp20, :yp21, :yp22). Bound with :yp0=5, :yp1=1, 
:yp2=741337, :yp3='fr', :yp4='tests attribut_invitations', :yp5='', 
:yp6='', :yp7='', :yp8='', :yp9='', :yp10='Invitation à participer à un 
questionnaire', :yp11='Cher(e) {FIRSTNAME},&lt;br /&gt;
&lt;br /&gt;
Vous avez été invité(e) à participer à un questionnaire.&lt;br /&gt;
&lt;br /&gt;
Celui-ci est intitulé :&lt;br /&gt;
"{SURVEYNAME}"&lt;br /&gt;
&lt;br /&gt;
"{SURVEYDESCRIPTION}"&lt;br /&gt;
&lt;br /&gt;
Pour participer, veuillez cliquer sur le lien ci-dessous.&lt;br /&gt;
&lt;br /&gt;
Cordialement,&lt;br /&gt;
&lt;br /&gt;
{ADMINNAME} ({ADMINEMAIL})&lt;br /&gt;
&lt;br /&gt;
----------------------------------------------&lt;br /&gt;
Cliquez ici pour remplir ce questionnaire :&lt;br /&gt;
{SURVEYURL}&lt;br /&gt;
&lt;br /&gt;
Si vous ne souhaitez pas participer à ce questionnaire et ne souhaitez 
plus recevoir aucune invitation, veuillez cliquer sur le lien suivant 
:&lt;br /&gt;
{OPTOUTURL}&lt;br /&gt;
&lt;br /&gt;
Si vous êtes sur liste noire mais que vous voulez participer à ce 
questionnaire et recevoir les invitations, merci de cliquer sur le lien 
suivant :&lt;br /&gt;
{OPTINURL}', :yp12='Rappel pour participer à un questionnaire', 
:yp13='Cher(e) {FIRSTNAME},&lt;br /&gt;
&lt;br /&gt;
Vous avez été invité(e) à participer à un questionnaire récemment.&lt;br
 /&gt;
&lt;br /&gt;
Nous avons pris en compte que vous n\'avez pas encore complété le 
questionnaire, et nous vous rappelons que celui-ci est toujours 
disponible si vous souhaitez participer.&lt;br /&gt;
&lt;br /&gt;
Le questionnaire est intitulé :&lt;br /&gt;
"{SURVEYNAME}"&lt;br /&gt;
&lt;br /&gt;
"{SURVEYDESCRIPTION}"&lt;br /&gt;
&lt;br /&gt;
Pour participer, veuillez cliquer sur le lien ci-dessous.&lt;br /&gt;
&lt;br /&gt;
Cordialement,&lt;br /&gt;
&lt;br /&gt;
{ADMINNAME} ({ADMINEMAIL})&lt;br /&gt;
&lt;br /&gt;
----------------------------------------------&lt;br /&gt;
Cliquez ici pour faire le questionnaire:&lt;br /&gt;
{SURVEYURL}&lt;br /&gt;
&lt;br /&gt;
Si vous ne souhaitez pas participer à ce questionnaire et ne souhaitez 
plus recevoir aucune invitation, veuillez cliquer sur le lien suivant 
:&lt;br /&gt;
{OPTOUTURL}', :yp14='Confirmation d\'enregistrement au questionnaire', 
:yp15='Bonjour {FIRSTNAME},&lt;br /&gt;
&lt;br /&gt;
Vous (ou quelqu’un utilisant votre adresse électronique) vous êtes 
enregistré pour participer à un questionnaire en ligne intitulé 
{SURVEYNAME}.&lt;br /&gt;
&lt;br /&gt;
Pour compléter ce questionnaire, cliquez sur le lien suivant :&lt;br 
/&gt;
{SURVEYURL}&lt;br /&gt;
&lt;br /&gt;
Si vous avez des questions à propos de ce questionnaire, ou si vous ne 
vous êtes pas enregistré pour participer à celui-ci et croyez que ce 
courriel est une erreur, veuillez contacter {ADMINNAME} à l’adresse 
{ADMINEMAIL}', :yp16='Confirmation de votre participation à notre 
questionnaire', :yp17='Bonjour {FIRSTNAME},&lt;br /&gt;
&lt;br /&gt;
Ce courriel vous confirme que vous avez complété le questionnaire 
intitulé {SURVEYNAME} et que votre réponse a été enregistrée. Merci pour
 votre participation.&lt;br /&gt;
&lt;br /&gt;
Si vous avez des questions à propos de ce courriel, veuillez contacter 
{ADMINNAME} à l’adresse {ADMINEMAIL}.&lt;br /&gt;
&lt;br /&gt;
Cordialement,&lt;br /&gt;
&lt;br /&gt;
{ADMINNAME}', :yp18='{"attribute_1":""}', :yp19='Soumission de réponse 
pour le questionnaire {SURVEYNAME}', :yp20='Bonjour,&lt;br /&gt;
&lt;br /&gt;
Une nouvelle réponse a été soumise pour votre questionnaire 
\'{SURVEYNAME}\'.&lt;br /&gt;
&lt;br /&gt;
Cliquez sur le lien suivant pour recharger votre questionnaire :&lt;br 
/&gt;
{RELOADURL}&lt;br /&gt;
&lt;br /&gt;
Cliquez sur le lien suivant pour voir la réponse :&lt;br /&gt;
{VIEWRESPONSEURL}&lt;br /&gt;
&lt;br /&gt;
Cliquez sur le lien suivant pour éditer la réponse :&lt;br /&gt;
{EDITRESPONSEURL}&lt;br /&gt;
&lt;br /&gt;
Visualisez les statistiques en cliquant ici :&lt;br /&gt;
{STATISTICSURL}&lt;br /&gt;
&lt;br /&gt;
les réponses suivantes ont été données par le participant :&lt;br /&gt;
{ANSWERTABLE}', :yp21='Soumission de réponse pour le questionnaire 
{SURVEYNAME} avec résultats', :yp22='Bonjour,&lt;br /&gt;
&lt;br /&gt;
Une nouvelle réponse a été soumise pour votre questionnaire 
\'{SURVEYNAME}\'.&lt;br /&gt;
&lt;br /&gt;
Cliquez sur le lien suivant pour recharger votre questionnaire :&lt;br 
/&gt;
{RELOADURL}&lt;br /&gt;
&lt;br /&gt;
Cliquez sur le lien suivant pour voir la réponse :&lt;br /&gt;
{VIEWRESPONSEURL}&lt;br /&gt;
&lt;br /&gt;
Cliquez sur le lien suivant pour éditer la réponse individuelle :&lt;br 
/&gt;
{EDITRESPONSEURL}&lt;br /&gt;
&lt;br /&gt;
Visualisez les statistiques en cliquant ici :&lt;br /&gt;
{STATISTICSURL}&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
les réponses suivantes ont été données par le participant :&lt;br /&gt;
{ANSWERTABLE}')</td>
		<td align="center">1</td>
		<td align="center">0.00067</td>
		<td align="center">0.00067</td>
		<td align="center">0.00067</td>
		<td align="center">0.00067</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SELECT a.qid, a.sqid, a.scale_id, 
a.specialtype, a.defaultvalue FROM limeliste_defaultvalues as a, 
limeliste_questions as b WHERE a.qid = b.qid AND a.language = b.language
 AND a.language = 'fr' AND b.same_default=0 AND b.sid = 741337)</td>
		<td align="center">1</td>
		<td align="center">0.00062</td>
		<td align="center">0.00062</td>
		<td align="center">0.00062</td>
		<td align="center">0.00062</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT 1 FROM `limeliste_answers` `t` 
WHERE (language=:language AND qid=:qid AND scale_id=:scale_id) AND 
(LOWER(`t`.`code`)=LOWER(:ycp26)) LIMIT 1. Bound with :language='fr', 
:qid='5662', :scale_id='0', :ycp26='A16')</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 1 FROM `limeliste_answers` `t` 
WHERE (language=:language AND qid=:qid AND scale_id=:scale_id) AND 
(LOWER(`t`.`code`)=LOWER(:ycp14)) LIMIT 1. Bound with :language='fr', 
:qid='5662', :scale_id='0', :ycp14='A10')</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:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT 1 FROM `limeliste_answers` `t` 
WHERE (language=:language AND qid=:qid AND scale_id=:scale_id) AND 
(LOWER(`t`.`code`)=LOWER(:ycp54)) LIMIT 1. Bound with :language='fr', 
:qid='5662', :scale_id='0', :ycp54='A6')</td>
		<td align="center">1</td>
		<td align="center">0.00055</td>
		<td align="center">0.00055</td>
		<td align="center">0.00055</td>
		<td align="center">0.00055</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SELECT 1 FROM `limeliste_answers` `t` 
WHERE (language=:language AND qid=:qid AND scale_id=:scale_id) AND 
(LOWER(`t`.`code`)=LOWER(:ycp60)) LIMIT 1. Bound with :language='fr', 
:qid='5662', :scale_id='0', :ycp60='A9')</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 1 FROM `limeliste_answers` `t` 
WHERE (language=:language AND qid=:qid AND scale_id=:scale_id) AND 
(LOWER(`t`.`code`)=LOWER(:ycp52)) LIMIT 1. Bound with :language='fr', 
:qid='5662', :scale_id='0', :ycp52='A5')</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(SELECT 1 FROM `limeliste_answers` `t` 
WHERE (language=:language AND qid=:qid AND scale_id=:scale_id) AND 
(LOWER(`t`.`code`)=LOWER(:ycp50)) LIMIT 1. Bound with :language='fr', 
:qid='5662', :scale_id='0', :ycp50='A4')</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 1 FROM `limeliste_answers` `t` 
WHERE (language=:language AND qid=:qid AND scale_id=:scale_id) AND 
(LOWER(`t`.`code`)=LOWER(:ycp58)) LIMIT 1. Bound with :language='fr', 
:qid='5662', :scale_id='0', :ycp58='A8')</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(SELECT 1 FROM `limeliste_answers` `t` 
WHERE (language=:language AND qid=:qid AND scale_id=:scale_id) AND 
(LOWER(`t`.`code`)=LOWER(:ycp48)) LIMIT 1. Bound with :language='fr', 
:qid='5662', :scale_id='0', :ycp48='A3')</td>
		<td align="center">1</td>
		<td align="center">0.00053</td>
		<td align="center">0.00053</td>
		<td align="center">0.00053</td>
		<td align="center">0.00053</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT 1 FROM `limeliste_answers` `t` 
WHERE (language=:language AND qid=:qid AND scale_id=:scale_id) AND 
(LOWER(`t`.`code`)=LOWER(:ycp46)) LIMIT 1. Bound with :language='fr', 
:qid='5662', :scale_id='0', :ycp46='A25')</td>
		<td align="center">1</td>
		<td align="center">0.00053</td>
		<td align="center">0.00053</td>
		<td align="center">0.00053</td>
		<td align="center">0.00053</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SELECT 1 FROM `limeliste_answers` `t` 
WHERE (language=:language AND qid=:qid AND scale_id=:scale_id) AND 
(LOWER(`t`.`code`)=LOWER(:ycp40)) LIMIT 1. Bound with :language='fr', 
:qid='5662', :scale_id='0', :ycp40='A22')</td>
		<td align="center">1</td>
		<td align="center">0.00053</td>
		<td align="center">0.00053</td>
		<td align="center">0.00053</td>
		<td align="center">0.00053</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT 1 FROM `limeliste_answers` `t` 
WHERE (language=:language AND qid=:qid AND scale_id=:scale_id) AND 
(LOWER(`t`.`code`)=LOWER(:ycp42)) LIMIT 1. Bound with :language='fr', 
:qid='5662', :scale_id='0', :ycp42='A23')</td>
		<td align="center">1</td>
		<td align="center">0.00053</td>
		<td align="center">0.00053</td>
		<td align="center">0.00053</td>
		<td align="center">0.00053</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SELECT 1 FROM `limeliste_answers` `t` 
WHERE (language=:language AND qid=:qid AND scale_id=:scale_id) AND 
(LOWER(`t`.`code`)=LOWER(:ycp31)) LIMIT 1. Bound with :language='fr', 
:qid='5662', :scale_id='0', :ycp31='A18')</td>
		<td align="center">1</td>
		<td align="center">0.00053</td>
		<td align="center">0.00053</td>
		<td align="center">0.00053</td>
		<td align="center">0.00053</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT 1 FROM `limeliste_answers` `t` 
WHERE (language=:language AND qid=:qid AND scale_id=:scale_id) AND 
(LOWER(`t`.`code`)=LOWER(:ycp44)) LIMIT 1. Bound with :language='fr', 
:qid='5662', :scale_id='0', :ycp44='A24')</td>
		<td align="center">1</td>
		<td align="center">0.00053</td>
		<td align="center">0.00053</td>
		<td align="center">0.00053</td>
		<td align="center">0.00053</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SELECT 1 FROM `limeliste_answers` `t` 
WHERE (language=:language AND qid=:qid AND scale_id=:scale_id) AND 
(LOWER(`t`.`code`)=LOWER(:ycp38)) LIMIT 1. Bound with :language='fr', 
:qid='5662', :scale_id='0', :ycp38='A21')</td>
		<td align="center">1</td>
		<td align="center">0.00053</td>
		<td align="center">0.00053</td>
		<td align="center">0.00053</td>
		<td align="center">0.00053</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT 1 FROM `limeliste_answers` `t` 
WHERE (language=:language AND qid=:qid AND scale_id=:scale_id) AND 
(LOWER(`t`.`code`)=LOWER(:ycp57)) LIMIT 1. Bound with :language='fr', 
:qid='5662', :scale_id='0', :ycp57='A7')</td>
		<td align="center">1</td>
		<td align="center">0.00052</td>
		<td align="center">0.00052</td>
		<td align="center">0.00052</td>
		<td align="center">0.00052</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SELECT 1 FROM `limeliste_answers` `t` 
WHERE (language=:language AND qid=:qid AND scale_id=:scale_id) AND 
(LOWER(`t`.`code`)=LOWER(:ycp36)) LIMIT 1. Bound with :language='fr', 
:qid='5662', :scale_id='0', :ycp36='A20')</td>
		<td align="center">1</td>
		<td align="center">0.00052</td>
		<td align="center">0.00052</td>
		<td align="center">0.00052</td>
		<td align="center">0.00052</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT 1 FROM `limeliste_answers` `t` 
WHERE (language=:language AND qid=:qid AND scale_id=:scale_id) AND 
(LOWER(`t`.`code`)=LOWER(:ycp28)) LIMIT 1. Bound with :language='fr', 
:qid='5662', :scale_id='0', :ycp28='A17')</td>
		<td align="center">1</td>
		<td align="center">0.00052</td>
		<td align="center">0.00052</td>
		<td align="center">0.00052</td>
		<td align="center">0.00052</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SELECT 1 FROM `limeliste_answers` `t` 
WHERE (language=:language AND qid=:qid AND scale_id=:scale_id) AND 
(LOWER(`t`.`code`)=LOWER(:ycp32)) LIMIT 1. Bound with :language='fr', 
:qid='5662', :scale_id='0', :ycp32='A19')</td>
		<td align="center">1</td>
		<td align="center">0.00052</td>
		<td align="center">0.00052</td>
		<td align="center">0.00052</td>
		<td align="center">0.00052</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT 1 FROM `limeliste_answers` `t` 
WHERE (language=:language AND qid=:qid AND scale_id=:scale_id) AND 
(LOWER(`t`.`code`)=LOWER(:ycp34)) LIMIT 1. Bound with :language='fr', 
:qid='5662', :scale_id='0', :ycp34='A2')</td>
		<td align="center">1</td>
		<td align="center">0.00052</td>
		<td align="center">0.00052</td>
		<td align="center">0.00052</td>
		<td align="center">0.00052</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.execute(INSERT INTO `limeliste_surveys` 
(`active`, `anonymized`, `savetimings`, `template`, `datestamp`, 
`usecookie`, `allowregister`, `allowsave`, `autonumber_start`, 
`autoredirect`, `allowprev`, `printanswers`, `ipaddr`, `refurl`, 
`publicstatistics`, `publicgraphs`, `listpublic`, `htmlemail`, 
`tokenanswerspersistence`, `assessments`, `usecaptcha`, `usetokens`, 
`tokenlength`, `showxquestions`, `showgroupinfo`, `shownoanswer`, 
`showqnumcode`, `bounceprocessing`, `showwelcome`, `showprogress`, 
`navigationdelay`, `nokeyboard`, `alloweditaftercompletion`, 
`sendconfirmation`, `questionindex`, `gsid`, `showsurveypolicynotice`, 
`format`, `language`, `sid`, `admin`, `adminemail`, `faxto`, 
`additional_languages`, `bounce_email`, `attributedescriptions`, 
`emailresponseto`, `emailnotificationto`, `googleanalyticsstyle`, 
`googleanalyticsapikey`, `owner_id`, `datecreated`, `startdate`, 
`expires`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7, :yp8,
 :yp9, :yp10, :yp11, :yp12, :yp13, :yp14, :yp15, :yp16, :yp17, :yp18, 
:yp19, :yp20, :yp21, :yp22, :yp23, :yp24, :yp25, :yp26, :yp27, :yp28, 
:yp29, :yp30, :yp31, :yp32, :yp33, :yp34, :yp35, :yp36, :yp37, :yp38, 
:yp39, :yp40, :yp41, :yp42, :yp43, :yp44, :yp45, :yp46, :yp47, :yp48, 
:yp49, :yp50, :yp51, :yp52, :yp53). Bound with :yp0='N', :yp1='N', 
:yp2='N', :yp3='vanilla', :yp4='N', :yp5='N', :yp6='N', :yp7='Y', 
:yp8=1, :yp9='N', :yp10='Y', :yp11='N', :yp12='N', :yp13='N', :yp14='N',
 :yp15='N', :yp16='N', :yp17='Y', :yp18='N', :yp19='N', :yp20='A', 
:yp21='N', :yp22=15, :yp23='Y', :yp24='B', :yp25='Y', :yp26='X', 
:yp27='N', :yp28='Y', :yp29='Y', :yp30=0, :yp31='N', :yp32='N', 
:yp33='Y', :yp34=0, :yp35=1, :yp36=0, :yp37='G', :yp38='fr', 
:yp39=741337, :yp40='les administrateurs', 
:yp41='l-sg-sep1b.galileo@finances.gouv.fr', :yp42='', :yp43='', 
:yp44='l-sg-sep1b.galileo@finances.gouv.fr', 
:yp45='{"attribute_1":{"description":"service","mandatory":"N","show_register":"N","cpdbmap":""}}',
 :yp46='', :yp47='', :yp48='0', :yp49='', :yp50=1, :yp51='2018-05-26 
16:14:41', :yp52=NULL, :yp53=NULL)</td>
		<td align="center">1</td>
		<td align="center">0.00052</td>
		<td align="center">0.00052</td>
		<td align="center">0.00052</td>
		<td align="center">0.00052</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT 1 FROM `limeliste_answers` `t` 
WHERE (language=:language AND qid=:qid AND scale_id=:scale_id) AND 
(LOWER(`t`.`code`)=LOWER(:ycp56)) LIMIT 1. Bound with :language='fr', 
:qid='5662', :scale_id='0', :ycp56='A7')</td>
		<td align="center">1</td>
		<td align="center">0.00052</td>
		<td align="center">0.00052</td>
		<td align="center">0.00052</td>
		<td align="center">0.00052</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SELECT 1 FROM `limeliste_answers` `t` 
WHERE (language=:language AND qid=:qid AND scale_id=:scale_id) AND 
(LOWER(`t`.`code`)=LOWER(:ycp59)) LIMIT 1. Bound with :language='fr', 
:qid='5662', :scale_id='0', :ycp59='A8')</td>
		<td align="center">1</td>
		<td align="center">0.00051</td>
		<td align="center">0.00051</td>
		<td align="center">0.00051</td>
		<td align="center">0.00051</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT 1 FROM `limeliste_answers` `t` 
WHERE (language=:language AND qid=:qid AND scale_id=:scale_id) AND 
(LOWER(`t`.`code`)=LOWER(:ycp16)) LIMIT 1. Bound with :language='fr', 
:qid='5662', :scale_id='0', :ycp16='A11')</td>
		<td align="center">1</td>
		<td align="center">0.00051</td>
		<td align="center">0.00051</td>
		<td align="center">0.00051</td>
		<td align="center">0.00051</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SELECT 1 FROM `limeliste_answers` `t` 
WHERE (language=:language AND qid=:qid AND scale_id=:scale_id) AND 
(LOWER(`t`.`code`)=LOWER(:ycp18)) LIMIT 1. Bound with :language='fr', 
:qid='5662', :scale_id='0', :ycp18='A12')</td>
		<td align="center">1</td>
		<td align="center">0.00051</td>
		<td align="center">0.00051</td>
		<td align="center">0.00051</td>
		<td align="center">0.00051</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT 1 FROM `limeliste_answers` `t` 
WHERE (language=:language AND qid=:qid AND scale_id=:scale_id) AND 
(LOWER(`t`.`code`)=LOWER(:ycp24)) LIMIT 1. Bound with :language='fr', 
:qid='5662', :scale_id='0', :ycp24='A15')</td>
		<td align="center">1</td>
		<td align="center">0.00051</td>
		<td align="center">0.00051</td>
		<td align="center">0.00051</td>
		<td align="center">0.00051</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SELECT 1 FROM `limeliste_answers` `t` 
WHERE (language=:language AND qid=:qid AND scale_id=:scale_id) AND 
(LOWER(`t`.`code`)=LOWER(:ycp61)) LIMIT 1. Bound with :language='fr', 
:qid='5662', :scale_id='0', :ycp61='A9')</td>
		<td align="center">1</td>
		<td align="center">0.00051</td>
		<td align="center">0.00051</td>
		<td align="center">0.00051</td>
		<td align="center">0.00051</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT 1 FROM `limeliste_answers` `t` 
WHERE (language=:language AND qid=:qid AND scale_id=:scale_id) AND 
(LOWER(`t`.`code`)=LOWER(:ycp30)) LIMIT 1. Bound with :language='fr', 
:qid='5662', :scale_id='0', :ycp30='A18')</td>
		<td align="center">1</td>
		<td align="center">0.00051</td>
		<td align="center">0.00051</td>
		<td align="center">0.00051</td>
		<td align="center">0.00051</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SELECT 1 FROM `limeliste_answers` `t` 
WHERE (language=:language AND qid=:qid AND scale_id=:scale_id) AND 
(LOWER(`t`.`code`)=LOWER(:ycp45)) LIMIT 1. Bound with :language='fr', 
:qid='5662', :scale_id='0', :ycp45='A24')</td>
		<td align="center">1</td>
		<td align="center">0.00051</td>
		<td align="center">0.00051</td>
		<td align="center">0.00051</td>
		<td align="center">0.00051</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT 1 FROM `limeliste_answers` `t` 
WHERE (language=:language AND qid=:qid AND scale_id=:scale_id) AND 
(LOWER(`t`.`code`)=LOWER(:ycp20)) LIMIT 1. Bound with :language='fr', 
:qid='5662', :scale_id='0', :ycp20='A13')</td>
		<td align="center">1</td>
		<td align="center">0.00051</td>
		<td align="center">0.00051</td>
		<td align="center">0.00051</td>
		<td align="center">0.00051</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SELECT 1 FROM `limeliste_answers` `t` 
WHERE (language=:language AND qid=:qid AND scale_id=:scale_id) AND 
(LOWER(`t`.`code`)=LOWER(:ycp22)) LIMIT 1. Bound with :language='fr', 
:qid='5662', :scale_id='0', :ycp22='A14')</td>
		<td align="center">1</td>
		<td align="center">0.00051</td>
		<td align="center">0.00051</td>
		<td align="center">0.00051</td>
		<td align="center">0.00051</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT 1 FROM `limeliste_answers` `t` 
WHERE (language=:language AND qid=:qid AND scale_id=:scale_id) AND 
(LOWER(`t`.`code`)=LOWER(:ycp47)) LIMIT 1. Bound with :language='fr', 
:qid='5662', :scale_id='0', :ycp47='A25')</td>
		<td align="center">1</td>
		<td align="center">0.00050</td>
		<td align="center">0.00050</td>
		<td align="center">0.00050</td>
		<td align="center">0.00050</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SELECT 1 FROM `limeliste_answers` `t` 
WHERE (language=:language AND qid=:qid AND scale_id=:scale_id) AND 
(LOWER(`t`.`code`)=LOWER(:ycp51)) LIMIT 1. Bound with :language='fr', 
:qid='5662', :scale_id='0', :ycp51='A4')</td>
		<td align="center">1</td>
		<td align="center">0.00050</td>
		<td align="center">0.00050</td>
		<td align="center">0.00050</td>
		<td align="center">0.00050</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT 1 FROM `limeliste_answers` `t` 
WHERE (language=:language AND qid=:qid AND scale_id=:scale_id) AND 
(LOWER(`t`.`code`)=LOWER(:ycp55)) LIMIT 1. Bound with :language='fr', 
:qid='5662', :scale_id='0', :ycp55='A6')</td>
		<td align="center">1</td>
		<td align="center">0.00050</td>
		<td align="center">0.00050</td>
		<td align="center">0.00050</td>
		<td align="center">0.00050</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SELECT 1 FROM `limeliste_answers` `t` 
WHERE (language=:language AND qid=:qid AND scale_id=:scale_id) AND 
(LOWER(`t`.`code`)=LOWER(:ycp12)) LIMIT 1. Bound with :language='fr', 
:qid='5662', :scale_id='0', :ycp12='A1')</td>
		<td align="center">1</td>
		<td align="center">0.00050</td>
		<td align="center">0.00050</td>
		<td align="center">0.00050</td>
		<td align="center">0.00050</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT 1 FROM `limeliste_answers` `t` 
WHERE (language=:language AND qid=:qid AND scale_id=:scale_id) AND 
(LOWER(`t`.`code`)=LOWER(:ycp53)) LIMIT 1. Bound with :language='fr', 
:qid='5662', :scale_id='0', :ycp53='A5')</td>
		<td align="center">1</td>
		<td align="center">0.00050</td>
		<td align="center">0.00050</td>
		<td align="center">0.00050</td>
		<td align="center">0.00050</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SELECT 1 FROM `limeliste_answers` `t` 
WHERE (language=:language AND qid=:qid AND scale_id=:scale_id) AND 
(LOWER(`t`.`code`)=LOWER(:ycp49)) LIMIT 1. Bound with :language='fr', 
:qid='5662', :scale_id='0', :ycp49='A3')</td>
		<td align="center">1</td>
		<td align="center">0.00050</td>
		<td align="center">0.00050</td>
		<td align="center">0.00050</td>
		<td align="center">0.00050</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT 1 FROM `limeliste_answers` `t` 
WHERE (language=:language AND qid=:qid AND scale_id=:scale_id) AND 
(LOWER(`t`.`code`)=LOWER(:ycp43)) LIMIT 1. Bound with :language='fr', 
:qid='5662', :scale_id='0', :ycp43='A23')</td>
		<td align="center">1</td>
		<td align="center">0.00050</td>
		<td align="center">0.00050</td>
		<td align="center">0.00050</td>
		<td align="center">0.00050</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SELECT 1 FROM `limeliste_answers` `t` 
WHERE (language=:language AND qid=:qid AND scale_id=:scale_id) AND 
(LOWER(`t`.`code`)=LOWER(:ycp33)) LIMIT 1. Bound with :language='fr', 
:qid='5662', :scale_id='0', :ycp33='A19')</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:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT 1 FROM `limeliste_answers` `t` 
WHERE (language=:language AND qid=:qid AND scale_id=:scale_id) AND 
(LOWER(`t`.`code`)=LOWER(:ycp41)) LIMIT 1. Bound with :language='fr', 
:qid='5662', :scale_id='0', :ycp41='A22')</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(SELECT 1 FROM `limeliste_answers` `t` 
WHERE (language=:language AND qid=:qid AND scale_id=:scale_id) AND 
(LOWER(`t`.`code`)=LOWER(:ycp21)) LIMIT 1. Bound with :language='fr', 
:qid='5662', :scale_id='0', :ycp21='A13')</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:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT 1 FROM `limeliste_answers` `t` 
WHERE (language=:language AND qid=:qid AND scale_id=:scale_id) AND 
(LOWER(`t`.`code`)=LOWER(:ycp35)) LIMIT 1. Bound with :language='fr', 
:qid='5662', :scale_id='0', :ycp35='A2')</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(SELECT 1 FROM `limeliste_answers` `t` 
WHERE (language=:language AND qid=:qid AND scale_id=:scale_id) AND 
(LOWER(`t`.`code`)=LOWER(:ycp23)) LIMIT 1. Bound with :language='fr', 
:qid='5662', :scale_id='0', :ycp23='A14')</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:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT 1 FROM `limeliste_answers` `t` 
WHERE (language=:language AND qid=:qid AND scale_id=:scale_id) AND 
(LOWER(`t`.`code`)=LOWER(:ycp29)) LIMIT 1. Bound with :language='fr', 
:qid='5662', :scale_id='0', :ycp29='A17')</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(SELECT 1 FROM `limeliste_answers` `t` 
WHERE (language=:language AND qid=:qid AND scale_id=:scale_id) AND 
(LOWER(`t`.`code`)=LOWER(:ycp37)) LIMIT 1. Bound with :language='fr', 
:qid='5662', :scale_id='0', :ycp37='A20')</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 1 FROM `limeliste_answers` `t` 
WHERE (language=:language AND qid=:qid AND scale_id=:scale_id) AND 
(LOWER(`t`.`code`)=LOWER(:ycp27)) LIMIT 1. Bound with :language='fr', 
:qid='5662', :scale_id='0', :ycp27='A16')</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:#FFFFFF">
		<td>system.db.CDbCommand.query(SELECT 1 FROM `limeliste_answers` `t` 
WHERE (language=:language AND qid=:qid AND scale_id=:scale_id) AND 
(LOWER(`t`.`code`)=LOWER(:ycp19)) LIMIT 1. Bound with :language='fr', 
:qid='5662', :scale_id='0', :ycp19='A12')</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 * FROM `limeliste_templates` `t` WHERE `t`.`name`='vanilla' LIMIT 1)</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:#FFFFFF">
		<td>system.db.CDbCommand.query(SELECT 1 FROM `limeliste_answers` `t` 
WHERE (language=:language AND qid=:qid AND scale_id=:scale_id) AND 
(LOWER(`t`.`code`)=LOWER(:ycp25)) LIMIT 1. Bound with :language='fr', 
:qid='5662', :scale_id='0', :ycp25='A15')</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 1 FROM `limeliste_answers` `t` 
WHERE (language=:language AND qid=:qid AND scale_id=:scale_id) AND 
(LOWER(`t`.`code`)=LOWER(:ycp39)) LIMIT 1. Bound with :language='fr', 
:qid='5662', :scale_id='0', :ycp39='A21')</td>
		<td align="center">1</td>
		<td align="center">0.00047</td>
		<td align="center">0.00047</td>
		<td align="center">0.00047</td>
		<td align="center">0.00047</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SELECT 1 FROM `limeliste_answers` `t` 
WHERE (language=:language AND qid=:qid AND scale_id=:scale_id) AND 
(LOWER(`t`.`code`)=LOWER(:ycp17)) LIMIT 1. Bound with :language='fr', 
:qid='5662', :scale_id='0', :ycp17='A11')</td>
		<td align="center">1</td>
		<td align="center">0.00046</td>
		<td align="center">0.00046</td>
		<td align="center">0.00046</td>
		<td align="center">0.00046</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT 1 FROM `limeliste_answers` `t` 
WHERE (language=:language AND qid=:qid AND scale_id=:scale_id) AND 
(LOWER(`t`.`code`)=LOWER(:ycp15)) LIMIT 1. Bound with :language='fr', 
:qid='5662', :scale_id='0', :ycp15='A10')</td>
		<td align="center">1</td>
		<td align="center">0.00046</td>
		<td align="center">0.00046</td>
		<td align="center">0.00046</td>
		<td align="center">0.00046</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SELECT * FROM `limeliste_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.00046</td>
		<td align="center">0.00046</td>
		<td align="center">0.00046</td>
		<td align="center">0.00046</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT 1 FROM `limeliste_answers` `t` 
WHERE (language=:language AND qid=:qid AND scale_id=:scale_id) AND 
(LOWER(`t`.`code`)=LOWER(:ycp13)) LIMIT 1. Bound with :language='fr', 
:qid='5662', :scale_id='0', :ycp13='A1')</td>
		<td align="center">1</td>
		<td align="center">0.00046</td>
		<td align="center">0.00046</td>
		<td align="center">0.00046</td>
		<td align="center">0.00046</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.execute(INSERT INTO `limeliste_groups` 
(`sid`, `group_name`, `group_order`, `randomization_group`, 
`description`, `language`, `grelevance`) VALUES (:yp0, :yp1, :yp2, :yp3,
 :yp4, :yp5, :yp6). Bound with :yp0=741337, :yp1='vos infos', :yp2=0, 
:yp3='', :yp4='', :yp5='fr', :yp6='')</td>
		<td align="center">1</td>
		<td align="center">0.00045</td>
		<td align="center">0.00045</td>
		<td align="center">0.00045</td>
		<td align="center">0.00045</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT 1 FROM `limeliste_questions` `t`
 WHERE (language=:language AND sid=:sid AND parent_qid=0) AND 
(`t`.`title`=:ycp9) LIMIT 1. Bound with :language='fr', :sid='741337', 
:ycp9='commentaires')</td>
		<td align="center">1</td>
		<td align="center">0.00045</td>
		<td align="center">0.00045</td>
		<td align="center">0.00045</td>
		<td align="center">0.00045</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SELECT 1 FROM `limeliste_questions` `t`
 WHERE (language=:language AND sid=:sid AND parent_qid=0) AND 
(`t`.`title`=:ycp6) LIMIT 1. Bound with :language='fr', :sid='741337', 
:ycp6='equation')</td>
		<td align="center">1</td>
		<td align="center">0.00045</td>
		<td align="center">0.00045</td>
		<td align="center">0.00045</td>
		<td align="center">0.00045</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT * FROM 
`limeliste_settings_global` `t` WHERE stg_name=:name LIMIT 1. Bound with
 :name='DBVersion')</td>
		<td align="center">1</td>
		<td align="center">0.00044</td>
		<td align="center">0.00044</td>
		<td align="center">0.00044</td>
		<td align="center">0.00044</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SELECT a.qid, a.sqid, a.scale_id, 
a.specialtype, a.defaultvalue FROM limeliste_defaultvalues as a, 
limeliste_questions as b WHERE a.qid = b.qid AND a.language = b.language
 AND a.language = 'fr' AND b.same_default=1 AND b.sid = 741337)</td>
		<td align="center">1</td>
		<td align="center">0.00044</td>
		<td align="center">0.00044</td>
		<td align="center">0.00044</td>
		<td align="center">0.00044</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT 1 FROM `limeliste_questions` `t`
 WHERE (language=:language AND sid=:sid AND parent_qid=0) AND 
(`t`.`title`=:ycp0) LIMIT 1. Bound with :language='fr', :sid='741337', 
:ycp0='Nom')</td>
		<td align="center">1</td>
		<td align="center">0.00044</td>
		<td align="center">0.00044</td>
		<td align="center">0.00044</td>
		<td align="center">0.00044</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SELECT 1 FROM `limeliste_questions` `t`
 WHERE (language=:language AND sid=:sid AND parent_qid=0) AND 
(`t`.`title`=:ycp11) LIMIT 1. Bound with :language='fr', :sid='741337', 
:ycp11='commentaires')</td>
		<td align="center">1</td>
		<td align="center">0.00044</td>
		<td align="center">0.00044</td>
		<td align="center">0.00044</td>
		<td align="center">0.00044</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT 1 FROM `limeliste_questions` `t`
 WHERE (language=:language AND sid=:sid AND parent_qid=0) AND 
(`t`.`title`=:ycp5) LIMIT 1. Bound with :language='fr', :sid='741337', 
:ycp5='service')</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 1 FROM `limeliste_questions` `t`
 WHERE (language=:language AND sid=:sid AND parent_qid=0) AND 
(`t`.`title`=:ycp10) LIMIT 1. Bound with :language='fr', :sid='741337', 
:ycp10='commentaires')</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:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT 1 FROM `limeliste_questions` `t`
 WHERE (language=:language AND sid=:sid AND parent_qid=0) AND 
(`t`.`title`=:ycp8) LIMIT 1. Bound with :language='fr', :sid='741337', 
:ycp8='equation')</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.execute(INSERT INTO `limeliste_questions` 
(`parent_qid`, `sid`, `gid`, `type`, `title`, `other`, `scale_id`, 
`same_default`, `question`, `preg`, `help`, `mandatory`, 
`question_order`, `language`, `relevance`, `modulename`) VALUES (:yp0, 
:yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7, :yp8, :yp9, :yp10, :yp11, 
:yp12, :yp13, :yp14, :yp15). Bound with :yp0=0, :yp1=741337, :yp2=272, 
:yp3='S', :yp4='Nom', :yp5='N', :yp6=0, :yp7=0, :yp8='Nom : 
{TOKEN:LASTNAME}', :yp9='', :yp10='', :yp11='N', :yp12=1, :yp13='fr', 
:yp14='1', :yp15='')</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:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT `quota`.`id` AS `t1_c0`, 
`quota`.`sid` AS `t1_c1`, `quota`.`name` AS `t1_c2`, `quota`.`qlimit` AS
 `t1_c3`, `quota`.`action` AS `t1_c4`, `quota`.`active` AS `t1_c5`, 
`quota`.`autoload_url` AS `t1_c6` FROM `limeliste_quota` `quota`  WHERE 
(`quota`.`id`=:ypl0). Bound with :ypl0='13')</td>
		<td align="center">1</td>
		<td align="center">0.00042</td>
		<td align="center">0.00042</td>
		<td align="center">0.00042</td>
		<td align="center">0.00042</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SELECT 1 FROM `limeliste_questions` `t`
 WHERE (language=:language AND sid=:sid AND parent_qid=0) AND 
(`t`.`title`=:ycp7) LIMIT 1. Bound with :language='fr', :sid='741337', 
:ycp7='equation')</td>
		<td align="center">1</td>
		<td align="center">0.00042</td>
		<td align="center">0.00042</td>
		<td align="center">0.00042</td>
		<td align="center">0.00042</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT 1 FROM `limeliste_questions` `t`
 WHERE (language=:language AND sid=:sid AND parent_qid=0) AND 
(`t`.`title`=:ycp4) LIMIT 1. Bound with :language='fr', :sid='741337', 
:ycp4='service')</td>
		<td align="center">1</td>
		<td align="center">0.00042</td>
		<td align="center">0.00042</td>
		<td align="center">0.00042</td>
		<td align="center">0.00042</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SELECT 1 FROM `limeliste_questions` `t`
 WHERE (language=:language AND sid=:sid AND parent_qid=0) AND 
(`t`.`title`=:ycp3) LIMIT 1. Bound with :language='fr', :sid='741337', 
:ycp3='service')</td>
		<td align="center">1</td>
		<td align="center">0.00042</td>
		<td align="center">0.00042</td>
		<td align="center">0.00042</td>
		<td align="center">0.00042</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT * FROM `limeliste_templates` `t` WHERE `t`.`name`='SDI_0_0_1_0_SEP_GALILEO' LIMIT 1)</td>
		<td align="center">1</td>
		<td align="center">0.00042</td>
		<td align="center">0.00042</td>
		<td align="center">0.00042</td>
		<td align="center">0.00042</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SELECT 1 FROM `limeliste_questions` `t`
 WHERE (language=:language AND sid=:sid AND parent_qid=0) AND 
(`t`.`title`=:ycp2) LIMIT 1. Bound with :language='fr', :sid='741337', 
:ycp2='Nom')</td>
		<td align="center">1</td>
		<td align="center">0.00041</td>
		<td align="center">0.00041</td>
		<td align="center">0.00041</td>
		<td align="center">0.00041</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SHOW CREATE TABLE `limeliste_surveys`)</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:#FFFFFF">
		<td>system.db.CDbCommand.query(SELECT 1 FROM `limeliste_questions` `t`
 WHERE (language=:language AND sid=:sid AND parent_qid=0) AND 
(`t`.`title`=:ycp1) LIMIT 1. Bound with :language='fr', :sid='741337', 
:ycp1='Nom')</td>
		<td align="center">1</td>
		<td align="center">0.00039</td>
		<td align="center">0.00039</td>
		<td align="center">0.00039</td>
		<td align="center">0.00039</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.execute(INSERT INTO `limeliste_questions` 
(`parent_qid`, `sid`, `gid`, `type`, `title`, `other`, `scale_id`, 
`same_default`, `question`, `preg`, `help`, `mandatory`, 
`question_order`, `language`, `relevance`, `modulename`) VALUES (:yp0, 
:yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7, :yp8, :yp9, :yp10, :yp11, 
:yp12, :yp13, :yp14, :yp15). Bound with :yp0=0, :yp1=741337, :yp2=272, 
:yp3='*', :yp4='equation', :yp5='N', :yp6=0, :yp7=0, 
:yp8='&lt;p&gt;{service=if(!is_empty(service.NAOK),service.NAOK,TOKEN:ATTRIBUTE_1)}&lt;/p&gt;

&lt;p&gt;&nbsp;&lt;/p&gt;
',
 :yp9='', :yp10='', :yp11='N', :yp12=0, :yp13='fr', :yp14='1', :yp15='')</td>
		<td align="center">1</td>
		<td align="center">0.00038</td>
		<td align="center">0.00038</td>
		<td align="center">0.00038</td>
		<td align="center">0.00038</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SELECT * FROM `limeliste_plugins` `t` WHERE `t`.`active`=:yp0. Bound with :yp0=1)</td>
		<td align="center">1</td>
		<td align="center">0.00038</td>
		<td align="center">0.00038</td>
		<td align="center">0.00038</td>
		<td align="center">0.00038</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT 1 FROM `limeliste_defaultvalues`
 `t` WHERE (specialtype=:specialtype and scale_id=:scale_id and 
sqid=:sqid and language=:language) AND (`t`.`qid`=:ycp62) LIMIT 1. Bound
 with :specialtype='', :scale_id='0', :sqid='0', :language='fr', 
:ycp62='5661')</td>
		<td align="center">1</td>
		<td align="center">0.00037</td>
		<td align="center">0.00037</td>
		<td align="center">0.00037</td>
		<td align="center">0.00037</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.execute(INSERT INTO 
`limeliste_question_attributes` (`qid`, `attribute`, `value`) VALUES 
(:yp0, :yp1, :yp2). Bound with :yp0=5662, :yp1='hidden', :yp2='1')</td>
		<td align="center">1</td>
		<td align="center">0.00037</td>
		<td align="center">0.00037</td>
		<td align="center">0.00037</td>
		<td align="center">0.00037</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.execute(INSERT INTO `limeliste_questions` 
(`parent_qid`, `sid`, `gid`, `type`, `title`, `other`, `scale_id`, 
`same_default`, `question`, `preg`, `help`, `mandatory`, 
`question_order`, `language`, `relevance`) VALUES (:yp0, :yp1, :yp2, 
:yp3, :yp4, :yp5, :yp6, :yp7, :yp8, :yp9, :yp10, :yp11, :yp12, :yp13, 
:yp14). Bound with :yp0=0, :yp1=741337, :yp2=273, :yp3='U', 
:yp4='commentaires', :yp5='N', :yp6=0, :yp7=0, :yp8='bonjour', :yp9='', 
:yp10='', :yp11='N', :yp12=1, :yp13='fr', :yp14='1')</td>
		<td align="center">1</td>
		<td align="center">0.00037</td>
		<td align="center">0.00037</td>
		<td align="center">0.00037</td>
		<td align="center">0.00037</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.execute(INSERT INTO `limeliste_questions` 
(`parent_qid`, `sid`, `gid`, `type`, `title`, `other`, `scale_id`, 
`same_default`, `question`, `preg`, `help`, `mandatory`, 
`question_order`, `language`, `relevance`, `modulename`) VALUES (:yp0, 
:yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7, :yp8, :yp9, :yp10, :yp11, 
:yp12, :yp13, :yp14, :yp15). Bound with :yp0=0, :yp1=741337, :yp2=272, 
:yp3='!', :yp4='service', :yp5='N', :yp6=0, :yp7=0, :yp8='service :', 
:yp9='', :yp10='', :yp11='N', :yp12=2, :yp13='fr', :yp14='1', :yp15='')</td>
		<td align="center">1</td>
		<td align="center">0.00037</td>
		<td align="center">0.00037</td>
		<td align="center">0.00037</td>
		<td align="center">0.00037</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.execute(INSERT INTO 
`limeliste_question_attributes` (`qid`, `attribute`, `value`) VALUES 
(:yp0, :yp1, :yp2). Bound with :yp0=5661, :yp1='hidden', :yp2='1')</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:#FFFFFF">
		<td>system.db.CDbCommand.execute(INSERT INTO `limeliste_answers` 
(`assessment_value`, `qid`, `code`, `answer`, `sortorder`, `language`, 
`scale_id`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6). Bound 
with :yp0=0, :yp1=5662, :yp2='A15', :yp3='DGFIP ANC', :yp4=15, 
:yp5='fr', :yp6=0)</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 1 FROM `limeliste_defaultvalues`
 `t` WHERE (specialtype=:specialtype and scale_id=:scale_id and 
sqid=:sqid and language=:language) AND (`t`.`qid`=:ycp63) LIMIT 1. Bound
 with :specialtype='', :scale_id='0', :sqid='0', :language='fr', 
:ycp63='5661')</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(INSERT INTO `limeliste_answers` 
(`assessment_value`, `qid`, `code`, `answer`, `sortorder`, `language`, 
`scale_id`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6). Bound 
with :yp0=0, :yp1=5662, :yp2='A1', :yp3='APE', :yp4=1, :yp5='fr', 
:yp6=0)</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(SHOW CREATE TABLE `limeliste_surveys_languagesettings`)</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>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.execute(INSERT INTO `limeliste_answers` 
(`assessment_value`, `qid`, `code`, `answer`, `sortorder`, `language`, 
`scale_id`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6). Bound 
with :yp0=0, :yp1=5662, :yp2='A9', :yp3='DG TRESOR', :yp4=9, :yp5='fr', 
:yp6=0)</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>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.execute(INSERT INTO `limeliste_answers` 
(`assessment_value`, `qid`, `code`, `answer`, `sortorder`, `language`, 
`scale_id`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6). Bound 
with :yp0=0, :yp1=5662, :yp2='A6', :yp3='CGEIET', :yp4=6, :yp5='fr', 
:yp6=0)</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>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.execute(INSERT INTO `limeliste_answers` 
(`assessment_value`, `qid`, `code`, `answer`, `sortorder`, `language`, 
`scale_id`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6). Bound 
with :yp0=0, :yp1=5662, :yp2='A18', :yp3='HFTN', :yp4=18, :yp5='fr', 
:yp6=0)</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>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.execute(INSERT INTO `limeliste_answers` 
(`assessment_value`, `qid`, `code`, `answer`, `sortorder`, `language`, 
`scale_id`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6). Bound 
with :yp0=0, :yp1=5662, :yp2='A8', :yp3='DB', :yp4=8, :yp5='fr', :yp6=0)</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>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.execute(INSERT INTO `limeliste_answers` 
(`assessment_value`, `qid`, `code`, `answer`, `sortorder`, `language`, 
`scale_id`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6). Bound 
with :yp0=0, :yp1=5662, :yp2='A4', :yp3='CBCM', :yp4=4, :yp5='fr', 
:yp6=0)</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>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.execute(INSERT INTO `limeliste_groups` 
(`sid`, `group_name`, `group_order`, `randomization_group`, 
`description`, `language`, `grelevance`) VALUES (:yp0, :yp1, :yp2, :yp3,
 :yp4, :yp5, :yp6). Bound with :yp0=741337, :yp1='g2', :yp2=1, :yp3='', 
:yp4='', :yp5='fr', :yp6='')</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>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.execute(INSERT INTO `limeliste_answers` 
(`assessment_value`, `qid`, `code`, `answer`, `sortorder`, `language`, 
`scale_id`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6). Bound 
with :yp0=0, :yp1=5662, :yp2='A3', :yp3='BC', :yp4=3, :yp5='fr', :yp6=0)</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>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.execute(INSERT INTO `limeliste_answers` 
(`assessment_value`, `qid`, `code`, `answer`, `sortorder`, `language`, 
`scale_id`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6). Bound 
with :yp0=0, :yp1=5662, :yp2='A5', :yp3='CGEFI', :yp4=5, :yp5='fr', 
:yp6=0)</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>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.execute(INSERT INTO `limeliste_answers` 
(`assessment_value`, `qid`, `code`, `answer`, `sortorder`, `language`, 
`scale_id`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6). Bound 
with :yp0=0, :yp1=5662, :yp2='A17', :yp3='DNLF', :yp4=17, :yp5='fr', 
:yp6=0)</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>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.execute(INSERT INTO `limeliste_answers` 
(`assessment_value`, `qid`, `code`, `answer`, `sortorder`, `language`, 
`scale_id`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6). Bound 
with :yp0=0, :yp1=5662, :yp2='A19', :yp3='INSEE', :yp4=19, :yp5='fr', 
:yp6=0)</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>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.execute(INSERT INTO `limeliste_answers` 
(`assessment_value`, `qid`, `code`, `answer`, `sortorder`, `language`, 
`scale_id`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6). Bound 
with :yp0=0, :yp1=5662, :yp2='A10', :yp3='DGAFP', :yp4=10, :yp5='fr', 
:yp6=0)</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>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.execute(INSERT INTO `limeliste_answers` 
(`assessment_value`, `qid`, `code`, `answer`, `sortorder`, `language`, 
`scale_id`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6). Bound 
with :yp0=0, :yp1=5662, :yp2='A14', :yp3='DGEFP', :yp4=14, :yp5='fr', 
:yp6=0)</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>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.execute(INSERT INTO `limeliste_answers` 
(`assessment_value`, `qid`, `code`, `answer`, `sortorder`, `language`, 
`scale_id`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6). Bound 
with :yp0=0, :yp1=5662, :yp2='A2', :yp3='APIE', :yp4=2, :yp5='fr', 
:yp6=0)</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>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.execute(INSERT INTO `limeliste_answers` 
(`assessment_value`, `qid`, `code`, `answer`, `sortorder`, `language`, 
`scale_id`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6). Bound 
with :yp0=0, :yp1=5662, :yp2='A7', :yp3='DAJ', :yp4=7, :yp5='fr', 
:yp6=0)</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>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.execute(INSERT INTO `limeliste_answers` 
(`assessment_value`, `qid`, `code`, `answer`, `sortorder`, `language`, 
`scale_id`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6). Bound 
with :yp0=0, :yp1=5662, :yp2='A16', :yp3='DGFIP', :yp4=16, :yp5='fr', 
:yp6=0)</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>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.execute(INSERT INTO `limeliste_answers` 
(`assessment_value`, `qid`, `code`, `answer`, `sortorder`, `language`, 
`scale_id`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6). Bound 
with :yp0=0, :yp1=5662, :yp2='A22', :yp3='ONP', :yp4=22, :yp5='fr', 
:yp6=0)</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>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.execute(INSERT INTO `limeliste_answers` 
(`assessment_value`, `qid`, `code`, `answer`, `sortorder`, `language`, 
`scale_id`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6). Bound 
with :yp0=0, :yp1=5662, :yp2='A20', :yp3='IGF', :yp4=20, :yp5='fr', 
:yp6=0)</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>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.execute(INSERT INTO `limeliste_answers` 
(`assessment_value`, `qid`, `code`, `answer`, `sortorder`, `language`, 
`scale_id`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6). Bound 
with :yp0=0, :yp1=5662, :yp2='A24', :yp3='SGAE', :yp4=24, :yp5='fr', 
:yp6=0)</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>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.execute(INSERT INTO `limeliste_answers` 
(`assessment_value`, `qid`, `code`, `answer`, `sortorder`, `language`, 
`scale_id`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6). Bound 
with :yp0=0, :yp1=5662, :yp2='A23', :yp3='SAE', :yp4=23, :yp5='fr', 
:yp6=0)</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>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.execute(INSERT INTO `limeliste_answers` 
(`assessment_value`, `qid`, `code`, `answer`, `sortorder`, `language`, 
`scale_id`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6). Bound 
with :yp0=0, :yp1=5662, :yp2='A25', :yp3='TRACFIN', :yp4=25, :yp5='fr', 
:yp6=0)</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>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.execute(INSERT INTO `limeliste_answers` 
(`assessment_value`, `qid`, `code`, `answer`, `sortorder`, `language`, 
`scale_id`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6). Bound 
with :yp0=0, :yp1=5662, :yp2='A11', :yp3='DGCCRF', :yp4=11, :yp5='fr', 
:yp6=0)</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>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.execute(INSERT INTO 
`limeliste_question_attributes` (`qid`, `attribute`, `value`) VALUES 
(:yp0, :yp1, :yp2). Bound with :yp0=5663, :yp1='hidden', :yp2='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>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.execute(INSERT INTO 
`limeliste_question_attributes` (`qid`, `attribute`, `value`) VALUES 
(:yp0, :yp1, :yp2). Bound with :yp0=5663, :yp1='equation', 
:yp2='{service=if(!is_empty(service.NAOK),service.NAOK,TOKEN:ATTRIBUTE_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>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.execute(INSERT INTO `limeliste_answers` 
(`assessment_value`, `qid`, `code`, `answer`, `sortorder`, `language`, 
`scale_id`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6). Bound 
with :yp0=0, :yp1=5662, :yp2='A12', :yp3='DGCIS', :yp4=12, :yp5='fr', 
:yp6=0)</td>
		<td align="center">1</td>
		<td align="center">0.00029</td>
		<td align="center">0.00029</td>
		<td align="center">0.00029</td>
		<td align="center">0.00029</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.execute(INSERT INTO `limeliste_quota` 
(`active`, `autoload_url`, `sid`, `name`, `qlimit`, `action`) VALUES 
(:yp0, :yp1, :yp2, :yp3, :yp4, :yp5). Bound with :yp0=1, :yp1=1, 
:yp2=741337, :yp3='A4', :yp4=0, :yp5=1)</td>
		<td align="center">1</td>
		<td align="center">0.00029</td>
		<td align="center">0.00029</td>
		<td align="center">0.00029</td>
		<td align="center">0.00029</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.execute(INSERT INTO `limeliste_answers` 
(`assessment_value`, `qid`, `code`, `answer`, `sortorder`, `language`, 
`scale_id`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6). Bound 
with :yp0=0, :yp1=5662, :yp2='A21', :yp3='MEDIASUP', :yp4=21, :yp5='fr',
 :yp6=0)</td>
		<td align="center">1</td>
		<td align="center">0.00029</td>
		<td align="center">0.00029</td>
		<td align="center">0.00029</td>
		<td align="center">0.00029</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.execute(INSERT INTO `limeliste_defaultvalues`
 (`qid`, `defaultvalue`, `specialtype`, `scale_id`, `sqid`, `language`) 
VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5). Bound with :yp0=5661, 
:yp1='{TOKEN:LASTNAME}', :yp2='', :yp3=0, :yp4=0, :yp5='fr')</td>
		<td align="center">1</td>
		<td align="center">0.00029</td>
		<td align="center">0.00029</td>
		<td align="center">0.00029</td>
		<td align="center">0.00029</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.execute(INSERT INTO `limeliste_answers` 
(`assessment_value`, `qid`, `code`, `answer`, `sortorder`, `language`, 
`scale_id`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6). Bound 
with :yp0=0, :yp1=5662, :yp2='A13', :yp3='DGDDI', :yp4=13, :yp5='fr', 
:yp6=0)</td>
		<td align="center">1</td>
		<td align="center">0.00029</td>
		<td align="center">0.00029</td>
		<td align="center">0.00029</td>
		<td align="center">0.00029</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.execute(INSERT INTO `limeliste_quota_members`
 (`sid`, `qid`, `quota_id`, `code`) VALUES (:yp0, :yp1, :yp2, :yp3). 
Bound with :yp0=741337, :yp1=5662, :yp2=13, :yp3='A12')</td>
		<td align="center">1</td>
		<td align="center">0.00029</td>
		<td align="center">0.00029</td>
		<td align="center">0.00029</td>
		<td align="center">0.00029</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SHOW CREATE TABLE `limeliste_settings_global`)</td>
		<td align="center">1</td>
		<td align="center">0.00026</td>
		<td align="center">0.00026</td>
		<td align="center">0.00026</td>
		<td align="center">0.00026</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SHOW CREATE TABLE `limeliste_templates`)</td>
		<td align="center">1</td>
		<td align="center">0.00026</td>
		<td align="center">0.00026</td>
		<td align="center">0.00026</td>
		<td align="center">0.00026</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SHOW CREATE TABLE `limeliste_questions`)</td>
		<td align="center">1</td>
		<td align="center">0.00023</td>
		<td align="center">0.00023</td>
		<td align="center">0.00023</td>
		<td align="center">0.00023</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SHOW CREATE TABLE `limeliste_quota`)</td>
		<td align="center">1</td>
		<td align="center">0.00023</td>
		<td align="center">0.00023</td>
		<td align="center">0.00023</td>
		<td align="center">0.00023</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SHOW CREATE TABLE `limeliste_permissions`)</td>
		<td align="center">1</td>
		<td align="center">0.00022</td>
		<td align="center">0.00022</td>
		<td align="center">0.00022</td>
		<td align="center">0.00022</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SHOW CREATE TABLE `limeliste_groups`)</td>
		<td align="center">1</td>
		<td align="center">0.00022</td>
		<td align="center">0.00022</td>
		<td align="center">0.00022</td>
		<td align="center">0.00022</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SHOW CREATE TABLE `limeliste_quota_languagesettings`)</td>
		<td align="center">1</td>
		<td align="center">0.00021</td>
		<td align="center">0.00021</td>
		<td align="center">0.00021</td>
		<td align="center">0.00021</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SHOW CREATE TABLE `limeliste_question_attributes`)</td>
		<td align="center">1</td>
		<td align="center">0.00021</td>
		<td align="center">0.00021</td>
		<td align="center">0.00021</td>
		<td align="center">0.00021</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SHOW CREATE TABLE `limeliste_answers`)</td>
		<td align="center">1</td>
		<td align="center">0.00021</td>
		<td align="center">0.00021</td>
		<td align="center">0.00021</td>
		<td align="center">0.00021</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SHOW CREATE TABLE `limeliste_defaultvalues`)</td>
		<td align="center">1</td>
		<td align="center">0.00021</td>
		<td align="center">0.00021</td>
		<td align="center">0.00021</td>
		<td align="center">0.00021</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SHOW CREATE TABLE `limeliste_quota_members`)</td>
		<td align="center">1</td>
		<td align="center">0.00020</td>
		<td align="center">0.00020</td>
		<td align="center">0.00020</td>
		<td align="center">0.00020</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SHOW CREATE TABLE `limeliste_plugins`)</td>
		<td align="center">1</td>
		<td align="center">0.00020</td>
		<td align="center">0.00020</td>
		<td align="center">0.00020</td>
		<td align="center">0.00020</td>
	</tr></tbody></table>
<!-- end of profiling summary --></body></html>
copy.html (70,806 bytes)   
Bug heat0
Complete LimeSurvey version number (& build)3.8.1 github
I will donate to the project if issue is resolvedNo
Browsernot relevant
Database type & versionmysql + pgsql
Server OS (if known)debian
Webserver software & version (if known)apache2
PHP VersionPHP5.6

Relationships

Relationship GraphDependency Graph
duplicate of 12227 closeddominikvitt "Error: Failed to insert data" and corrupted quotas when i've tried to import old (v2.5.xx) surveys 

Users monitoring this issue

There are no users monitoring this issue.

Activities

Issue History

Date Modified Username Field Change
2018-05-26 16:31 DenisChenu New Issue
2018-05-26 16:31 DenisChenu File Added: QUOTAS_V2.64_limesurvey_survey_741337.lss
2018-05-26 16:31 DenisChenu File Added: QUOTAS_V2.64_SANS_QUOTAS_limesurvey_survey_741337.lss
2018-05-26 16:31 DenisChenu File Added: copy.html
2018-05-28 15:31 DenisChenu Relationship added duplicate of 12227
2018-05-28 15:32 DenisChenu Assigned To => DenisChenu
2018-05-28 15:32 DenisChenu Status new => closed
2018-05-28 15:32 DenisChenu Resolution open => duplicate
2018-05-28 15:32 DenisChenu Fixed in Version => 3.8.x