View Issue Details

This bug affects 1 person(s).
 8
IDProjectCategoryView StatusLast Update
11985Bug reportsOtherpublic2018-03-15 17:28
Reporterrbaier Assigned Toc_schmitz  
PrioritynoneSeverityminor 
Status closedResolutionunable to reproduce 
Product Version2.55.x 
Summary11985: Data redundancy check: Cannot delete leftover answer tables and token tables
Description

Sorry for this revival of issue 11972, but the problem still exists.

When "Check data integrity" has run we are not able to delete leftover answer tables nor token tables on our limesurvey server.

Steps To Reproduce

Execute "Check data integrity".
Afterwards we can resolve the problems reported in "Data consistency check" successfully.
But if we check items in the "Data redundancy check" list and start "Delete checked items", nothing is deleted.
We do not receive any message with this action.

This was observed in version 2.55, and still is in 2.56.1.

Additional Information

For convenience, I have exported my recent test survey ("Test_Leftover") as an *.lsa Archive from the Demo Server (http://demo.limesurvey.org/index.php?r=admin/authentication/sa/login) and imported it in our own limesurvey server.
After deactivating this survey there was one leftover answer table for this survey and this cannot be deleted.
BTW: It would be great to get a message for SUCCESS or ERROR for this action.

Leftover tables from other surveys also cannot be deleted using the "Check data integrity" way.

TagsNo tags attached.
Bug heat8
Complete LimeSurvey version number (& build)2.56.1+161118
I will donate to the project if issue is resolvedNo
BrowserFirefox 50.0.2
Database type & versionMySQL Server Version: 5.5.53-0ubuntu0.14.04.1-log
Server OS (if known)SLES 12 SP1
Webserver software & version (if known)Apache/2.4.16 (Linux/SUSE) OpenSSL/1.0.1i-fips PHP/7.0.7
PHP VersionPHP 7.0.7

Relationships

related to 11972 closedLouisGac Data redundancy check: Cannot delete leftover tables 

Users monitoring this issue

There are no users monitoring this issue.

Activities

LouisGac

LouisGac

2016-12-07 14:24

developer   ~42441

I can't reproduce. In demo, those kind of operations are blocked.

rbaier

rbaier

2016-12-07 15:30

reporter   ~42449

How can I find out, what's the reason for this issue?

LouisGac

LouisGac

2016-12-07 15:31

developer   ~42450

can you please try to reproduce this bug on a local and up to date installation?

rbaier

rbaier

2016-12-08 09:02

reporter   ~42468

That's what I have described here: the bug as seen on our local and up to date installation.

LouisGac

LouisGac

2016-12-08 10:08

developer   ~42469

ok

DenisChenu

DenisChenu

2016-12-08 12:55

developer   ~42471

In your local installtion : did you have :

  • javascript issue (look at your console)
  • test with activating debug (see manual)

We can not reproduce the issue

rbaier

rbaier

2016-12-08 15:21

reporter   ~42473

In the javascript console I could not find anything related to the failed delete.

I have activated debug ('debug'=>2) and debugsql ('debugsql'=>1) and I do not get any error messages or warnings.
In the SQl Performance-Analysis output (obtained with debugsql activated), should there appear lines corresonding to the deletion of leftover tables?

May I ask how you managed to block the deletion of leftover tables on the demo server?

LouisGac

LouisGac

2016-12-08 16:31

developer   ~42477

I bet it's related to PHP7. We'll give it a try.

c_schmitz

c_schmitz

2018-01-24 16:49

administrator   ~46034

rbaier: Is this still an issue using the latest version?

rbaier

rbaier

2018-01-25 10:27

reporter   ~46076

In Version 2.72.5+171121 it is still not possible to delete any of the tables ( answer tables, timings tables, token tables) shown in the "Data redundancy check" results.

LouisGac

LouisGac

2018-01-25 10:32

developer   ~46077

rbaier: well start by updating to latest 2.73

rbaier

rbaier

2018-02-09 11:46

reporter   ~46342

In limesurvey2.73.0-build171219 it is still not possible to delete any of the leftover tables ( answer tables, timings tables, token tables) shown in the "Data redundancy check" results.

Issue History

Date Modified Username Field Change
2016-12-07 14:11 rbaier New Issue
2016-12-07 14:24 LouisGac Note Added: 42441
2016-12-07 15:30 rbaier Note Added: 42449
2016-12-07 15:31 LouisGac Note Added: 42450
2016-12-08 09:02 rbaier Note Added: 42468
2016-12-08 10:08 LouisGac Note Added: 42469
2016-12-08 12:53 DenisChenu Relationship added related to 11972
2016-12-08 12:55 DenisChenu Note Added: 42471
2016-12-08 15:21 rbaier Note Added: 42473
2016-12-08 16:31 LouisGac Note Added: 42477
2018-01-24 16:49 c_schmitz Assigned To => c_schmitz
2018-01-24 16:49 c_schmitz Status new => feedback
2018-01-24 16:49 c_schmitz Note Added: 46034
2018-01-25 10:27 rbaier Note Added: 46076
2018-01-25 10:27 rbaier Status feedback => assigned
2018-01-25 10:32 LouisGac Note Added: 46077
2018-02-09 11:46 rbaier Note Added: 46342
2018-02-20 14:58 c_schmitz Status assigned => feedback
2018-03-15 17:28 c_schmitz Status feedback => closed
2018-03-15 17:28 c_schmitz Resolution open => unable to reproduce