View Issue Details

Jump to NotesJump to History
This issue affects 1 person(s).
 6
IDProjectCategoryView StatusDate SubmittedLast Update
10874Bug reportsOtherpublic2016-04-06 07:442016-04-15 10:24
ReporterDrewskie Assigned Toc_schmitz  
PriorityhighSeverityminor 
Status closedResolutionunable to reproduce 
Product Version2.50.x 
Summary10874: Data Redundency Check not deleting records
Description

When I "Check data integrity" and select records to be deleted under "Data redundency Check", they do not delete

Steps To Reproduce

Select "Check data integrity"
Select records under "Data redundency Check"
Click "Deleted checked items"

TagsNo tags attached.
Attached Files
redundency check.JPG (108,136 bytes)
Bug heat6
Complete LimeSurvey version number (& build)160404
I will donate to the project if issue is resolvedNo
BrowserIE11
Database type & versionSQL 2008
Server OS (if known)Windows 2012
Webserver software & version (if known)IIS8
PHP Version5.4.24
Git branch / Pull Request URL

Users monitoring this issue

Drewskie

Activities

c_schmitz

c_schmitz

2016-04-13 12:24

administrator   ~37301

What records are you selecting? Can you provide a screenshot?
c_schmitz

c_schmitz

2016-04-13 12:29

administrator   ~37304

I cannot reproduce. Maybe missing permissions? (DELETE TABLE)
Drewskie

Drewskie

2016-04-13 12:55

reporter   ~37315

Once I click "Delete checked items" the page reloads and the records are still there.
c_schmitz

c_schmitz

2016-04-13 13:27

administrator   ~37319

Yes, I tested that function. NO problem here with MSSQL. Can you try with a different browser?
Drewskie

Drewskie

2016-04-13 13:59

reporter   ~37326

Have tried Chrome 49 too but no luck.

I just tested in 2.06 160929 and the issue is there too.
c_schmitz

c_schmitz

2016-04-13 14:56

administrator   ~37329

I think it is a missing permission in your database server, not a bug.
Drewskie

Drewskie

2016-04-13 15:24

reporter   ~37336

I am using my sysadmin user for the connection to remove that risk and just to be 100% sure, I tested adding and deleting tables directlty in the DB and it works with this user.

Olle has a DB dump if you want to have a look at the data.
c_schmitz

c_schmitz

2016-04-13 15:59

administrator   ~37339

I restored your database from your dump. Integrity check and deletion of the old tables works just fine, so it must be something with your system.
c_schmitz

c_schmitz

2016-04-15 10:24

administrator   ~37415

Version 2.50+ Build 160415 released

Issue History

Date Modified Username Field Change
2016-04-06 07:44 Drewskie New Issue
2016-04-06 07:45 Drewskie Issue Monitored: Drewskie
2016-04-07 14:11 c_schmitz Priority none => high
2016-04-13 12:24 c_schmitz Note Added: 37301
2016-04-13 12:24 c_schmitz Assigned To => c_schmitz
2016-04-13 12:24 c_schmitz Status new => feedback
2016-04-13 12:29 c_schmitz Note Added: 37304
2016-04-13 12:54 Drewskie File Added: redundency check.JPG
2016-04-13 12:55 Drewskie Note Added: 37315
2016-04-13 12:55 Drewskie Status feedback => assigned
2016-04-13 13:27 c_schmitz Note Added: 37319
2016-04-13 13:27 c_schmitz Status assigned => feedback
2016-04-13 13:59 Drewskie Note Added: 37326
2016-04-13 13:59 Drewskie Status feedback => assigned
2016-04-13 14:56 c_schmitz Note Added: 37329
2016-04-13 15:24 Drewskie Note Added: 37336
2016-04-13 15:59 c_schmitz Note Added: 37339
2016-04-13 16:00 c_schmitz Status assigned => resolved
2016-04-13 16:00 c_schmitz Resolution open => unable to reproduce
2016-04-15 10:24 c_schmitz Note Added: 37415
2016-04-15 10:24 c_schmitz Status resolved => closed