View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 2
IDProjectCategoryView StatusDate SubmittedLast Update
08795Bug reportsInstallationpublic2014-03-03 11:012014-03-17 13:14
Reporterfvanderstarre Assigned Toc_schmitz  
PrioritynormalSeveritypartial_block 
Status closedResolutionfixed 
Product Version2.05+ 
Fixed in Version2.05+ 
Summary08795: Unable to create or import survey after 2.05+ build 140302 installation (mssql/Linux)
Description

After installing L.S. 2.05+ build 140302 I tried to create a survey.
DB error returned:"Cannot insert the value NULL into column 'googleanalyticsapikey', table 'LimeSurvey_temp.dbo.surveys'; column does not allow nulls.".
Following statements in install/sql/create-mssql.sql should be adapted:
CREATE TABLE [prefix_surveys] (....,
[nokeyboard] varchar(1) default 'N',
[alloweditaftercompletion] varchar(1) default 'N',
[googleanalyticsstyle] varchar(1),
[googleanalyticsapikey] varchar(25),
to:
CREATE TABLE [prefix_surveys] (....,
[nokeyboard] varchar(1) NULL default 'N',
[alloweditaftercompletion] varchar(1) NULL default 'N',
[googleanalyticsstyle] varchar(1) NULL,
[googleanalyticsapikey] varchar(25) NULL,

And for [prefix_surveys_languagesettings]:
change "[attachments] varchar(max) default null," to:
"[attachments] varchar(max) NULL default null,"

Steps To Reproduce

Install 2.05+ build 140302 (Linux/mssql/pdo_dblib/FreeTDS)

Additional Information

Statements are OK in 2.00+ install/sql/create-mssql.sql (for surveys table)

TagsNo tags attached.
Bug heat2
Complete LimeSurvey version number (& build)2.05+ 140302
I will donate to the project if issue is resolvedNo
BrowserFirefox
Database type & versionMS SQL server 2008 10.0.5500.0 (X64)
Server OS (if known)DB server: Windows NT 6.1 <X64> build 7601 SP1. Appl/web server: Linux RHEL 5.8
Webserver software & version (if known)Apache/2.2.3 (Red Hat)
PHP Version5.3.3

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2014-03-03 11:12

administrator   ~29072

Thank you very much.
c_schmitz

c_schmitz

2014-03-03 11:13

administrator   ~29073

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=13965
c_schmitz

c_schmitz

2014-03-05 08:02

administrator   ~29094

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=13973
c_schmitz

c_schmitz

2014-03-05 08:07

administrator   ~29095

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=13974
c_schmitz

c_schmitz

2014-03-17 13:14

administrator   ~29279

2.05+ Build 140317 released

Related Changesets

LimeSurvey: master aa2a1cff

2014-03-03 11:13

c_schmitz


Details Diff		 Fixed issue 08795: Unable to create or import survey after new installation and using MSSQL from Linux Affected Issues
08795
mod - installer/sql/create-mssql.sql Diff File

LimeSurvey: master fc1943f0

2014-03-05 08:01

c_schmitz


Details Diff		 Fixed issue 08795: Unable to create or import survey after new installation and using MSSQL from Linux Affected Issues
08795
mod - installer/sql/create-mssql.sql Diff File

LimeSurvey: master 019b94ab

2014-03-05 08:06

c_schmitz


Details Diff		 Fixed issue 08795: Unable to create or import survey after new installation and using MSSQL from Linux Affected Issues
08795
mod - installer/sql/create-mssql.sql Diff File

Issue History

Date Modified Username Field Change
2014-03-03 11:01 fvanderstarre New Issue
2014-03-03 11:11 c_schmitz Assigned To => c_schmitz
2014-03-03 11:11 c_schmitz Status new => assigned
2014-03-03 11:12 c_schmitz Note Added: 29072
2014-03-03 11:13 c_schmitz Status assigned => resolved
2014-03-03 11:13 c_schmitz Fixed in Version => 2.05+
2014-03-03 11:13 c_schmitz Resolution open => fixed
2014-03-03 11:13 c_schmitz Changeset attached => LimeSurvey master aa2a1cff
2014-03-03 11:13 c_schmitz Note Added: 29073
2014-03-05 08:02 c_schmitz Changeset attached => LimeSurvey master fc1943f0
2014-03-05 08:02 c_schmitz Note Added: 29094
2014-03-05 08:07 c_schmitz Changeset attached => LimeSurvey master 019b94ab
2014-03-05 08:07 c_schmitz Note Added: 29095
2014-03-17 13:14 c_schmitz Note Added: 29279
2014-03-17 13:14 c_schmitz Status resolved => closed