I'm getting the error below on checking integrity after a ComfortUpdate to latest.  Any ideas?

500: Internal Server Error
CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups g ON t.gid=g.gid WHERE (g.gid IS NULL)' at line 1

Latest stable (3.x) or latest unstable (4.x)?

LimeSurvey
Version 4.5.2+210426

I note also that if I try click on Resources on a survey, browser hangs and I see this in Console:

[Error] Failed to load resource: the server responded with a status of 404 (Not Found) (index.php, line 0)

In Chrome, Console error on clicking Resources is:

pjax.combined.min.js:1 GET https://<snip.host.name>/index.php?r=admin/filemanager&surveyid=812247&1619638071465 404 (Not Found)
m @ pjax.combined.min.js:1
value @ pjax.combined.min.js:1
v @ pjax.combined.min.js:1
(anonymous) @ pjax.combined.min.js:1

LS 4.x is still unstable, so these things might happen.

As you are a paying customer of the ComfortUpdate, I would open a support ticket with the Limesurvey GmbH. Sounds like some files have not made it to the server with the ComfortUpdate.

The debug logging is:

CDbException
CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups g ON t.gid=g.gid WHERE (g.gid IS NULL)' at line 1. The SQL statement executed was: SELECT `t`.`id`, `t`.`gid`, `t`.`group_name`, `t`.`description`, `t`.`language` FROM `group_l10ns` `t` LEFT JOIN groups g ON t.gid=g.gid WHERE (g.gid IS NULL)

/var/www/html/limesurvey/framework/db/CDbCommand.php(543)

