View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
11512Bug reportsOtherpublic2016-08-01 15:442017-01-23 12:50
Reporterthiagosmartins Assigned Toc_schmitz  
PrioritynoneSeverityminor 
Status closedResolutionunable to reproduce 
Product Version2.50.x 
Summary11512: Data redundancy check not removing tables leftover
Description

When using "Check data integrity" tool, the Data redundancy check finds lots of leftovers but does not delete them.

Steps To Reproduce
  • Populate surveys with data and stop thems to genarate tables backups
  • Remove and reimport surveys with token tables
  • Try to remove leftovers with data integrity check.
TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)2.50+ Build 160731
I will donate to the project if issue is resolvedNo
BrowserAll
Database type & versionSQLServer
Server OS (if known)Windows Server 2012 Datacenter Edition
Webserver software & version (if known)IIS 8.0
PHP Version5.6.22

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2016-08-04 16:20

administrator   ~40170

I cannot reproduce it here. It removes the tables properly (testing with Windows 7 IIS and MSSQL) so I am at loss here.
Can you check permissions?
thiagosmartins

thiagosmartins

2016-08-04 17:33

reporter   ~40172

Last edited: 2016-08-04 17:36

I have checked permissions.
I can DROP tables with the user using a query, for example:

Drop Table lime_old_survey_414837_20160610163011;

I did that inside SQL Server Management Studio logged on as the lime survey user that has db_owner permission.

Is there any way to debug that? What do you suggest?
c_schmitz

c_schmitz

2016-08-11 10:21

administrator   ~40246

I think that something on page submission is going wrong. Do you maybe have some security modules installed on your server that kicks in and removes part of the request?

What browser are you using? What does your integrity check URL look like, can you please quote it as I cannot see it on the video?
Can you check what values are posted and to which URL?
thiagosmartins

thiagosmartins

2016-08-12 15:09

reporter   ~40281

c_schmitz, I will log a session using Fiddler to see the request. I am travelling now and can´t do it this week. As soon as possible I send you the results.

I have tried to do it using Firefox, Chrome and Edge (I don't have IE anymore). All give the same result.

The URL is "https://server/index.php?r=admin/checkintegrity/fixredundancy"
c_schmitz

c_schmitz

2016-09-21 15:13

administrator   ~40886

Any news regarding this?
c_schmitz

c_schmitz

2017-01-23 12:50

administrator   ~42794

Closed due to missing feedback.

Issue History

Date Modified Username Field Change
2016-08-01 15:44 thiagosmartins New Issue
2016-08-01 15:44 thiagosmartins File Added: lime_dataintegrity_remove.mp4
2016-08-04 16:20 c_schmitz Note Added: 40170
2016-08-04 16:20 c_schmitz Assigned To => c_schmitz
2016-08-04 16:20 c_schmitz Status new => feedback
2016-08-04 17:33 thiagosmartins Note Added: 40172
2016-08-04 17:33 thiagosmartins Status feedback => assigned
2016-08-04 17:36 thiagosmartins Note Edited: 40172
2016-08-11 10:21 c_schmitz Note Added: 40246
2016-08-11 10:21 c_schmitz Status assigned => feedback
2016-08-12 15:09 thiagosmartins Note Added: 40281
2016-08-12 15:09 thiagosmartins Status feedback => assigned
2016-08-12 15:16 c_schmitz Status assigned => feedback
2016-09-21 15:13 c_schmitz Note Added: 40886
2017-01-23 12:50 c_schmitz Status feedback => closed
2017-01-23 12:50 c_schmitz Resolution open => unable to reproduce
2017-01-23 12:50 c_schmitz Note Added: 42794
2017-01-23 12:50 c_schmitz File Deleted: lime_dataintegrity_remove.mp4