Hello,

i have a user that i want to give permissions to edit a specific template. When i go to users and click "Set template permissions for this user" i get this error:

CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'def07_no_red_mark_focus_first_empty_cells_yesnoaut' for key 'PRIMARY'. The SQL statement executed was: INSERT INTO `lime_templates` (`folder`, `creator`) VALUES (:yp0, :yp1)

Same error on other users as well.

I run the latest stable Version 171017
Full debug:
pastebin.com/5iyW41Ke

Any ideas?

Strange, I'll have a look.

Have you been testing LS 3.0 beta on the same database?

The LS 3.0 changes the template database table completely, so you will run into trouble if you go back to 2.7x after.

I have not tested LS 3.0. That can not be the problem.

OK, I've pushed a change to repository to help see the error. Can you either pull from github or apply this patch manually?

github.com/LimeSurvey/LimeSurvey/commit/...981439b24984880b1003

Alternatively you can wait until the next release.

I have applied the patch and now it still shows the error, but it lets me go to the permission settings.

Screenshot:
imgur.com/TsZU0mo

Edit: I just noticed that the list of templates in the permission settings does not match the list of avaiable templates.
For example i deleted def06.. and def08....
Here is the list of templates i can edit in the template editor:
imgur.com/ZQoU7yE

Maybe a delete template action went wrong and an inconsistency was created between templates in the database and templates in the filesystem?

It seems that way. Can i just delete the entry in mysql?

Mysql:
Filesystem:

If the template doesn't exist in the file system it should be safe to delete that entry in the database.