We are also getting this error since today - however we are still on version 5.6.59 and did not actively update anything.

Kindregards

@DenisChenu can you please look into this? It is caused by this commit https://github.com/LimeSurvey/LimeSurvey/pull/3786. I couldn't reproduce it on my local though, but already a couple users reported this issue.

Rolling back to 5.6.58 (same DB version) restored the normal behaviour.

@proveloict : can you check with https://github.com/LimeSurvey/LimeSurvey/pull/3820

@FabianLucas : try with replace the file models/Template.php with this one https://raw.githubusercontent.com/LimeSurvey/LimeSurvey/a413c130e65fa2ef2534c3cefd9cbdf7e6b78cd7/application/models/Template.php

@DenisChenu : I get the same error after upgrading again and applying the patch (https://github.com/LimeSurvey/LimeSurvey/pull/3820/files) manually.
(I downgraded again to keep the instance online).
Let me know if there is anything else I can do to help.

@proveloict : can you show a SQL result ?

SELECT template_name, lime_templates.folder FROM lime_template_configuration LEFT JOIN lime_templates ON lime_template_configuration.template_name = lime_templates.name WHERE sid IS NULL and gsid is NULL; ?

@DenisChenu

I had to adapt the command because I don't have a prefix on the tables. So i ran
SELECT template_name, templates.folder FROM template_configuration LEFT JOIN templates ON template_configuration.template_name =templates.name WHERE sid IS NULL and gsid is NULL;

And the result was this:

+-------------------------+-------------------------+
| template_name           | folder                  |
+-------------------------+-------------------------+
| bootswatch              | bootswatch              |
| fruity                  | fruity                  |
| vanilla                 | vanilla                 |
| Pro_Velo_extends_fruity | Pro_Velo_extends_fruity |
| material                | material                |
| vanilla_pro_velo        | vanilla_pro_velo        |
| theBP                   | theBP                   |
+-------------------------+-------------------------+
7 rows in set (0.000 sec)

And no material directory in ./theme/ right ?

The issue came from getTemplateListWithPreviews … i didn't update this (broken function)

I create the 2 lines … no way to reproduice …
I create a PR, but unsure if it work

@DenisChenu: indeed, no material direction in ./theme/

PR for 5.X : https://github.com/LimeSurvey/LimeSurvey/pull/3829
Based on https://github.com/LimeSurvey/LimeSurvey/pull/3820 (need both)

Please try with : https://github.com/LimeSurvey/LimeSurvey/blob/1795f45d732d81d5065f0bf59d42f132f2ea618b/application/models/Template.php

I have merged both PRs into 5.x branch.
@DenisChenu is there anything else to be done regarding this ticket?

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

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

Do the last one for 6/master
I do it now or tomorrow morning

master : https://github.com/LimeSurvey/LimeSurvey/pull/3833

For master : https://github.com/LimeSurvey/LimeSurvey/pull/3833

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

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

Fixed in Release 6.5.5+240429