View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 04624 | Bug reports | Other | public | 2010-09-24 14:34 | 2010-10-13 16:22 |
| Reporter | erick | Assigned To | c_schmitz | ||
| Priority | normal | Severity | minor | ||
| Status | closed | Resolution | fixed | ||
| Product Version | 1.87+ | ||||
| Fixed in Version | 1.90+ | ||||
| Summary | 04624: Checking database integrity | ||||
| Description | After deleting surveys directly in the DB from the lime_surveys table, the "Check Integrity" functionality doesn't clean all foreign references to the deleted surveys. I found that this functionality leaves some garbage. As far as I have seen, it didn't delete records from tables lime_groups, lime_survey_languagesettings, lime_survey_rights and didn't drop the tables limetokens and limesurvey. | ||||
| Steps To Reproduce | Create a new survey. | ||||
| Tags | No tags attached. | ||||
| Bug heat | 6 | ||||
| Complete LimeSurvey version number (& build) | 8472 | ||||
| I will donate to the project if issue is resolved | |||||
| Browser | |||||
| Database type & version | MySQL 5 | ||||
| Server OS (if known) | Debian Linux | ||||
| Webserver software & version (if known) | Apache | ||||
| PHP Version | 5.2.6 | ||||
| Git branch / Pull Request URL | |||||
|
Thibault, do you know who coded this feature? Is it worth improving it or should we just say "don't delete surveys at the DB"? This seems to be the easier solution because I guess that when deleting a survey from the admin backend, no garbage should be left? |
|
|
Let me add that while I think saying "don't delete surveys at the DB" is okay, I believe LimeSurvey should have a mass survey delete functionality. This problem happened to me because I had to delete over 300 surveys. |
|
|
Fixed in rev. 9185 |
|
|
Released in latest Plus version |
|
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2010-09-24 14:34 | erick | New Issue | |
| 2010-09-24 16:04 | Mazi | Assigned To | => lemeur |
| 2010-09-24 16:04 | Mazi | Status | new => assigned |
| 2010-09-24 16:05 | Mazi | Note Added: 12904 | |
| 2010-09-24 16:31 | erick | Note Added: 12905 | |
| 2010-10-04 21:33 | c_schmitz | Assigned To | lemeur => c_schmitz |
| 2010-10-08 02:58 | c_schmitz | Note Added: 13039 | |
| 2010-10-08 02:58 | c_schmitz | Status | assigned => resolved |
| 2010-10-08 02:58 | c_schmitz | Fixed in Version | => 1.90+ |
| 2010-10-08 02:58 | c_schmitz | Resolution | open => fixed |
| 2010-10-13 16:22 | c_schmitz | Note Added: 13130 | |
| 2010-10-13 16:22 | c_schmitz | Status | resolved => closed |
| 2010-10-25 00:21 | c_schmitz | Category | Data Access => (No Category) |