Anonymous Login
2016-12-09 00:59 CET

View Issue Details Jump to Notes ]
IDProjectCategoryView StatusLast Update
06823Bug reports[All Projects] Survey takingpublic2012-11-02 13:58
Reporterriqcles 
Assigned Toc_schmitz 
PrioritylowSeveritytrivial 
StatusclosedResolutionno 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
Attached Files

-Relationships
+Relationships

-Notes

~21914

c_schmitz (administrator)

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.
+Notes

-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
+Issue History