View Issue Details

This bug affects 1 person(s).
 2
IDProjectCategoryView StatusLast Update
06823Bug reportsSurvey takingpublic2012-11-02 13:58
Reporterriqcles Assigned Toc_schmitz  
PrioritylowSeveritytrivial 
Status closedResolutionno change required 
Product Version2.00+ 
Summary06823: reach maximum numbers of surveys - overwrite for the next ?
Description

Hello, for limesuvey V185 + (build 7689), I feel I have reached the limit of creation questionnaire:

When the number 99,999 is reached, it restarts the numbering. (At least that's the impression I have).

In capturing -1 - shows the number of questionnaire.
In capturing -2 - shows the table structure lime_survey

The sid of type integer.
According to the doc postgresql (I have 8.1.4) - www.postgresql.org/docs/8.4/static/datatype-numeric.html
we see that the integer has a range of -2147483648 to +2147483647.

I wonder if questionnaires active / inactive / expired, are not made by crushing created after the new 99999?

These symptoms are present in the V192 + and V2?
In French Forum, DenisChenu say :
the number on the core of limesurvey (for V185 and 192) was 99 999 max.

he say that the number for limesurvey 2.00 is more bigger.

But how many ?
and if i reached the new max limit, what append ?
Crushing previous survey ?

Steps To Reproduce

reach the max number of survey
try to create a new one

TagsNo tags attached.
Attached Files
nombre_questionnaire.png (16,410 bytes)   
nombre_questionnaire.png (16,410 bytes)   
parametre_lime_survey.png (24,923 bytes)   
parametre_lime_survey.png (24,923 bytes)   
Bug heat2
Complete LimeSurvey version number (& build)121025
I will donate to the project if issue is resolvedNo
BrowserInternet explorer 8 8.0.6001.18702IC / Firefox 10.0.0
Database type & versionPostgreSql 9.1
Server OS (if known)Windows XP SP3 / CentOS 5.x
Webserver software & version (if known)Wamp 2.2 / Apache 2.2.4
PHP VersionPHP Version 5.1.13

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2012-11-02 13:58

administrator   ~21914

The survey ID is randomly selected so unless you have more than 99,999 surveys in your system you will not run out of numbers.

Issue History

Date Modified Username Field Change
2012-11-02 13:41 riqcles New Issue
2012-11-02 13:41 riqcles File Added: nombre_questionnaire.png
2012-11-02 13:42 riqcles File Added: parametre_lime_survey.png
2012-11-02 13:58 c_schmitz Note Added: 21914
2012-11-02 13:58 c_schmitz Status new => closed
2012-11-02 13:58 c_schmitz Assigned To => c_schmitz
2012-11-02 13:58 c_schmitz Resolution open => no change required