06823: reach maximum numbers of surveys - overwrite for the next ? - LimeSurvey bugs, patches and feature requests

LimeSurvey issue tracker

Registration

View Issue Details [ Jump to Notes ]

[ Issue History ] [ Print ]

Project

Category

View Status

Date Submitted

Last Update

06823

Bug reports

[All Projects] Survey taking

public

2012-11-02 13:41

2012-11-02 13:58

Reporter

riqcles

Assigned To

c_schmitz

Priority

low

Severity

trivial

Status

closed

Resolution

no change required

Product Version

2.00+

Target Version

Fixed in Version

Summary

06823: 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

I will donate to the project if issue is resolved within 48 hrs

LimeSurvey build number

121025

Browser

Internet explorer 8 8.0.6001.18702IC / Firefox 10.0.0

Database & DB-Version

PostgreSql 9.1

Operating System (Server)

Windows XP SP3 / CentOS 5.x

Webserver software & version

Wamp 2.2 / Apache 2.2.4

PHP Version

PHP Version 5.1.13

Attached Files

nombre_questionnaire.png [^] (16,410 bytes) 2012-11-02 13:41

parametre_lime_survey.png [^] (24,923 bytes) 2012-11-02 13:42

Relationships

Notes
(21914) c_schmitz (administrator) 2012-11-02 13:58	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