View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 8
IDProjectCategoryView StatusDate SubmittedLast Update
09491Bug reportsCentral participant databasepublic2015-02-03 19:432015-05-08 09:16
ReporterWitz Assigned Toc_schmitz  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Product Version2.05+ 
Fixed in Version2.05+ 
Summary09491: Id column and Primary key is not generated when the survey is re-activated.
Description

Id column and Primary key is generated in the survey table when the survey is activated first time. But, Id column and Primary key is not generated when the survey is deactivated and then re-activated.

The survey is working without Id column and Primary key in the database table. It could affect to the performance when there are lots of records in the table. Without an identity column, it's not indexed and any query of the table requires a complete table scan as you know.

Steps To Reproduce
  1. Create the survey and activate it.
  2. Check the database table for the Id column.
  3. Deactivate and reactivated the survey.
  4. Check the database table for the Id column again.
TagsNo tags attached.
Bug heat8
Complete LimeSurvey version number (& build)141229
I will donate to the project if issue is resolvedNo
Browser
Database type & versionMS-SQL 10.0
Server OS (if known)Windows Server 2008 R2
Webserver software & version (if known)IIS7.0
PHP Version5.3.8

Relationships

Relationship GraphDependency Graph
related to 09140 closedc_schmitz end users shown that a survey has been saved even if it hasn't - no useful error logs 

Users monitoring this issue

There are no users monitoring this issue.

Activities

Witz

Witz

2015-02-05 16:18

reporter   ~31639

There was a mistake in my original description. Id column is generated but "primary key" is NOT assigned when the survey is re-activated.
aesteban

aesteban

2015-02-11 00:18

developer   ~31650

I just tested on postgresql. It works fine.
DenisChenu

DenisChenu

2015-02-12 09:13

developer   ~31681

Yep, same than MySQL (mysql do it itself). SUrely linked with http://bugs.limesurvey.org/view.php?id=9140#c30534
c_schmitz

c_schmitz

2015-02-12 10:58

administrator   ~31683

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=14925
c_schmitz

c_schmitz

2015-05-08 09:16

administrator   ~32131

2.05+ Build 150508 released

Related Changesets

LimeSurvey: master bf79d41a

2015-02-12 09:57:18

c_schmitz

Details Diff 		Fixed issue 09491: Id column and Primary key is not generated when the survey is re-activated. Affected Issues
09491
mod - application/helpers/admin/import_helper.php Diff File

Issue History

Date Modified Username Field Change
2015-02-03 19:43 Witz New Issue
2015-02-04 09:27 DenisChenu Relationship added related to 09140
2015-02-05 16:18 Witz Note Added: 31639
2015-02-11 00:18 aesteban Note Added: 31650
2015-02-12 09:13 DenisChenu Note Added: 31681
2015-02-12 10:57 c_schmitz Assigned To => c_schmitz
2015-02-12 10:57 c_schmitz Status new => assigned
2015-02-12 10:57 c_schmitz Status assigned => resolved
2015-02-12 10:57 c_schmitz Fixed in Version => 2.05+
2015-02-12 10:57 c_schmitz Resolution open => fixed
2015-02-12 10:58 c_schmitz Changeset attached => LimeSurvey master bf79d41a
2015-02-12 10:58 c_schmitz Note Added: 31683
2015-05-08 09:16 c_schmitz Note Added: 32131
2015-05-08 09:16 c_schmitz Status resolved => closed