View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
12680Bug reportsInstallationpublic2017-09-18 07:472017-10-25 11:12
Reporterfvanderstarre Assigned Toc_schmitz  
PrioritynoneSeveritypartial_block 
Status closedResolutionfixed 
Product Version3.0.0-beta.x 
Fixed in Version3.0.0-beta.x 
Summary12680: Incorrect and missing statements in create-mssql.sql
Description

Statements for table "prefix_template_configuration" show mysql syntax, NOT ms-sql (3.0.0-beta2 & 3).
Statements for table "prefix_surveys_groups" are missing (3.0.0-beta3).

Steps To Reproduce

Check file ../installer/create-mssql.sql

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)3.0.0-beta.2+170810, 3.0.0-beta.3+170914
I will donate to the project if issue is resolvedNo
BrowserNot applicable
Database type & versionMS-SQL 2008 R2
Server OS (if known)Linux RHEL 7
Webserver software & version (if known)Apache 2.4.6
PHP Version5.6.31

Users monitoring this issue

There are no users monitoring this issue.

Activities

fvanderstarre

fvanderstarre

2017-10-20 10:16

reporter   ~44758

Also:
CREATE TABLE prefix_surveymenu_entries (
[id] int(11) NOT NULL ,.......
=> Cannot specify a column width on data type int.

INSERT INTO prefix_surveymenu VALUES (1,NULL,NULL,NULL,0,0,'surveymenu','side','Main survey menu',NOW(),0,NOW(),0);
=> 'NOW' is not a recognized built-in function name.

See also issue 12588.
Will there be another beta release soon?
c_schmitz

c_schmitz

2017-10-20 11:13

administrator   ~44759

There will be an RC release probably today.
fvanderstarre

fvanderstarre

2017-10-20 11:44

reporter   ~44760

Will it still make sense to do a pull request for create-mssql.sql for beta 3? I'm working on it...
c_schmitz

c_schmitz

2017-10-20 12:02

administrator   ~44761

No, it does not make sense.
Especially since create-mssql.sql is not used anymore for database setup in the latest dev version.
c_schmitz

c_schmitz

2017-10-25 11:12

administrator   ~44822

3.0.0-RC1 Build 171025 released

Issue History

Date Modified Username Field Change
2017-09-18 07:47 fvanderstarre New Issue
2017-10-20 10:16 fvanderstarre Note Added: 44758
2017-10-20 11:13 c_schmitz Assigned To => c_schmitz
2017-10-20 11:13 c_schmitz Status new => resolved
2017-10-20 11:13 c_schmitz Resolution open => fixed
2017-10-20 11:13 c_schmitz Fixed in Version => 3.0.0-beta.x
2017-10-20 11:13 c_schmitz Note Added: 44759
2017-10-20 11:44 fvanderstarre Note Added: 44760
2017-10-20 12:02 c_schmitz Note Added: 44761
2017-10-25 11:12 c_schmitz Note Added: 44822
2017-10-25 11:12 c_schmitz Status resolved => closed