View Issue Details

IDProjectCategoryView StatusLast Update
06823Bug reports[All Projects] Survey takingpublic2012-11-02 13:58
ReporterriqclesAssigned Toc_schmitz 
PrioritylowSeveritytrivial 
Status closedResolutionno change required 
Product Version2.00+ 
Target VersionFixed in Version 
Summary06823: reach maximum numbers of surveys - overwrite for the next ?
DescriptionHello, 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 Reproducereach the max number of survey
try to create a new one
TagsNo tags attached.
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 & DB-VersionPostgreSql 9.1
Operating System (Server)Windows XP SP3 / CentOS 5.x
Webserver software & versionWamp 2.2 / Apache 2.2.4
PHP VersionPHP Version 5.1.13

Activities

riqcles

2012-11-02 13:41

reporter  

nombre_questionnaire.png (16,410 bytes)
nombre_questionnaire.png (16,410 bytes)

riqcles

2012-11-02 13:42

reporter  

parametre_lime_survey.png (24,923 bytes)
parametre_lime_survey.png (24,923 bytes)

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