View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
04266 | Bug reports | Import/Export | public | 2010-04-06 19:59 | 2010-08-24 16:29 |
Reporter | critter | Assigned To | adamzammit | ||
Priority | low | Severity | minor | ||
Status | closed | Resolution | fixed | ||
Product Version | 1.87+ | ||||
Fixed in Version | 1.90+ | ||||
Summary | 04266: 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. | ||||
Additional Information | For SQL Server 2k5 the sql statement should be: SELECT LEN(COUNT(*)) ... | ||||
Tags | No tags attached. | ||||
Bug heat | 4 | ||||
Complete LimeSurvey version number (& build) | 8518 | ||||
I will donate to the project if issue is resolved | |||||
Browser | IE 8 | ||||
Database type & version | SQL 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 Version | 5.3.2 | ||||
Hello Adam, |
|
Fixed in revision 9073 (uses PHP strlen function instead) |
|
New version 1.90+ 9089 released. |
|
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 |