View Issue Details

This bug affects 1 person(s).
 16
IDProjectCategoryView StatusLast Update
19262Bug reportsUsability/user experiencepublic2024-02-05 18:58
Reportermferraz Assigned Toollehar  
PrioritynoneSeveritycrash 
Status closedResolutionfixed 
Product Version6.3.x 
Summary19262: Invalid fruity_twentythree template directory | SELECT * FROM "lime_template_configuration" "t" WHERE template_name='fruity_twen
Description

Hi.

We're getting a lot of PostgreSQL resource usage (quite a few processes) with only this query:
SELECT * FROM "lime_template_configuration" "t" WHERE template_name='fruity_twentythree' AND sid IS NULL AND gsid IS NULL ORDER BY "t"."template_name" LIMIT 1

When I try this query myself, I don't get any row.

After searching for what was causing the resource usage I've found this when I've opened a survey:

CException
Invalid fruity_twentythree template directory

/opt/limesurvey/application/models/Template.php(426)

414
415 /
416 This function returns the complete URL path to a given template name
417

418 @param string $sTemplateName
419
@return string template url
420 /
421 public static function getTemplateURL($sTemplateName = "")
422 {
423 $sTemplateName = self::templateNameFilter($sTemplateName);
424 // Make sure template name is valid
425 if (!self::checkIfTemplateExists($sTemplateName)) {
426 throw new \CException("Invalid {$sTemplateName} template directory");
427 }
428
429 static $aTemplateUrl = array();
430 if (isset($aTemplateUrl[$sTemplateName])) {
431 return $aTemplateUrl[$sTemplateName];
432 }
433
434 $oTemplate = self::model()->findByPk($sTemplateName);
435
436 if (is_object($oTemplate)) {
437 Yii::import('application.helpers.SurveyThemeHelper');
438 if (SurveyThemeHelper::isStandardTemplate($sTemplateName)) {
Stack Trace
#0
– /opt/limesurvey/application/helpers/common_helper.php(3115): Template::getTemplateURL("fruity_twentythree")
3110
@param mixed $sTemplateName
3111 @return string
3112
/
3113 function getTemplateURL($sTemplateName)
3114 {
3115 return Template::getTemplateURL($sTemplateName);
3116 }
3117
3118 /

3119 Return an array of subquestions for a given sid/qid
3120

#1
– /opt/limesurvey/application/helpers/replacements_helper.php(115): getTemplateURL("fruity_twentythree")
110 $templatename = $thissurvey['templatedir'];
111 } else {
112 $templatename = App()->getConfig('defaulttheme');
113 }
114 if (!isset($templateurl)) {
115 $templateurl = getTemplateURL($templatename) . "/";
116 }
117
118 /*
119
Template css/js files from the template config files are loaded.
120 It use the asset manager (so user never need to empty the cache, even if template is updated)
#2
– /opt/limesurvey/application/helpers/expressions/em_manager_helper.php(3340): templatereplace("{SID}")
3335 'jsName' => '',
3336 'readWrite' => 'N',
3337 ];
3338 }
3339 /
Add the core replacement before question code : needed if use it in equation , use SID to never send error */
3340 templatereplace("{SID}");
3341
3342 // Since building array of allowable answers, need to know preset values for certain question types
3343 $presets = [];
3344 $presets['G'] = [ //GENDER drop-down list
3345 'M' => $this->gT("Male"),
#3

  • /opt/limesurvey/application/helpers/expressions/em_manager_helper.php(4539): LimeExpressionManager->setVariableAndTokenMappingsForExpressionManager(172562)
    #4
  • /opt/limesurvey/application/controllers/SurveyAdministrationController.php(144): LimeExpressionManager::StartProcessingPage(false, true)
    #5
  • /opt/limesurvey/vendor/yiisoft/yii/framework/web/actions/CInlineAction.php(49): SurveyAdministrationController->actionView()
    #6
  • /opt/limesurvey/vendor/yiisoft/yii/framework/web/CController.php(308): CInlineAction->runWithParams(array("iSurveyID" => "172562"))
    #7
  • /opt/limesurvey/vendor/yiisoft/yii/framework/web/filters/CFilterChain.php(134): CController->runAction(CInlineAction)
    #8
  • /opt/limesurvey/vendor/yiisoft/yii/framework/web/CController.php(291): CFilterChain->run()
    #9
  • /opt/limesurvey/vendor/yiisoft/yii/framework/web/CController.php(265): CController->runActionWithFilters(CInlineAction, array("postOnly + copy"))
    #10
  • /opt/limesurvey/application/controllers/LSBaseController.php(145): CController->run("view")
    #11
  • /opt/limesurvey/vendor/yiisoft/yii/framework/web/CWebApplication.php(282): LSBaseController->run("view")
    #12
  • /opt/limesurvey/vendor/yiisoft/yii/framework/web/CWebApplication.php(141): CWebApplication->runController("surveyAdministration/view")
    #13
  • /opt/limesurvey/vendor/yiisoft/yii/framework/base/CApplication.php(185): CWebApplication->processRequest()
    #14
  • /opt/limesurvey/index.php(161): CApplication->run()
    2023-11-22 12:23:38 Apache Yii Framework/1.1.28
Steps To Reproduce

This is caused by db upgrade 617 using PostgresDB.

So checkout dbversion 616 on a postgres system and run the upgrade.

TagsPostgreSQL
Bug heat16
Complete LimeSurvey version number (& build) 6.3.6+231120
I will donate to the project if issue is resolvedYes
Browser
Database type & versionPostgreSQL 13+225
Server OS (if known)
Webserver software & version (if known)
PHP Version8.1

Users monitoring this issue

There are no users monitoring this issue.

Activities

mferraz

mferraz

2023-11-22 13:29

reporter   ~78623

Plus, I've realized that there are several files with a+x permissions on this last release...

mferraz

mferraz

2023-11-22 13:48

reporter   ~78624

About that, there's the list of files with 775 permissions (that shouldn't be the default):
./node_modules/dom-to-image/bower_components/ocrad-bower/ocrad-0.23-pre1/configure
./node_modules/dom-to-image/bower_components/ocrad-bower/ocrad-0.23-pre1/testsuite/check.sh
./node_modules/dom-to-image/bower_components/js-imagediff/bin/imagediff
./node_modules/jquery-ui-touch-punch/jquery.ui.touch-punch.js
./upload/readme.txt
./upload/twig/extensions/README.md
./upload/twig/extensions/HelloWorld_Twig_Extension/HelloWorld_Twig_Extension.xml
./upload/twig/extensions/HelloWorld_Twig_Extension/README.md
./upload/twig/extensions/HelloWorld_Twig_Extension/HelloWorld_Twig_Extension.php
./upload/surveys/.htaccess
./upload/labels/readme.txt
./upload/labels/index.html
./upload/admintheme/index.html
./upload/themes/index.html
./upload/themes/survey/index.html
./upload/themes/survey/generalfiles/index.html
./upload/plugins/index.html
./upload/global/index.html
./open-api-gen.php
./tmp/upload/index.html
./tmp/index.html
./tmp/runtime/index.html
./tmp/assets/index.html
./vendor/pear/ole/OLE.php
./vendor/pear/ole/OLE/PPS/Root.php
./vendor/tecnickcom/tcpdf/tools/tcpdf_addfont.php
./vendor/yiisoft/yii/framework/yiic
./application/controllers/SurveysController.php
./application/controllers/admin/UserAction.php
./application/controllers/admin/Themes.php
./application/controllers/admin/Update.php
./application/controllers/OptoutController.php
./application/extensions/yiiwheels/widgets/datepicker/assets/build/build_standalone.less
./application/extensions/yiiwheels/widgets/datepicker/assets/build/build_standalone3.less
./application/extensions/yiiwheels/widgets/datepicker/assets/build/build3.less
./application/extensions/yiiwheels/widgets/datepicker/assets/build/build.less
./application/extensions/yiiwheels/widgets/datepicker/assets/css/datepicker.css
./application/extensions/yiiwheels/widgets/datepicker/assets/js/bootstrap-datepicker.js
./application/extensions/yiiwheels/widgets/datepicker/assets/js/locales/bootstrap-datepicker.lv.js
./application/extensions/yiiwheels/widgets/datepicker/assets/js/locales/bootstrap-datepicker.ar.js
./application/extensions/yiiwheels/widgets/datepicker/assets/js/locales/bootstrap-datepicker.ua.js
./application/extensions/yiiwheels/widgets/datepicker/assets/js/locales/bootstrap-datepicker.sv.js
./application/extensions/yiiwheels/widgets/datepicker/assets/js/locales/bootstrap-datepicker.fa.js
./application/extensions/yiiwheels/widgets/datepicker/assets/js/locales/bootstrap-datepicker.nl-BE.js
./application/extensions/yiiwheels/widgets/datepicker/assets/js/locales/bootstrap-datepicker.rs.js
./application/extensions/yiiwheels/widgets/datepicker/assets/js/locales/bootstrap-datepicker.az.js
./application/extensions/yiiwheels/widgets/datepicker/assets/js/locales/bootstrap-datepicker.id.js
./application/extensions/yiiwheels/widgets/datepicker/assets/js/locales/bootstrap-datepicker.hr.js
./application/extensions/yiiwheels/widgets/datepicker/assets/js/locales/bootstrap-datepicker.no.js
./application/extensions/yiiwheels/widgets/datepicker/assets/js/locales/bootstrap-datepicker.sw.js
./application/extensions/yiiwheels/widgets/datepicker/assets/js/locales/bootstrap-datepicker.ka.js
./application/extensions/yiiwheels/widgets/datepicker/assets/js/locales/bootstrap-datepicker.pt.js
./application/extensions/yiiwheels/widgets/datepicker/assets/js/locales/bootstrap-datepicker.lt.js
./application/extensions/yiiwheels/widgets/datepicker/assets/js/locales/bootstrap-datepicker.pt-BR.js
./application/extensions/yiiwheels/widgets/datepicker/assets/js/locales/bootstrap-datepicker.it.js
./application/extensions/yiiwheels/widgets/datepicker/assets/js/locales/bootstrap-datepicker.sl.js
./application/extensions/yiiwheels/widgets/datepicker/assets/js/locales/bootstrap-datepicker.sk.js
./application/extensions/yiiwheels/widgets/datepicker/assets/js/locales/bootstrap-datepicker.fi.js
./application/extensions/yiiwheels/widgets/datepicker/assets/js/locales/bootstrap-datepicker.rs-latin.js
./application/extensions/yiiwheels/widgets/datepicker/assets/js/locales/bootstrap-datepicker.tr.js
./application/extensions/yiiwheels/widgets/datepicker/assets/js/locales/bootstrap-datepicker.kr.js
./application/extensions/yiiwheels/widgets/datepicker/assets/js/locales/bootstrap-datepicker.zh-CN.js
./application/extensions/yiiwheels/widgets/datepicker/assets/js/locales/bootstrap-datepicker.mk.js
./application/extensions/yiiwheels/widgets/datepicker/assets/js/locales/bootstrap-datepicker.th.js
./application/extensions/yiiwheels/widgets/datepicker/assets/js/locales/bootstrap-datepicker.cs.js
./application/extensions/yiiwheels/widgets/datepicker/assets/js/locales/bootstrap-datepicker.gl.js
./application/extensions/yiiwheels/widgets/datepicker/assets/js/locales/bootstrap-datepicker.hu.js
./application/extensions/yiiwheels/widgets/datepicker/assets/js/locales/bootstrap-datepicker.ja.js
./application/extensions/yiiwheels/widgets/datepicker/assets/js/locales/bootstrap-datepicker.pl.js
./application/extensions/yiiwheels/widgets/datepicker/assets/js/locales/bootstrap-datepicker.nl.js
./application/extensions/yiiwheels/widgets/datepicker/assets/js/locales/bootstrap-datepicker.is.js
./application/extensions/yiiwheels/widgets/datepicker/assets/js/locales/bootstrap-datepicker.de.js
./application/extensions/yiiwheels/widgets/datepicker/assets/js/locales/bootstrap-datepicker.ro.js
./application/extensions/yiiwheels/widgets/datepicker/assets/js/locales/bootstrap-datepicker.he.js
./application/extensions/yiiwheels/widgets/datepicker/assets/js/locales/bootstrap-datepicker.ms.js
./application/extensions/yiiwheels/widgets/datepicker/assets/js/locales/bootstrap-datepicker.kk.js
./application/extensions/yiiwheels/widgets/datepicker/assets/js/locales/bootstrap-datepicker.ru.js
./application/extensions/yiiwheels/widgets/datepicker/assets/js/locales/bootstrap-datepicker.el.js
./application/extensions/yiiwheels/widgets/datepicker/assets/js/locales/bootstrap-datepicker.es.js
./application/extensions/yiiwheels/widgets/datepicker/assets/js/locales/bootstrap-datepicker.ca.js
./application/extensions/yiiwheels/widgets/datepicker/assets/js/locales/bootstrap-datepicker.da.js
./application/extensions/yiiwheels/widgets/datepicker/assets/js/locales/bootstrap-datepicker.nb.js
./application/extensions/yiiwheels/widgets/datepicker/assets/js/locales/bootstrap-datepicker.cy.js
./application/extensions/yiiwheels/widgets/datepicker/assets/js/locales/bootstrap-datepicker.et.js
./application/extensions/yiiwheels/widgets/datepicker/assets/js/locales/bootstrap-datepicker.zh-TW.js
./application/extensions/yiiwheels/widgets/datepicker/assets/js/locales/bootstrap-datepicker.bg.js
./application/extensions/yiiwheels/widgets/datepicker/assets/js/locales/bootstrap-datepicker.vi.js
./application/extensions/yiiwheels/widgets/datepicker/assets/js/locales/bootstrap-datepicker.sq.js
./application/extensions/yiiwheels/widgets/datepicker/assets/js/locales/bootstrap-datepicker.fr.js
./application/extensions/yiiwheels/widgets/gallery/assets/img/video-play.svg
./application/extensions/yiiwheels/widgets/gallery/assets/img/play-pause.svg
./application/extensions/yiiwheels/widgets/gallery/assets/img/error.svg
./application/extensions/yiiwheels/widgets/gallery/assets/img/loading.gif
./application/extensions/yiiwheels/widgets/gallery/assets/blueimp-gallery.jquery.json
./application/extensions/yiiwheels/widgets/gallery/assets/Makefile
./application/extensions/yiiwheels/widgets/gallery/assets/css/blueimp-gallery.css
./application/extensions/yiiwheels/widgets/gallery/assets/css/blueimp-gallery-video.css
./application/extensions/yiiwheels/widgets/gallery/assets/css/blueimp-gallery-indicator.css
./application/extensions/yiiwheels/widgets/gallery/assets/css/blueimp-gallery.min.css
./application/extensions/yiiwheels/widgets/gallery/assets/css/demo.css
./application/extensions/yiiwheels/widgets/gallery/assets/README.md
./application/extensions/yiiwheels/widgets/gallery/assets/bower.json
./application/extensions/yiiwheels/widgets/gallery/assets/js/blueimp-helper.js
./application/extensions/yiiwheels/widgets/gallery/assets/js/demo.js
./application/extensions/yiiwheels/widgets/gallery/assets/js/blueimp-gallery.js
./application/extensions/yiiwheels/widgets/gallery/assets/js/jquery.blueimp-gallery.js
./application/extensions/yiiwheels/widgets/gallery/assets/js/jquery.blueimp-gallery.min.js
./application/extensions/yiiwheels/widgets/gallery/assets/js/blueimp-gallery-video.js
./application/extensions/yiiwheels/widgets/gallery/assets/js/blueimp-gallery-indicator.js
./application/extensions/yiiwheels/widgets/gallery/assets/js/blueimp-gallery.min.js
./application/extensions/yiiwheels/widgets/gallery/assets/js/blueimp-gallery-fullscreen.js
./application/extensions/yiiwheels/widgets/gallery/assets/index.html
./application/extensions/yiiwheels/widgets/fileupload/assets/img/progressbar.gif
./application/extensions/yiiwheels/widgets/fileupload/assets/js/vendor/jquery-ui-1.9.1.custom.min.js
./application/extensions/yiiwheels/widgets/fileupload/assets/js/jquery.fileupload-fp.js
./application/extensions/yiiwheels/widgets/grid/WhGridView.php
./application/extensions/yiiwheels/widgets/redactor/assets/css/redactor.css
./application/extensions/yiiwheels/widgets/redactor/assets/css/redactor-iframe.css
./application/extensions/yiiwheels/widgets/redactor/assets/js/langs/vi.js
./application/extensions/yiiwheels/widgets/redactor/assets/js/langs/nl.js
./application/extensions/yiiwheels/widgets/redactor/assets/js/langs/ko.js
./application/extensions/yiiwheels/widgets/redactor/assets/js/langs/sv.js
./application/extensions/yiiwheels/widgets/redactor/assets/js/langs/hr.js
./application/extensions/yiiwheels/widgets/redactor/assets/js/langs/hu.js
./application/extensions/yiiwheels/widgets/redactor/assets/js/langs/lv.js
./application/extensions/yiiwheels/widgets/redactor/assets/js/langs/sr-lat.js
./application/extensions/yiiwheels/widgets/redactor/assets/js/langs/pt_br.js
./application/extensions/yiiwheels/widgets/redactor/assets/js/langs/fr.js
./application/extensions/yiiwheels/widgets/redactor/assets/js/langs/az.js
./application/extensions/yiiwheels/widgets/redactor/assets/js/langs/it.js
./application/extensions/yiiwheels/widgets/redactor/assets/js/langs/zh_tw.js
./application/extensions/yiiwheels/widgets/redactor/assets/js/langs/ja.js
./application/extensions/yiiwheels/widgets/redactor/assets/js/langs/mk.js
./application/extensions/yiiwheels/widgets/redactor/assets/js/langs/cs.js
./application/extensions/yiiwheels/widgets/redactor/assets/js/langs/da.js
./application/extensions/yiiwheels/widgets/redactor/assets/js/langs/sr-cir.js
./application/extensions/yiiwheels/widgets/redactor/assets/js/langs/eo.js
./application/extensions/yiiwheels/widgets/redactor/assets/js/langs/sl.js
./application/extensions/yiiwheels/widgets/redactor/assets/js/langs/pt_pt.js
./application/extensions/yiiwheels/widgets/redactor/assets/js/langs/ua.js
./application/extensions/yiiwheels/widgets/redactor/assets/js/langs/zh_cn.js
./application/extensions/yiiwheels/widgets/redactor/assets/js/langs/el.js
./application/extensions/yiiwheels/widgets/redactor/assets/js/langs/ro.js
./application/extensions/yiiwheels/widgets/redactor/assets/js/langs/de.js
./application/extensions/yiiwheels/widgets/redactor/assets/js/langs/he.js
./application/extensions/yiiwheels/widgets/redactor/assets/js/langs/id.js
./application/extensions/yiiwheels/widgets/redactor/assets/js/langs/th.js
./application/extensions/yiiwheels/widgets/redactor/assets/js/langs/lt.js
./application/extensions/yiiwheels/widgets/redactor/assets/js/langs/sk.js
./application/extensions/yiiwheels/widgets/redactor/assets/js/langs/sq.js
./application/extensions/yiiwheels/widgets/redactor/assets/js/langs/ru.js
./application/extensions/yiiwheels/widgets/redactor/assets/js/langs/pl.js
./application/extensions/yiiwheels/widgets/redactor/assets/js/langs/tr.js
./application/extensions/yiiwheels/widgets/redactor/assets/js/langs/ar.js
./application/extensions/yiiwheels/widgets/redactor/assets/js/langs/by.js
./application/extensions/yiiwheels/widgets/redactor/assets/js/langs/bg.js
./application/extensions/yiiwheels/widgets/redactor/assets/js/langs/fa.js
./application/extensions/yiiwheels/widgets/redactor/assets/js/langs/es.js
./application/extensions/yiiwheels/widgets/redactor/assets/js/langs/ca.js
./application/extensions/yiiwheels/widgets/redactor/assets/js/langs/no_NB.js
./application/extensions/yiiwheels/widgets/redactor/assets/js/langs/es_ar.js
./application/extensions/yiiwheels/widgets/redactor/assets/js/langs/fi.js
./application/extensions/yiiwheels/widgets/redactor/assets/js/langs/ba.js
./application/extensions/yiiwheels/widgets/redactor/assets/js/plugins/fullscreen/fullscreen.js
./application/extensions/yiiwheels/widgets/redactor/assets/js/plugins/fullscreen/index.html
./application/extensions/yiiwheels/widgets/redactor/assets/js/plugins/fontcolor/fontcolor/fontcolor.js
./application/extensions/yiiwheels/widgets/redactor/assets/js/plugins/textdirection/textdirection.js
./application/extensions/yiiwheels/widgets/redactor/assets/js/plugins/textdirection/index.html
./application/extensions/yiiwheels/widgets/redactor/assets/js/plugins/clips/index.html
./application/extensions/yiiwheels/widgets/redactor/assets/js/plugins/clips/clips.js
./application/extensions/yiiwheels/widgets/redactor/assets/js/plugins/clips/clips.css
./application/extensions/yiiwheels/widgets/redactor/assets/js/plugins/fontfamily/fontfamily.js
./application/extensions/yiiwheels/widgets/redactor/assets/js/plugins/fontfamily/index.html
./application/extensions/yiiwheels/widgets/redactor/assets/js/plugins/fontsize/fontsize.js
./application/extensions/yiiwheels/widgets/redactor/assets/js/plugins/fontsize/index.html
./application/extensions/yiiwheels/widgets/rangeslider/assets/css/iThing.css
./application/extensions/yiiwheels/widgets/rangeslider/assets/css/icons-classic/resultset_previous.png
./application/extensions/yiiwheels/widgets/rangeslider/assets/css/icons-classic/resultset_next.png
./application/extensions/yiiwheels/widgets/rangeslider/assets/css/classic.css
./application/extensions/yiiwheels/widgets/rangeslider/assets/css/classic-min.css
./application/extensions/yiiwheels/widgets/rangeslider/assets/css/iThing-min.css
./application/extensions/yiiwheels/widgets/rangeslider/assets/js/jQAllRangeSliders-min.js
./application/extensions/yiiwheels/widgets/rangeslider/assets/js/jQAllRangeSliders-withRuler-min.js
./application/extensions/yiiwheels/widgets/timeago/assets/js/locales/jquery.timeago.it.js
./application/extensions/yiiwheels/widgets/timeago/assets/js/locales/jquery.timeago.ru.js
./application/extensions/yiiwheels/widgets/timeago/assets/js/locales/jquery.timeago.sk.js
./application/extensions/yiiwheels/widgets/timeago/assets/js/locales/jquery.timeago.hy.js
./application/extensions/yiiwheels/widgets/timeago/assets/js/locales/jquery.timeago.en.js
./application/extensions/yiiwheels/widgets/timeago/assets/js/locales/jquery.timeago.fr.js
./application/extensions/yiiwheels/widgets/timeago/assets/js/locales/jquery.timeago.he.js
./application/extensions/yiiwheels/widgets/timeago/assets/js/locales/jquery.timeago.es.js
./application/extensions/yiiwheels/widgets/timeago/assets/js/locales/jquery.timeago.cs.js
./application/extensions/yiiwheels/widgets/timeago/assets/js/locales/jquery.timeago.fr-short.js
./application/extensions/yiiwheels/widgets/timeago/assets/js/locales/jquery.timeago.uk.js
./application/extensions/yiiwheels/widgets/timeago/assets/js/locales/jquery.timeago.jv.js
./application/extensions/yiiwheels/widgets/timeago/assets/js/locales/jquery.timeago.th.js
./application/extensions/yiiwheels/widgets/timeago/assets/js/locales/jquery.timeago.sl.js
./application/extensions/yiiwheels/widgets/timeago/assets/js/locales/jquery.timeago.ja.js
./application/extensions/yiiwheels/widgets/timeago/assets/js/locales/jquery.timeago.bg.js
./application/extensions/yiiwheels/widgets/timeago/assets/js/locales/jquery.timeago.pt.js
./application/extensions/yiiwheels/widgets/timeago/assets/js/locales/jquery.timeago.en-short.js
./application/extensions/yiiwheels/widgets/timeago/assets/js/locales/jquery.timeago.id.js
./application/extensions/yiiwheels/widgets/timeago/assets/js/locales/jquery.timeago.fa.js
./application/extensions/yiiwheels/widgets/timeago/assets/js/locales/jquery.timeago.no.js
./application/extensions/yiiwheels/widgets/timeago/assets/js/locales/README.md
./application/extensions/yiiwheels/widgets/timeago/assets/js/locales/jquery.timeago.uz.js
./application/extensions/yiiwheels/widgets/timeago/assets/js/locales/jquery.timeago.pl.js
./application/extensions/yiiwheels/widgets/timeago/assets/js/locales/jquery.timeago.tr.js
./application/extensions/yiiwheels/widgets/timeago/assets/js/locales/jquery.timeago.hu.js
./application/extensions/yiiwheels/widgets/timeago/assets/js/locales/jquery.timeago.ro.js
./application/extensions/yiiwheels/widgets/timeago/assets/js/locales/jquery.timeago.ko.js
./application/extensions/yiiwheels/widgets/timeago/assets/js/locales/jquery.timeago.zh-TW.js
./application/extensions/yiiwheels/widgets/timeago/assets/js/locales/jquery.timeago.is.js
./application/extensions/yiiwheels/widgets/timeago/assets/js/locales/jquery.timeago.hr.js
./application/extensions/yiiwheels/widgets/timeago/assets/js/locales/jquery.timeago.zh-CN.js
./application/extensions/yiiwheels/widgets/timeago/assets/js/locales/jquery.timeago.bs.js
./application/extensions/yiiwheels/widgets/timeago/assets/js/locales/jquery.timeago.nl.js
./application/extensions/yiiwheels/widgets/timeago/assets/js/locales/jquery.timeago.de.js
./application/extensions/yiiwheels/widgets/timeago/assets/js/locales/jquery.timeago.rs.js
./application/extensions/yiiwheels/widgets/timeago/assets/js/locales/jquery.timeago.cy.js
./application/extensions/yiiwheels/widgets/timeago/assets/js/locales/jquery.timeago.ar.js
./application/extensions/yiiwheels/widgets/timeago/assets/js/locales/jquery.timeago.vi.js
./application/extensions/yiiwheels/widgets/timeago/assets/js/locales/jquery.timeago.da.js
./application/extensions/yiiwheels/widgets/timeago/assets/js/locales/jquery.timeago.mk.js
./application/extensions/yiiwheels/widgets/timeago/assets/js/locales/jquery.timeago.fi.js
./application/extensions/yiiwheels/widgets/timeago/assets/js/locales/jquery.timeago.el.js
./application/extensions/yiiwheels/widgets/timeago/assets/js/locales/jquery.timeago.gl.js
./application/extensions/yiiwheels/widgets/timeago/assets/js/locales/jquery.timeago.et.js
./application/extensions/yiiwheels/widgets/timeago/assets/js/locales/jquery.timeago.sv.js
./application/extensions/yiiwheels/widgets/timeago/assets/js/locales/jquery.timeago.pt-br.js
./application/extensions/yiiwheels/widgets/timeago/assets/js/locales/jquery.timeago.ca.js
./application/extensions/yiiwheels/widgets/timeago/assets/js/locales/jquery.timeago.lt.js
./application/extensions/yiiwheels/widgets/timeago/assets/js/locales/jquery.timeago.es-short.js
./application/extensions/yiiwheels/widgets/select2/assets/css/select2.css
./application/extensions/yiiwheels/widgets/formhelpers/assets/img/bootstrap-formhelpers-countries.flags-LICENSE.txt
./application/extensions/yiiwheels/widgets/formhelpers/assets/i18n/ru_RU/bootstrap-formhelpers-datepicker.ru_RU.js
./application/extensions/yiiwheels/widgets/formhelpers/assets/i18n/ru_RU/bootstrap-formhelpers-countries.ru_RU.js
./application/extensions/yiiwheels/widgets/formhelpers/assets/i18n/de_DE/bootstrap-formhelpers-countries.de_DE.js
./application/extensions/yiiwheels/widgets/formhelpers/assets/i18n/es_ES/bootstrap-formhelpers-datepicker.es_ES.js
./application/extensions/yiiwheels/widgets/formhelpers/assets/i18n/es_ES/bootstrap-formhelpers-countries.es_ES.js
./application/extensions/yiiwheels/widgets/formhelpers/assets/i18n/it_IT/bootstrap-formhelpers-countries.it_IT.js
./application/extensions/yiiwheels/widgets/formhelpers/assets/i18n/zh_TW/bootstrap-formhelpers-countries.zh_TW.js
./application/extensions/yiiwheels/widgets/formhelpers/assets/i18n/ar/bootstrap-formhelpers-countries.ar.js
./application/extensions/yiiwheels/widgets/formhelpers/assets/i18n/en_US/bootstrap-formhelpers-datepicker.en_US.js
./application/extensions/yiiwheels/widgets/formhelpers/assets/i18n/en_US/bootstrap-formhelpers-timezones.en_US.js
./application/extensions/yiiwheels/widgets/formhelpers/assets/i18n/en_US/bootstrap-formhelpers-fontsizes.en_US.js
./application/extensions/yiiwheels/widgets/formhelpers/assets/i18n/en_US/bootstrap-formhelpers-googlefonts.en_US.js
./application/extensions/yiiwheels/widgets/formhelpers/assets/i18n/en_US/bootstrap-formhelpers-fonts.en_US.js
./application/extensions/yiiwheels/widgets/formhelpers/assets/i18n/en_US/bootstrap-formhelpers-currencies.en_US.js
./application/extensions/yiiwheels/widgets/formhelpers/assets/i18n/en_US/bootstrap-formhelpers-timepicker.en_US.js
./application/extensions/yiiwheels/widgets/formhelpers/assets/i18n/en_US/bootstrap-formhelpers-languages.en_US.js
./application/extensions/yiiwheels/widgets/formhelpers/assets/i18n/en_US/bootstrap-formhelpers-phone.en_US.js
./application/extensions/yiiwheels/widgets/formhelpers/assets/i18n/en_US/bootstrap-formhelpers-countries.en_US.js
./application/extensions/yiiwheels/widgets/formhelpers/assets/i18n/en_US/bootstrap-formhelpers-states.en_US.js
./application/extensions/yiiwheels/widgets/formhelpers/assets/i18n/es_US/bootstrap-formhelpers-datepicker.es_US.js
./application/extensions/yiiwheels/widgets/formhelpers/assets/i18n/pt_BR/bootstrap-formhelpers-countries.pt_BR.js
./application/extensions/yiiwheels/widgets/formhelpers/assets/i18n/zh_CN/bootstrap-formhelpers-countries.zh_CN.js
./application/extensions/yiiwheels/widgets/formhelpers/assets/i18n/zh_CN/bootstrap-formhelpers-timezones.zh_CN.js
./application/extensions/yiiwheels/widgets/formhelpers/assets/css/bootstrap-formhelpers.css
./application/extensions/yiiwheels/widgets/formhelpers/assets/css/bootstrap-formhelpers.min.css
./application/extensions/yiiwheels/widgets/formhelpers/assets/js/bootstrap-formhelpers.js
./application/extensions/yiiwheels/widgets/formhelpers/assets/js/bootstrap-formhelpers.min.js
./application/extensions/yiiwheels/widgets/timepicker/assets/css/bootstrap-timepicker.css
./application/extensions/yiiwheels/widgets/timepicker/assets/css/bootstrap-timepicker.min.css
./application/extensions/yiiwheels/widgets/timepicker/assets/js/bootstrap-timepicker.js
./application/extensions/yiiwheels/widgets/timepicker/assets/js/bootstrap-timepicker.min.js
./application/extensions/yiiwheels/widgets/timepicker/assets/less/timepicker.less
./application/extensions/yiiwheels/assets/css/bootstrap-image-gallery.min.css
./application/extensions/yiiwheels/assets/css/bootstrap-image-gallery.css
./application/extensions/yiiwheels/assets/js/bootstrap-image-gallery.min.js
./application/extensions/yiiwheels/assets/js/load-image.js
./application/extensions/yiiwheels/assets/js/bootstrap-image-gallery.js
./application/extensions/bootstrap5/widgets/TbGridView.php
./application/extensions/bootstrap5/widgets/TbButtonColumn.php
./application/extensions/bootstrap5/helpers/TbHtml.php
./application/models/TemplateManifest.php
./application/models/Participant.php
./application/models/Template.php
./application/models/TemplateConfiguration.php
./application/views/admin/update/check_updates/update_buttons/_updatesavailable.php
./application/views/admin/update/check_updates/update_buttons/_updatesavailable_error.php
./application/views/admin/update/updater/steps/_final.php
./application/views/admin/update/updater/steps/_change_log.php
./application/views/admin/update/updater/steps/_backup.php
./application/views/admin/update/updater/steps/_fileSystem.php
./application/views/admin/survey/printablesurvey_view.php
./application/views/admin/survey/subview/tab_edit_view.php
./application/views/admin/survey/subview/accordion/_integration_panel.php
./application/views/admin/survey/subview/accordion/_resources_panel.php
./application/views/admin/survey/subview/accordion/_generaloptions_panel.php
./application/views/admin/survey/subview/accordion/_notification_panel.php
./application/views/admin/survey/subview/accordion/_tokens_panel.php
./application/views/admin/survey/subview/accordion/_publication_panel.php
./application/views/surveyAdministration/tabImport_view.php
./application/views/surveyAdministration/tabCopy_view.php
./application/views/surveyAdministration/tabCreate_view.php
./application/helpers/replacements_helper.php
./application/config/email.php
./application/config/config-sample-pgsql.php
./application/config/config-sample-dblib.php
./application/config/rest.php
./application/config/ldap.php
./application/config/routes.php
./application/config/index.html
./application/config/rest/v1/survey.php
./application/config/rest/v1/session.php
./application/config/rest/v1.php
./application/config/tcpdf.php
./application/config/config-sample-sqlsrv.php
./application/config/config-sample-mysql.php
./assets/fonts/font-src/opensans/open-sans-v15-latin_latin-ext-600.svg
./assets/fonts/font-src/opensans/open-sans-v15-latin_latin-ext-700italic.eot
./assets/fonts/font-src/opensans/open-sans-v15-latin_latin-ext-700italic.woff
./assets/fonts/font-src/opensans/open-sans-v15-latin_latin-ext-800.woff2
./assets/fonts/font-src/opensans/open-sans-v15-latin_latin-ext-regular.eot
./assets/fonts/font-src/opensans/open-sans-v15-latin_latin-ext-300.ttf
./assets/fonts/font-src/opensans/open-sans-v15-latin_latin-ext-600.woff2
./assets/fonts/font-src/opensans/open-sans-v15-latin_latin-ext-regular.woff
./assets/fonts/font-src/opensans/open-sans-v15-latin_latin-ext-800.svg
./assets/fonts/font-src/opensans/open-sans-v15-latin_latin-ext-800.ttf
./assets/fonts/font-src/opensans/open-sans-v15-latin_latin-ext-italic.ttf
./assets/fonts/font-src/opensans/open-sans-v15-latin_latin-ext-300italic.woff2
./assets/fonts/font-src/opensans/open-sans-v15-latin_latin-ext-300.woff2
./assets/fonts/font-src/opensans/open-sans-v15-latin_latin-ext-800italic.ttf
./assets/fonts/font-src/opensans/open-sans-v15-latin_latin-ext-italic.woff2
./assets/fonts/font-src/opensans/open-sans-v15-latin_latin-ext-italic.woff
./assets/fonts/font-src/opensans/open-sans-v15-latin_latin-ext-700italic.svg
./assets/fonts/font-src/opensans/open-sans-v15-latin_latin-ext-700italic.woff2
./assets/fonts/font-src/opensans/open-sans-v15-latin_latin-ext-600.ttf
./assets/fonts/font-src/opensans/open-sans-v15-latin_latin-ext-300.svg
./assets/fonts/font-src/opensans/open-sans-v15-latin_latin-ext-300italic.svg
./assets/fonts/font-src/opensans/open-sans-v15-latin_latin-ext-regular.svg
./assets/fonts/font-src/opensans/open-sans-v15-latin_latin-ext-800italic.svg
./assets/fonts/font-src/opensans/open-sans-v15-latin_latin-ext-800.woff
./assets/fonts/font-src/opensans/open-sans-v15-latin_latin-ext-300.eot
./assets/fonts/font-src/opensans/open-sans-v15-latin_latin-ext-600italic.eot
./assets/fonts/font-src/opensans/open-sans-v15-latin_latin-ext-italic.svg
./assets/fonts/font-src/opensans/open-sans-v15-latin_latin-ext-regular.ttf
./assets/fonts/font-src/opensans/open-sans-v15-latin_latin-ext-600italic.woff
./assets/fonts/font-src/opensans/open-sans-v15-latin_latin-ext-600italic.ttf
./assets/fonts/font-src/opensans/open-sans-v15-latin_latin-ext-600.eot
./assets/fonts/font-src/opensans/open-sans-v15-latin_latin-ext-300italic.eot
./assets/fonts/font-src/opensans/open-sans-v15-latin_latin-ext-700.svg
./assets/fonts/font-src/opensans/open-sans-v15-latin_latin-ext-800.eot
./assets/fonts/font-src/opensans/open-sans-v15-latin_latin-ext-300italic.ttf
./assets/fonts/font-src/opensans/open-sans-v15-latin_latin-ext-800italic.eot
./assets/fonts/font-src/opensans/open-sans-v15-latin_latin-ext-700.woff2
./assets/fonts/font-src/opensans/open-sans-v15-latin_latin-ext-700italic.ttf
./assets/fonts/font-src/opensans/open-sans-v15-latin_latin-ext-600.woff
./assets/fonts/font-src/opensans/open-sans-v15-latin_latin-ext-italic.eot
./assets/fonts/font-src/opensans/open-sans-v15-latin_latin-ext-600italic.woff2
./assets/fonts/font-src/opensans/open-sans-v15-latin_latin-ext-800italic.woff
./assets/fonts/font-src/opensans/open-sans-v15-latin_latin-ext-800italic.woff2
./assets/fonts/font-src/opensans/open-sans-v15-latin_latin-ext-700.ttf
./assets/fonts/font-src/opensans/open-sans-v15-latin_latin-ext-700.woff
./assets/fonts/font-src/opensans/open-sans-v15-latin_latin-ext-700.eot
./assets/fonts/font-src/opensans/open-sans-v15-latin_latin-ext-300italic.woff
./assets/fonts/font-src/opensans/open-sans-v15-latin_latin-ext-600italic.svg
./assets/fonts/font-src/opensans/open-sans-v15-latin_latin-ext-300.woff
./assets/fonts/font-src/opensans/open-sans-v15-latin_latin-ext-regular.woff2
./assets/fonts/opensans.css
./assets/packages/ckeditor/plugins/lsswitchtoolbars/plugin.js
./assets/survey_themes/fruity_twentythree/participant/captcha/captcha.scss
./assets/survey_themes/fruity_twentythree/old_fruity.scss
./assets/scripts/admin/listresponse.js
./themes/survey/fruity_twentythree/views/subviews/content/outerframe.twig
./themes/survey/fruity_twentythree/views/subviews/navigation/navigator.twig
./themes/survey/fruity_twentythree/scripts/theme.js
./themes/survey/vanilla/config.xml
./installer/create-database.php

mferraz

mferraz

2023-11-22 14:21

reporter   ~78625

Also, when I try the query:
SELECT * FROM "lime_template_configuration" ;

I get 0 rows:
id | template_name | sid | gsid | uid | files_css | files_js | files_print_css | options | cssframework_name | cssframework_css | cssframework_js | packages_to_load | packages_ltr | packages_rtl
----+---------------+-----+------+-----+-----------+----------+-----------------+---------+-------------------+------------------+-----------------+------------------+--------------+--------------
(0 rows)

DenisChenu

DenisChenu

2023-11-22 14:31

developer   ~78626

Plus, I've realized that there are several files with a+x permissions on this last release...

Please : on issue => one mantis issue. report it separately (we can delete yoor message after)

SELECT * FROM "lime_template_configuration" ;

really strange here !

It's a fresh install ?
https://github.com/LimeSurvey/LimeSurvey/blob/2e74c7ae4466a9ffc98d57fac047dcf37bb68f9c/installer/create-database.php#L975

mferraz

mferraz

2023-11-22 14:33

reporter   ~78627

Hi.

thank you for your quick reply, It's not a fresh install.

DenisChenu

DenisChenu

2023-11-22 14:39

developer   ~78629

Update from ?

No issue when upgrade ?

Hope it's not an issue with this update : https://github.com/LimeSurvey/LimeSurvey/blob/2e74c7ae4466a9ffc98d57fac047dcf37bb68f9c/application/helpers/update/updates/Update_617.php

Do you have backup DB from your previous upgrade ?

mferraz

mferraz

2023-11-22 14:39

reporter   ~78630

Also, I've realized that I can't list any survey themes, although they are available in the correct directory:

image.png (80,855 bytes)   
image.png (80,855 bytes)   
mferraz

mferraz

2023-11-22 14:47

reporter   ~78632

From version 6.3.5+231113.
I've daily database backups

mferraz

mferraz

2023-11-22 14:55

reporter   ~78634

ok, unfortunately, I guess you're right, I've checked a backup from 4/11/2023, and there are the entries to the config table.
Can I just restore that table?

DenisChenu

DenisChenu

2023-11-22 15:07

developer   ~78638

Can I just restore that table?

Think yes

DenisChenu

DenisChenu

2023-11-22 15:08

developer   ~78639

ping @p_teichmann

mferraz

mferraz

2023-11-22 15:16

reporter   ~78641

Ok, after restoring the table I'm getting this when I try to open a survey, but now I can see the templates list on the configuration:

CDbCommand failed to execute the SQL statement: SQLSTATE[42501]: Insufficient privilege: 7 ERROR: permission denied for sequence lime_template_configuration_id_seq. The SQL statement executed was: INSERT INTO "lime_template_configuration" ("template_name", "sid", "gsid", "uid", "files_css", "files_js", "files_print_css", "options", "cssframework_name", "cssframework_css", "cssframework_js", "packages_to_load", "packages_ltr", "packages_rtl") VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7, :yp8, :yp9, :yp10, :yp11, :yp12, :yp13)

mferraz

mferraz

2023-11-22 15:18

reporter   ~78643

And the user has the needed permissions:
grantee | privilege_type
------------+----------------
postgres | INSERT
postgres | SELECT
postgres | UPDATE
postgres | DELETE
postgres | TRUNCATE
postgres | REFERENCES
postgres | TRIGGER
inqueritos | INSERT
inqueritos | SELECT
inqueritos | UPDATE
inqueritos | DELETE
inqueritos | TRUNCATE
inqueritos | REFERENCES
inqueritos | TRIGGER
(14 rows)

mferraz

mferraz

2023-11-22 15:29

reporter   ~78646

ok, solved after doing a grant all privileges to the user for lime_template_configuration_id_seq

tibor.pacalat

tibor.pacalat

2023-11-24 11:16

administrator   ~78706

@DenisChenu This is caused by db upgrade 617 using PostgresDB.

DenisChenu

DenisChenu

2023-11-24 11:23

developer   ~78707

Last edited: 2023-11-24 11:26

@DenisChenu This is caused by db upgrade 617 using PostgresDB.

I don't know … i didn't have PG on my new setup. But seems a possibility, to be tested.

I can start to fix it ext week only.

DenisChenu

DenisChenu

2023-11-27 15:47

developer   ~78739

Not started to look at it

thegcat

thegcat

2023-11-27 21:05

reporter   ~78752

I can confirm that we are also seeing this issue.

I'm also a little surprised that an update effectively rendering an installation of your software unusable wasn't pulled until this is fixed to avoid any new broken installation. Maybe this is still an option?

thegcat

thegcat

2023-11-28 09:38

reporter   ~78761

Yes, I would suggest re-reading my comment. I have in no way criticised this bug from happening and I am aware that "PostgreSQL is supported" in LimeSurvey-Land means "not actually tested". My comment has nothing to do with any of that.

My comment is about release management and mitigating any more issues caused by this bug.

Regarding the larger issue of PostgreSQL support, we have been bitten enough that we are indeed considering migrating our installations to MariaDB/MySQL. I actually created an account to confirm this issue and discuss a way to avoid additional breakage by this (mitigation that many other projects, open or closed source, would probably consider matter of fact). I am instead presented with what looks like a knee-jerk reaction to PG problems, probably because it isn't the first time you are dealing with a PG-specific bug either, and which in no way helps either avoiding more breakage by this bug nor would offer a way to fix this for affected people. (I don't understand the bug in the SQL enough to say if a current CI test would have caught this, but that's a different problem altogether). Maybe it would be better for LimeSurvey GMBH and the LimeSurvey project to drop PostgreSQL support if it isn't able or willing to test for it and/or has contingencies like pulling releases in case of problems, this would avoid some false expectations by users and might reduce the load on LimeSurvey GMBH team and other LimeSurvey dev.

Anyway, I didn't want to derail this issue so I will keep to discussing this bug in future comments. Feel free to point me to another place better suited if you are interested in discussing release management or another issue.

DenisChenu

DenisChenu

2023-11-28 09:51

developer   ~78762

Last edited: 2023-11-28 09:51

I delete my comment

But still : if you have a solution to test on pG :we are super happy !

ollehar

ollehar

2023-11-28 15:41

administrator   ~78768

Upgrade from version 6.3.5+231113 to latest release breaks your installation when using Postgres, then, correct? I will try to reproduce this.

ollehar

ollehar

2023-11-28 15:42

administrator   ~78769

Wait, @DenisChenu, did you already start working on this?

ollehar

ollehar

2023-11-28 16:02

administrator   ~78772

Can reproduce. Will debug.

ollehar

ollehar

2023-11-28 16:19

administrator   ~78775

Last edited: 2023-11-28 16:20

This query returns an empty array on Postgres:

SELECT MAX(id) AS maxRecordId FROM "lime_template_configuration" GROUP BY "template_name", "sid", "gsid", "uid"

Hm but not when run manually

limesurvey=# SELECT MAX(id) AS maxRecordId FROM "lime_template_configuration" GROUP BY "template_name", "sid", "gsid", "uid";
 maxrecordid
-------------
           2
           4
           1
           3
ollehar

ollehar

2023-11-28 16:25

administrator   ~78776

Last edited: 2023-11-28 16:27

Dunno why, but it seems like Postgres always returns column alias in all lowercase, maxrecordid, which makes the array filter after return empty array. The solution would be to use all lower case for the alias from the start. Will provide a fix.

Like all objects, aliases will be in lowercase by default. If mixed-case letters or special symbols, or spaces are required, quotes must be used.

https://www.enterprisedb.com/postgres-tutorials/how-use-tables-and-column-aliases-when-building-postgresql-query

DenisChenu

DenisChenu

2023-11-29 10:31

developer   ~78800

@ollehar : need a way to add multiple lines to test it too !

(i just setup my PGSQL version at tags/6.3.4+231108 … too late

cbm.it

cbm.it

2023-12-04 12:48

reporter   ~78855

Hi, just to say that upgrades from 5.x release are also broken. I'm also using Postgres and I'm getting the same "CException - Invalid fruity_twentythree template directory" error, survey template list is empty. I'm not using that specific instance of Limesurvey right now, do I need to restore the db from the backup or can you fix it with a new release? Thanks!

DenisChenu

DenisChenu

2023-12-04 12:56

developer   ~78856

Yes ALL update currently

Need the patch : https://github.com/LimeSurvey/LimeSurvey/pull/3642/files before updating

If you have a backup of your 5.X DB, (disable webserver) update code, apply patch and (enable webserver) update DB : it can be great (we have a second tester)

cbm.it

cbm.it

2023-12-04 14:44

reporter   ~78864

I'm currently updating with ComfortUpdate, so I suppose I should:

  • restore files and db 5.x from the backup
  • manually update the code
  • apply patch
  • upgrade database

Correct?

DenisChenu

DenisChenu

2023-12-04 16:14

developer   ~78865

Yes,
If you want to update now (and tel us it's OK).
You can wait to have the patch in the official release version.

lavamind

lavamind

2023-12-04 19:58

reporter   ~78871

Do we know of a fix or workaround to recover existing installations from the bad database update, after its been applied?

lavamind

lavamind

2023-12-04 20:38

reporter   ~78872

Ok for what it's worth we ended up recovering from backups, applying the fix to the 617 upgrade, and applying database updates once again.

ollehar

ollehar

2023-12-05 09:45

administrator   ~78875

The patch worked for you, @lavamind ?

cbm.it

cbm.it

2023-12-05 11:34

reporter   ~78876

I can confirm the patch worked. Restored from backup, applied patch, db was upgraded and Limesurvey looks fine.

lavamind

lavamind

2023-12-05 14:40

reporter   ~78877

@ollehar yes it worked

ollehar

ollehar

2023-12-05 15:55

administrator   ~78879

Cool, @tibor.pacalat maybe we can merge then?

ollehar

ollehar

2023-12-11 10:28

administrator   ~78934

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=35815

LimeBot

LimeBot

2023-12-11 13:03

administrator   ~78937

Fixed in Release 6.3.9+231211

Related Changesets

LimeSurvey: master 7558178f

2023-12-11 10:28:00

ollehar


Committer: GitHub Details Diff
Fixed issue 19262: Invalid fruity_twentythree template directory on PostgreSQL (03642) Affected Issues
19262
mod - application/helpers/update/updates/Update_617.php Diff File

Issue History

Date Modified Username Field Change
2023-11-22 13:24 mferraz New Issue
2023-11-22 13:29 mferraz Note Added: 78623
2023-11-22 13:29 mferraz Bug heat 0 => 2
2023-11-22 13:48 mferraz Note Added: 78624
2023-11-22 14:21 mferraz Note Added: 78625
2023-11-22 14:31 DenisChenu Note Added: 78626
2023-11-22 14:31 DenisChenu Bug heat 2 => 4
2023-11-22 14:33 mferraz Note Added: 78627
2023-11-22 14:39 DenisChenu Note Added: 78629
2023-11-22 14:39 mferraz Note Added: 78630
2023-11-22 14:39 mferraz File Added: image.png
2023-11-22 14:47 mferraz Note Added: 78632
2023-11-22 14:55 mferraz Note Added: 78634
2023-11-22 15:07 DenisChenu Note Added: 78638
2023-11-22 15:08 DenisChenu Note Added: 78639
2023-11-22 15:16 mferraz Note Added: 78641
2023-11-22 15:18 mferraz Note Added: 78643
2023-11-22 15:29 mferraz Note Added: 78646
2023-11-24 11:16 tibor.pacalat Assigned To => tibor.pacalat
2023-11-24 11:16 tibor.pacalat Status new => confirmed
2023-11-24 11:16 tibor.pacalat Note Added: 78706
2023-11-24 11:16 tibor.pacalat Bug heat 4 => 6
2023-11-24 11:21 tibor.pacalat Assigned To tibor.pacalat => DenisChenu
2023-11-24 11:23 DenisChenu Note Added: 78707
2023-11-24 11:26 DenisChenu Note Edited: 78707
2023-11-27 15:47 DenisChenu Note Added: 78739
2023-11-27 21:05 thegcat Note Added: 78752
2023-11-27 21:05 thegcat Bug heat 6 => 8
2023-11-28 09:38 thegcat Note Added: 78761
2023-11-28 09:51 DenisChenu Note Added: 78762
2023-11-28 09:51 DenisChenu Note Edited: 78762
2023-11-28 09:51 DenisChenu Note Edited: 78762
2023-11-28 15:41 ollehar Note Added: 78768
2023-11-28 15:41 ollehar Bug heat 8 => 10
2023-11-28 15:42 ollehar Note Added: 78769
2023-11-28 15:45 ollehar Steps to Reproduce Updated
2023-11-28 16:02 ollehar Note Added: 78772
2023-11-28 16:19 ollehar Note Added: 78775
2023-11-28 16:20 ollehar Note Edited: 78775
2023-11-28 16:20 ollehar Note Edited: 78775
2023-11-28 16:20 ollehar Note Edited: 78775
2023-11-28 16:25 ollehar Note Added: 78776
2023-11-28 16:27 ollehar Note Edited: 78776
2023-11-28 16:30 ollehar Assigned To DenisChenu => ollehar
2023-11-28 16:30 ollehar Status confirmed => ready for code review
2023-11-29 10:31 DenisChenu Note Added: 78800
2023-12-04 12:48 cbm.it Note Added: 78855
2023-12-04 12:48 cbm.it Bug heat 10 => 12
2023-12-04 12:56 DenisChenu Note Added: 78856
2023-12-04 14:44 cbm.it Note Added: 78864
2023-12-04 16:14 DenisChenu Note Added: 78865
2023-12-04 16:15 DenisChenu Status ready for code review => ready for testing
2023-12-04 19:58 lavamind Note Added: 78871
2023-12-04 19:58 lavamind Bug heat 12 => 14
2023-12-04 20:38 lavamind Note Added: 78872
2023-12-05 09:45 ollehar Note Added: 78875
2023-12-05 11:34 cbm.it Note Added: 78876
2023-12-05 14:40 lavamind Note Added: 78877
2023-12-05 15:55 ollehar Note Added: 78879
2023-12-11 10:28 ollehar Changeset attached => LimeSurvey master 7558178f
2023-12-11 10:28 ollehar Note Added: 78934
2023-12-11 10:28 ollehar Resolution open => fixed
2023-12-11 12:56 tibor.pacalat Status ready for testing => resolved
2023-12-11 13:03 LimeBot Note Added: 78937
2023-12-11 13:03 LimeBot Status resolved => closed
2023-12-11 13:03 LimeBot Bug heat 14 => 16
2024-02-05 18:58 lavamind Tag Attached: PostgreSQL