View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 6
IDProjectCategoryView StatusDate SubmittedLast Update
08173Bug reportsSurvey participants (Tokens)public2013-09-19 05:592013-11-07 15:00
Reporterrola Assigned Toc_schmitz  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Product Version2.00+ 
Fixed in Version2.00+ 
Summary08173: Error 500 after Clicking "Display Tokens" Icon
Description

Hi,

using LimeSurvey version 1.94 , I have created one survey with 18,000 Survey participants entries without facing any problem.

but after upgrading to version 2.00+ Build 130913, I receive HTTP Error 500 whenever I click on "Display Tokens" icon from Token Management screen.

I referred to the tokens table in the database, I deleted some entries to find out that 15,574 is maximum number of entries I can have in the tokens table in order to avoid mentioned problem . adding one extra entry "15,575" return a blank page, as you insert more ,you will receive the http 500 error.

any help!

TagsNo tags attached.
Bug heat6
Complete LimeSurvey version number (& build)130913
I will donate to the project if issue is resolved
Browser
Database type & versionSQL Server 2008
Server OS (if known)
Webserver software & version (if known)
PHP Version

Users monitoring this issue

There are no users monitoring this issue.

Activities

jjxice46

jjxice46

2013-09-26 15:16

reporter   ~26386

I remember encountering a similar issue like this before.

Out of curiosity are you using SQL Server 2008 or 2012? in combination with IIS when you get this issue?
rola

rola

2013-09-30 11:23

reporter   ~26445

SQL Server 2008
c_schmitz

c_schmitz

2013-10-11 17:55

administrator   ~26740

jjxice46, any idea on this? I cannot reproduce here and I am reluctant to try to install IIS.

Rola, can you activate debug mode in /application/config/config.php and see if you get a more distinctive error?
c_schmitz

c_schmitz

2013-10-21 08:39

administrator   ~26857

Feedback please`?
jjxice46

jjxice46

2013-10-21 14:34

reporter   ~26873

I wasnt able to easily find any root cause for it other then it happened in SQL Server 2008 & SQL Server 2012 with almost any version of IIS. I can tell you that i dont belive it is caused by IIS since we did a resintall of the entire OS when this happened but i belive it is caused by SQL Server. In our case we simply ended up using Mysql on the same system and did not have the issue.
c_schmitz

c_schmitz

2013-10-30 14:14

administrator   ~27030

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

c_schmitz

2013-10-30 14:47

administrator   ~27031

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

c_schmitz

2013-11-07 15:00

administrator   ~27131

Version 2.00+ Build 131107 released.

Related Changesets

LimeSurvey: master e7fd3f3c

2013-10-30 13:14:21

c_schmitz

Details Diff 		Fixed issue 08173: High memory usage when using alot of tokens, particularly with MSSQL Affected Issues
08173
mod - application/controllers/admin/tokens.php Diff File

LimeSurvey: 2.05 7eef2802

2013-10-30 13:47:28

c_schmitz

Details Diff 		Fixed issue 08173: High memory usage when using alot of tokens, particularly with MSSQL Affected Issues
08173
mod - application/controllers/admin/tokens.php Diff File

Issue History

Date Modified Username Field Change
2013-09-19 05:59 rola New Issue
2013-09-26 15:16 jjxice46 Note Added: 26386
2013-09-30 11:23 rola Note Added: 26445
2013-10-01 00:11 c_schmitz Project Feature requests => Bug reports
2013-10-11 17:53 c_schmitz LimeSurvey build number OR git commit ID => 130913
2013-10-11 17:53 c_schmitz Product Version => 2.00+
2013-10-11 17:53 c_schmitz Database & DB-Version => SQL Server 2008
2013-10-11 17:55 c_schmitz Note Added: 26740
2013-10-11 17:55 c_schmitz Assigned To => c_schmitz
2013-10-11 17:55 c_schmitz Status new => feedback
2013-10-21 08:39 c_schmitz Note Added: 26857
2013-10-21 14:34 jjxice46 Note Added: 26873
2013-10-29 14:46 c_schmitz Status feedback => assigned
2013-10-30 14:14 c_schmitz Changeset attached => LimeSurvey master e7fd3f3c
2013-10-30 14:14 c_schmitz Note Added: 27030
2013-10-30 14:14 c_schmitz Resolution open => fixed
2013-10-30 14:14 c_schmitz Status assigned => resolved
2013-10-30 14:14 c_schmitz Fixed in Version => 2.00+
2013-10-30 14:47 c_schmitz Changeset attached => LimeSurvey 2.05 7eef2802
2013-10-30 14:47 c_schmitz Note Added: 27031
2013-11-07 15:00 c_schmitz Note Added: 27131
2013-11-07 15:00 c_schmitz Status resolved => closed
2016-12-08 10:39 c_schmitz Category Tokens => Survey participants (Tokens)