View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
12829Bug reportsInstallationpublic2017-10-27 11:342017-11-03 13:16
Reporterfvanderstarre Assigned ToLouisGac 
PrioritynoneSeveritypartial_block 
Status closedResolutionwon't fix 
Product Version3.0.0-rc.x 
Summary12829: Update from 3.0.0.beta-2 to 3.0.0-RC.1 fails with db error (ms-sql)
Description

Updating from 3.0.0-beta.2+170810 (db version 309) to 3.0.0-RC.1+171025 (db version 323) fails with:

CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 20018 Cannot insert the value NULL into column 'parent_id', table 'LimeSurvey_temp.dbo.surveymenu'; column does not allow nulls. INSERT fails. [20018] (severity 16) [(null)]. The SQL statement executed was: INSERT INTO [surveymenu] ([parent_id], [survey_id], [user_id], [ordering], [level], [title], [position], [description], [changed_at], [changed_by], [created_at], [created_by]) VALUES (:parent_id, :survey_id, :user_id, :ordering, :level, :title, :position, :description, :changed_at, :changed_by, :created_at, :created_by). Bound with :parent_id=NULL, :survey_id=NULL, :user_id=NULL, :ordering=1, :level=0, :title='surveymenu', :position='side', :description='Main survey menu', :changed_at='2017-10-27 09:28:58', :changed_by=0, :created_at='2017-10-27 09:28:58', :created_by=0

Steps To Reproduce

Perform update as mentioned above (on ms-sql with freetds)

Additional Information

I think freeTDS may be the problem here, because I can execute the statement in SQL Server Mgmt. Studio without any problem.
Why are INTEGER columns defined as nullable with default NULL, instead of non-nullable with default 0? That would prevent the problem.

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)3.0.0-RC.1 + 171025
I will donate to the project if issue is resolvedNo
BrowserAny
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

LouisGac

LouisGac

2017-11-03 12:13

developer   ~44950

Sorry for the inconvenience, but we will not fix that one.
please, just drop all table in your DB, and delete config.php to reinstall a clean db.

fvanderstarre

fvanderstarre

2017-11-03 12:59

reporter   ~44959

That will give me the same error I'm afraid (inserting NULL value into INTEGER db column) with tables surveymenu & surveymenu_entries.
But I'll try just to make sure.
LouisGac

LouisGac

2017-11-03 13:01

developer   ~44960

ok thank you for reporting then. We're not working on MsSQL for development. But be sure it will be fixed for master.
I let it open for now.
fvanderstarre

fvanderstarre

2017-11-03 13:16

reporter   ~44961

It seems I was mistaken, a clean installation worked OK on my system! Please close the issue. I intend to do a clean install for the final release anyway.....
Thank you for your feedback.

Issue History

Date Modified Username Field Change
2017-10-27 11:34 fvanderstarre New Issue
2017-11-03 12:13 LouisGac Assigned To => LouisGac
2017-11-03 12:13 LouisGac Status new => closed
2017-11-03 12:13 LouisGac Resolution open => won't fix
2017-11-03 12:13 LouisGac Note Added: 44950
2017-11-03 12:59 fvanderstarre Note Added: 44959
2017-11-03 13:01 LouisGac Note Added: 44960
2017-11-03 13:16 fvanderstarre Note Added: 44961