Relationship Graph
View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
11985 | Bug reports | Other | public | 2016-12-07 14:11 | 2018-03-15 17:28 |
Reporter | rbaier | Assigned To | c_schmitz | ||
Priority | none | Severity | minor | ||
Status | closed | Resolution | unable to reproduce | ||
Product Version | 2.55.x | ||||
Summary | 11985: 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". 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. Leftover tables from other surveys also cannot be deleted using the "Check data integrity" way. | ||||
Tags | No tags attached. | ||||
Bug heat | 8 | ||||
Complete LimeSurvey version number (& build) | 2.56.1+161118 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | Firefox 50.0.2 | ||||
Database type & version | MySQL 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 Version | PHP 7.0.7 | ||||
related to | 11972 | closed | Data redundancy check: Cannot delete leftover tables |
I can't reproduce. In demo, those kind of operations are blocked. |
|
How can I find out, what's the reason for this issue? |
|
can you please try to reproduce this bug on a local and up to date installation? |
|
That's what I have described here: the bug as seen on our local and up to date installation. |
|
ok |
|
In your local installtion : did you have :
We can not reproduce the issue |
|
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. May I ask how you managed to block the deletion of leftover tables on the demo server? |
|
I bet it's related to PHP7. We'll give it a try. |
|
rbaier: Is this still an issue using the latest version? |
|
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. |
|
rbaier: well start by updating to latest 2.73 |
|
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. |
|
Date Modified | Username | Field | Change |
---|---|---|---|
2016-12-07 14:11 | rbaier | New Issue | |
2016-12-07 14:24 |
|
Note Added: 42441 | |
2016-12-07 15:30 | rbaier | Note Added: 42449 | |
2016-12-07 15:31 |
|
Note Added: 42450 | |
2016-12-08 09:02 | rbaier | Note Added: 42468 | |
2016-12-08 10:08 |
|
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 |
|
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 |
|
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 |