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 | ||||
| Git branch / Pull Request URL | |||||
|
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 |