View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
04266Bug reportsImport/Exportpublic2010-04-06 19:592010-08-24 16:29
Reportercritter Assigned Toadamzammit  
PrioritylowSeverityminor 
Status closedResolutionfixed 
Product Version1.87+ 
Fixed in Version1.90+ 
Summary04266: SQL error while exporting a survey to XML file.
Description

[Microsoft][ODBC SQL Server Driver][SQL Server]'LENGTH' non ? un valore riconosciuto di nome di funzione predefinita.:SELECT LENGTH(COUNT(*)) as sc FROM lime_labels WHERE lid = 0

(english: 'LENGTH' is not a value recognized as name of predefined function)

Steps To Reproduce

Configure limesurvey to access SQL Server via ODBC.
Create a survey (not activated yet) and try to export it to XML format.

Additional Information

For SQL Server 2k5 the sql statement should be: SELECT LEN(COUNT(*)) ...

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)8518
I will donate to the project if issue is resolved
BrowserIE 8
Database type & versionSQL Server 2005 9.0.4035
Server OS (if known)Windows Server 2003 R2 SE SP2 32 bit
Webserver software & version (if known)IIS V6.0
PHP Version5.3.2

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2010-07-01 15:53

administrator   ~12322

Hello Adam,
please keep in mind that LimeSurvey works on three different database types so if you use functions in SQL statements you have to make sure that these works across platforms or (if they don't) either create according conditions for each DB type or try to not use it at all.
If you have questions don't hesitate to pcik my brain ;)
adamzammit

adamzammit

2010-08-19 06:44

developer   ~12659

Fixed in revision 9073 (uses PHP strlen function instead)
c_schmitz

c_schmitz

2010-08-24 16:29

administrator   ~12688

New version 1.90+ 9089 released.

Issue History

Date Modified Username Field Change
2010-04-06 19:59 critter New Issue
2010-04-11 00:32 c_schmitz Status new => assigned
2010-04-11 00:32 c_schmitz Assigned To => c_schmitz
2010-07-01 15:51 c_schmitz Assigned To c_schmitz => adamzammit
2010-07-01 15:53 c_schmitz Note Added: 12322
2010-08-19 06:44 adamzammit Note Added: 12659
2010-08-19 21:38 c_schmitz Status assigned => resolved
2010-08-19 21:38 c_schmitz Fixed in Version => 1.90+
2010-08-19 21:38 c_schmitz Resolution open => fixed
2010-08-24 16:29 c_schmitz Note Added: 12688
2010-08-24 16:29 c_schmitz Status resolved => closed