531 {
532 if($this->_connection->enableProfiling)
533 Yii::endProfile('system.db.CDbCommand.query('.$this->getText().$par.')','system.db.CDbCommand.query');
534
535 $errorInfo=$e instanceof PDOException ? $e->errorInfo : null;
536 $message=$e->getMessage();
537 Yii::log(Yii::t('yii','CDbCommand::{method}() failed: {error}. The SQL statement executed was: {sql}.',
538 array('{method}'=>$method, '{error}'=>$message, '{sql}'=>$this->getText().$par)),CLogger::LEVEL_ERROR,'system.db.CDbCommand');
539
540 if(YII_DEBUG)
541 $message.='. The SQL statement executed was: '.$this->getText().$par;
542
543 throw new CDbException(Yii::t('yii','CDbCommand failed to execute the SQL statement: {error}',
544 array('{error}'=>$message)),(int)$e->getCode(),$errorInfo);
545 }
546 }
547
548 /**
549 * Builds a SQL SELECT statement from the given query specification.
550 * @param array $query the query specification in name-value pairs. The following
551 * query options are supported: {@link select}, {@link distinct}, {@link from},
552 * {@link where}, {@link join}, {@link group}, {@link having}, {@link order},
553 * {@link limit}, {@link offset} and {@link union}.
554 * @throws CDbException if "from" key is not present in given query parameter
555 * @return string the SQL statement
Stack Trace
#0
+ /var/www/html/limesurvey/framework/db/CDbCommand.php(396): CDbCommand->queryInternal()
#1
+ /var/www/html/limesurvey/framework/db/ar/CActiveRecord.php(1359): CDbCommand->queryAll()
#2
– /var/www/html/limesurvey/application/models/LSActiveRecord.php(74): CActiveRecord->query()
69 * @since 1.1.7
70 */
71 protected function query($criteria, $all = false, $asAR = true)
72 {
73 if ($asAR === true) {
74 return parent::query($criteria, $all);
75 } else {
76 $this->beforeFind();
77 $this->applyScopes($criteria);
78 if (!$all) {
79 $criteria->limit = 1;
#3
+ /var/www/html/limesurvey/framework/db/ar/CActiveRecord.php(1478): LSActiveRecord->query()
#4
– /var/www/html/limesurvey/application/controllers/admin/checkintegrity.php(929): CActiveRecord->findAll()
924 /**********************************************************************/
925 $oCriteria = new CDbCriteria();
926 $oCriteria->join = 'LEFT JOIN {{groups}} g ON t.gid=g.gid';
927 $oCriteria->condition = '(g.gid IS NULL)';
928
929 $groups = QuestionGroupL10n::model()->resetScope()->findAll($oCriteria);
930 foreach ($groups as $group) {
931 $aDelete[] = array('id' => $group, 'gid' => $group, 'reason' => gT('No parent group'));
932 }
933
934 /**********************************************************************/
#5
– /var/www/html/limesurvey/application/controllers/admin/checkintegrity.php(41): CheckIntegrity->_checkintegrity()
36 Yii::app()->loadHelper('surveytranslator');
37 }
38
39 public function index()
40 {
41 $aData = $this->_checkintegrity();
42
43
44 $aData = 'admin/index';
45 $aData = gT('Return to admin home');
46
#6
unknown(0): CheckIntegrity->index()
#7
+ /var/www/html/limesurvey/framework/web/actions/CAction.php(109): ReflectionMethod->invokeArgs()
#8
+ /var/www/html/limesurvey/application/core/Survey_Common_Action.php(86): CAction->runWithParamsInternal()
#9
+ /var/www/html/limesurvey/framework/web/CController.php(308): Survey_Common_Action->runWithParams()
#10
+ /var/www/html/limesurvey/framework/web/CController.php(286): CController->runAction()
#11
+ /var/www/html/limesurvey/framework/web/CController.php(265): CController->runActionWithFilters()
#12
+ /var/www/html/limesurvey/application/controllers/AdminController.php(202): CController->run()
#13
+ /var/www/html/limesurvey/framework/web/CWebApplication.php(282): AdminController->run()
#14
+ /var/www/html/limesurvey/framework/web/CWebApplication.php(141): CWebApplication->runController()
#15
+ /var/www/html/limesurvey/framework/base/CApplication.php(185): CWebApplication->processRequest()
#16
+ /var/www/html/limesurvey/index.php(182): CApplication->run()
2021-04-28 21:48:35 nginx/1.18.0 Yii Framework/1.1.22-dev
Profiling Summary Report (Time: 1.48760s, Memory: 10,094KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
system.db.CDbCommand.query(SELECT * FROM `users` `t` WHERE `t`.`uid`=2 LIMIT 1) 23 0.07830 0.00340 0.00327 0.00353
system.db.CDbCommand.query(SELECT `t`.`gsid` AS `t0_c0`, `t`.`owner_id` AS `t0_c1`, `t`.`admin` AS `t0_c2`, `t`.`adminemail` AS `t0_c3`, `t`.`anonymized` AS `t0_c4`, `t`.`format` AS `t0_c5`, `t`.`savetimings` AS `t0_c6`, `t`.`template` AS `t0_c7`, `t`.`datestamp` AS `t0_c8`, `t`.`usecookie` AS `t0_c9`, `t`.`allowregister` AS `t0_c10`, `t`.`allowsave` AS `t0_c11`, `t`.`autonumber_start` AS `t0_c12`, `t`.`autoredirect` AS `t0_c13`, `t`.`allowprev` AS `t0_c14`, `t`.`printanswers` AS `t0_c15`, `t`.`ipaddr` AS `t0_c16`, `t`.`ipanonymize` AS `t0_c17`, `t`.`refurl` AS `t0_c18`, `t`.`showsurveypolicynotice` AS `t0_c19`, `t`.`publicstatistics` AS `t0_c20`, `t`.`publicgraphs` AS `t0_c21`, `t`.`listpublic` AS `t0_c22`, `t`.`htmlemail` AS `t0_c23`, `t`.`sendconfirmation` AS `t0_c24`, `t`.`tokenanswerspersistence` AS `t0_c25`, `t`.`assessments` AS `t0_c26`, `t`.`usecaptcha` AS `t0_c27`, `t`.`bounce_email` AS `t0_c28`, `t`.`attributedescriptions` AS `t0_c29`, `t`.`emailresponseto` AS `t0_c30`, `t`.`emailnotificationto` AS `t0_c31`, `t`.`tokenlength` AS `t0_c32`, `t`.`showxquestions` AS `t0_c33`, `t`.`showgroupinfo` AS `t0_c34`, `t`.`shownoanswer` AS `t0_c35`, `t`.`showqnumcode` AS `t0_c36`, `t`.`showwelcome` AS `t0_c37`, `t`.`showprogress` AS `t0_c38`, `t`.`questionindex` AS `t0_c39`, `t`.`navigationdelay` AS `t0_c40`, `t`.`nokeyboard` AS `t0_c41`, `t`.`alloweditaftercompletion` AS `t0_c42`, `SurveysGroups`.`gsid` AS `t1_c0`, `SurveysGroups`.`name` AS `t1_c1`, `SurveysGroups`.`title` AS `t1_c2`, `SurveysGroups`.`template` AS `t1_c3`, `SurveysGroups`.`description` AS `t1_c4`, `SurveysGroups`.`sortorder` AS `t1_c5`, `SurveysGroups`.`owner_id` AS `t1_c6`, `SurveysGroups`.`parent_id` AS `t1_c7`, `SurveysGroups`.`created` AS `t1_c8`, `SurveysGroups`.`modified` AS `t1_c9`, `SurveysGroups`.`created_by` AS `t1_c10`, `SurveysGroups`.`alwaysavailable` AS `t1_c11` FROM `surveys_groupsettings` `t` LEFT OUTER JOIN `surveys_groups` `SurveysGroups` ON (`SurveysGroups`.`gsid`=`t`.`gsid`) WHERE (`t`.`gsid`=1)) 12 0.04606 0.00384 0.00366 0.00432
system.db.CDbCommand.query(SELECT * FROM `surveys_groupsettings` `t` WHERE `t`.`gsid`=0 LIMIT 1) 12 0.04313 0.00359 0.00348 0.00381
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `surveys`) 3 0.02108 0.00703 0.00681 0.00744
system.db.CDbCommand.query(SELECT `t`.`id`, `t`.`aid`, `t`.`answer`, `t`.`language` FROM `answer_l10ns` `t` LEFT JOIN answers a ON t.aid=a.aid WHERE (a.aid IS NULL)) 1 0.01964 0.01964 0.01964 0.01964
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `templates`) 3 0.01919 0.00640 0.00527 0.00805
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `users`) 3 0.01624 0.00541 0.00533 0.00545
system.db.CDbCommand.query(SHOW CREATE TABLE `templates`) 3 0.01419 0.00473 0.00328 0.00754
system.db.CDbCommand.query(SHOW CREATE TABLE `expression_errors`) 1 0.01373 0.01373 0.01373 0.01373
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `surveys_groupsettings`) 2 0.01220 0.00610 0.00607 0.00613
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `surveys_languagesettings`) 2 0.01187 0.00594 0.00555 0.00633
system.db.CDbCommand.query(SELECT `sq`.`qid`, `q`.`gid`, `q`.`type` FROM `questions` `sq` JOIN `questions` `q` ON sq.parent_qid=q.qid WHERE sq.parent_qid>0 AND (sq.gid!=q.gid or sq.type!=q.type) LIMIT 10000) 1 0.01141 0.01141 0.01141 0.01141
system.db.CDbCommand.query(SHOW CREATE TABLE `surveys`) 3 0.01118 0.00373 0.00358 0.00400
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `quota`) 2 0.01054 0.00527 0.00497 0.00557
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `questions`) 2 0.01053 0.00526 0.00519 0.00534
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `quota_languagesettings`) 2 0.01044 0.00522 0.00506 0.00538
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `assessments`) 2 0.01038 0.00519 0.00519 0.00520
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `defaultvalues`) 2 0.01037 0.00518 0.00510 0.00526
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `question_attributes`) 2 0.01025 0.00513 0.00479 0.00546
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `answers`) 2 0.01022 0.00511 0.00508 0.00514
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `answer_l10ns`) 2 0.01010 0.00505 0.00493 0.00516
system.db.CDbCommand.query(SHOW CREATE TABLE `old_survey_618283_20201111162054`) 1 0.01009 0.01009 0.01009 0.01009
system.db.CDbCommand.query(SHOW CREATE TABLE `map_tutorial_users`) 1 0.01009 0.01009 0.01009 0.01009
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `surveys_groups`) 2 0.01004 0.00502 0.00502 0.00502
system.db.CDbCommand.query(SELECT `t`.`id`, `t`.`qid`, `t`.`question`, `t`.`help`, `t`.`script`, `t`.`language` FROM `question_l10ns` `t` LEFT JOIN questions q ON t.qid=q.qid WHERE (q.qid IS NULL)) 1 0.01003 0.01003 0.01003 0.01003
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `question_themes`) 2 0.01003 0.00501 0.00447 0.00556
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `quota_members`) 2 0.00997 0.00499 0.00483 0.00515
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `groups`) 2 0.00996 0.00498 0.00493 0.00504
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `group_l10ns`) 2 0.00995 0.00498 0.00488 0.00507
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `plugins`) 2 0.00995 0.00498 0.00497 0.00498
system.db.CDbCommand.query(SELECT `t`.`qid`, `t`.`parent_qid`, `t`.`sid`, `t`.`gid`, `t`.`type`, `t`.`title`, `t`.`preg`, `t`.`other`, `t`.`mandatory`, `t`.`encrypted`, `t`.`question_order`, `t`.`scale_id`, `t`.`same_default`, `t`.`relevance`, `t`.`modulename` FROM `questions` `t` LEFT JOIN surveys s ON t.sid=s.sid LEFT JOIN `groups` g ON t.gid=g.gid WHERE (g.gid IS NULL) OR (s.sid IS NULL)) 1 0.00990 0.00990 0.00990 0.00990
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `question_l10ns`) 2 0.00984 0.00492 0.00489 0.00495
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `permissions`) 2 0.00977 0.00488 0.00466 0.00510
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `settings_global`) 2 0.00976 0.00488 0.00471 0.00505
system.db.CDbCommand.query(SHOW CREATE TABLE `users`) 3 0.00975 0.00325 0.00322 0.00331
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `old_survey_557875_20210428073430`) 1 0.00925 0.00925 0.00925 0.00925
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `old_survey_3_20201109134907`) 1 0.00925 0.00925 0.00925 0.00925
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `old_survey_618283_20201111162054`) 1 0.00919 0.00919 0.00919 0.00919
system.db.CDbCommand.query(SHOW CREATE TABLE `old_survey_3_20201109134907`) 1 0.00895 0.00895 0.00895 0.00895
system.db.CDbCommand.query(SHOW CREATE TABLE `old_survey_586118_20201203103642`) 1 0.00885 0.00885 0.00885 0.00885
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `old_survey_1709_20200918085005`) 1 0.00855 0.00855 0.00855 0.00855
system.db.CDbCommand.query(SHOW CREATE TABLE `old_survey_557875_20210428073430`) 1 0.00849 0.00849 0.00849 0.00849
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `old_survey_586118_20201203103642`) 1 0.00845 0.00845 0.00845 0.00845
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `old_survey_1809_20201110120344`) 1 0.00831 0.00831 0.00831 0.00831
system.db.CDbCommand.query(SELECT `t`.`aid`, `t`.`qid`, `t`.`code`, `t`.`sortorder`, `t`.`assessment_value`, `t`.`scale_id` FROM `answers` `t` LEFT JOIN questions q ON t.qid=q.qid WHERE (q.qid IS NULL)) 1 0.00748 0.00748 0.00748 0.00748
system.db.CDbCommand.query(SHOW CREATE TABLE `old_survey_1809_20201110120344`) 1 0.00730 0.00730 0.00730 0.00730
system.db.CDbCommand.query(SHOW CREATE TABLE `defaultvalues`) 2 0.00724 0.00362 0.00341 0.00384
system.db.CDbCommand.query(select qid from question_attributes where qid not in (select qid from questions)) 1 0.00721 0.00721 0.00721 0.00721
system.db.CDbCommand.query(SHOW CREATE TABLE `surveys_groupsettings`) 2 0.00700 0.00350 0.00341 0.00359
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `old_survey_772281_20201203083053`) 1 0.00699 0.00699 0.00699 0.00699
system.db.CDbCommand.query(SHOW CREATE TABLE `old_survey_1709_20200918085005`) 1 0.00690 0.00690 0.00690 0.00690
system.db.CDbCommand.query(SHOW CREATE TABLE `surveys_languagesettings`) 2 0.00690 0.00345 0.00339 0.00351
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `expression_errors`) 1 0.00687 0.00687 0.00687 0.00687
system.db.CDbCommand.query(SHOW CREATE TABLE `quota`) 2 0.00684 0.00342 0.00333 0.00351
system.db.CDbCommand.query(SHOW CREATE TABLE `assessments`) 2 0.00677 0.00338 0.00337 0.00340
system.db.CDbCommand.query(SELECT * FROM `users` `t` WHERE `t`.`uid`=1 LIMIT 1) 2 0.00676 0.00338 0.00330 0.00346
system.db.CDbCommand.query(SHOW CREATE TABLE `answers`) 2 0.00674 0.00337 0.00336 0.00338
system.db.CDbCommand.query(SHOW CREATE TABLE `quota_members`) 2 0.00674 0.00337 0.00326 0.00348
system.db.CDbCommand.query(SHOW CREATE TABLE `quota_languagesettings`) 2 0.00672 0.00336 0.00333 0.00339
system.db.CDbCommand.query(SHOW CREATE TABLE `groups`) 2 0.00662 0.00331 0.00324 0.00338
system.db.CDbCommand.query(SHOW CREATE TABLE `answer_l10ns`) 2 0.00659 0.00329 0.00323 0.00336
system.db.CDbCommand.query(SHOW CREATE TABLE `group_l10ns`) 2 0.00652 0.00326 0.00323 0.00329
system.db.CDbCommand.query(SHOW CREATE TABLE `surveys_groups`) 2 0.00647 0.00324 0.00319 0.00328
system.db.CDbCommand.query(SHOW CREATE TABLE `question_l10ns`) 2 0.00646 0.00323 0.00316 0.00331
system.db.CDbCommand.query(SHOW CREATE TABLE `plugins`) 2 0.00645 0.00323 0.00316 0.00329
system.db.CDbCommand.query(SHOW CREATE TABLE `question_themes`) 2 0.00645 0.00323 0.00320 0.00325
system.db.CDbCommand.query(SHOW CREATE TABLE `permissions`) 2 0.00640 0.00320 0.00310 0.00330
system.db.CDbCommand.query(SELECT * FROM `question_themes` `t` WHERE `t`.`extends`=:yp0. Bound with :yp0='') 1 0.00640 0.00640 0.00640 0.00640
system.db.CDbCommand.query(SHOW CREATE TABLE `questions`) 2 0.00639 0.00319 0.00317 0.00322
system.db.CDbCommand.query(SHOW CREATE TABLE `question_attributes`) 2 0.00638 0.00319 0.00312 0.00326
system.db.CDbCommand.query(SHOW CREATE TABLE `settings_global`) 2 0.00630 0.00315 0.00315 0.00315
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `old_survey_545886_20201127081154`) 1 0.00614 0.00614 0.00614 0.00614
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tutorials`) 1 0.00603 0.00603 0.00603 0.00603
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `saved_control`) 1 0.00600 0.00600 0.00600 0.00600
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `user_groups`) 1 0.00578 0.00578 0.00578 0.00578
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `labelsets`) 1 0.00572 0.00572 0.00572 0.00572
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `user_in_permissionrole`) 1 0.00570 0.00570 0.00570 0.00570
system.db.CDbCommand.query(SHOW CREATE TABLE `old_survey_772281_20201203083053`) 1 0.00569 0.00569 0.00569 0.00569
system.db.CDbCommand.query(SHOW TABLES) 1 0.00568 0.00568 0.00568 0.00568
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tutorial_entry_relation`) 1 0.00568 0.00568 0.00568 0.00568
system.db.CDbCommand.query(SHOW CREATE TABLE `old_survey_975678_20201203083011`) 1 0.00563 0.00563 0.00563 0.00563
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `label_l10ns`) 1 0.00563 0.00563 0.00563 0.00563
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `old_survey_975678_20201203083011`) 1 0.00561 0.00561 0.00561 0.00561
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `permissiontemplates`) 1 0.00559 0.00559 0.00559 0.00559
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `labels`) 1 0.00556 0.00556 0.00556 0.00556
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `user_in_groups`) 1 0.00555 0.00555 0.00555 0.00555
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `survey_url_parameters`) 1 0.00550 0.00550 0.00550 0.00550
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `surveymenu_entries`) 1 0.00550 0.00550 0.00550 0.00550
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tutorial_entries`) 1 0.00548 0.00548 0.00548 0.00548
system.db.CDbCommand.query(SHOW CREATE TABLE `tutorials`) 1 0.00547 0.00547 0.00547 0.00547
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `map_tutorial_users`) 1 0.00545 0.00545 0.00545 0.00545
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `survey_links`) 1 0.00542 0.00542 0.00542 0.00542
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `notifications`) 1 0.00540 0.00540 0.00540 0.00540
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `sessions`) 1 0.00539 0.00539 0.00539 0.00539
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `surveymenu`) 1 0.00532 0.00532 0.00532 0.00532
system.db.CDbCommand.query(SHOW CREATE TABLE `participants`) 1 0.00529 0.00529 0.00529 0.00529
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `participants`) 1 0.00521 0.00521 0.00521 0.00521
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `template_configuration`) 1 0.00520 0.00520 0.00520 0.00520
system.db.CDbCommand.query(SHOW CREATE TABLE `saved_control`) 1 0.00520 0.00520 0.00520 0.00520
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `boxes`) 1 0.00514 0.00514 0.00514 0.00514
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `conditions`) 1 0.00514 0.00514 0.00514 0.00514
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `defaultvalue_l10ns`) 1 0.00514 0.00514 0.00514 0.00514
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `participant_attribute_names`) 1 0.00512 0.00512 0.00512 0.00512
system.db.CDbCommand.query(SHOW CREATE TABLE `tutorial_entries`) 1 0.00509 0.00509 0.00509 0.00509
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `failed_login_attempts`) 1 0.00507 0.00507 0.00507 0.00507
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `participant_shares`) 1 0.00502 0.00502 0.00502 0.00502
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `participant_attribute_names_lang`) 1 0.00501 0.00501 0.00501 0.00501
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `participant_attribute`) 1 0.00498 0.00498 0.00498 0.00498
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `participant_attribute_values`) 1 0.00495 0.00495 0.00495 0.00495
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `asset_version`) 1 0.00494 0.00494 0.00494 0.00494
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `plugin_settings`) 1 0.00490 0.00490 0.00490 0.00490
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `settings_user`) 1 0.00482 0.00482 0.00482 0.00482
system.db.CDbCommand.execute(DELETE `permissions` FROM `permissions` LEFT JOIN users u ON permissions.uid=u.uid WHERE (u.uid IS NULL)) 1 0.00481 0.00481 0.00481 0.00481
system.db.CDbCommand.query(SHOW TABLES LIKE 'survey\_%') 1 0.00478 0.00478 0.00478 0.00478
system.db.CDbCommand.execute(DELETE `permissions` FROM `permissions` LEFT JOIN surveys s ON permissions.entity_id=s.sid WHERE (s.sid IS NULL AND entity='survey')) 1 0.00477 0.00477 0.00477 0.00477
system.db.CDbCommand.query(SHOW TABLES LIKE 'tokens\_%') 1 0.00469 0.00469 0.00469 0.00469
system.db.CDbCommand.query(SHOW CREATE TABLE `old_survey_545886_20201127081154`) 1 0.00458 0.00458 0.00458 0.00458
system.db.CDbCommand.query(SHOW CREATE TABLE `survey_links`) 1 0.00435 0.00435 0.00435 0.00435
system.db.CDbCommand.query(SHOW CREATE TABLE `permissiontemplates`) 1 0.00433 0.00433 0.00433 0.00433
system.db.CDbCommand.query(SELECT * FROM `settings_global` `t`) 1 0.00429 0.00429 0.00429 0.00429
system.db.CDbCommand.query(SHOW CREATE TABLE `tutorial_entry_relation`) 1 0.00428 0.00428 0.00428 0.00428
system.db.CDbCommand.query(SHOW CREATE TABLE `user_groups`) 1 0.00427 0.00427 0.00427 0.00427
system.db.CDbCommand.query(SELECT `t`.`surveyls_survey_id` AS `t0_c0`, `t`.`surveyls_language` AS `t0_c1`, `survey`.`sid` AS `t1_c0`, `survey`.`owner_id` AS `t1_c1`, `survey`.`gsid` AS `t1_c2`, `survey`.`admin` AS `t1_c3`, `survey`.`active` AS `t1_c4`, `survey`.`expires` AS `t1_c5`, `survey`.`startdate` AS `t1_c6`, `survey`.`adminemail` AS `t1_c7`, `survey`.`anonymized` AS `t1_c8`, `survey`.`faxto` AS `t1_c9`, `survey`.`format` AS `t1_c10`, `survey`.`savetimings` AS `t1_c11`, `survey`.`template` AS `t1_c12`, `survey`.`language` AS `t1_c13`, `survey`.`additional_languages` AS `t1_c14`, `survey`.`datestamp` AS `t1_c15`, `survey`.`usecookie` AS `t1_c16`, `survey`.`allowregister` AS `t1_c17`, `survey`.`allowsave` AS `t1_c18`, `survey`.`autonumber_start` AS `t1_c19`, `survey`.`autoredirect` AS `t1_c20`, `survey`.`allowprev` AS `t1_c21`, `survey`.`printanswers` AS `t1_c22`, `survey`.`ipaddr` AS `t1_c23`, `survey`.`ipanonymize` AS `t1_c24`, `survey`.`refurl` AS `t1_c25`, `survey`.`datecreated` AS `t1_c26`, `survey`.`showsurveypolicynotice` AS `t1_c27`, `survey`.`publicstatistics` AS `t1_c28`, `survey`.`publicgraphs` AS `t1_c29`, `survey`.`listpublic` AS `t1_c30`, `survey`.`htmlemail` AS `t1_c31`, `survey`.`sendconfirmation` AS `t1_c32`, `survey`.`tokenanswerspersistence` AS `t1_c33`, `survey`.`assessments` AS `t1_c34`, `survey`.`usecaptcha` AS `t1_c35`, `survey`.`usetokens` AS `t1_c36`, `survey`.`bounce_email` AS `t1_c37`, `survey`.`attributedescriptions` AS `t1_c38`, `survey`.`emailresponseto` AS `t1_c39`, `survey`.`emailnotificationto` AS `t1_c40`, `survey`.`tokenlength` AS `t1_c41`, `survey`.`showxquestions` AS `t1_c42`, `survey`.`showgroupinfo` AS `t1_c43`, `survey`.`shownoanswer` AS `t1_c44`, `survey`.`showqnumcode` AS `t1_c45`, `survey`.`bouncetime` AS `t1_c46`, `survey`.`bounceprocessing` AS `t1_c47`, `survey`.`bounceaccounttype` AS `t1_c48`, `survey`.`bounceaccounthost` AS `t1_c49`, `survey`.`bounceaccountpass` AS `t1_c50`, `survey`.`bounceaccountencryption` AS `t1_c51`, `survey`.`bounceaccountuser` AS `t1_c52`, `survey`.`showwelcome` AS `t1_c53`, `survey`.`showprogress` AS `t1_c54`, `survey`.`questionindex` AS `t1_c55`, `survey`.`navigationdelay` AS `t1_c56`, `survey`.`nokeyboard` AS `t1_c57`, `survey`.`alloweditaftercompletion` AS `t1_c58`, `survey`.`googleanalyticsstyle` AS `t1_c59`, `survey`.`googleanalyticsapikey` AS `t1_c60`, `survey`.`tokenencryptionoptions` AS `t1_c61` FROM `surveys_languagesettings` `t` LEFT OUTER JOIN `surveys` `survey` ON (t.surveyls_survey_id = survey.sid) WHERE (survey.sid IS NULL)) 1 0.00424 0.00424 0.00424 0.00424
system.db.CDbCommand.query(SHOW CREATE TABLE `survey_url_parameters`) 1 0.00416 0.00416 0.00416 0.00416
system.db.CDbCommand.query(SELECT `t`.`gid`, `t`.`sid`, `t`.`group_order`, `t`.`randomization_group`, `t`.`grelevance` FROM `groups` `t` LEFT JOIN surveys s ON t.sid=s.sid WHERE (s.sid IS NULL)) 1 0.00414 0.00414 0.00414 0.00414
system.db.CDbCommand.query(SHOW CREATE TABLE `user_in_groups`) 1 0.00411 0.00411 0.00411 0.00411
system.db.CDbCommand.query(SHOW CREATE TABLE `labels`) 1 0.00411 0.00411 0.00411 0.00411
system.db.CDbCommand.query(SELECT * FROM `surveys` `t`) 1 0.00410 0.00410 0.00410 0.00410
system.db.CDbCommand.query(SHOW CREATE TABLE `participant_attribute_names`) 1 0.00402 0.00402 0.00402 0.00402
system.db.CDbCommand.query(SHOW CREATE TABLE `participant_attribute_names_lang`) 1 0.00401 0.00401 0.00401 0.00401
system.db.CDbCommand.query(SHOW CREATE TABLE `user_in_permissionrole`) 1 0.00400 0.00400 0.00400 0.00400
system.db.CDbCommand.query(SELECT * FROM `surveys` `t` ORDER BY sid) 1 0.00399 0.00399 0.00399 0.00399
system.db.CDbCommand.query(SHOW CREATE TABLE `label_l10ns`) 1 0.00397 0.00397 0.00397 0.00397
system.db.CDbCommand.query(SHOW CREATE TABLE `participant_attribute`) 1 0.00392 0.00392 0.00392 0.00392
system.db.CDbCommand.query(SHOW CREATE TABLE `labelsets`) 1 0.00392 0.00392 0.00392 0.00392
system.db.CDbCommand.query(SHOW CREATE TABLE `sessions`) 1 0.00391 0.00391 0.00391 0.00391
system.db.CDbCommand.query(SHOW CREATE TABLE `participant_shares`) 1 0.00389 0.00389 0.00389 0.00389
system.db.CDbCommand.query(SHOW CREATE TABLE `participant_attribute_values`) 1 0.00387 0.00387 0.00387 0.00387
system.db.CDbCommand.query(SELECT COUNT(*) FROM `questions` `t` WHERE `t`.`qid`=:yp0. Bound with :yp0='1961') 1 0.00376 0.00376 0.00376 0.00376
system.db.CDbCommand.query(SELECT cqid,cid,cfieldname FROM conditions) 1 0.00375 0.00375 0.00375 0.00375
system.db.CDbCommand.query(SELECT * FROM `surveys_languagesettings` `t` WHERE surveyls_survey_id=:surveyid AND surveyls_language=:langname LIMIT 1. Bound with :surveyid='723217', :langname='en') 1 0.00374 0.00374 0.00374 0.00374
system.db.CDbCommand.query(SELECT * FROM `surveys_languagesettings` `t` WHERE surveyls_survey_id=:surveyid AND surveyls_language=:langname LIMIT 1. Bound with :surveyid='812247', :langname='en') 1 0.00372 0.00372 0.00372 0.00372
system.db.CDbCommand.query(SELECT * FROM `surveys_languagesettings` `t` WHERE surveyls_survey_id=:surveyid AND surveyls_language=:langname LIMIT 1. Bound with :surveyid='557875', :langname='en') 1 0.00371 0.00371 0.00371 0.00371
system.db.CDbCommand.query(SELECT * FROM `surveys_languagesettings` `t` WHERE surveyls_survey_id=:surveyid AND surveyls_language=:langname LIMIT 1. Bound with :surveyid='586118', :langname='en') 1 0.00368 0.00368 0.00368 0.00368
system.db.CDbCommand.query(SELECT * FROM `surveys_languagesettings` `t` WHERE surveyls_survey_id=:surveyid AND surveyls_language=:langname LIMIT 1. Bound with :surveyid='588569', :langname='en') 1 0.00364 0.00364 0.00364 0.00364
system.db.CDbCommand.query(SELECT * FROM `templates` `t` WHERE `t`.`name`='fruity' LIMIT 1) 1 0.00360 0.00360 0.00360 0.00360
system.db.CDbCommand.query(SELECT * FROM `surveys_languagesettings` `t` WHERE surveyls_survey_id=:surveyid AND surveyls_language=:langname LIMIT 1. Bound with :surveyid='963423', :langname='en') 1 0.00359 0.00359 0.00359 0.00359
system.db.CDbCommand.query(SELECT * FROM `templates` `t` WHERE `t`.`name`='LS Gravity' LIMIT 1) 1 0.00351 0.00351 0.00351 0.00351
system.db.CDbCommand.query(SHOW CREATE TABLE `conditions`) 1 0.00349 0.00349 0.00349 0.00349
system.db.CDbCommand.query(SELECT * FROM `plugins` `t` WHERE `t`.`active`=:yp0 ORDER BY priority DESC. Bound with :yp0=1) 1 0.00349 0.00349 0.00349 0.00349
system.db.CDbCommand.query(SHOW CREATE TABLE `failed_login_attempts`) 1 0.00347 0.00347 0.00347 0.00347
system.db.CDbCommand.query(SELECT `t`.`id`, `t`.`sid`, `t`.`name`, `t`.`qlimit`, `t`.`action`, `t`.`active`, `t`.`autoload_url` FROM `quota` `t` LEFT JOIN surveys s ON t.sid=s.sid WHERE (s.sid IS NULL)) 1 0.00346 0.00346 0.00346 0.00346
system.db.CDbCommand.query(SELECT COUNT(*) FROM `questions` `t` WHERE `t`.`qid`=:yp0. Bound with :yp0='1746') 1 0.00345 0.00345 0.00345 0.00345
system.db.CDbCommand.query(SELECT COUNT(*) FROM `questions` `t` WHERE `t`.`qid`=:yp0. Bound with :yp0='1619') 1 0.00344 0.00344 0.00344 0.00344
system.db.CDbCommand.query(SELECT COUNT(*) FROM `questions` `t` WHERE `t`.`qid`=:yp0. Bound with :yp0='1621') 1 0.00341 0.00341 0.00341 0.00341
system.db.CDbCommand.query(SELECT COUNT(*) FROM `questions` `t` WHERE `t`.`qid`=:yp0. Bound with :yp0='1792') 1 0.00341 0.00341 0.00341 0.00341
system.db.CDbCommand.query(SELECT COUNT(*) FROM `questions` `t` WHERE `t`.`qid`=:yp0. Bound with :yp0='1757') 1 0.00340 0.00340 0.00340 0.00340
system.db.CDbCommand.query(SELECT COUNT(*) FROM `questions` `t` WHERE `t`.`qid`=:yp0. Bound with :yp0='1620') 1 0.00340 0.00340 0.00340 0.00340
system.db.CDbCommand.query(SELECT COUNT(*) FROM `questions` `t` WHERE `t`.`qid`=:yp0. Bound with :yp0='1803') 1 0.00339 0.00339 0.00339 0.00339
system.db.CDbCommand.query(SHOW CREATE TABLE `boxes`) 1 0.00339 0.00339 0.00339 0.00339
system.db.CDbCommand.query(SELECT `t`.`dvid`, `t`.`qid`, `t`.`scale_id`, `t`.`sqid`, `t`.`specialtype` FROM `defaultvalues` `t` LEFT JOIN questions q ON t.qid=q.qid WHERE q.qid IS NULL) 1 0.00337 0.00337 0.00337 0.00337
system.db.CDbCommand.query(SELECT COUNT(*) FROM `questions` `t` WHERE `t`.`qid`=:yp0. Bound with :yp0='1615') 1 0.00337 0.00337 0.00337 0.00337
system.db.CDbCommand.query(SELECT * FROM `permissions` `t` WHERE `t`.`entity_id`=:yp0 AND `t`.`entity`=:yp1 AND `t`.`uid`=:yp2 AND `t`.`permission`=:yp3 LIMIT 1. Bound with :yp0=0, :yp1='global', :yp2=2, :yp3='superadmin') 1 0.00336 0.00336 0.00336 0.00336
system.db.CDbCommand.query(SELECT COUNT(*) FROM `questions` `t` WHERE `t`.`qid`=:yp0. Bound with :yp0='256') 1 0.00336 0.00336 0.00336 0.00336
system.db.CDbCommand.query(SELECT `t`.`id`, `t`.`sid`, `t`.`qid`, `t`.`quota_id`, `t`.`code` FROM `quota_members` `t` LEFT JOIN questions q ON t.qid=q.qid LEFT JOIN surveys s ON t.sid=s.sid WHERE (q.qid IS NULL) OR (s.sid IS NULL)) 1 0.00336 0.00336 0.00336 0.00336
system.db.CDbCommand.query(SELECT COUNT(*) FROM `questions` `t` WHERE `t`.`qid`=:yp0. Bound with :yp0='1826') 1 0.00335 0.00335 0.00335 0.00335
system.db.CDbCommand.query(SELECT * FROM `assessments` `t` WHERE scope=:ycp0. Bound with :ycp0='T') 1 0.00335 0.00335 0.00335 0.00335
system.db.CDbCommand.query(SHOW CREATE TABLE `defaultvalue_l10ns`) 1 0.00333 0.00333 0.00333 0.00333
system.db.CDbCommand.query(SHOW CREATE TABLE `plugin_settings`) 1 0.00332 0.00332 0.00332 0.00332
system.db.CDbCommand.query(SELECT COUNT(*) FROM `questions` `t` WHERE `t`.`qid`=:yp0. Bound with :yp0='1485') 1 0.00331 0.00331 0.00331 0.00331
system.db.CDbCommand.query(SELECT * FROM `settings_global` `t` WHERE stg_name=:name LIMIT 1. Bound with :name='DBVersion') 1 0.00329 0.00329 0.00329 0.00329
system.db.CDbCommand.query(SELECT COUNT(*) FROM `questions` `t` WHERE `t`.`qid`=:yp0. Bound with :yp0='260') 1 0.00329 0.00329 0.00329 0.00329
system.db.CDbCommand.query(SELECT COUNT(*) FROM `questions` `t` WHERE `t`.`qid`=:yp0. Bound with :yp0='2026') 1 0.00329 0.00329 0.00329 0.00329
system.db.CDbCommand.query(SELECT `t`.`quotals_id`, `t`.`quotals_quota_id`, `t`.`quotals_language`, `t`.`quotals_name`, `t`.`quotals_message`, `t`.`quotals_url`, `t`.`quotals_urldescrip` FROM `quota_languagesettings` `t` LEFT JOIN quota s ON t.quotals_quota_id=s.id WHERE (s.id IS NULL)) 1 0.00329 0.00329 0.00329 0.00329
system.db.CDbCommand.query(SELECT `t`.`id`, `t`.`gid`, `t`.`group_name`, `t`.`description`, `t`.`language` FROM `group_l10ns` `t` LEFT JOIN groups g ON t.gid=g.gid WHERE (g.gid IS NULL)) 1 0.00327 0.00327 0.00327 0.00327
system.db.CDbCommand.query(SHOW CREATE TABLE `surveymenu_entries`) 1 0.00327 0.00327 0.00327 0.00327
system.db.CDbCommand.query(SHOW CREATE TABLE `template_configuration`) 1 0.00327 0.00327 0.00327 0.00327
system.db.CDbCommand.query(SELECT COUNT(*) FROM `questions` `t` WHERE `t`.`qid`=:yp0. Bound with :yp0='258') 1 0.00327 0.00327 0.00327 0.00327
system.db.CDbCommand.query(SELECT COUNT(*) FROM `questions` `t` WHERE `t`.`qid`=:yp0. Bound with :yp0='9') 1 0.00327 0.00327 0.00327 0.00327
system.db.CDbCommand.query(SHOW CREATE TABLE `notifications`) 1 0.00327 0.00327 0.00327 0.00327
system.db.CDbCommand.query(SELECT COUNT(*) FROM `questions` `t` WHERE `t`.`qid`=:yp0. Bound with :yp0='1480') 1 0.00326 0.00326 0.00326 0.00326
system.db.CDbCommand.query(SELECT * FROM `assessments` `t` WHERE scope=:ycp1. Bound with :ycp1='G') 1 0.00324 0.00324 0.00324 0.00324
system.db.CDbCommand.query(SELECT COUNT(*) FROM `questions` `t` WHERE `t`.`qid`=:yp0. Bound with :yp0='1486') 1 0.00322 0.00322 0.00322 0.00322
system.db.CDbCommand.query(SELECT COUNT(*) FROM `questions` `t` WHERE `t`.`qid`=:yp0. Bound with :yp0='1484') 1 0.00321 0.00321 0.00321 0.00321
system.db.CDbCommand.query(SHOW CREATE TABLE `asset_version`) 1 0.00321 0.00321 0.00321 0.00321
system.db.CDbCommand.query(SHOW CREATE TABLE `surveymenu`) 1 0.00319 0.00319 0.00319 0.00319
system.db.CDbCommand.query(select sid from surveys) 1 0.00317 0.00317 0.00317 0.00317
system.db.CDbCommand.query(SHOW CREATE TABLE `settings_user`) 1 0.00317 0.00317 0.00317 0.00317
system.db.CDbCommand.query(SELECT * FROM `settings_global` `t` WHERE `t`.`stg_name`=:yp0 LIMIT 1. Bound with :yp0='DBVersion') 1 0.00312 0.00312 0.00312 0.00312

Thanks. I have done so.

Are you using MySQL 8?