View Issue Details

This issue affects 1 person(s).
 0
IDProjectCategoryView StatusLast Update
10235Bug reportsInstallationpublic2016-02-06 01:13
Reportermpeacock Assigned Toc_schmitz  
PrioritynormalSeveritypartial_block 
Status closedResolutionfixed 
Fixed in Version2.50.x 
Summary10235: 2.5RC6 MS SQL installation fails
Description

Installation to MSSQL database fails due to a problem in mssql-create.sql relating to the boxes table.

Modifying mssql-create.sql to

--
-- Table structure & data for boxes

CREATE TABLE prefix_boxes (
[id] int NOT NULL IDENTITY,
[position] int DEFAULT NULL ,
[url] varchar(max) NOT NULL ,
[title] varchar(max) NOT NULL ,
[img] varchar(max) NOT NULL ,
[ico] varchar(max) DEFAULT NULL,
[desc] varchar(max) NOT NULL ,
[page] varchar(max) NOT NULL ,
PRIMARY KEY ([id])
);

SET IDENTITY_INSERT prefix_boxes ON;
INSERT INTO prefix_boxes ([id], [position], [url], [title], [img], [ico], [desc], [page]) VALUES
(1, 1, 'admin/survey/sa/newsurvey', 'Create survey', 'add.png', 'add', 'Create a new survey', 'welcome'),
(2, 2, 'admin/survey/sa/listsurveys', 'List surveys', 'surveylist.png', 'list', 'List available surveys', 'welcome'),
(3, 3, 'admin/globalsettings', 'Global settings', 'global.png', 'settings', 'Edit global settings', 'welcome'),
(4, 4, 'admin/update', 'ComfortUpdate', 'shield-update.png', 'shield', 'Stay safe and up to date', 'welcome'),
(5, 5, 'admin/labels/sa/view', 'Label sets', 'labels.png', 'label','Edit label sets', 'welcome'),
(6, 6, 'admin/templates/sa/view', 'Template editor', 'templates.png','templates', 'Edit LimeSurvey templates', 'welcome');
SET IDENTITY_INSERT prefix_boxes OFF;

Allows the table to be created.

Upgrades also fail on the boxes table but I haven't looked into why.

Steps To Reproduce

Install Limesurvey 2.5RC6 with dblib MSSQL backend.

TagsNo tags attached.
Bug heat0
Complete LimeSurvey version number (& build)250RC6-build160108
I will donate to the project if issue is resolvedNo
Browser
Database type & versionMS SQL 2008 R2
Server OS (if known)Linux
Webserver software & version (if known)Apache
PHP Version5.5
Git branch / Pull Request URL

Users monitoring this issue

There are no users monitoring this issue.

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2016-01-21 14:45 mpeacock New Issue
2016-01-22 08:37 DenisChenu Assigned To => LouisGac
2016-01-22 08:37 DenisChenu Status new => assigned
2016-02-06 01:13 c_schmitz Status assigned => closed
2016-02-06 01:13 c_schmitz Assigned To LouisGac => c_schmitz
2016-02-06 01:13 c_schmitz Resolution open => fixed
2016-02-06 01:13 c_schmitz Fixed in Version => 2.5