View Issue Details

Jump to NotesJump to History
This issue affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
20076Bug reports_ Unknownpublic2025-04-28 08:302025-04-29 12:56
ReporterRyszard Assigned Toc_schmitz  
PrioritynoneSeverityminor 
Status feedbackResolutionopen 
Product Version6.6.x 
Summary20076: new survey is created as a copy of the existing survey from the database
Description

While creating a copy of a survey from another survey existing in the database, we noticed some logs that worry us.

Steps To Reproduce

Steps to reproduce

Copy an existing survey in the database as a new survey.

Expected result

A new survey is created as a copy of the existing survey from the database.

Actual result

A new survey is created as a copy of the existing survey from the database,
but unwanted error logs are also generated.

TagsNo tags attached.
Attached Files
app.log.tgz (31,164 bytes)
Bug heat4
Complete LimeSurvey version number (& build)6.10.2
I will donate to the project if issue is resolvedNo
BrowserChrome (66%) 135.0.7049.42
Database type & versionpostgres:15
Server OS (if known)Linux
Webserver software & version (if known)nginx:latest
PHP Version8.3.19

Users monitoring this issue

There are no users monitoring this issue.

Activities

DenisChenu

DenisChenu

2025-04-28 08:46

developer   ~82494

Maybe an issue when try t set pezrmission

2025/04/28 07:00:53 [error] [system.db.CDbCommand] Wywołanie CDbCommand::execute() nie powiodło się: SQLSTATE[23505]: Unique violation: 7 ERROR:  duplicate key value violates unique constraint "lime_idx1_permissions"
DETAIL:  Key (entity_id, entity, permission, uid)=(4444, survey, assessments, 1) already exists.. Wykonywana instrukcja SQL to: INSERT INTO "lime_permissions" ("create_p", "read_p", "update_p", "delete_p", "import_p", "export_p", "entity", "entity_id", "uid", "permission") VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7, :yp8, :yp9).
2025/04/28 07:00:53 [error] [system.db.CDbCommand] Wywołanie CDbCommand::execute() nie powiodło się: SQLSTATE[23505]: Unique violation: 7 ERROR:  duplicate key value violates unique constraint "lime_idx1_permissions"
c_schmitz

c_schmitz

2025-04-29 12:56

administrator   ~82517

Run the integrity check once and see if the error goes away.

Issue History

Date Modified Username Field Change
2025-04-28 08:30 Ryszard New Issue
2025-04-28 08:30 Ryszard File Added: app.log.tgz
2025-04-28 08:46 DenisChenu Note Added: 82494
2025-04-28 08:46 DenisChenu Bug heat 0 => 2
2025-04-29 12:56 c_schmitz Note Added: 82517
2025-04-29 12:56 c_schmitz Bug heat 2 => 4
2025-04-29 12:56 c_schmitz Assigned To => c_schmitz
2025-04-29 12:56 c_schmitz Status new => feedback