View Issue Details

This issue affects 1 person(s).
 2
IDProjectCategoryView StatusLast Update
05110Bug reportsSurvey editingpublic2011-04-13 16:44
Reportermedicnick Assigned Toc_schmitz  
PriorityurgentSeverityblock 
Status closedResolutionno change required 
Product Version1.91RC6 
Summary05110: Connection to DB timing otu
Description

I have a hosted web server and MSSQL server with a relatively simple and light survey in place. I received a number of complaints today from users who experienced similar issues. After pressing NEXT for the first group (of three) there was a long delay and then the error message that says something about not finding the database and needing to run install.php is displayed.

I can assure you that the database exists and is populated and that a refresh will force it to find the database on the next load.

Along with this complaint were complaints about it taking too long to load pages. My ISP (discountasp.net)checked their server status and reported back that they did not detect any problems.

Additional Information

I decided to change the default PHP time limit in common.php from 1200 to 3600. I understand that is supposed to be seconds but I wonder if it could be miliseconds or some other factor?

Since making this change there have not yet been any further complaints about the speed or losing the database. I have taken the same survey multiple times since then without any apparent delays but end users always find ways to really test a system.

Is this the proper way to address this issue? If so, could this be permanently changed or set to be configurable in the UI?

[code] Line 54
if (ini_get("max_execution_time")<1200) @set_time_limit(3600); // Maximum execution time - works only if safe_mode is off
[/code]

TagsNo tags attached.
Bug heat2
Complete LimeSurvey version number (& build)9991
I will donate to the project if issue is resolvedNo
BrowserFF4
Database type & versionMSSQL R2
Server OS (if known)WIN 2008
Webserver software & version (if known)IIS7.5
PHP Version5.2.5
Git branch / Pull Request URL

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2011-04-13 16:44

administrator   ~14811

THis is about seconds and could not have influenced the behaviour. If you had the impression that it did then the problem should reappear if you remove your 'fix'. (I bet it won't)

I think your hoster f***ed up somehow and didn't have the balls to admit it. I get the feeling there is something generally weird about your hosting. Anyway. this is not a bug. please do not use the bug tracker as support forum. Thank you.

Issue History

Date Modified Username Field Change
2011-04-13 07:01 medicnick New Issue
2011-04-13 16:44 c_schmitz Note Added: 14811
2011-04-13 16:44 c_schmitz Status new => closed
2011-04-13 16:44 c_schmitz Assigned To => c_schmitz
2011-04-13 16:44 c_schmitz Resolution open => fixed
2011-04-13 16:44 c_schmitz Resolution fixed => no change required
2019-11-01 17:25 c_schmitz Category Survey design => Survey editing