View Issue Details

This issue affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
05271Bug reportsSurvey editingpublic2011-06-14 14:49
ReporterjonoF Assigned Toc_schmitz  
PrioritynormalSeverityminor 
Status closedResolutionwon't fix 
Product Version1.91 
Summary05271: 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.

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)1.91
I will donate to the project if issue is resolvedNo
BrowserFirefox & IE
Database type & versionMS SQL Server
Server OS (if known)CentOS
Webserver software & version (if known)Apache 2
PHP Version5.1.6
Git branch / Pull Request URL

Users monitoring this issue

There are no users monitoring this issue.

Activities

jonoF

jonoF

2011-06-14 05:38

reporter   ~15427

Build number is actually 10060.

c_schmitz

c_schmitz

2011-06-14 14:49

administrator   ~15431

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.

Issue History

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