View Issue Details

Jump to NotesJump to History
This issue affects 1 person(s).
 10
IDProjectCategoryView StatusDate SubmittedLast Update
10657Bug reportsSurvey editingpublic2016-03-03 10:202016-03-10 08:00
Reporteraqualam Assigned Toollehar  
PrioritylowSeveritypartial_block 
Status closedResolutionunable to reproduce 
Product Version2.50.x 
Summary10657: could not change the survey startdate and expiredate
Description

could not change the survey startdate and expiredate, and even active the survey but cannot get into the survey since the date can not update.

TagsNo tags attached.
Attached Files
Image 1.png (13,965 bytes)   
Image 1.png (13,965 bytes)   
Bug heat10
Complete LimeSurvey version number (& build)250plus-build160228
I will donate to the project if issue is resolvedNo
Browser
Database type & versionMSSQL 2008
Server OS (if known)centos 6
Webserver software & version (if known)Apache2.2.15
PHP Version5.3.14

Users monitoring this issue

aqualam

Activities

ollehar

ollehar

2016-03-03 12:27

administrator   ~35863

This might be a Javascript error. Which browser are you using? Could you press F12 and see if there's an error in the Javascript console?
LouisGac

LouisGac

2016-03-03 13:10

developer   ~35865

can't reproduce the bug.
please, provide an lss file.
aqualam

aqualam

2016-03-04 05:56

reporter   ~35940

Last edited: 2016-03-04 07:32

I think it's related to the Freetds. I am using dblib to connect MSSQL, it can correctly save the date to MSSQL, but cannot show correctly, it cause could not active the survey.

I want to debug the date is correctly come out or could not query the correct date, but no method to debug.
aqualam

aqualam

2016-03-04 05:58

reporter   ~35941

I can get correct date by using sqlsrv in windows, but could not get correct date by using dblib in CentOs;
c_schmitz

c_schmitz

2016-03-07 15:58

administrator   ~36085

Probably FreeTDS is not properly configured.
Try fixing this problem by forcing the FreeTDS protocol version to at least 7.0. See http://www.php.net/manual/de/ref.pdo-dblib.connection.php#112146
aqualam

aqualam

2016-03-10 03:29

reporter   ~36241

My freetds version is 8.0.
Finally, I solved this problem by change the default date format in /etc/locale.conf as "%Y %m %d". The system can show the correct date and time.
c_schmitz

c_schmitz

2016-03-10 08:00

administrator   ~36246

If you can document this setting on our troubleshooting page here:
https://manual.limesurvey.org/Troubleshooting

THat would be nice. Thank you!

Issue History

Date Modified Username Field Change
2016-03-03 10:20 aqualam New Issue
2016-03-03 10:20 aqualam File Added: Image 1.png
2016-03-03 10:28 aqualam Issue Monitored: aqualam
2016-03-03 12:27 ollehar Note Added: 35863
2016-03-03 12:27 ollehar Assigned To => ollehar
2016-03-03 12:27 ollehar Status new => assigned
2016-03-03 13:10 LouisGac Note Added: 35865
2016-03-03 13:10 LouisGac Status assigned => feedback
2016-03-04 05:56 aqualam Note Added: 35940
2016-03-04 05:56 aqualam Status feedback => assigned
2016-03-04 05:58 aqualam Note Added: 35941
2016-03-04 07:32 aqualam Note Edited: 35940
2016-03-07 15:46 LouisGac Priority urgent => low
2016-03-07 15:58 c_schmitz Note Added: 36085
2016-03-07 17:36 c_schmitz Status assigned => feedback
2016-03-07 18:31 LouisGac Category Survey taking => Survey design
2016-03-10 03:29 aqualam Note Added: 36241
2016-03-10 03:29 aqualam Status feedback => assigned
2016-03-10 08:00 c_schmitz Note Added: 36246
2016-03-10 08:00 c_schmitz Status assigned => closed
2016-03-10 08:00 c_schmitz Resolution open => unable to reproduce
2019-11-01 17:25 c_schmitz Category Survey design => Survey editing