View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
19808 | Bug reports | _ Unknown | public | 2024-10-16 18:56 | 2024-11-20 15:57 |
Reporter | DenisChenu | Assigned To | |||
Priority | none | Severity | minor | ||
Status | new | Resolution | open | ||
Product Version | 6.6.x | ||||
Summary | 19808: 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) | ||||
Steps To Reproduce | Steps to reproduceActivate survey Expected resultOld table are renamed and an alert is shown ? Actual resultNo way to activate | ||||
Tags | No tags attached. | ||||
Attached Files | |||||
Bug heat | 4 | ||||
Complete LimeSurvey version number (& build) | 6.6.6 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | not relevant | ||||
Database type & version | not relevant | ||||
Server OS (if known) | not relevant | ||||
Webserver software & version (if known) | not relevant | ||||
PHP Version | not relevant | ||||
Integrity check should fix it? |
|
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) |
|
Integrity check works just fine here also with a huge number of surveys (remember I optimized it a couple months ago) |
|
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) |
|
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 |
|
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 |
|
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 |