17361: upgrade from 3.14.6 to version 5.0.3 fails for missing table (lack of maintenance page for public survey list)

This bug affects 1 person(s).

ID	Project	Category	View Status	Date Submitted	Last Update

17361	Bug reports	Database design	public	2021-06-09 14:39	2021-08-12 08:46

Reporter	yniquet	Assigned To	ollehar
Priority	normal	Severity	crash
Status	closed	Resolution	fixed
Product Version	5.x

Summary	17361: upgrade from 3.14.6 to version 5.0.3 fails for missing table (lack of maintenance page for public survey list)
Description	The database update from 3.14.6. to 5.0.3 fails because missing table SurveysGroupsettings CDbException La table « {{surveys_groupsettings}} » associée à la classe Active record « SurveysGroupsettings » est introuvable dans la base de données. /data/www/limesurvey2-lab/framework/db/ar/CActiveRecord.php(2390) 2378 2379 /* 2380 Constructor. 2381 @param CActiveRecord $model the model instance 2382 @throws CDbException if specified table for active record class cannot be found in the database 2383 */ 2384 public function __construct($model) 2385 { 2386 $this->_modelClassName=get_class($model); 2387 2388 $tableName=$model->tableName(); 2389 if(($table=$model->getDbConnection()->getSchema()->getTable($tableName))===null) 2390 throw new CDbException(Yii::t('yii','The table "{table}" for active record class "{class}" cannot be found in the database.', 2391 array('{class}'=>$this->_modelClassName,'{table}'=>$tableName))); 2392 2393 if(($modelPk=$model->primaryKey())!==null \|\| $table->primaryKey===null) 2394 { 2395 $table->primaryKey=$modelPk; 2396 if(is_string($table->primaryKey) && isset($table->columns[$table->primaryKey])) 2397 $table->columns[$table->primaryKey]->isPrimaryKey=true; 2398 elseif(is_array($table->primaryKey)) 2399 { 2400 foreach($table->primaryKey as $name) 2401 { 2402 if(isset($table->columns[$name]))
Steps To Reproduce	deploy the latest 5.x version and copied the config.php and folder upload . Login to start the database upgrade and it will fail.
Tags	No tags attached.
Attached Files	2021-06-09 08_32_18-CDbException.png (46,022 bytes) 2021-06-09 08_32_18-CDbException.png (46,022 bytes)

Bug heat	10
Complete LimeSurvey version number (& build)	LimeSurvey Community Edition Version 5.0.3
I will donate to the project if issue is resolved	No
Browser	chrome
Database type & version	maria db
Server OS (if known)	linux
Webserver software & version (if known)	apache 2.4.38
PHP Version	7.3.19

User List	ollehar

ollehar 2021-06-09 14:56 administrator ~64801	is it possible for you to give us the database dump of your LS3 installation? You can attach it as private. Then we can test the upgrade procedure. Thank you.

ollehar 2021-06-09 15:11 administrator ~64803	Great, we'll have a look.

ollehar 2021-06-09 16:14 administrator ~64804	Commit hash for LS 3.14.6: bfa334cfeae0719a429e5350299c7f9d836bed56

ollehar 2021-06-09 16:23 administrator ~64806	Sorry, I need you to upload another database dump, which includes the table creation. It's hard for me to match the exact tables you expect, because of how the installation populates the tables. Lots of conflicts.

yniquet 2021-06-09 16:29 reporter ~64807	you need the database before the upgrade ?

ollehar 2021-06-09 16:31 administrator ~64808	I need the database from before the update, when you were running LS 3.14.6, and I need it to include "CREATE TABLE" statements, not only "INSERT" statements.

ollehar 2021-06-09 16:52 administrator ~64810	This actually worked for me. Using PHP 7.3 mysql Ver 15.1 Distrib 10.1.48-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2 debug = 2, but shouldn't matter. Selection_999(413).png (41,786 bytes) Selection_999(413).png (41,786 bytes) Selection_999(414).png (14,469 bytes) Selection_999(414).png (14,469 bytes)

ollehar 2021-06-09 16:53 administrator ~64811	It could be related to a caching issue in the active record classes.

ollehar 2021-06-09 16:55 administrator ~64812	Do you still have access to the error message? Can you upload the HTML file so I can see the trace?

ollehar 2021-06-09 17:00 administrator ~64813	Tried with debug = 0 and clearing cache before switching to LS5, but still worked.

ollehar 2021-06-09 17:02 administrator ~64815	Can you reload that error with debug = 2, please? Paste the complete trace.

yniquet 2021-06-09 17:08 reporter ~64816	500 : Erreur interne au serveur La table « {{surveys_groupsettings}} » associée à la classe Active record « SurveysGroupsettings » est introuvable dans la base de données. Une erreur interne est survenue quand le serveur Web traitait votre requête. Veuillez contacter Administrateur LimeSurvey pour rapporter ce problème. Sommaire du rapport de profilage (Durée: 0.07427s, Memoire: 8,411KB) Fonction Nb Total (s) Moy. (s) Min. (s) Max. (s) system.db.CDbCommand.query(SELECT `t`.`sid` AS `t0_c0`, `t`.`owner_id` AS `t0_c1`, `t`.`gsid` AS `t0_c2`, `t`.`admin` AS `t0_c3`, `t`.`active` AS `t0_c4`, `t`.`expires` AS `t0_c5`, `t`.`startdate` AS `t0_c6`, `t`.`adminemail` AS `t0_c7`, `t`.`anonymized` AS `t0_c8`, `t`.`faxto` AS `t0_c9`, `t`.`format` AS `t0_c10`, `t`.`savetimings` AS `t0_c11`, `t`.`template` AS `t0_c12`, `t`.`language` AS `t0_c13`, `t`.`additional_languages` AS `t0_c14`, `t`.`datestamp` AS `t0_c15`, `t`.`usecookie` AS `t0_c16`, `t`.`allowregister` AS `t0_c17`, `t`.`allowsave` AS `t0_c18`, `t`.`autonumber_start` AS `t0_c19`, `t`.`autoredirect` AS `t0_c20`, `t`.`allowprev` AS `t0_c21`, `t`.`printanswers` AS `t0_c22`, `t`.`ipaddr` AS `t0_c23`, `t`.`refurl` AS `t0_c24`, `t`.`datecreated` AS `t0_c25`, `t`.`showsurveypolicynotice` AS `t0_c26`, `t`.`publicstatistics` AS `t0_c27`, `t`.`publicgraphs` AS `t0_c28`, `t`.`listpublic` AS `t0_c29`, `t`.`htmlemail` AS `t0_c30`, `t`.`sendconfirmation` AS `t0_c31`, `t`.`tokenanswerspersistence` AS `t0_c32`, `t`.`assessments` AS `t0_c33`, `t`.`usecaptcha` AS `t0_c34`, `t`.`usetokens` AS `t0_c35`, `t`.`bounce_email` AS `t0_c36`, `t`.`attributedescriptions` AS `t0_c37`, `t`.`emailresponseto` AS `t0_c38`, `t`.`emailnotificationto` AS `t0_c39`, `t`.`tokenlength` AS `t0_c40`, `t`.`showxquestions` AS `t0_c41`, `t`.`showgroupinfo` AS `t0_c42`, `t`.`shownoanswer` AS `t0_c43`, `t`.`showqnumcode` AS `t0_c44`, `t`.`bouncetime` AS `t0_c45`, `t`.`bounceprocessing` AS `t0_c46`, `t`.`bounceaccounttype` AS `t0_c47`, `t`.`bounceaccounthost` AS `t0_c48`, `t`.`bounceaccountpass` AS `t0_c49`, `t`.`bounceaccountencryption` AS `t0_c50`, `t`.`bounceaccountuser` AS `t0_c51`, `t`.`showwelcome` AS `t0_c52`, `t`.`showprogress` AS `t0_c53`, `t`.`questionindex` AS `t0_c54`, `t`.`navigationdelay` AS `t0_c55`, `t`.`nokeyboard` AS `t0_c56`, `t`.`alloweditaftercompletion` AS `t0_c57`, `t`.`googleanalyticsstyle` AS `t0_c58`, `t`.`googleanalyticsapikey` AS `t0_c59`, `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_policy_notice` AS `t1_c6`, `languagesettings`.`surveyls_policy_error` AS `t1_c7`, `languagesettings`.`surveyls_policy_notice_label` AS `t1_c8`, `languagesettings`.`surveyls_url` AS `t1_c9`, `languagesettings`.`surveyls_urldescription` AS `t1_c10`, `languagesettings`.`surveyls_email_invite_subj` AS `t1_c11`, `languagesettings`.`surveyls_email_invite` AS `t1_c12`, `languagesettings`.`surveyls_email_remind_subj` AS `t1_c13`, `languagesettings`.`surveyls_email_remind` AS `t1_c14`, `languagesettings`.`surveyls_email_register_subj` AS `t1_c15`, `languagesettings`.`surveyls_email_register` AS `t1_c16`, `languagesettings`.`surveyls_email_confirm_subj` AS `t1_c17`, `languagesettings`.`surveyls_email_confirm` AS `t1_c18`, `languagesettings`.`surveyls_dateformat` AS `t1_c19`, `languagesettings`.`surveyls_attributecaptions` AS `t1_c20`, `languagesettings`.`email_admin_notification_subj` AS `t1_c21`, `languagesettings`.`email_admin_notification` AS `t1_c22`, `languagesettings`.`email_admin_responses_subj` AS `t1_c23`, `languagesettings`.`email_admin_responses` AS `t1_c24`, `languagesettings`.`surveyls_numberformat` AS `t1_c25`, `languagesettings`.`attachments` AS `t1_c26` FROM `surveys` `t` LEFT OUTER JOIN `surveys_languagesettings` `languagesettings` ON (`languagesettings`.`surveyls_survey_id`=`t`.`sid`) WHERE (((active = 'Y') AND ((startdate <= :now1 OR startdate IS NULL) AND (expires >= :now2 OR expires IS NULL))) AND (listpublic = 'Y' or listpublic = 'I')). Bound with :now1='2021-06-09 11:05:28', :now2='2021-06-09 11:05:28') 1 0.01035 0.01035 0.01035 0.01035 system.db.CDbCommand.query(SELECT FROM `template_configuration` `t` WHERE template_name=:template_name AND sid IS NULL AND gsid IS NULL ORDER BY `t`.`template_name` LIMIT 1. Bound with :template_name='fruity') 1 0.00329 0.00329 0.00329 0.00329 system.db.CDbCommand.query(SELECT FROM `settings_global` `t`) 1 0.00323 0.00323 0.00323 0.00323 system.db.CDbCommand.query(SELECT FROM `templates` `t` WHERE `t`.`name`='fruity' LIMIT 1) 3 0.00262 0.00087 0.00019 0.00224 system.db.CDbCommand.query(SELECT FROM `plugins` `t` WHERE `t`.`active`=:yp0. Bound with :yp0=1) 1 0.00251 0.00251 0.00251 0.00251 system.db.CDbCommand.query(SELECT `t`.`id`, `t`.`template_name`, `t`.`sid`, `t`.`gsid`, `t`.`uid`, `t`.`files_css`, `t`.`files_js`, `t`.`files_print_css`, `t`.`options`, `t`.`cssframework_name`, `t`.`cssframework_css`, `t`.`cssframework_js`, `t`.`packages_to_load`, `t`.`packages_ltr`, `t`.`packages_rtl` FROM `template_configuration` `t` INNER JOIN templates AS template ON `t`.`template_name` = template.name WHERE ((t.sid IS NULL) AND (t.gsid IS NULL)) AND (template.name IS NOT NULL) ORDER BY `t`.`template_name`) 2 0.00191 0.00096 0.00080 0.00111 system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `surveys_groupsettings`) 1 0.00100 0.00100 0.00100 0.00100 system.db.CDbCommand.query(SELECT `template`.`id` AS `t1_c0`, `template`.`name` AS `t1_c1`, `template`.`folder` AS `t1_c2`, `template`.`title` AS `t1_c3`, `template`.`creation_date` AS `t1_c4`, `template`.`author` AS `t1_c5`, `template`.`author_email` AS `t1_c6`, `template`.`author_url` AS `t1_c7`, `template`.`copyright` AS `t1_c8`, `template`.`license` AS `t1_c9`, `template`.`version` AS `t1_c10`, `template`.`api_version` AS `t1_c11`, `template`.`view_folder` AS `t1_c12`, `template`.`files_folder` AS `t1_c13`, `template`.`description` AS `t1_c14`, `template`.`last_update` AS `t1_c15`, `template`.`owner_id` AS `t1_c16`, `template`.`extends` AS `t1_c17` FROM `templates` `template` WHERE (`template`.`name`=:ypl0). Bound with :ypl0='template_teq_v3') 2 0.00087 0.00044 0.00024 0.00063 system.db.CDbCommand.query(SELECT `template`.`id` AS `t1_c0`, `template`.`name` AS `t1_c1`, `template`.`folder` AS `t1_c2`, `template`.`title` AS `t1_c3`, `template`.`creation_date` AS `t1_c4`, `template`.`author` AS `t1_c5`, `template`.`author_email` AS `t1_c6`, `template`.`author_url` AS `t1_c7`, `template`.`copyright` AS `t1_c8`, `template`.`license` AS `t1_c9`, `template`.`version` AS `t1_c10`, `template`.`api_version` AS `t1_c11`, `template`.`view_folder` AS `t1_c12`, `template`.`files_folder` AS `t1_c13`, `template`.`description` AS `t1_c14`, `template`.`last_update` AS `t1_c15`, `template`.`owner_id` AS `t1_c16`, `template`.`extends` AS `t1_c17` FROM `templates` `template` WHERE (`template`.`name`=:ypl0). Bound with :ypl0='vanilla') 3 0.00068 0.00023 0.00021 0.00025 system.db.CDbCommand.query(SELECT `template`.`id` AS `t1_c0`, `template`.`name` AS `t1_c1`, `template`.`folder` AS `t1_c2`, `template`.`title` AS `t1_c3`, `template`.`creation_date` AS `t1_c4`, `template`.`author` AS `t1_c5`, `template`.`author_email` AS `t1_c6`, `template`.`author_url` AS `t1_c7`, `template`.`copyright` AS `t1_c8`, `template`.`license` AS `t1_c9`, `template`.`version` AS `t1_c10`, `template`.`api_version` AS `t1_c11`, `template`.`view_folder` AS `t1_c12`, `template`.`files_folder` AS `t1_c13`, `template`.`description` AS `t1_c14`, `template`.`last_update` AS `t1_c15`, `template`.`owner_id` AS `t1_c16`, `template`.`extends` AS `t1_c17` FROM `templates` `template` WHERE (`template`.`name`=:ypl0). Bound with :ypl0='fruity') 3 0.00065 0.00022 0.00021 0.00023 system.db.CDbCommand.query(SELECT `template`.`id` AS `t1_c0`, `template`.`name` AS `t1_c1`, `template`.`folder` AS `t1_c2`, `template`.`title` AS `t1_c3`, `template`.`creation_date` AS `t1_c4`, `template`.`author` AS `t1_c5`, `template`.`author_email` AS `t1_c6`, `template`.`author_url` AS `t1_c7`, `template`.`copyright` AS `t1_c8`, `template`.`license` AS `t1_c9`, `template`.`version` AS `t1_c10`, `template`.`api_version` AS `t1_c11`, `template`.`view_folder` AS `t1_c12`, `template`.`files_folder` AS `t1_c13`, `template`.`description` AS `t1_c14`, `template`.`last_update` AS `t1_c15`, `template`.`owner_id` AS `t1_c16`, `template`.`extends` AS `t1_c17` FROM `templates` `template` WHERE (`template`.`name`=:ypl0). Bound with :ypl0='extends_template_intranet_confidentiel_v3') 2 0.00058 0.00029 0.00022 0.00036 system.db.CDbCommand.query(SELECT `template`.`id` AS `t1_c0`, `template`.`name` AS `t1_c1`, `template`.`folder` AS `t1_c2`, `template`.`title` AS `t1_c3`, `template`.`creation_date` AS `t1_c4`, `template`.`author` AS `t1_c5`, `template`.`author_email` AS `t1_c6`, `template`.`author_url` AS `t1_c7`, `template`.`copyright` AS `t1_c8`, `template`.`license` AS `t1_c9`, `template`.`version` AS `t1_c10`, `template`.`api_version` AS `t1_c11`, `template`.`view_folder` AS `t1_c12`, `template`.`files_folder` AS `t1_c13`, `template`.`description` AS `t1_c14`, `template`.`last_update` AS `t1_c15`, `template`.`owner_id` AS `t1_c16`, `template`.`extends` AS `t1_c17` FROM `templates` `template` WHERE (`template`.`name`=:ypl0). Bound with :ypl0='template_mern_piv') 2 0.00050 0.00025 0.00020 0.00030 system.db.CDbCommand.query(SELECT `template`.`id` AS `t1_c0`, `template`.`name` AS `t1_c1`, `template`.`folder` AS `t1_c2`, `template`.`title` AS `t1_c3`, `template`.`creation_date` AS `t1_c4`, `template`.`author` AS `t1_c5`, `template`.`author_email` AS `t1_c6`, `template`.`author_url` AS `t1_c7`, `template`.`copyright` AS `t1_c8`, `template`.`license` AS `t1_c9`, `template`.`version` AS `t1_c10`, `template`.`api_version` AS `t1_c11`, `template`.`view_folder` AS `t1_c12`, `template`.`files_folder` AS `t1_c13`, `template`.`description` AS `t1_c14`, `template`.`last_update` AS `t1_c15`, `template`.`owner_id` AS `t1_c16`, `template`.`extends` AS `t1_c17` FROM `templates` `template` WHERE (`template`.`name`=:ypl0). Bound with :ypl0='template_intranet_confidentiel_v4') 2 0.00050 0.00025 0.00023 0.00027 system.db.CDbCommand.query(SELECT `template`.`id` AS `t1_c0`, `template`.`name` AS `t1_c1`, `template`.`folder` AS `t1_c2`, `template`.`title` AS `t1_c3`, `template`.`creation_date` AS `t1_c4`, `template`.`author` AS `t1_c5`, `template`.`author_email` AS `t1_c6`, `template`.`author_url` AS `t1_c7`, `template`.`copyright` AS `t1_c8`, `template`.`license` AS `t1_c9`, `template`.`version` AS `t1_c10`, `template`.`api_version` AS `t1_c11`, `template`.`view_folder` AS `t1_c12`, `template`.`files_folder` AS `t1_c13`, `template`.`description` AS `t1_c14`, `template`.`last_update` AS `t1_c15`, `template`.`owner_id` AS `t1_c16`, `template`.`extends` AS `t1_c17` FROM `templates` `template` WHERE (`template`.`name`=:ypl0). Bound with :ypl0='template_mern_interministeriel') 2 0.00049 0.00025 0.00024 0.00026 system.db.CDbCommand.query(SELECT `template`.`id` AS `t1_c0`, `template`.`name` AS `t1_c1`, `template`.`folder` AS `t1_c2`, `template`.`title` AS `t1_c3`, `template`.`creation_date` AS `t1_c4`, `template`.`author` AS `t1_c5`, `template`.`author_email` AS `t1_c6`, `template`.`author_url` AS `t1_c7`, `template`.`copyright` AS `t1_c8`, `template`.`license` AS `t1_c9`, `template`.`version` AS `t1_c10`, `template`.`api_version` AS `t1_c11`, `template`.`view_folder` AS `t1_c12`, `template`.`files_folder` AS `t1_c13`, `template`.`description` AS `t1_c14`, `template`.`last_update` AS `t1_c15`, `template`.`owner_id` AS `t1_c16`, `template`.`extends` AS `t1_c17` FROM `templates` `template` WHERE (`template`.`name`=:ypl0). Bound with :ypl0='bootswatch') 2 0.00049 0.00025 0.00024 0.00025 system.db.CDbCommand.query(SELECT `template`.`id` AS `t1_c0`, `template`.`name` AS `t1_c1`, `template`.`folder` AS `t1_c2`, `template`.`title` AS `t1_c3`, `template`.`creation_date` AS `t1_c4`, `template`.`author` AS `t1_c5`, `template`.`author_email` AS `t1_c6`, `template`.`author_url` AS `t1_c7`, `template`.`copyright` AS `t1_c8`, `template`.`license` AS `t1_c9`, `template`.`version` AS `t1_c10`, `template`.`api_version` AS `t1_c11`, `template`.`view_folder` AS `t1_c12`, `template`.`files_folder` AS `t1_c13`, `template`.`description` AS `t1_c14`, `template`.`last_update` AS `t1_c15`, `template`.`owner_id` AS `t1_c16`, `template`.`extends` AS `t1_c17` FROM `templates` `template` WHERE (`template`.`name`=:ypl0). Bound with :ypl0='template_profil_gouvernementale') 2 0.00049 0.00024 0.00023 0.00026 system.db.CDbCommand.query(SELECT `template`.`id` AS `t1_c0`, `template`.`name` AS `t1_c1`, `template`.`folder` AS `t1_c2`, `template`.`title` AS `t1_c3`, `template`.`creation_date` AS `t1_c4`, `template`.`author` AS `t1_c5`, `template`.`author_email` AS `t1_c6`, `template`.`author_url` AS `t1_c7`, `template`.`copyright` AS `t1_c8`, `template`.`license` AS `t1_c9`, `template`.`version` AS `t1_c10`, `template`.`api_version` AS `t1_c11`, `template`.`view_folder` AS `t1_c12`, `template`.`files_folder` AS `t1_c13`, `template`.`description` AS `t1_c14`, `template`.`last_update` AS `t1_c15`, `template`.`owner_id` AS `t1_c16`, `template`.`extends` AS `t1_c17` FROM `templates` `template` WHERE (`template`.`name`=:ypl0). Bound with :ypl0='template_teq') 2 0.00046 0.00023 0.00022 0.00025 system.db.CDbCommand.query(SELECT `template`.`id` AS `t1_c0`, `template`.`name` AS `t1_c1`, `template`.`folder` AS `t1_c2`, `template`.`title` AS `t1_c3`, `template`.`creation_date` AS `t1_c4`, `template`.`author` AS `t1_c5`, `template`.`author_email` AS `t1_c6`, `template`.`author_url` AS `t1_c7`, `template`.`copyright` AS `t1_c8`, `template`.`license` AS `t1_c9`, `template`.`version` AS `t1_c10`, `template`.`api_version` AS `t1_c11`, `template`.`view_folder` AS `t1_c12`, `template`.`files_folder` AS `t1_c13`, `template`.`description` AS `t1_c14`, `template`.`last_update` AS `t1_c15`, `template`.`owner_id` AS `t1_c16`, `template`.`extends` AS `t1_c17` FROM `templates` `template` WHERE (`template`.`name`=:ypl0). Bound with :ypl0='template_teq_piv') 2 0.00046 0.00023 0.00022 0.00025 system.db.CDbCommand.query(SELECT `template`.`id` AS `t1_c0`, `template`.`name` AS `t1_c1`, `template`.`folder` AS `t1_c2`, `template`.`title` AS `t1_c3`, `template`.`creation_date` AS `t1_c4`, `template`.`author` AS `t1_c5`, `template`.`author_email` AS `t1_c6`, `template`.`author_url` AS `t1_c7`, `template`.`copyright` AS `t1_c8`, `template`.`license` AS `t1_c9`, `template`.`version` AS `t1_c10`, `template`.`api_version` AS `t1_c11`, `template`.`view_folder` AS `t1_c12`, `template`.`files_folder` AS `t1_c13`, `template`.`description` AS `t1_c14`, `template`.`last_update` AS `t1_c15`, `template`.`owner_id` AS `t1_c16`, `template`.`extends` AS `t1_c17` FROM `templates` `template` WHERE (`template`.`name`=:ypl0). Bound with :ypl0='template_intranet_confidentiel_v2') 2 0.00046 0.00023 0.00022 0.00024 system.db.CDbCommand.query(SELECT * FROM `template_configuration` `t` WHERE template_name=:template_name AND sid IS NULL AND gsid IS NULL ORDER BY `t`.`template_name` LIMIT 1. Bound with :template_name='vanilla') 1 0.00045 0.00045 0.00045 0.00045 system.db.CDbCommand.query(SELECT `template`.`id` AS `t1_c0`, `template`.`name` AS `t1_c1`, `template`.`folder` AS `t1_c2`, `template`.`title` AS `t1_c3`, `template`.`creation_date` AS `t1_c4`, `template`.`author` AS `t1_c5`, `template`.`author_email` AS `t1_c6`, `template`.`author_url` AS `t1_c7`, `template`.`copyright` AS `t1_c8`, `template`.`license` AS `t1_c9`, `template`.`version` AS `t1_c10`, `template`.`api_version` AS `t1_c11`, `template`.`view_folder` AS `t1_c12`, `template`.`files_folder` AS `t1_c13`, `template`.`description` AS `t1_c14`, `template`.`last_update` AS `t1_c15`, `template`.`owner_id` AS `t1_c16`, `template`.`extends` AS `t1_c17` FROM `templates` `template` WHERE (`template`.`name`=:ypl0). Bound with :ypl0='template_intranet_piv') 2 0.00045 0.00022 0.00022 0.00023 system.db.CDbCommand.query(SELECT `template`.`id` AS `t1_c0`, `template`.`name` AS `t1_c1`, `template`.`folder` AS `t1_c2`, `template`.`title` AS `t1_c3`, `template`.`creation_date` AS `t1_c4`, `template`.`author` AS `t1_c5`, `template`.`author_email` AS `t1_c6`, `template`.`author_url` AS `t1_c7`, `template`.`copyright` AS `t1_c8`, `template`.`license` AS `t1_c9`, `template`.`version` AS `t1_c10`, `template`.`api_version` AS `t1_c11`, `template`.`view_folder` AS `t1_c12`, `template`.`files_folder` AS `t1_c13`, `template`.`description` AS `t1_c14`, `template`.`last_update` AS `t1_c15`, `template`.`owner_id` AS `t1_c16`, `template`.`extends` AS `t1_c17` FROM `templates` `template` WHERE (`template`.`name`=:ypl0). Bound with :ypl0='template_intranet') 2 0.00045 0.00022 0.00020 0.00025 system.db.CDbCommand.query(SELECT `template`.`id` AS `t1_c0`, `template`.`name` AS `t1_c1`, `template`.`folder` AS `t1_c2`, `template`.`title` AS `t1_c3`, `template`.`creation_date` AS `t1_c4`, `template`.`author` AS `t1_c5`, `template`.`author_email` AS `t1_c6`, `template`.`author_url` AS `t1_c7`, `template`.`copyright` AS `t1_c8`, `template`.`license` AS `t1_c9`, `template`.`version` AS `t1_c10`, `template`.`api_version` AS `t1_c11`, `template`.`view_folder` AS `t1_c12`, `template`.`files_folder` AS `t1_c13`, `template`.`description` AS `t1_c14`, `template`.`last_update` AS `t1_c15`, `template`.`owner_id` AS `t1_c16`, `template`.`extends` AS `t1_c17` FROM `templates` `template` WHERE (`template`.`name`=:ypl0). Bound with :ypl0='template_mern_v2') 2 0.00045 0.00022 0.00021 0.00024 system.db.CDbCommand.query(SELECT `template`.`id` AS `t1_c0`, `template`.`name` AS `t1_c1`, `template`.`folder` AS `t1_c2`, `template`.`title` AS `t1_c3`, `template`.`creation_date` AS `t1_c4`, `template`.`author` AS `t1_c5`, `template`.`author_email` AS `t1_c6`, `template`.`author_url` AS `t1_c7`, `template`.`copyright` AS `t1_c8`, `template`.`license` AS `t1_c9`, `template`.`version` AS `t1_c10`, `template`.`api_version` AS `t1_c11`, `template`.`view_folder` AS `t1_c12`, `template`.`files_folder` AS `t1_c13`, `template`.`description` AS `t1_c14`, `template`.`last_update` AS `t1_c15`, `template`.`owner_id` AS `t1_c16`, `template`.`extends` AS `t1_c17` FROM `templates` `template` WHERE (`template`.`name`=:ypl0). Bound with :ypl0='template_mffp') 2 0.00045 0.00022 0.00022 0.00023 system.db.CDbCommand.query(SELECT `template`.`id` AS `t1_c0`, `template`.`name` AS `t1_c1`, `template`.`folder` AS `t1_c2`, `template`.`title` AS `t1_c3`, `template`.`creation_date` AS `t1_c4`, `template`.`author` AS `t1_c5`, `template`.`author_email` AS `t1_c6`, `template`.`author_url` AS `t1_c7`, `template`.`copyright` AS `t1_c8`, `template`.`license` AS `t1_c9`, `template`.`version` AS `t1_c10`, `template`.`api_version` AS `t1_c11`, `template`.`view_folder` AS `t1_c12`, `template`.`files_folder` AS `t1_c13`, `template`.`description` AS `t1_c14`, `template`.`last_update` AS `t1_c15`, `template`.`owner_id` AS `t1_c16`, `template`.`extends` AS `t1_c17` FROM `templates` `template` WHERE (`template`.`name`=:ypl0). Bound with :ypl0='template_JSDENEUVILLE') 2 0.00044 0.00022 0.00021 0.00023 system.db.CDbCommand.query(SELECT `template`.`id` AS `t1_c0`, `template`.`name` AS `t1_c1`, `template`.`folder` AS `t1_c2`, `template`.`title` AS `t1_c3`, `template`.`creation_date` AS `t1_c4`, `template`.`author` AS `t1_c5`, `template`.`author_email` AS `t1_c6`, `template`.`author_url` AS `t1_c7`, `template`.`copyright` AS `t1_c8`, `template`.`license` AS `t1_c9`, `template`.`version` AS `t1_c10`, `template`.`api_version` AS `t1_c11`, `template`.`view_folder` AS `t1_c12`, `template`.`files_folder` AS `t1_c13`, `template`.`description` AS `t1_c14`, `template`.`last_update` AS `t1_c15`, `template`.`owner_id` AS `t1_c16`, `template`.`extends` AS `t1_c17` FROM `templates` `template` WHERE (`template`.`name`=:ypl0). Bound with :ypl0='template_mern_v3') 2 0.00044 0.00022 0.00022 0.00022 system.db.CDbCommand.query(SELECT `template`.`id` AS `t1_c0`, `template`.`name` AS `t1_c1`, `template`.`folder` AS `t1_c2`, `template`.`title` AS `t1_c3`, `template`.`creation_date` AS `t1_c4`, `template`.`author` AS `t1_c5`, `template`.`author_email` AS `t1_c6`, `template`.`author_url` AS `t1_c7`, `template`.`copyright` AS `t1_c8`, `template`.`license` AS `t1_c9`, `template`.`version` AS `t1_c10`, `template`.`api_version` AS `t1_c11`, `template`.`view_folder` AS `t1_c12`, `template`.`files_folder` AS `t1_c13`, `template`.`description` AS `t1_c14`, `template`.`last_update` AS `t1_c15`, `template`.`owner_id` AS `t1_c16`, `template`.`extends` AS `t1_c17` FROM `templates` `template` WHERE (`template`.`name`=:ypl0). Bound with :ypl0='template_mffp_v2') 2 0.00042 0.00021 0.00021 0.00021 system.db.CDbCommand.query(SELECT `template`.`id` AS `t1_c0`, `template`.`name` AS `t1_c1`, `template`.`folder` AS `t1_c2`, `template`.`title` AS `t1_c3`, `template`.`creation_date` AS `t1_c4`, `template`.`author` AS `t1_c5`, `template`.`author_email` AS `t1_c6`, `template`.`author_url` AS `t1_c7`, `template`.`copyright` AS `t1_c8`, `template`.`license` AS `t1_c9`, `template`.`version` AS `t1_c10`, `template`.`api_version` AS `t1_c11`, `template`.`view_folder` AS `t1_c12`, `template`.`files_folder` AS `t1_c13`, `template`.`description` AS `t1_c14`, `template`.`last_update` AS `t1_c15`, `template`.`owner_id` AS `t1_c16`, `template`.`extends` AS `t1_c17` FROM `templates` `template` WHERE (`template`.`name`=:ypl0). Bound with :ypl0='template_mffp_piv') 2 0.00042 0.00021 0.00021 0.00021 system.db.CDbCommand.query(SELECT `template`.`id` AS `t1_c0`, `template`.`name` AS `t1_c1`, `template`.`folder` AS `t1_c2`, `template`.`title` AS `t1_c3`, `template`.`creation_date` AS `t1_c4`, `template`.`author` AS `t1_c5`, `template`.`author_email` AS `t1_c6`, `template`.`author_url` AS `t1_c7`, `template`.`copyright` AS `t1_c8`, `template`.`license` AS `t1_c9`, `template`.`version` AS `t1_c10`, `template`.`api_version` AS `t1_c11`, `template`.`view_folder` AS `t1_c12`, `template`.`files_folder` AS `t1_c13`, `template`.`description` AS `t1_c14`, `template`.`last_update` AS `t1_c15`, `template`.`owner_id` AS `t1_c16`, `template`.`extends` AS `t1_c17` FROM `templates` `template` WHERE (`template`.`name`=:ypl0). Bound with :ypl0='template_teq_v2') 2 0.00042 0.00021 0.00020 0.00021 system.db.CDbCommand.query(SELECT `template`.`id` AS `t1_c0`, `template`.`name` AS `t1_c1`, `template`.`folder` AS `t1_c2`, `template`.`title` AS `t1_c3`, `template`.`creation_date` AS `t1_c4`, `template`.`author` AS `t1_c5`, `template`.`author_email` AS `t1_c6`, `template`.`author_url` AS `t1_c7`, `template`.`copyright` AS `t1_c8`, `template`.`license` AS `t1_c9`, `template`.`version` AS `t1_c10`, `template`.`api_version` AS `t1_c11`, `template`.`view_folder` AS `t1_c12`, `template`.`files_folder` AS `t1_c13`, `template`.`description` AS `t1_c14`, `template`.`last_update` AS `t1_c15`, `template`.`owner_id` AS `t1_c16`, `template`.`extends` AS `t1_c17` FROM `templates` `template` WHERE (`template`.`name`=:ypl0). Bound with :ypl0='template_intranet_confidentiel') 2 0.00041 0.00021 0.00020 0.00022 system.db.CDbCommand.query(SELECT `template`.`id` AS `t1_c0`, `template`.`name` AS `t1_c1`, `template`.`folder` AS `t1_c2`, `template`.`title` AS `t1_c3`, `template`.`creation_date` AS `t1_c4`, `template`.`author` AS `t1_c5`, `template`.`author_email` AS `t1_c6`, `template`.`author_url` AS `t1_c7`, `template`.`copyright` AS `t1_c8`, `template`.`license` AS `t1_c9`, `template`.`version` AS `t1_c10`, `template`.`api_version` AS `t1_c11`, `template`.`view_folder` AS `t1_c12`, `template`.`files_folder` AS `t1_c13`, `template`.`description` AS `t1_c14`, `template`.`last_update` AS `t1_c15`, `template`.`owner_id` AS `t1_c16`, `template`.`extends` AS `t1_c17` FROM `templates` `template` WHERE (`template`.`name`=:ypl0). Bound with :ypl0='template_mern') 2 0.00041 0.00020 0.00020 0.00021 system.db.CDbCommand.query(SELECT FROM `templates` `t` WHERE `t`.`name`='vanilla' LIMIT 1) 2 0.00040 0.00020 0.00020 0.00021 system.db.CDbCommand.query(SELECT `template`.`id` AS `t1_c0`, `template`.`name` AS `t1_c1`, `template`.`folder` AS `t1_c2`, `template`.`title` AS `t1_c3`, `template`.`creation_date` AS `t1_c4`, `template`.`author` AS `t1_c5`, `template`.`author_email` AS `t1_c6`, `template`.`author_url` AS `t1_c7`, `template`.`copyright` AS `t1_c8`, `template`.`license` AS `t1_c9`, `template`.`version` AS `t1_c10`, `template`.`api_version` AS `t1_c11`, `template`.`view_folder` AS `t1_c12`, `template`.`files_folder` AS `t1_c13`, `template`.`description` AS `t1_c14`, `template`.`last_update` AS `t1_c15`, `template`.`owner_id` AS `t1_c16`, `template`.`extends` AS `t1_c17` FROM `templates` `template` WHERE (`template`.`name`=:ypl0). Bound with :ypl0='template_intranet_v2') 2 0.00040 0.00020 0.00020 0.00020 system.db.CDbCommand.query(SELECT FROM `templates` `t` WHERE `t`.`name`='template_teq' LIMIT 1) 1 0.00028 0.00028 0.00028 0.00028 system.db.CDbCommand.query(SELECT * FROM `settings_global` `t` WHERE stg_name=:name LIMIT 1. Bound with :name='DBVersion') 1 0.00022 0.00022 0.00022 0.00022

c_schmitz 2021-06-10 08:02 administrator ~64821 Last edited: 2021-06-10 08:02	Can you please take a screenhot of the screen before you click the button to start the upgrade? Please set debug= 2 and attach the complete webpage with the error. On your first screenshot we can only see the upper half.

c_schmitz 2021-06-10 08:04 administrator ~64822	Usage of models in dbupgrade: https://github.com/LimeSurvey/LimeSurvey/blob/master/application/helpers/update/updatedb_helper.php#L3459 :-(

c_schmitz 2021-06-10 08:15 administrator ~64823	@ollehar see also https://github.com/LimeSurvey/LimeSurvey/blob/master/application/helpers/update/updatedb_helper.php#L5234 and https://github.com/LimeSurvey/LimeSurvey/blob/master/application/helpers/update/updatedb_helper.php#L5255

ollehar 2021-06-10 12:21 administrator ~64830	I've implemented a fix to this file: https://raw.githubusercontent.com/LimeSurvey/LimeSurvey/bug/17361-Upgrade-from-3.14.6-to-5.0.3-fails/application/helpers/update/updatedb_helper.php You can either replace the file manually in your system, or download our patch release next Monday.

yniquet 2021-06-10 13:40 reporter ~64832	I have the error before accessing the update page

ollehar 2021-06-10 13:43 administrator ~64833	Can you try to clear your cache? Delete the content of <root folder>/tmp/runtime/cache/. (Don't delete the folder itself.)

yniquet 2021-06-10 13:54 reporter ~64836	clearing the cache did not fix the problem, do i need to replace updatedb_helper.php manually before ?

ollehar 2021-06-10 13:58 administrator ~64837	Can you give us a screenshot of your error? Include the URL in the browser, please. You only need to replace updatedb_helper.php if you want to redo the upgrade procedure (that is, start from your LS3 database again).

yniquet 2021-06-10 14:01 reporter ~64838	Voilà 2021-06-10 07_59_28-CDbException.png (63,493 bytes) 2021-06-10 07_59_28-CDbException.png (63,493 bytes)

ollehar 2021-06-10 14:02 administrator ~64839	Yeah, ok. Please do this: Restore your LS3 database. Replace updatedb_helper.php with my link above. Reload the interface to trigger the update. Let us know if it works.

yniquet 2021-06-10 14:25 reporter ~64840	Restore LS 3, replace updatedb_helper.php, reload the page, got the same error ... 2021-06-10 08_21_15-CDbException.png (60,915 bytes) 2021-06-10 08_21_15-CDbException.png (60,915 bytes)

ollehar 2021-06-10 14:26 administrator ~64841	Damn. Can you save that HTML page and upload it here? Then we can view the entire error.

yniquet 2021-06-10 14:27 reporter ~64842	<!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>CDbException</title> <style type="text/css"> /<![CDATA[/ html,body,div,span,applet,object,iframe,h1,h2,h3,h4,h5,h6,p,blockquote,pre,a,abbr,acronym,address,big,cite,code,del,dfn,em,font,img,ins,kbd,q,s,samp,small,strike,strong,sub,sup,tt,var,b,u,i,center,dl,dt,dd,ol,ul,li,fieldset,form,label,legend,table,caption,tbody,tfoot,thead,tr,th,td{border:0;outline:0;font-size:100%;vertical-align:baseline;background:transparent;margin:0;padding:0;} body{line-height:1;} ol,ul{list-style:none;} blockquote,q{quotes:none;} blockquote:before,blockquote:after,q:before,q:after{content:none;} :focus{outline:0;} ins{text-decoration:none;} del{text-decoration:line-through;} table{border-collapse:collapse;border-spacing:0;} body { font: normal 9pt "Verdana"; color: #000; background: #fff; } h1 { font: normal 18pt "Verdana"; color: #f00; margin-bottom: .5em; } h2 { font: normal 14pt "Verdana"; color: #800000; margin-bottom: .5em; } h3 { font: bold 11pt "Verdana"; } pre { font: normal 11pt Menlo, Consolas, "Lucida Console", Monospace; } pre span.error { display: block; background: #fce3e3; } pre span.ln { color: #999; padding-right: 0.5em; border-right: 1px solid #ccc; } pre span.error-ln { font-weight: bold; } .container { margin: 1em 4em; } .version { color: gray; font-size: 8pt; border-top: 1px solid #aaa; padding-top: 1em; margin-bottom: 1em; } .message { color: #000; padding: 1em; font-size: 11pt; background: #f3f3f3; -webkit-border-radius: 10px; -moz-border-radius: 10px; border-radius: 10px; margin-bottom: 1em; line-height: 160%; } .source { margin-bottom: 1em; } .code pre { background-color: #ffe; margin: 0.5em 0; padding: 0.5em; line-height: 125%; border: 1px solid #eee; } .source .file { margin-bottom: 1em; font-weight: bold; } .traces { margin: 2em 0; } .trace { margin: 0.5em 0; padding: 0.5em; } .trace.app { border: 1px dashed #c00; } .trace .number { text-align: right; width: 2em; padding: 0.5em; } .trace .content { padding: 0.5em; } .trace .plus, .trace .minus { display:inline; vertical-align:middle; text-align:center; border:1px solid #000; color:#000; font-size:10px; line-height:10px; margin:0; padding:0 1px; width:10px; height:10px; } .trace.collapsed .minus, .trace.expanded .plus, .trace.collapsed pre { display: none; } .trace-file { cursor: pointer; padding: 0.2em; } .trace-file:hover { background: #f0ffff; } /]]>/ </style> </head> <body> <div class="container"> <h1>CDbException</h1> `<p class="message"> La table « {{surveys_groupsettings}} » associée à la classe Active record « SurveysGroupsettings » est introuvable dans la base de données. </p> <div class="source"> <p class="file">/data/www/limesurvey2-lab/framework/db/ar/CActiveRecord.php(2390)</p> <div class="code"><pre><span class="ln">2378</span>` <span class="ln">2379</span> <span class="ln">2380</span> <span class="ln">2381</span> <span class="ln">2382</span> <span class="ln">2383</span> <span class="ln">2384</span> <span class="ln">2385</span> <span class="ln">2386</span> <span class="ln">2387</span> Constructor. @param CActiveRecord $model the model instance @throws CDbException if specified table for active record class cannot be found in the database / public function __construct($model) { $this->_modelClassName=get_class($model); /> $tableName=$model->tableName(); if(($table=$model->getDbConnection()->getSchema()->getTable($tableName))===null) class="ln error-ln">2390</span> throw new CDbException(Yii::t('yii','The table "{table}" for active record class "{class}" cannot be found in the database.', array('{class}'=>$this->_modelClassName,'{table}'=>$tableName))); /> if(($modelPk=$model->primaryKey())!==null \|\| $table->primaryKey===null) { $table->primaryKey=$modelPk; if(is_string($table->primaryKey) && isset($table->columns[$table->primaryKey])) $table->columns[$table->primaryKey]->isPrimaryKey=true; elseif(is_array($table->primaryKey)) { foreach($table->primaryKey as $name) { if(isset($table->columns[$name])) <div class="traces"> <h2>Stack Trace</h2> <table style="width:100%;"> <tr class="trace core collapsed"> <td class="number"> #0 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div>  /data/www/limesurvey2-lab/framework/db/ar/CActiveRecord.php(413): <strong>CActiveRecordMetaData</strong>-><strong>__construct</strong>(SurveysGroupsettings) </div> <div class="code"><pre><span class="ln">408</span> { <span class="ln">409</span> $className=get_class($this); <span class="ln">410</span> if(!array_key_exists($className,self::$_md)) <span class="ln">411</span> { <span class="ln">412</span> self::$_md[$className]=null; // preventing recursive invokes of {@link getMetaData()} via {@link __get()} <span class="error"><span class="ln error-ln">413</span> self::$_md[$className]=new CActiveRecordMetaData($this); </span><span class="ln">414</span> } <span class="ln">415</span> return self::$_md[$className]; <span class="ln">416</span> } <span class="ln">417</span> <span class="ln">418</span> /* </pre></div> </td> </tr> <tr class="trace core collapsed"> <td class="number"> #1 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div> /data/www/limesurvey2-lab/framework/db/ar/CActiveRecord.php(682): <strong>CActiveRecord</strong>-><strong>getMetaData</strong>() </div> `<div class="code"><pre><span class="ln">677</span> * @param string $name attribute name` <span class="ln">678</span> @return boolean whether this AR has the named attribute (table column). <span class="ln">679</span> / <span class="ln">680</span> public function hasAttribute($name) <span class="ln">681</span> { <span class="error"><span class="ln error-ln">682</span> return isset($this->getMetaData()->columns[$name]); </span><span class="ln">683</span> } <span class="ln">684</span> <span class="ln">685</span> /* <span class="ln">686</span> Returns the named attribute value. <span class="ln">687</span> * If this is a new record and the attribute is not set before, </pre></div> </td> </tr> <tr class="trace app expanded"> <td class="number"> #2 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div> /data/www/limesurvey2-lab/application/models/LSActiveRecord.php(35): <strong>CActiveRecord</strong>-><strong>hasAttribute</strong>("created") </div> `<div class="code"><pre><span class="ln">30</span> * @see CTimestampBehavior` <span class="ln">31</span> / <span class="ln">32</span> public function behaviors() <span class="ln">33</span> { <span class="ln">34</span> $aBehaviors = []; <span class="error"><span class="ln error-ln">35</span> $sCreateFieldName = ($this->hasAttribute('created') ? 'created' : null); </span><span class="ln">36</span> $sUpdateFieldName = ($this->hasAttribute('modified') ? 'modified' : null); <span class="ln">37</span> $sDriverName = Yii::app()->db->getDriverName(); <span class="ln">38</span> if ($sDriverName == 'sqlsrv' \|\| $sDriverName == 'dblib') { <span class="ln">39</span> $sTimestampExpression = new CDbExpression('GETDATE()'); <span class="ln">40</span> } else { </pre></div> </td> </tr> <tr class="trace core collapsed"> <td class="number"> #3 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div> /data/www/limesurvey2-lab/framework/db/ar/CActiveRecord.php(398): <strong>LSActiveRecord</strong>-><strong>behaviors</strong>() </div> `<div class="code"><pre><span class="ln">393</span> if(isset(self::$_models[$className]))` <span class="ln">394</span> return self::$_models[$className]; <span class="ln">395</span> else <span class="ln">396</span> { <span class="ln">397</span> $model=self::$_models[$className]=new $className(null); <span class="error"><span class="ln error-ln">398</span> $model->attachBehaviors($model->behaviors()); </span><span class="ln">399</span> return $model; <span class="ln">400</span> } <span class="ln">401</span> } <span class="ln">402</span> <span class="ln">403</span> /* </pre></div> </td> </tr> <tr class="trace app expanded"> <td class="number"> #4 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div> /data/www/limesurvey2-lab/application/models/SurveysGroupsettings.php(260): <strong>CActiveRecord</strong>::<strong>model</strong>("SurveysGroupsettings") </div> `<div class="code"><pre><span class="ln">255</span> * @param string $className active record class name.` <span class="ln">256</span> @return SurveysGroupsettings the static model class <span class="ln">257</span> / <span class="ln">258</span> public static function model($className = CLASS) <span class="ln">259</span> { <span class="error"><span class="ln error-ln">260</span> return parent::model($className); </span><span class="ln">261</span> } <span class="ln">262</span> <span class="ln">263</span> /* <span class="ln">264</span> @return bool <span class="ln">265</span> / </pre></div> </td> </tr> <tr class="trace app expanded"> <td class="number"> #5 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div> /data/www/limesurvey2-lab/application/models/SurveysGroupsettings.php(305): <strong>SurveysGroupsettings</strong>::<strong>model</strong>() </div> `<div class="code"><pre><span class="ln">300</span> /` <span class="ln">301</span> public static function getInstance($iSurveyGroupId = 0, $oSurvey = null, $instance = null, $iStep = 1, $bRealValues = false) <span class="ln">302</span> { <span class="ln">303</span> <span class="ln">304</span> if ($iSurveyGroupId > 0) { <span class="error"><span class="ln error-ln">305</span> $model = SurveysGroupsettings::model()->with('SurveysGroups')->findByPk($iSurveyGroupId); </span><span class="ln">306</span> } else { <span class="ln">307</span> //this is the default group setting with gsid=0 !!! <span class="ln">308</span> $model = SurveysGroupsettings::model()->findByPk($iSurveyGroupId); <span class="ln">309</span> } <span class="ln">310</span> </pre></div> </td> </tr> <tr class="trace app collapsed"> <td class="number"> #6 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div> /data/www/limesurvey2-lab/application/models/Survey.php(2099): <strong>SurveysGroupsettings</strong>::<strong>getInstance</strong>("5", Survey, null, 1, ...) </div> `<div class="code"><pre><span class="ln">2094</span> $this->tokenencryptionoptions = $options;` <span class="ln">2095</span> } <span class="ln">2096</span> <span class="ln">2097</span> public function setOptions($gsid = 1) <span class="ln">2098</span> { <span class="error"><span class="ln error-ln">2099</span> $instance = SurveysGroupsettings::getInstance($gsid, $this, null, 1, $this->bShowRealOptionValues); </span><span class="ln">2100</span> if ($instance) { <span class="ln">2101</span> $this->oOptions = $instance->oOptions; <span class="ln">2102</span> $this->oOptionLabels = $instance->oOptionLabels; <span class="ln">2103</span> $this->aOptions = (array) $instance->oOptions; <span class="ln">2104</span> $this->showInherited = $instance->showInherited; </pre></div> </td> </tr> <tr class="trace app collapsed"> <td class="number"> #7 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div> /data/www/limesurvey2-lab/application/models/Survey.php(560): <strong>Survey</strong>-><strong>setOptions</strong>("5") </div> `<div class="code"><pre><span class="ln">555</span> }` <span class="ln">556</span> if ($this->template != 'inherit') { <span class="ln">557</span> $this->template = Template::templateNameFilter($this->template); <span class="ln">558</span> } <span class="ln">559</span> / this is fixed, setOptions for inherited after all / <span class="error"><span class="ln error-ln">560</span> $this->setOptions($this->gsid); </span><span class="ln">561</span> } <span class="ln">562</span> <span class="ln">563</span> <span class="ln">564</span> /* <span class="ln">565</span> filterTemplateSave to fix some template name </pre></div> </td> </tr> <tr class="trace core collapsed"> <td class="number"> #8 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div> /data/www/limesurvey2-lab/framework/base/CComponent.php(561): <strong>Survey</strong>-><strong>afterFindSurvey</strong>(CEvent) </div> `<div class="code"><pre><span class="ln">556</span> // an array: 0 - object, 1 - method name` <span class="ln">557</span> list($object,$method)=$handler; <span class="ln">558</span> if(is_string($object)) // static method call <span class="ln">559</span> call_user_func($handler,$event); <span class="ln">560</span> elseif(method_exists($object,$method)) <span class="error"><span class="ln error-ln">561</span> $object->$method($event); </span><span class="ln">562</span> else <span class="ln">563</span> throw new CException(Yii::t('yii','Event "{class}.{event}" is attached with an invalid handler "{handler}".', <span class="ln">564</span> array('{class}'=>get_class($this), '{event}'=>$name, '{handler}'=>$handler[1]))); <span class="ln">565</span> } <span class="ln">566</span> else // PHP 5.3: anonymous function </pre></div> </td> </tr> <tr class="trace core collapsed"> <td class="number"> #9 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div> /data/www/limesurvey2-lab/framework/db/ar/CActiveRecord.php(902): <strong>CComponent</strong>-><strong>raiseEvent</strong>("onafterfind", CEvent) </div> `<div class="code"><pre><span class="ln">897</span> * This event is raised after the record is instantiated by a find method.` <span class="ln">898</span> @param CEvent $event the event parameter <span class="ln">899</span> / <span class="ln">900</span> public function onAfterFind($event) <span class="ln">901</span> { <span class="error"><span class="ln error-ln">902</span> $this->raiseEvent('onAfterFind',$event); </span><span class="ln">903</span> } <span class="ln">904</span> <span class="ln">905</span> /* <span class="ln">906</span> Given 'with' options returns a new active finder instance. <span class="ln">907</span> * </pre></div> </td> </tr> <tr class="trace core collapsed"> <td class="number"> #10 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div> /data/www/limesurvey2-lab/framework/db/ar/CActiveRecord.php(1040): <strong>CActiveRecord</strong>-><strong>onAfterFind</strong>(CEvent) </div> `<div class="code"><pre><span class="ln">1035</span> * Make sure you call the parent implementation so that the event is raised properly.` <span class="ln">1036</span> / <span class="ln">1037</span> protected function afterFind() <span class="ln">1038</span> { <span class="ln">1039</span> if($this->hasEventHandler('onAfterFind')) <span class="error"><span class="ln error-ln">1040</span> $this->onAfterFind(new CEvent($this)); </span><span class="ln">1041</span> } <span class="ln">1042</span> <span class="ln">1043</span> / <span class="ln">1044</span> Calls {@link beforeFind}. <span class="ln">1045</span> * This method is internally used. </pre></div> </td> </tr> <tr class="trace core collapsed"> <td class="number"> #11 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div> /data/www/limesurvey2-lab/framework/db/ar/CActiveRecord.php(1058): <strong>CActiveRecord</strong>-><strong>afterFind</strong>() </div> `<div class="code"><pre><span class="ln">1053</span> * Calls {@link afterFind}.` <span class="ln">1054</span> This method is internally used. <span class="ln">1055</span> / <span class="ln">1056</span> public function afterFindInternal() <span class="ln">1057</span> { <span class="error"><span class="ln error-ln">1058</span> $this->afterFind(); </span><span class="ln">1059</span> } <span class="ln">1060</span> <span class="ln">1061</span> /* <span class="ln">1062</span> Inserts a row into the table based on this active record attributes. <span class="ln">1063</span> * If the table's primary key is auto-incremental and is null before insertion, </pre></div> </td> </tr> <tr class="trace core collapsed"> <td class="number"> #12 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div> /data/www/limesurvey2-lab/framework/db/ar/CActiveFinder.php(776): <strong>CActiveRecord</strong>-><strong>afterFindInternal</strong>() </div> `<div class="code"><pre><span class="ln">771</span> * Calls {@link CActiveRecord::afterFind} of all the records.` <span class="ln">772</span> / <span class="ln">773</span> public function afterFind() <span class="ln">774</span> { <span class="ln">775</span> foreach($this->records as $record) <span class="error"><span class="ln error-ln">776</span> $record->afterFindInternal(); </span><span class="ln">777</span> foreach($this->children as $child) <span class="ln">778</span> $child->afterFind(); <span class="ln">779</span> <span class="ln">780</span> $this->children = null; <span class="ln">781</span> } </pre></div> </td> </tr> <tr class="trace core collapsed"> <td class="number"> #13 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div> /data/www/limesurvey2-lab/framework/db/ar/CActiveFinder.php(69): <strong>CJoinElement</strong>-><strong>afterFind</strong>() </div> `<div class="code"><pre><span class="ln">64</span> $this->_joinTree->tableAlias=$criteria->alias;` <span class="ln">65</span> $this->_joinTree->rawTableAlias=$this->_builder->getSchema()->quoteTableName($criteria->alias); <span class="ln">66</span> } <span class="ln">67</span> <span class="ln">68</span> $this->_joinTree->find($criteria); <span class="error"><span class="ln error-ln">69</span> $this->_joinTree->afterFind(); </span><span class="ln">70</span> <span class="ln">71</span> if($all) <span class="ln">72</span> { <span class="ln">73</span> $result = array_values($this->_joinTree->records); <span class="ln">74</span> if ($criteria->index!==null) </pre></div> </td> </tr> <tr class="trace core collapsed"> <td class="number"> #14 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div> /data/www/limesurvey2-lab/framework/db/ar/CActiveRecord.php(1364): <strong>CActiveFinder</strong>-><strong>query</strong>(CDbCriteria, true) </div> `<div class="code"><pre><span class="ln">1359</span> return $all ? $this->populateRecords($command->queryAll(), true, $criteria->index) : $this->populateRecord($command->queryRow());` <span class="ln">1360</span> } <span class="ln">1361</span> else <span class="ln">1362</span> { <span class="ln">1363</span> $finder=$this->getActiveFinder($criteria->with); <span class="error"><span class="ln error-ln">1364</span> return $finder->query($criteria,$all); </span><span class="ln">1365</span> } <span class="ln">1366</span> } <span class="ln">1367</span> <span class="ln">1368</span> / <span class="ln">1369</span> Applies the query scopes to the given criteria. </pre></div> </td> </tr> <tr class="trace app collapsed"> <td class="number"> #15 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div> /data/www/limesurvey2-lab/application/models/LSActiveRecord.php(74): <strong>CActiveRecord</strong>-><strong>query</strong>(CDbCriteria, true) </div> `<div class="code"><pre><span class="ln">69</span> * @since 1.1.7` <span class="ln">70</span> / <span class="ln">71</span> protected function query($criteria, $all = false, $asAR = true) <span class="ln">72</span> { <span class="ln">73</span> if ($asAR === true) { <span class="error"><span class="ln error-ln">74</span> return parent::query($criteria, $all); </span><span class="ln">75</span> } else { <span class="ln">76</span> $this->beforeFind(); <span class="ln">77</span> $this->applyScopes($criteria); <span class="ln">78</span> if (!$all) { <span class="ln">79</span> $criteria->limit = 1; </pre></div> </td> </tr> <tr class="trace core collapsed"> <td class="number"> #16 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div> /data/www/limesurvey2-lab/framework/db/ar/CActiveRecord.php(1478): <strong>LSActiveRecord</strong>-><strong>query</strong>(CDbCriteria, true) </div> `<div class="code"><pre><span class="ln">1473</span> /` <span class="ln">1474</span> public function findAll($condition='',$params=array()) <span class="ln">1475</span> { <span class="ln">1476</span> Yii::trace(get_class($this).'.findAll()','system.db.ar.CActiveRecord'); <span class="ln">1477</span> $criteria=$this->getCommandBuilder()->createCriteria($condition,$params); <span class="error"><span class="ln error-ln">1478</span> return $this->query($criteria,true); </span><span class="ln">1479</span> } <span class="ln">1480</span> <span class="ln">1481</span> /* <span class="ln">1482</span> Finds a single active record with the specified primary key. <span class="ln">1483</span> * See {@link find()} for detailed explanation about $condition and $params. </pre></div> </td> </tr> <tr class="trace app collapsed"> <td class="number"> #17 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div> /data/www/limesurvey2-lab/application/models/Survey.php(2286): <strong>CActiveRecord</strong>-><strong>findAll</strong>(CDbCriteria) </div> `<div class="code"><pre><span class="ln">2281</span> /` <span class="ln">2282</span> public function findAllPublic() <span class="ln">2283</span> { <span class="ln">2284</span> $oCriteria = new CDbCriteria(); <span class="ln">2285</span> $oCriteria->condition = "listpublic = 'Y' or listpublic = 'I'"; <span class="error"><span class="ln error-ln">2286</span> $aSurveys = $this->findAll($oCriteria); </span><span class="ln">2287</span> $aSurveys = array_filter( <span class="ln">2288</span> $aSurveys, <span class="ln">2289</span> function ($s) { <span class="ln">2290</span> return $s->isListPublic; <span class="ln">2291</span> } </pre></div> </td> </tr> <tr class="trace app collapsed"> <td class="number"> #18 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div> /data/www/limesurvey2-lab/application/controllers/SurveysController.php(38): <strong>Survey</strong>-><strong>findAllPublic</strong>() </div> `<div class="code"><pre><span class="ln">33</span>` <span class="ln">34</span> $oTemplate = Template::model()->getInstance(getGlobalSetting('defaulttheme')); <span class="ln">35</span> $this->sTemplate = $oTemplate->sTemplateName; <span class="ln">36</span> <span class="ln">37</span> $aData = array( <span class="error"><span class="ln error-ln">38</span> 'publicSurveys' => Survey::model()->active()->open()->with('languagesettings')->findAllPublic(), </span><span class="ln">39</span> 'futureSurveys' => Survey::model()->active()->registration()->with('languagesettings')->findAllPublic(), <span class="ln">40</span> 'oTemplate' => $oTemplate, <span class="ln">41</span> 'sSiteName' => Yii::app()->getConfig('sitename'), <span class="ln">42</span> 'sSiteAdminName' => Yii::app()->getConfig("siteadminname"), <span class="ln">43</span> 'sSiteAdminEmail' => Yii::app()->getConfig("siteadminemail"), </pre></div> </td> </tr> <tr class="trace core collapsed"> <td class="number"> #19 </td> <td class="content"> <div class="trace-file"> unknown(0): <strong>SurveysController</strong>-><strong>actionPublicList</strong>("fr") </div> </td> </tr> <tr class="trace core collapsed"> <td class="number"> #20 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div>  /data/www/limesurvey2-lab/framework/web/actions/CAction.php(115): <strong>ReflectionMethod</strong>-><strong>invokeArgs</strong>(SurveysController, array(null)) </div> <div class="code"><pre><span class="ln">110</span> elseif($param->isDefaultValueAvailable()) <span class="ln">111</span> $ps[]=$param->getDefaultValue(); <span class="ln">112</span> else <span class="ln">113</span> return false; <span class="ln">114</span> } <span class="error"><span class="ln error-ln">115</span> $method->invokeArgs($object,$ps); </span><span class="ln">116</span> return true; <span class="ln">117</span> } <span class="ln">118</span> } </pre></div> </td> </tr> <tr class="trace core collapsed"> <td class="number"> #21 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div> /data/www/limesurvey2-lab/framework/web/actions/CInlineAction.php(47): <strong>CAction</strong>-><strong>runWithParamsInternal</strong>(SurveysController, ReflectionMethod, array()) </div> `<div class="code"><pre><span class="ln">42</span> {` <span class="ln">43</span> $methodName='action'.$this->getId(); <span class="ln">44</span> $controller=$this->getController(); <span class="ln">45</span> $method=new ReflectionMethod($controller, $methodName); <span class="ln">46</span> if($method->getNumberOfParameters()>0) <span class="error"><span class="ln error-ln">47</span> return $this->runWithParamsInternal($controller, $method, $params); </span><span class="ln">48</span> <span class="ln">49</span> $controller->$methodName(); <span class="ln">50</span> return true; <span class="ln">51</span> } <span class="ln">52</span> } </pre></div> </td> </tr> <tr class="trace core collapsed"> <td class="number"> #22 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div> /data/www/limesurvey2-lab/framework/web/CController.php(308): <strong>CInlineAction</strong>-><strong>runWithParams</strong>(array()) </div> `<div class="code"><pre><span class="ln">303</span> {` <span class="ln">304</span> $priorAction=$this->_action; <span class="ln">305</span> $this->_action=$action; <span class="ln">306</span> if($this->beforeAction($action)) <span class="ln">307</span> { <span class="error"><span class="ln error-ln">308</span> if($action->runWithParams($this->getActionParams())===false) </span><span class="ln">309</span> $this->invalidActionParams($action); <span class="ln">310</span> else <span class="ln">311</span> $this->afterAction($action); <span class="ln">312</span> } <span class="ln">313</span> $this->_action=$priorAction; </pre></div> </td> </tr> <tr class="trace core collapsed"> <td class="number"> #23 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div> /data/www/limesurvey2-lab/framework/web/CController.php(286): <strong>CController</strong>-><strong>runAction</strong>(CInlineAction) </div> `<div class="code"><pre><span class="ln">281</span> @see runAction` <span class="ln">282</span> / <span class="ln">283</span> public function runActionWithFilters($action,$filters) <span class="ln">284</span> { <span class="ln">285</span> if(empty($filters)) <span class="error"><span class="ln error-ln">286</span> $this->runAction($action); </span><span class="ln">287</span> else <span class="ln">288</span> { <span class="ln">289</span> $priorAction=$this->_action; <span class="ln">290</span> $this->_action=$action; <span class="ln">291</span> CFilterChain::create($this,$action,$filters)->run(); </pre></div> </td> </tr> <tr class="trace core collapsed"> <td class="number"> #24 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div> /data/www/limesurvey2-lab/framework/web/CController.php(265): <strong>CController</strong>-><strong>runActionWithFilters</strong>(CInlineAction, array()) </div> `<div class="code"><pre><span class="ln">260</span> {` <span class="ln">261</span> if(($parent=$this->getModule())===null) <span class="ln">262</span> $parent=Yii::app(); <span class="ln">263</span> if($parent->beforeControllerAction($this,$action)) <span class="ln">264</span> { <span class="error"><span class="ln error-ln">265</span> $this->runActionWithFilters($action,$this->filters()); </span><span class="ln">266</span> $parent->afterControllerAction($this,$action); <span class="ln">267</span> } <span class="ln">268</span> } <span class="ln">269</span> else <span class="ln">270</span> $this->missingAction($actionID); </pre></div> </td> </tr> <tr class="trace core collapsed"> <td class="number"> #25 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div> /data/www/limesurvey2-lab/framework/web/CWebApplication.php(282): <strong>CController</strong>-><strong>run</strong>("") </div> `<div class="code"><pre><span class="ln">277</span> {` <span class="ln">278</span> list($controller,$actionID)=$ca; <span class="ln">279</span> $oldController=$this->_controller; <span class="ln">280</span> $this->_controller=$controller; <span class="ln">281</span> $controller->init(); <span class="error"><span class="ln error-ln">282</span> $controller->run($actionID); </span><span class="ln">283</span> $this->_controller=$oldController; <span class="ln">284</span> } <span class="ln">285</span> else <span class="ln">286</span> throw new CHttpException(404,Yii::t('yii','Unable to resolve the request "{route}".', <span class="ln">287</span> array('{route}'=>$route===''?$this->defaultController:$route))); </pre></div> </td> </tr> <tr class="trace core collapsed"> <td class="number"> #26 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div> /data/www/limesurvey2-lab/framework/web/CWebApplication.php(141): <strong>CWebApplication</strong>-><strong>runController</strong>("") </div> `<div class="code"><pre><span class="ln">136</span> foreach(array_splice($this->catchAllRequest,1) as $name=>$value)` <span class="ln">137</span> $_GET[$name]=$value; <span class="ln">138</span> } <span class="ln">139</span> else <span class="ln">140</span> $route=$this->getUrlManager()->parseUrl($this->getRequest()); <span class="error"><span class="ln error-ln">141</span> $this->runController($route); </span><span class="ln">142</span> } <span class="ln">143</span> <span class="ln">144</span> / <span class="ln">145</span> Registers the core application components. <span class="ln">146</span> * This method overrides the parent implementation by registering additional core components. </pre></div> </td> </tr> <tr class="trace core collapsed"> <td class="number"> #27 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div> /data/www/limesurvey2-lab/framework/base/CApplication.php(185): <strong>CWebApplication</strong>-><strong>processRequest</strong>() </div> `<div class="code"><pre><span class="ln">180</span> public function run()` <span class="ln">181</span> { <span class="ln">182</span> if($this->hasEventHandler('onBeginRequest')) <span class="ln">183</span> $this->onBeginRequest(new CEvent($this)); <span class="ln">184</span> register_shutdown_function(array($this,'end'),0,false); <span class="error"><span class="ln error-ln">185</span> $this->processRequest(); </span><span class="ln">186</span> if($this->hasEventHandler('onEndRequest')) <span class="ln">187</span> $this->onEndRequest(new CEvent($this)); <span class="ln">188</span> } <span class="ln">189</span> <span class="ln">190</span> /** </pre></div> </td> </tr> <tr class="trace app collapsed"> <td class="number"> #28 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div> /data/www/limesurvey2-lab/index.php(182): <strong>CApplication</strong>-><strong>run</strong>() </div> `<div class="code"><pre><span class="ln">177</span> require_once APPPATH . 'core/LSYii_Application' . EXT;` <span class="ln">178</span> <span class="ln">179</span> $config = require_once(APPPATH . 'config/internal' . EXT); <span class="ln">180</span> <span class="ln">181</span> Yii::$enableIncludePath = false; <span class="error"><span class="ln error-ln">182</span> Yii::createApplication('LSYii_Application', $config)->run(); </span><span class="ln">183</span> <span class="ln">184</span> / End of file index.php / <span class="ln">185</span> / Location: ./index.php / </pre></div> </td> </tr> </table> </div> `<div class="version"> 2021-06-10 08:26:48 Apache http://www.yiiframework.com//1.1.24-dev </div>` </div> <script type="text/javascript"> /<![CDATA[/ var traceReg = new RegExp("(^\|\s)trace-file(\s\|$)"); var collapsedReg = new RegExp("(^\|\s)collapsed(\s\|$)"); var e = document.getElementsByTagName("div"); for(var j=0,len=e.length;j<len;j++){ if(traceReg.test(e[j].className)){ e[j].onclick = function(){ var trace = this.parentNode.parentNode; if(collapsedReg.test(trace.className)) trace.className = trace.className.replace("collapsed", "expanded"); else trace.className = trace.className.replace("expanded", "collapsed"); } } } /]]>/ </script> </body> </html> <!-- start profiling summary --> <table class="yiiLog" width="100%" cellpadding="2" style="border-spacing:1px;font:11px Verdana, Arial, Helvetica, sans-serif;background:#EEEEEE;color:#666666;"> <tr> <th style="background:black;color:white;" colspan="6"> Sommaire du rapport de profilage (Durée: 0.06973s, Memoire: 8,139KB) </th> </tr> <tr style="background-color: #ccc;"> <th>Fonction</th> <th>Nb</th> <th>Total (s)</th> <th>Moy. (s)</th> <th>Min. (s)</th> <th>Max. (s)</th> </tr> <tr style="background:#FFFFFF"> <td>system.db.CDbCommand.query(SELECT `t`.`sid` AS `t0_c0`, `t`.`owner_id` AS `t0_c1`, `t`.`gsid` AS `t0_c2`, `t`.`admin` AS `t0_c3`, `t`.`active` AS `t0_c4`, `t`.`expires` AS `t0_c5`, `t`.`startdate` AS `t0_c6`, `t`.`adminemail` AS `t0_c7`, `t`.`anonymized` AS `t0_c8`, `t`.`faxto` AS `t0_c9`, `t`.`format` AS `t0_c10`, `t`.`savetimings` AS `t0_c11`, `t`.`template` AS `t0_c12`, `t`.`language` AS `t0_c13`, `t`.`additional_languages` AS `t0_c14`, `t`.`datestamp` AS `t0_c15`, `t`.`usecookie` AS `t0_c16`, `t`.`allowregister` AS `t0_c17`, `t`.`allowsave` AS `t0_c18`, `t`.`autonumber_start` AS `t0_c19`, `t`.`autoredirect` AS `t0_c20`, `t`.`allowprev` AS `t0_c21`, `t`.`printanswers` AS `t0_c22`, `t`.`ipaddr` AS `t0_c23`, `t`.`refurl` AS `t0_c24`, `t`.`datecreated` AS `t0_c25`, `t`.`showsurveypolicynotice` AS `t0_c26`, `t`.`publicstatistics` AS `t0_c27`, `t`.`publicgraphs` AS `t0_c28`, `t`.`listpublic` AS `t0_c29`, `t`.`htmlemail` AS `t0_c30`, `t`.`sendconfirmation` AS `t0_c31`, `t`.`tokenanswerspersistence` AS `t0_c32`, `t`.`assessments` AS `t0_c33`, `t`.`usecaptcha` AS `t0_c34`, `t`.`usetokens` AS `t0_c35`, `t`.`bounce_email` AS `t0_c36`, `t`.`attributedescriptions` AS `t0_c37`, `t`.`emailresponseto` AS `t0_c38`, `t`.`emailnotificationto` AS `t0_c39`, `t`.`tokenlength` AS `t0_c40`, `t`.`showxquestions` AS `t0_c41`, `t`.`showgroupinfo` AS `t0_c42`, `t`.`shownoanswer` AS `t0_c43`, `t`.`showqnumcode` AS `t0_c44`, `t`.`bouncetime` AS `t0_c45`, `t`.`bounceprocessing` AS `t0_c46`, `t`.`bounceaccounttype` AS `t0_c47`, `t`.`bounceaccounthost` AS `t0_c48`, `t`.`bounceaccountpass` AS `t0_c49`, `t`.`bounceaccountencryption` AS `t0_c50`, `t`.`bounceaccountuser` AS `t0_c51`, `t`.`showwelcome` AS `t0_c52`, `t`.`showprogress` AS `t0_c53`, `t`.`questionindex` AS `t0_c54`, `t`.`navigationdelay` AS `t0_c55`, `t`.`nokeyboard` AS `t0_c56`, `t`.`alloweditaftercompletion` AS `t0_c57`, `t`.`googleanalyticsstyle` AS `t0_c58`, `t`.`googleanalyticsapikey` AS `t0_c59`, `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_policy_notice` AS `t1_c6`, `languagesettings`.`surveyls_policy_error` AS `t1_c7`, `languagesettings`.`surveyls_policy_notice_label` AS `t1_c8`, `languagesettings`.`surveyls_url` AS `t1_c9`, `languagesettings`.`surveyls_urldescription` AS `t1_c10`, `languagesettings`.`surveyls_email_invite_subj` AS `t1_c11`, `languagesettings`.`surveyls_email_invite` AS `t1_c12`, `languagesettings`.`surveyls_email_remind_subj` AS `t1_c13`, `languagesettings`.`surveyls_email_remind` AS `t1_c14`, `languagesettings`.`surveyls_email_register_subj` AS `t1_c15`, `languagesettings`.`surveyls_email_register` AS `t1_c16`, `languagesettings`.`surveyls_email_confirm_subj` AS `t1_c17`, `languagesettings`.`surveyls_email_confirm` AS `t1_c18`, `languagesettings`.`surveyls_dateformat` AS `t1_c19`, `languagesettings`.`surveyls_attributecaptions` AS `t1_c20`, `languagesettings`.`email_admin_notification_subj` AS `t1_c21`, `languagesettings`.`email_admin_notification` AS `t1_c22`, `languagesettings`.`email_admin_responses_subj` AS `t1_c23`, `languagesettings`.`email_admin_responses` AS `t1_c24`, `languagesettings`.`surveyls_numberformat` AS `t1_c25`, `languagesettings`.`attachments` AS `t1_c26` FROM `surveys` `t` LEFT OUTER JOIN `surveys_languagesettings` `languagesettings` ON (`languagesettings`.`surveyls_survey_id`=`t`.`sid`) WHERE (((active = 'Y') AND ((startdate <= :now1 OR startdate IS NULL) AND (expires >= :now2 OR expires IS NULL))) AND (listpublic = 'Y' or listpublic = 'I')). Bound with :now1='2021-06-10 08:26:48', :now2='2021-06-10 08:26:48')</td> <td align="center">1</td> <td align="center">0.00208</td> <td align="center">0.00208</td> <td align="center">0.00208</td> <td align="center">0.00208</td> </tr> <tr style="background:#F5F5F5"> <td>system.db.CDbCommand.query(SELECT `t`.`id`, `t`.`template_name`, `t`.`sid`, `t`.`gsid`, `t`.`uid`, `t`.`files_css`, `t`.`files_js`, `t`.`files_print_css`, `t`.`options`, `t`.`cssframework_name`, `t`.`cssframework_css`, `t`.`cssframework_js`, `t`.`packages_to_load`, `t`.`packages_ltr`, `t`.`packages_rtl` FROM `template_configuration` `t` INNER JOIN templates AS template ON `t`.`template_name` = template.name WHERE ((t.sid IS NULL) AND (t.gsid IS NULL)) AND (template.name IS NOT NULL) ORDER BY `t`.`template_name`)</td> <td align="center">2</td> <td align="center">0.00159</td> <td align="center">0.00080</td> <td align="center">0.00062</td> <td align="center">0.00097</td> </tr> <tr style="background:#FFFFFF"> <td>system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `settings_global`)</td> <td align="center">1</td> <td align="center">0.00131</td> <td align="center">0.00131</td> <td align="center">0.00131</td> <td align="center">0.00131</td> </tr> <tr style="background:#F5F5F5"> <td>system.db.CDbCommand.query(SELECT FROM `templates` `t` WHERE `t`.`name`='fruity' LIMIT 1)</td> <td align="center">3</td> <td align="center">0.00075</td> <td align="center">0.00025</td> <td align="center">0.00017</td> <td align="center">0.00042</td> </tr> <tr style="background:#FFFFFF"> <td>system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `surveys`)</td> <td align="center">1</td> <td align="center">0.00075</td> <td align="center">0.00075</td> <td align="center">0.00075</td> <td align="center">0.00075</td> </tr> <tr style="background:#F5F5F5"> <td>system.db.CDbCommand.query(SELECT FROM `settings_global` `t`)</td> <td align="center">1</td> <td align="center">0.00073</td> <td align="center">0.00073</td> <td align="center">0.00073</td> <td align="center">0.00073</td> </tr> <tr style="background:#FFFFFF"> <td>system.db.CDbCommand.query(SELECT `template`.`id` AS `t1_c0`, `template`.`name` AS `t1_c1`, `template`.`folder` AS `t1_c2`, `template`.`title` AS `t1_c3`, `template`.`creation_date` AS `t1_c4`, `template`.`author` AS `t1_c5`, `template`.`author_email` AS `t1_c6`, `template`.`author_url` AS `t1_c7`, `template`.`copyright` AS `t1_c8`, `template`.`license` AS `t1_c9`, `template`.`version` AS `t1_c10`, `template`.`api_version` AS `t1_c11`, `template`.`view_folder` AS `t1_c12`, `template`.`files_folder` AS `t1_c13`, `template`.`description` AS `t1_c14`, `template`.`last_update` AS `t1_c15`, `template`.`owner_id` AS `t1_c16`, `template`.`extends` AS `t1_c17` FROM `templates` `template` WHERE (`template`.`name`=:ypl0). Bound with :ypl0='vanilla')</td> <td align="center">3</td> <td align="center">0.00063</td> <td align="center">0.00021</td> <td align="center">0.00019</td> <td align="center">0.00024</td> </tr> <tr style="background:#F5F5F5"> <td>system.db.CDbCommand.query(SELECT `template`.`id` AS `t1_c0`, `template`.`name` AS `t1_c1`, `template`.`folder` AS `t1_c2`, `template`.`title` AS `t1_c3`, `template`.`creation_date` AS `t1_c4`, `template`.`author` AS `t1_c5`, `template`.`author_email` AS `t1_c6`, `template`.`author_url` AS `t1_c7`, `template`.`copyright` AS `t1_c8`, `template`.`license` AS `t1_c9`, `template`.`version` AS `t1_c10`, `template`.`api_version` AS `t1_c11`, `template`.`view_folder` AS `t1_c12`, `template`.`files_folder` AS `t1_c13`, `template`.`description` AS `t1_c14`, `template`.`last_update` AS `t1_c15`, `template`.`owner_id` AS `t1_c16`, `template`.`extends` AS `t1_c17` FROM `templates` `template` WHERE (`template`.`name`=:ypl0). Bound with :ypl0='fruity')</td> <td align="center">3</td> <td align="center">0.00062</td> <td align="center">0.00021</td> <td align="center">0.00019</td> <td align="center">0.00022</td> </tr> <tr style="background:#FFFFFF"> <td>system.db.CDbCommand.query(SELECT `template`.`id` AS `t1_c0`, `template`.`name` AS `t1_c1`, `template`.`folder` AS `t1_c2`, `template`.`title` AS `t1_c3`, `template`.`creation_date` AS `t1_c4`, `template`.`author` AS `t1_c5`, `template`.`author_email` AS `t1_c6`, `template`.`author_url` AS `t1_c7`, `template`.`copyright` AS `t1_c8`, `template`.`license` AS `t1_c9`, `template`.`version` AS `t1_c10`, `template`.`api_version` AS `t1_c11`, `template`.`view_folder` AS `t1_c12`, `template`.`files_folder` AS `t1_c13`, `template`.`description` AS `t1_c14`, `template`.`last_update` AS `t1_c15`, `template`.`owner_id` AS `t1_c16`, `template`.`extends` AS `t1_c17` FROM `templates` `template` WHERE (`template`.`name`=:ypl0). Bound with :ypl0='bootswatch')</td> <td align="center">2</td> <td align="center">0.00060</td> <td align="center">0.00030</td> <td align="center">0.00024</td> <td align="center">0.00036</td> </tr> <tr style="background:#F5F5F5"> <td>system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `surveys_groupsettings`)</td> <td align="center">1</td> <td align="center">0.00059</td> <td align="center">0.00059</td> <td align="center">0.00059</td> <td align="center">0.00059</td> </tr> <tr style="background:#FFFFFF"> <td>system.db.CDbCommand.query(SELECT `template`.`id` AS `t1_c0`, `template`.`name` AS `t1_c1`, `template`.`folder` AS `t1_c2`, `template`.`title` AS `t1_c3`, `template`.`creation_date` AS `t1_c4`, `template`.`author` AS `t1_c5`, `template`.`author_email` AS `t1_c6`, `template`.`author_url` AS `t1_c7`, `template`.`copyright` AS `t1_c8`, `template`.`license` AS `t1_c9`, `template`.`version` AS `t1_c10`, `template`.`api_version` AS `t1_c11`, `template`.`view_folder` AS `t1_c12`, `template`.`files_folder` AS `t1_c13`, `template`.`description` AS `t1_c14`, `template`.`last_update` AS `t1_c15`, `template`.`owner_id` AS `t1_c16`, `template`.`extends` AS `t1_c17` FROM `templates` `template` WHERE (`template`.`name`=:ypl0). Bound with :ypl0='template_intranet_v2')</td> <td align="center">2</td> <td align="center">0.00054</td> <td align="center">0.00027</td> <td align="center">0.00023</td> <td align="center">0.00032</td> </tr> <tr style="background:#F5F5F5"> <td>system.db.CDbCommand.query(SELECT `template`.`id` AS `t1_c0`, `template`.`name` AS `t1_c1`, `template`.`folder` AS `t1_c2`, `template`.`title` AS `t1_c3`, `template`.`creation_date` AS `t1_c4`, `template`.`author` AS `t1_c5`, `template`.`author_email` AS `t1_c6`, `template`.`author_url` AS `t1_c7`, `template`.`copyright` AS `t1_c8`, `template`.`license` AS `t1_c9`, `template`.`version` AS `t1_c10`, `template`.`api_version` AS `t1_c11`, `template`.`view_folder` AS `t1_c12`, `template`.`files_folder` AS `t1_c13`, `template`.`description` AS `t1_c14`, `template`.`last_update` AS `t1_c15`, `template`.`owner_id` AS `t1_c16`, `template`.`extends` AS `t1_c17` FROM `templates` `template` WHERE (`template`.`name`=:ypl0). Bound with :ypl0='template_intranet_confidentiel')</td> <td align="center">2</td> <td align="center">0.00052</td> <td align="center">0.00026</td> <td align="center">0.00020</td> <td align="center">0.00032</td> </tr> <tr style="background:#FFFFFF"> <td>system.db.CDbCommand.query(SELECT `template`.`id` AS `t1_c0`, `template`.`name` AS `t1_c1`, `template`.`folder` AS `t1_c2`, `template`.`title` AS `t1_c3`, `template`.`creation_date` AS `t1_c4`, `template`.`author` AS `t1_c5`, `template`.`author_email` AS `t1_c6`, `template`.`author_url` AS `t1_c7`, `template`.`copyright` AS `t1_c8`, `template`.`license` AS `t1_c9`, `template`.`version` AS `t1_c10`, `template`.`api_version` AS `t1_c11`, `template`.`view_folder` AS `t1_c12`, `template`.`files_folder` AS `t1_c13`, `template`.`description` AS `t1_c14`, `template`.`last_update` AS `t1_c15`, `template`.`owner_id` AS `t1_c16`, `template`.`extends` AS `t1_c17` FROM `templates` `template` WHERE (`template`.`name`=:ypl0). Bound with :ypl0='template_intranet_piv')</td> <td align="center">2</td> <td align="center">0.00052</td> <td align="center">0.00026</td> <td align="center">0.00019</td> <td align="center">0.00033</td> </tr> <tr style="background:#F5F5F5"> <td>system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `templates`)</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 FROM `template_configuration` `t` WHERE template_name=:template_name AND sid IS NULL AND gsid IS NULL ORDER BY `t`.`template_name` LIMIT 1. Bound with :template_name='fruity')</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(SHOW FULL COLUMNS FROM `surveys_languagesettings`)</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 FULL COLUMNS FROM `template_configuration`)</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 `template`.`id` AS `t1_c0`, `template`.`name` AS `t1_c1`, `template`.`folder` AS `t1_c2`, `template`.`title` AS `t1_c3`, `template`.`creation_date` AS `t1_c4`, `template`.`author` AS `t1_c5`, `template`.`author_email` AS `t1_c6`, `template`.`author_url` AS `t1_c7`, `template`.`copyright` AS `t1_c8`, `template`.`license` AS `t1_c9`, `template`.`version` AS `t1_c10`, `template`.`api_version` AS `t1_c11`, `template`.`view_folder` AS `t1_c12`, `template`.`files_folder` AS `t1_c13`, `template`.`description` AS `t1_c14`, `template`.`last_update` AS `t1_c15`, `template`.`owner_id` AS `t1_c16`, `template`.`extends` AS `t1_c17` FROM `templates` `template` WHERE (`template`.`name`=:ypl0). Bound with :ypl0='template_intranet_confidentiel_v2')</td> <td align="center">2</td> <td align="center">0.00048</td> <td align="center">0.00024</td> <td align="center">0.00019</td> <td align="center">0.00029</td> </tr> <tr style="background:#FFFFFF"> <td>system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `plugins`)</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:#F5F5F5"> <td>system.db.CDbCommand.query(SELECT `template`.`id` AS `t1_c0`, `template`.`name` AS `t1_c1`, `template`.`folder` AS `t1_c2`, `template`.`title` AS `t1_c3`, `template`.`creation_date` AS `t1_c4`, `template`.`author` AS `t1_c5`, `template`.`author_email` AS `t1_c6`, `template`.`author_url` AS `t1_c7`, `template`.`copyright` AS `t1_c8`, `template`.`license` AS `t1_c9`, `template`.`version` AS `t1_c10`, `template`.`api_version` AS `t1_c11`, `template`.`view_folder` AS `t1_c12`, `template`.`files_folder` AS `t1_c13`, `template`.`description` AS `t1_c14`, `template`.`last_update` AS `t1_c15`, `template`.`owner_id` AS `t1_c16`, `template`.`extends` AS `t1_c17` FROM `templates` `template` WHERE (`template`.`name`=:ypl0). Bound with :ypl0='template_mern_v2')</td> <td align="center">2</td> <td align="center">0.00046</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(SELECT FROM `templates` `t` WHERE `t`.`name`='vanilla' LIMIT 1)</td> <td align="center">2</td> <td align="center">0.00045</td> <td align="center">0.00023</td> <td align="center">0.00018</td> <td align="center">0.00028</td> </tr> <tr style="background:#F5F5F5"> <td>system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `permissions`)</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 `template`.`id` AS `t1_c0`, `template`.`name` AS `t1_c1`, `template`.`folder` AS `t1_c2`, `template`.`title` AS `t1_c3`, `template`.`creation_date` AS `t1_c4`, `template`.`author` AS `t1_c5`, `template`.`author_email` AS `t1_c6`, `template`.`author_url` AS `t1_c7`, `template`.`copyright` AS `t1_c8`, `template`.`license` AS `t1_c9`, `template`.`version` AS `t1_c10`, `template`.`api_version` AS `t1_c11`, `template`.`view_folder` AS `t1_c12`, `template`.`files_folder` AS `t1_c13`, `template`.`description` AS `t1_c14`, `template`.`last_update` AS `t1_c15`, `template`.`owner_id` AS `t1_c16`, `template`.`extends` AS `t1_c17` FROM `templates` `template` WHERE (`template`.`name`=:ypl0). Bound with :ypl0='template_teq_v3')</td> <td align="center">2</td> <td align="center">0.00044</td> <td align="center">0.00022</td> <td align="center">0.00019</td> <td align="center">0.00024</td> </tr> <tr style="background:#F5F5F5"> <td>system.db.CDbCommand.query(SELECT `template`.`id` AS `t1_c0`, `template`.`name` AS `t1_c1`, `template`.`folder` AS `t1_c2`, `template`.`title` AS `t1_c3`, `template`.`creation_date` AS `t1_c4`, `template`.`author` AS `t1_c5`, `template`.`author_email` AS `t1_c6`, `template`.`author_url` AS `t1_c7`, `template`.`copyright` AS `t1_c8`, `template`.`license` AS `t1_c9`, `template`.`version` AS `t1_c10`, `template`.`api_version` AS `t1_c11`, `template`.`view_folder` AS `t1_c12`, `template`.`files_folder` AS `t1_c13`, `template`.`description` AS `t1_c14`, `template`.`last_update` AS `t1_c15`, `template`.`owner_id` AS `t1_c16`, `template`.`extends` AS `t1_c17` FROM `templates` `template` WHERE (`template`.`name`=:ypl0). Bound with :ypl0='template_intranet')</td> <td align="center">2</td> <td align="center">0.00043</td> <td align="center">0.00022</td> <td align="center">0.00019</td> <td align="center">0.00025</td> </tr> <tr style="background:#FFFFFF"> <td>system.db.CDbCommand.query(SELECT `template`.`id` AS `t1_c0`, `template`.`name` AS `t1_c1`, `template`.`folder` AS `t1_c2`, `template`.`title` AS `t1_c3`, `template`.`creation_date` AS `t1_c4`, `template`.`author` AS `t1_c5`, `template`.`author_email` AS `t1_c6`, `template`.`author_url` AS `t1_c7`, `template`.`copyright` AS `t1_c8`, `template`.`license` AS `t1_c9`, `template`.`version` AS `t1_c10`, `template`.`api_version` AS `t1_c11`, `template`.`view_folder` AS `t1_c12`, `template`.`files_folder` AS `t1_c13`, `template`.`description` AS `t1_c14`, `template`.`last_update` AS `t1_c15`, `template`.`owner_id` AS `t1_c16`, `template`.`extends` AS `t1_c17` FROM `templates` `template` WHERE (`template`.`name`=:ypl0). Bound with :ypl0='template_teq')</td> <td align="center">2</td> <td align="center">0.00043</td> <td align="center">0.00022</td> <td align="center">0.00021</td> <td align="center">0.00022</td> </tr> <tr style="background:#F5F5F5"> <td>system.db.CDbCommand.query(SELECT `template`.`id` AS `t1_c0`, `template`.`name` AS `t1_c1`, `template`.`folder` AS `t1_c2`, `template`.`title` AS `t1_c3`, `template`.`creation_date` AS `t1_c4`, `template`.`author` AS `t1_c5`, `template`.`author_email` AS `t1_c6`, `template`.`author_url` AS `t1_c7`, `template`.`copyright` AS `t1_c8`, `template`.`license` AS `t1_c9`, `template`.`version` AS `t1_c10`, `template`.`api_version` AS `t1_c11`, `template`.`view_folder` AS `t1_c12`, `template`.`files_folder` AS `t1_c13`, `template`.`description` AS `t1_c14`, `template`.`last_update` AS `t1_c15`, `template`.`owner_id` AS `t1_c16`, `template`.`extends` AS `t1_c17` FROM `templates` `template` WHERE (`template`.`name`=:ypl0). Bound with :ypl0='template_mffp')</td> <td align="center">2</td> <td align="center">0.00043</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(SELECT `template`.`id` AS `t1_c0`, `template`.`name` AS `t1_c1`, `template`.`folder` AS `t1_c2`, `template`.`title` AS `t1_c3`, `template`.`creation_date` AS `t1_c4`, `template`.`author` AS `t1_c5`, `template`.`author_email` AS `t1_c6`, `template`.`author_url` AS `t1_c7`, `template`.`copyright` AS `t1_c8`, `template`.`license` AS `t1_c9`, `template`.`version` AS `t1_c10`, `template`.`api_version` AS `t1_c11`, `template`.`view_folder` AS `t1_c12`, `template`.`files_folder` AS `t1_c13`, `template`.`description` AS `t1_c14`, `template`.`last_update` AS `t1_c15`, `template`.`owner_id` AS `t1_c16`, `template`.`extends` AS `t1_c17` FROM `templates` `template` WHERE (`template`.`name`=:ypl0). Bound with :ypl0='template_teq_v2')</td> <td align="center">2</td> <td align="center">0.00043</td> <td align="center">0.00021</td> <td align="center">0.00019</td> <td align="center">0.00024</td> </tr> <tr style="background:#F5F5F5"> <td>system.db.CDbCommand.query(SELECT `template`.`id` AS `t1_c0`, `template`.`name` AS `t1_c1`, `template`.`folder` AS `t1_c2`, `template`.`title` AS `t1_c3`, `template`.`creation_date` AS `t1_c4`, `template`.`author` AS `t1_c5`, `template`.`author_email` AS `t1_c6`, `template`.`author_url` AS `t1_c7`, `template`.`copyright` AS `t1_c8`, `template`.`license` AS `t1_c9`, `template`.`version` AS `t1_c10`, `template`.`api_version` AS `t1_c11`, `template`.`view_folder` AS `t1_c12`, `template`.`files_folder` AS `t1_c13`, `template`.`description` AS `t1_c14`, `template`.`last_update` AS `t1_c15`, `template`.`owner_id` AS `t1_c16`, `template`.`extends` AS `t1_c17` FROM `templates` `template` WHERE (`template`.`name`=:ypl0). Bound with :ypl0='template_mern_interministeriel')</td> <td align="center">2</td> <td align="center">0.00043</td> <td align="center">0.00021</td> <td align="center">0.00021</td> <td align="center">0.00022</td> </tr> <tr style="background:#FFFFFF"> <td>system.db.CDbCommand.query(SELECT `template`.`id` AS `t1_c0`, `template`.`name` AS `t1_c1`, `template`.`folder` AS `t1_c2`, `template`.`title` AS `t1_c3`, `template`.`creation_date` AS `t1_c4`, `template`.`author` AS `t1_c5`, `template`.`author_email` AS `t1_c6`, `template`.`author_url` AS `t1_c7`, `template`.`copyright` AS `t1_c8`, `template`.`license` AS `t1_c9`, `template`.`version` AS `t1_c10`, `template`.`api_version` AS `t1_c11`, `template`.`view_folder` AS `t1_c12`, `template`.`files_folder` AS `t1_c13`, `template`.`description` AS `t1_c14`, `template`.`last_update` AS `t1_c15`, `template`.`owner_id` AS `t1_c16`, `template`.`extends` AS `t1_c17` FROM `templates` `template` WHERE (`template`.`name`=:ypl0). Bound with :ypl0='template_intranet_confidentiel_v4')</td> <td align="center">2</td> <td align="center">0.00043</td> <td align="center">0.00021</td> <td align="center">0.00019</td> <td align="center">0.00024</td> </tr> <tr style="background:#F5F5F5"> <td>system.db.CDbCommand.query(SELECT `template`.`id` AS `t1_c0`, `template`.`name` AS `t1_c1`, `template`.`folder` AS `t1_c2`, `template`.`title` AS `t1_c3`, `template`.`creation_date` AS `t1_c4`, `template`.`author` AS `t1_c5`, `template`.`author_email` AS `t1_c6`, `template`.`author_url` AS `t1_c7`, `template`.`copyright` AS `t1_c8`, `template`.`license` AS `t1_c9`, `template`.`version` AS `t1_c10`, `template`.`api_version` AS `t1_c11`, `template`.`view_folder` AS `t1_c12`, `template`.`files_folder` AS `t1_c13`, `template`.`description` AS `t1_c14`, `template`.`last_update` AS `t1_c15`, `template`.`owner_id` AS `t1_c16`, `template`.`extends` AS `t1_c17` FROM `templates` `template` WHERE (`template`.`name`=:ypl0). Bound with :ypl0='template_mern_v3')</td> <td align="center">2</td> <td align="center">0.00043</td> <td align="center">0.00021</td> <td align="center">0.00019</td> <td align="center">0.00024</td> </tr> <tr style="background:#FFFFFF"> <td>system.db.CDbCommand.query(SELECT `template`.`id` AS `t1_c0`, `template`.`name` AS `t1_c1`, `template`.`folder` AS `t1_c2`, `template`.`title` AS `t1_c3`, `template`.`creation_date` AS `t1_c4`, `template`.`author` AS `t1_c5`, `template`.`author_email` AS `t1_c6`, `template`.`author_url` AS `t1_c7`, `template`.`copyright` AS `t1_c8`, `template`.`license` AS `t1_c9`, `template`.`version` AS `t1_c10`, `template`.`api_version` AS `t1_c11`, `template`.`view_folder` AS `t1_c12`, `template`.`files_folder` AS `t1_c13`, `template`.`description` AS `t1_c14`, `template`.`last_update` AS `t1_c15`, `template`.`owner_id` AS `t1_c16`, `template`.`extends` AS `t1_c17` FROM `templates` `template` WHERE (`template`.`name`=:ypl0). Bound with :ypl0='template_mern')</td> <td align="center">2</td> <td align="center">0.00042</td> <td align="center">0.00021</td> <td align="center">0.00019</td> <td align="center">0.00023</td> </tr> <tr style="background:#F5F5F5"> <td>system.db.CDbCommand.query(SELECT `template`.`id` AS `t1_c0`, `template`.`name` AS `t1_c1`, `template`.`folder` AS `t1_c2`, `template`.`title` AS `t1_c3`, `template`.`creation_date` AS `t1_c4`, `template`.`author` AS `t1_c5`, `template`.`author_email` AS `t1_c6`, `template`.`author_url` AS `t1_c7`, `template`.`copyright` AS `t1_c8`, `template`.`license` AS `t1_c9`, `template`.`version` AS `t1_c10`, `template`.`api_version` AS `t1_c11`, `template`.`view_folder` AS `t1_c12`, `template`.`files_folder` AS `t1_c13`, `template`.`description` AS `t1_c14`, `template`.`last_update` AS `t1_c15`, `template`.`owner_id` AS `t1_c16`, `template`.`extends` AS `t1_c17` FROM `templates` `template` WHERE (`template`.`name`=:ypl0). Bound with :ypl0='template_mffp_piv')</td> <td align="center">2</td> <td align="center">0.00041</td> <td align="center">0.00021</td> <td align="center">0.00019</td> <td align="center">0.00022</td> </tr> <tr style="background:#FFFFFF"> <td>system.db.CDbCommand.query(SELECT `template`.`id` AS `t1_c0`, `template`.`name` AS `t1_c1`, `template`.`folder` AS `t1_c2`, `template`.`title` AS `t1_c3`, `template`.`creation_date` AS `t1_c4`, `template`.`author` AS `t1_c5`, `template`.`author_email` AS `t1_c6`, `template`.`author_url` AS `t1_c7`, `template`.`copyright` AS `t1_c8`, `template`.`license` AS `t1_c9`, `template`.`version` AS `t1_c10`, `template`.`api_version` AS `t1_c11`, `template`.`view_folder` AS `t1_c12`, `template`.`files_folder` AS `t1_c13`, `template`.`description` AS `t1_c14`, `template`.`last_update` AS `t1_c15`, `template`.`owner_id` AS `t1_c16`, `template`.`extends` AS `t1_c17` FROM `templates` `template` WHERE (`template`.`name`=:ypl0). Bound with :ypl0='extends_template_intranet_confidentiel_v3')</td> <td align="center">2</td> <td align="center">0.00041</td> <td align="center">0.00020</td> <td align="center">0.00020</td> <td align="center">0.00021</td> </tr> <tr style="background:#F5F5F5"> <td>system.db.CDbCommand.query(SELECT `template`.`id` AS `t1_c0`, `template`.`name` AS `t1_c1`, `template`.`folder` AS `t1_c2`, `template`.`title` AS `t1_c3`, `template`.`creation_date` AS `t1_c4`, `template`.`author` AS `t1_c5`, `template`.`author_email` AS `t1_c6`, `template`.`author_url` AS `t1_c7`, `template`.`copyright` AS `t1_c8`, `template`.`license` AS `t1_c9`, `template`.`version` AS `t1_c10`, `template`.`api_version` AS `t1_c11`, `template`.`view_folder` AS `t1_c12`, `template`.`files_folder` AS `t1_c13`, `template`.`description` AS `t1_c14`, `template`.`last_update` AS `t1_c15`, `template`.`owner_id` AS `t1_c16`, `template`.`extends` AS `t1_c17` FROM `templates` `template` WHERE (`template`.`name`=:ypl0). Bound with :ypl0='template_profil_gouvernementale')</td> <td align="center">2</td> <td align="center">0.00040</td> <td align="center">0.00020</td> <td align="center">0.00020</td> <td align="center">0.00021</td> </tr> <tr style="background:#FFFFFF"> <td>system.db.CDbCommand.query(SELECT `template`.`id` AS `t1_c0`, `template`.`name` AS `t1_c1`, `template`.`folder` AS `t1_c2`, `template`.`title` AS `t1_c3`, `template`.`creation_date` AS `t1_c4`, `template`.`author` AS `t1_c5`, `template`.`author_email` AS `t1_c6`, `template`.`author_url` AS `t1_c7`, `template`.`copyright` AS `t1_c8`, `template`.`license` AS `t1_c9`, `template`.`version` AS `t1_c10`, `template`.`api_version` AS `t1_c11`, `template`.`view_folder` AS `t1_c12`, `template`.`files_folder` AS `t1_c13`, `template`.`description` AS `t1_c14`, `template`.`last_update` AS `t1_c15`, `template`.`owner_id` AS `t1_c16`, `template`.`extends` AS `t1_c17` FROM `templates` `template` WHERE (`template`.`name`=:ypl0). Bound with :ypl0='template_JSDENEUVILLE')</td> <td align="center">2</td> <td align="center">0.00040</td> <td align="center">0.00020</td> <td align="center">0.00019</td> <td align="center">0.00021</td> </tr> <tr style="background:#F5F5F5"> <td>system.db.CDbCommand.query(SELECT `template`.`id` AS `t1_c0`, `template`.`name` AS `t1_c1`, `template`.`folder` AS `t1_c2`, `template`.`title` AS `t1_c3`, `template`.`creation_date` AS `t1_c4`, `template`.`author` AS `t1_c5`, `template`.`author_email` AS `t1_c6`, `template`.`author_url` AS `t1_c7`, `template`.`copyright` AS `t1_c8`, `template`.`license` AS `t1_c9`, `template`.`version` AS `t1_c10`, `template`.`api_version` AS `t1_c11`, `template`.`view_folder` AS `t1_c12`, `template`.`files_folder` AS `t1_c13`, `template`.`description` AS `t1_c14`, `template`.`last_update` AS `t1_c15`, `template`.`owner_id` AS `t1_c16`, `template`.`extends` AS `t1_c17` FROM `templates` `template` WHERE (`template`.`name`=:ypl0). Bound with :ypl0='template_mern_piv')</td> <td align="center">2</td> <td align="center">0.00039</td> <td align="center">0.00020</td> <td align="center">0.00019</td> <td align="center">0.00021</td> </tr> <tr style="background:#FFFFFF"> <td>system.db.CDbCommand.query(SELECT `template`.`id` AS `t1_c0`, `template`.`name` AS `t1_c1`, `template`.`folder` AS `t1_c2`, `template`.`title` AS `t1_c3`, `template`.`creation_date` AS `t1_c4`, `template`.`author` AS `t1_c5`, `template`.`author_email` AS `t1_c6`, `template`.`author_url` AS `t1_c7`, `template`.`copyright` AS `t1_c8`, `template`.`license` AS `t1_c9`, `template`.`version` AS `t1_c10`, `template`.`api_version` AS `t1_c11`, `template`.`view_folder` AS `t1_c12`, `template`.`files_folder` AS `t1_c13`, `template`.`description` AS `t1_c14`, `template`.`last_update` AS `t1_c15`, `template`.`owner_id` AS `t1_c16`, `template`.`extends` AS `t1_c17` FROM `templates` `template` WHERE (`template`.`name`=:ypl0). Bound with :ypl0='template_teq_piv')</td> <td align="center">2</td> <td align="center">0.00039</td> <td align="center">0.00020</td> <td align="center">0.00019</td> <td align="center">0.00020</td> </tr> <tr style="background:#F5F5F5"> <td>system.db.CDbCommand.query(SELECT `template`.`id` AS `t1_c0`, `template`.`name` AS `t1_c1`, `template`.`folder` AS `t1_c2`, `template`.`title` AS `t1_c3`, `template`.`creation_date` AS `t1_c4`, `template`.`author` AS `t1_c5`, `template`.`author_email` AS `t1_c6`, `template`.`author_url` AS `t1_c7`, `template`.`copyright` AS `t1_c8`, `template`.`license` AS `t1_c9`, `template`.`version` AS `t1_c10`, `template`.`api_version` AS `t1_c11`, `template`.`view_folder` AS `t1_c12`, `template`.`files_folder` AS `t1_c13`, `template`.`description` AS `t1_c14`, `template`.`last_update` AS `t1_c15`, `template`.`owner_id` AS `t1_c16`, `template`.`extends` AS `t1_c17` FROM `templates` `template` WHERE (`template`.`name`=:ypl0). Bound with :ypl0='template_mffp_v2')</td> <td align="center">2</td> <td align="center">0.00038</td> <td align="center">0.00019</td> <td align="center">0.00019</td> <td align="center">0.00019</td> </tr> <tr style="background:#FFFFFF"> <td>system.db.CDbCommand.query(SELECT FROM `template_configuration` `t` WHERE template_name=:template_name AND sid IS NULL AND gsid IS NULL ORDER BY `t`.`template_name` LIMIT 1. Bound with :template_name='vanilla')</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.query(SELECT FROM `plugins` `t` WHERE `t`.`active`=:yp0. Bound with :yp0=1)</td> <td align="center">1</td> <td align="center">0.00033</td> <td align="center">0.00033</td> <td align="center">0.00033</td> <td align="center">0.00033</td> </tr> <tr style="background:#FFFFFF"> <td>system.db.CDbCommand.query(SELECT FROM `settings_global` `t` WHERE stg_name=:name LIMIT 1. Bound with :name='DBVersion')</td> <td align="center">1</td> <td align="center">0.00027</td> <td align="center">0.00027</td> <td align="center">0.00027</td> <td align="center">0.00027</td> </tr> <tr style="background:#F5F5F5"> <td>system.db.CDbCommand.query(SHOW CREATE TABLE `surveys`)</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(SELECT FROM `templates` `t` WHERE `t`.`name`='template_teq' LIMIT 1)</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 `surveys_languagesettings`)</td> <td align="center">1</td> <td align="center">0.00019</td> <td align="center">0.00019</td> <td align="center">0.00019</td> <td align="center">0.00019</td> </tr> <tr style="background:#FFFFFF"> <td>system.db.CDbCommand.query(SHOW CREATE TABLE `settings_global`)</td> <td align="center">1</td> <td align="center">0.00017</td> <td align="center">0.00017</td> <td align="center">0.00017</td> <td align="center">0.00017</td> </tr> <tr style="background:#F5F5F5"> <td>system.db.CDbCommand.query(SHOW CREATE TABLE `plugins`)</td> <td align="center">1</td> <td align="center">0.00016</td> <td align="center">0.00016</td> <td align="center">0.00016</td> <td align="center">0.00016</td> </tr> <tr style="background:#FFFFFF"> <td>system.db.CDbCommand.query(SHOW CREATE TABLE `templates`)</td> <td align="center">1</td> <td align="center">0.00016</td> <td align="center">0.00016</td> <td align="center">0.00016</td> <td align="center">0.00016</td> </tr> <tr style="background:#F5F5F5"> <td>system.db.CDbCommand.query(SHOW CREATE TABLE `template_configuration`)</td> <td align="center">1</td> <td align="center">0.00015</td> <td align="center">0.00015</td> <td align="center">0.00015</td> <td align="center">0.00015</td> </tr> <tr style="background:#FFFFFF"> <td>system.db.CDbCommand.query(SHOW CREATE TABLE `permissions`)</td> <td align="center">1</td> <td align="center">0.00011</td> <td align="center">0.00011</td> <td align="center">0.00011</td> <td align="center">0.00011</td> </tr></table> <!-- end of profiling summary -->

ollehar 2021-06-10 14:35 administrator ~64843	Nice, but can you please attach the HTML file and not copy paste? :) It's easier to read.

ollehar 2021-06-10 14:42 administrator ~64844	So strange. It seems as if the upgrade didn't happen at all. Are you using any special config? How does your config.php looks like? You can upload it here, private, but make sure to REMOVE any PASSWORDS first.

ollehar 2021-06-10 14:51 administrator ~64846	Alright, thanks. Nothing special there. Can you run "SHOW TABLES;" in your database to see if the table surveys_groupsettings was added at all? Then we can rule out caching problem. Paste the result of the command here.

ollehar 2021-06-10 16:08 administrator ~64849	Yes, something is wrong here. OK, please do: select * from settings_global where lime_settings_global.stg_name = 'dbversion'; This will show which dbversion you updated to.

yniquet 2021-06-10 16:17 reporter ~64850	mysql> select * from settings_global where lime_settings_global.stg_name = 'dbversion'; ERROR 1054 (42S22): Unknown column 'lime_settings_global.stg_name' in 'where clause' mysql>

yniquet 2021-06-10 16:24 reporter ~64851	mysql> select * from settings_global where settings_global.stg_name = 'DBVersion'; +-----------+-----------+ \| stg_name \| stg_value \| +-----------+-----------+ \| DBVersion \| 355 \| +-----------+-----------+ 1 row in set (0.00 sec)

ollehar 2021-06-10 19:37 administrator ~64855	Sorry, wrong prefix there. Good you found it.

ollehar 2021-06-10 19:40 administrator ~64856	Can you please navigate to the admin interface instead of the public survey list? Looks like you didn't trigger the database update procedure at all yet.

ollehar 2021-06-10 19:41 administrator ~64857	The address should be something like this: limesurvey2-lab.intranet.mm.gouv/index.php?r=admin

yniquet 2021-06-10 19:51 reporter ~64858	same result 2021-06-10 13_49_37-CDbException.png (61,293 bytes) 2021-06-10 13_49_37-CDbException.png (61,293 bytes)

ollehar 2021-06-10 19:54 administrator ~64859	And for limesurvey2-lab.intranet.mm.gouv/admin ?

yniquet 2021-06-10 19:57 reporter ~64860	YÉÉÉÉÉÉÉÉÉÉÉÉÉ 2021-06-10 13_56_14-LimeSurvey-Dev.png (22,736 bytes) 2021-06-10 13_56_14-LimeSurvey-Dev.png (22,736 bytes)

ollehar 2021-06-10 19:57 administrator ~64861	Another alternative is to run the update from command line instead of the browser: $ php application/commands/console.php updatedb If you cd into your web root.

ollehar 2021-06-10 19:58 administrator ~64862	Oh yeah, you got it. :D

yniquet 2021-06-10 20:03 reporter ~64863	I restore my DB LS 3 and retry, i have also set debug to 0 2021-06-10 13_59_37-PHP warning.png (38,434 bytes) 2021-06-10 13_59_37-PHP warning.png (38,434 bytes) 2021-06-10 14_01_20-LimeSurvey-Dev.png (9,561 bytes) 2021-06-10 14_01_20-LimeSurvey-Dev.png (9,561 bytes)

yniquet 2021-06-10 20:05 reporter ~64864	i will retry ...

ollehar 2021-06-10 20:06 administrator ~64865	I believe this is a bug in the new updatedb_helper.php file I linked you. Can you restore the previous one? That's the one in the 5.0.3 install package.

yniquet 2021-06-10 20:51 reporter ~64866	It's Works... 5.0.3 don't fix the problem for plugins page, need to change the value for of plugins_type to core in AuthDb table, Do you think i can in production with 5.0.3 Thank's a lot ! 2021-06-10 14_19_21-LimeSurvey-succes.png (22,755 bytes) 2021-06-10 14_19_21-LimeSurvey-succes.png (22,755 bytes) 2021-06-10 14_49_54-Mysql2Lab_limesurvey_2_lab_plugins_ - HeidiSQL 9.5.0.5278.png (36,959 bytes) 2021-06-10 14_49_54-Mysql2Lab_limesurvey_2_lab_plugins_ - HeidiSQL 9.5.0.5278.png (36,959 bytes)

ollehar 2021-06-10 20:55 administrator ~64867	need to change the value for of plugins_type to core in AuthDb table Yeah? We've had this problem reported in other places. I'll write it down. Do you think i can in production with 5.0.3 We consider 5.0.3 to be stable enough for medium-scale production usage, yes. But make sure to report any problems.

DenisChenu 2021-07-01 09:12 developer ~65173	@ollehar : See : https://forums.limesurvey.org/forum/installation-a-update-issues/124868-missing-configuration-file-for-plugin-authdb-after-upgrade-from-3-x-to-5-x#217748

ollehar 2021-07-01 09:19 administrator ~65174	Thanks!

ollehar 2021-07-01 09:20 administrator ~65175	Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=32162

Date Modified	Username	Field	Change
2021-06-09 14:39	yniquet	New Issue
2021-06-09 14:39	yniquet	File Added: 2021-06-09 08_32_18-CDbException.png
2021-06-09 14:56	ollehar	Note Added: 64801
2021-06-09 14:56	ollehar	Priority	none => immediate
2021-06-09 14:56	ollehar	Severity	block => crash
2021-06-09 14:56	ollehar	Description Updated
2021-06-09 15:10	ollehar	Sync to Zoho Project	=> \|Yes\|
2021-06-09 15:11	ollehar	Note Added: 64803
2021-06-09 16:14	ollehar	Note Added: 64804
2021-06-09 16:23	ollehar	Note Added: 64806
2021-06-09 16:23	ollehar	Assigned To	=> ollehar
2021-06-09 16:23	ollehar	Status	new => feedback
2021-06-09 16:29	yniquet	Note Added: 64807
2021-06-09 16:29	yniquet	Status	feedback => assigned
2021-06-09 16:31	ollehar	Note Added: 64808
2021-06-09 16:52	ollehar	Note Added: 64810
2021-06-09 16:52	ollehar	File Added: Selection_999(413).png
2021-06-09 16:52	ollehar	File Added: Selection_999(414).png
2021-06-09 16:53	ollehar	Note Added: 64811
2021-06-09 16:55	ollehar	Note Added: 64812
2021-06-09 17:00	ollehar	Note Added: 64813
2021-06-09 17:00	ollehar	Status	assigned => feedback
2021-06-09 17:01	yniquet	Status	feedback => assigned
2021-06-09 17:02	ollehar	Note Added: 64815
2021-06-09 17:08	yniquet	Note Added: 64816
2021-06-10 08:02	c_schmitz	Status	assigned => feedback
2021-06-10 08:02	c_schmitz	Note Added: 64821
2021-06-10 08:02	c_schmitz	Note Edited: 64821
2021-06-10 08:04	c_schmitz	Note Added: 64822
2021-06-10 08:15	c_schmitz	Note Added: 64823
2021-06-10 12:21	ollehar	Note Added: 64830
2021-06-10 12:21	ollehar	Status	feedback => ready for testing
2021-06-10 12:30	ollehar	Sync to Zoho Project	Yes => \|Yes\|
2021-06-10 12:30	ollehar	Working Git branch (developer only)	=> bug/17361-Upgrade-from-3.14.6-to-5.0.3-fails
2021-06-10 13:40	yniquet	Note Added: 64832
2021-06-10 13:43	ollehar	Note Added: 64833
2021-06-10 13:54	yniquet	Note Added: 64836
2021-06-10 13:58	ollehar	Note Added: 64837
2021-06-10 14:01	yniquet	Note Added: 64838
2021-06-10 14:01	yniquet	File Added: 2021-06-10 07_59_28-CDbException.png
2021-06-10 14:02	ollehar	Note Added: 64839
2021-06-10 14:25	yniquet	Note Added: 64840
2021-06-10 14:25	yniquet	File Added: 2021-06-10 08_21_15-CDbException.png
2021-06-10 14:26	ollehar	Note Added: 64841
2021-06-10 14:27	yniquet	Note Added: 64842
2021-06-10 14:35	ollehar	Note Added: 64843
2021-06-10 14:42	ollehar	Note Added: 64844
2021-06-10 14:51	ollehar	Note Added: 64846
2021-06-10 16:08	ollehar	Note Added: 64849
2021-06-10 16:17	yniquet	Note Added: 64850
2021-06-10 16:24	yniquet	Note Added: 64851
2021-06-10 19:37	ollehar	Note Added: 64855
2021-06-10 19:40	ollehar	Note Added: 64856
2021-06-10 19:41	ollehar	Note Added: 64857
2021-06-10 19:51	yniquet	Note Added: 64858
2021-06-10 19:51	yniquet	File Added: 2021-06-10 13_49_37-CDbException.png
2021-06-10 19:54	ollehar	Note Added: 64859
2021-06-10 19:57	yniquet	Note Added: 64860
2021-06-10 19:57	yniquet	File Added: 2021-06-10 13_56_14-LimeSurvey-Dev.png
2021-06-10 19:57	ollehar	Note Added: 64861
2021-06-10 19:58	ollehar	Note Added: 64862
2021-06-10 20:03	yniquet	Note Added: 64863
2021-06-10 20:03	yniquet	File Added: 2021-06-10 13_59_37-PHP warning.png
2021-06-10 20:03	yniquet	File Added: 2021-06-10 14_01_20-LimeSurvey-Dev.png
2021-06-10 20:05	yniquet	Note Added: 64864
2021-06-10 20:06	ollehar	Note Added: 64865
2021-06-10 20:51	yniquet	Note Added: 64866
2021-06-10 20:51	yniquet	File Added: 2021-06-10 14_19_21-LimeSurvey-succes.png
2021-06-10 20:51	yniquet	File Added: 2021-06-10 14_49_54-Mysql2Lab_limesurvey_2_lab_plugins_ - HeidiSQL 9.5.0.5278.png
2021-06-10 20:55	ollehar	Note Added: 64867
2021-06-14 16:08	ollehar	Priority	immediate => normal
2021-06-14 16:08	ollehar	Summary	upgrade from 3.14.6 to version 5.0.3 fails for missing table => upgrade from 3.14.6 to version 5.0.3 fails for missing table (lack of maintenance page for public survey list)
2021-06-14 16:08	ollehar	Sync to Zoho Project	Yes => \|Yes\|
2021-07-01 09:12	DenisChenu	Note Added: 65173
2021-07-01 09:19	ollehar	Note Added: 65174
2021-07-01 09:20	ollehar	Changeset attached	=> LimeSurvey master 01497431
2021-07-01 09:20	ollehar	Note Added: 65175
2021-07-01 09:20	ollehar	Resolution	open => fixed
2021-07-21 17:28	ollehar	Issue Monitored: ollehar
2021-07-21 17:28	ollehar	Status	ready for testing => resolved
2021-08-12 08:46	c_schmitz	Status	resolved => closed

LimeSurvey: master 01497431 2021-07-01 09:20:44 ollehar Details Diff	Fixed issue 17361: Upgrade from 3.14.6 to version 5.0.3 fails		Affected Issues 17361
	mod - application/helpers/update/updatedb_helper.php		Diff File

View Issue Details

Users monitoring this issue

Activities

Related Changesets

Issue History