View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 05271 | Bug reports | Survey editing | public | 2011-06-14 05:28 | 2011-06-14 14:49 |
| Reporter | jonoF | Assigned To | c_schmitz | ||
| Priority | normal | Severity | minor | ||
| Status | closed | Resolution | won't fix | ||
| Product Version | 1.91 | ||||
| Summary | 05271: Cannot create surveys: no fields can be nullable | ||||
| Description | After installation using the mysql_n driver, the tables created have entirely 'not nullable' fields. This means that surveys cannot be created, as by default some fields are not initialised. Additionally subquestions cannot be created. | ||||
| Steps To Reproduce | Install a limesurvey database using mssql_n driver. Attempt to create a new survey. (After modifying the survey table, a similar issue can be found by attempting to created subquestions, e.g. in an array). | ||||
| Additional Information | This was easily corrected by manually changing all fields except keys to nullable, but it would be better to have correct database setup during installation. | ||||
| Tags | No tags attached. | ||||
| Bug heat | 4 | ||||
| Complete LimeSurvey version number (& build) | 1.91 | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | Firefox & IE | ||||
| Database type & version | MS SQL Server | ||||
| Server OS (if known) | CentOS | ||||
| Webserver software & version (if known) | Apache 2 | ||||
| PHP Version | 5.1.6 | ||||
| Git branch / Pull Request URL | |||||
|
Build number is actually 10060. |
|
|
The msslq_n driver is marked as experimental and should not be used for production - I recommend to use mssql_odbc instead, even on Linux. Incidentally we will swap the whole database layer for the next version so we won't put any effort in mssql_n anymore because it will be obsolete and hopefully replaced with an even more stable version. |
|
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2011-06-14 05:28 | jonoF | New Issue | |
| 2011-06-14 05:38 | jonoF | Note Added: 15427 | |
| 2011-06-14 14:49 | c_schmitz | Note Added: 15431 | |
| 2011-06-14 14:49 | c_schmitz | Status | new => closed |
| 2011-06-14 14:49 | c_schmitz | Assigned To | => c_schmitz |
| 2011-06-14 14:49 | c_schmitz | Resolution | open => won't fix |
| 2019-11-01 17:25 | c_schmitz | Category | Survey design => Survey editing |