View Issue Details

This bug affects 1 person(s).
 2
IDProjectCategoryView StatusLast Update
05946Bug reportsOtherpublic2012-03-23 22:01
Reporterdreier Assigned Toc_schmitz  
PrioritynormalSeverityblock 
Status closedResolutionfixed 
Product Version1.92+ 
Fixed in Version1.92+ 
Summary05946: SQL error while creating new survey
Description

I tried newest Build, cause of some other issues and got just new one...
I installed a totally new Limesurvey and new MSSQL Database. If i login and create a survey following error occurs:
"SQLState: 42000 Error Code: 102 Message: [Microsoft][SQL Server Native Client 10.0][SQL Server]Falsche Syntax in der N�he von '='. :SELECT anonymized, datestamp, ipaddr, refurl FROM [lime_surveys] WHERE sid="
If i press F5 nothing happens..just if I retype the URL i come back to admin page and the survey is created... Cannot let my users do that..

Steps To Reproduce

login
create survey

TagsNo tags attached.
Bug heat2
Complete LimeSurvey version number (& build)120323
I will donate to the project if issue is resolvedNo
Browser
Database type & versionMSSQL
Server OS (if known)Windows Server 2003
Webserver software & version (if known)Apache 2.2
PHP Version5.3.10

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2012-03-23 16:25

administrator   ~18068

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

Related Changesets

LimeSurvey: master 806e6be9

2012-03-23 08:25:51

c_schmitz

Details Diff
Fixed issue 05946: SQL error while creating new survey Affected Issues
05946
mod - admin/database.php Diff File
mod - docs/release_notes.txt Diff File

Issue History

Date Modified Username Field Change
2012-03-23 14:17 dreier New Issue
2012-03-23 16:24 c_schmitz Assigned To => c_schmitz
2012-03-23 16:24 c_schmitz Status new => assigned
2012-03-23 16:25 c_schmitz Changeset attached => LimeSurvey master 806e6be9
2012-03-23 16:25 c_schmitz Note Added: 18068
2012-03-23 16:25 c_schmitz Resolution open => fixed
2012-03-23 16:26 c_schmitz Status assigned => resolved
2012-03-23 16:26 c_schmitz Fixed in Version => 1.92+
2012-03-23 22:01 c_schmitz Status resolved => closed