View Issue Details

This bug affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
19808Bug reports_ Unknownpublic2024-11-20 15:57
ReporterDenisChenu Assigned To 
PrioritynoneSeverityminor 
Status newResolutionopen 
Product Version6.6.x 
Summary19808: Table can not create because already exist
Description

Unsure if it's a feature or an issue. But sometime, due to bad import or plugins (or server stop … I didn't know)
But if table didn't exist : there are no workaround, unure on the good workaround

Steps To Reproduce

Steps to reproduce

Activate survey
Update UPDATE lime_surveys SET active = 'N' WHERE lime_surveys.sid = XXX; in DB
Try to activate survey gain

Expected result

Old table are renamed and an alert is shown ?

Actual result

No way to activate
PS : debug 2 show error, maybe add it when debug=0 too ?

TagsNo tags attached.
Attached Files
Bug heat4
Complete LimeSurvey version number (& build)6.6.6
I will donate to the project if issue is resolvedNo
Browsernot relevant
Database type & versionnot relevant
Server OS (if known)not relevant
Webserver software & version (if known)not relevant
PHP Versionnot relevant

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2024-11-19 14:09

administrator   ~81430

Integrity check should fix it?

DenisChenu

DenisChenu

2024-11-19 14:59

developer   ~81434

More than 4000 activated survey : no way to use Integrity check (i think there are already an Integrity check by survey feature somewhere)

(PS : just in case : i can create it on git if needed after moving)

c_schmitz

c_schmitz

2024-11-19 15:35

administrator   ~81439

Integrity check works just fine here also with a huge number of surveys (remember I optimized it a couple months ago)

DenisChenu

DenisChenu

2024-11-19 15:42

developer   ~81440

SQL DB on another server it always take more time (at 30 minutes currentky)

I need to disable the part : https://github.com/LimeSurvey/LimeSurvey/blob/1dbc0171bac3ee44f2d96c955e62d962093640c2/application/controllers/admin/CheckIntegrity.php#L628

Let me check, I do it some month ago now.

(PS !: still need a By survey for old table management too, or when survey didn't launch and user are not superadmin)

c_schmitz

c_schmitz

2024-11-20 12:32

administrator   ~81461

This part is already deactivated and will only be executed if you add a special parameter (checkResponseTableFields) to the URL:

DenisChenu

DenisChenu

2024-11-20 13:23

developer   ~81463

Last edited: 2024-11-20 13:27

This part is already deactivated and will only be executed if you add a special parameter (checkResponseTableFields) to the URL:

Right, but then : you need a way to do it by survey, no ?

Else : survey->active = 'N' + have response table : no code on Integrity check

Oups : found it : https://github.com/LimeSurvey/LimeSurvey/blob/1dbc0171bac3ee44f2d96c955e62d962093640c2/application/controllers/admin/CheckIntegrity.php#L723

c_schmitz

c_schmitz

2024-11-20 14:26

administrator   ~81465

Yep, close this issue?

DenisChenu

DenisChenu

2024-11-20 15:57

developer   ~81468

Yep, close this issue?

Unsure here : have a cleaner solution seem better.

And have something Simple survey manager can do are a needed part IMHO

Issue History

Date Modified Username Field Change
2024-10-16 18:56 DenisChenu New Issue
2024-10-16 18:56 DenisChenu File Added: Capture d’écran du 2024-10-16 18-52-04.png
2024-10-16 18:56 DenisChenu File Added: Capture d’écran du 2024-10-16 18-51-28.png
2024-10-16 18:56 DenisChenu Summary Table can not create because alredy exist => Table can not create because already exist
2024-10-24 11:49 guest Bug heat 0 => 6
2024-10-24 11:49 sampnot12 Bug heat 6 => 0
2024-11-19 14:09 c_schmitz Note Added: 81430
2024-11-19 14:09 c_schmitz Bug heat 0 => 2
2024-11-19 14:59 DenisChenu Note Added: 81434
2024-11-19 14:59 DenisChenu Bug heat 2 => 4
2024-11-19 15:35 c_schmitz Note Added: 81439
2024-11-19 15:42 DenisChenu Note Added: 81440
2024-11-20 12:32 c_schmitz Note Added: 81461
2024-11-20 13:23 DenisChenu Note Added: 81463
2024-11-20 13:27 DenisChenu Note Edited: 81463
2024-11-20 14:26 c_schmitz Note Added: 81465
2024-11-20 15:57 DenisChenu Note Added: 81468