View Issue Details

This bug affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
08412Bug reportsCentral participant databasepublic2013-12-09 15:23
ReporterElmarKnipp Assigned Toc_schmitz  
PrioritynormalSeverityblock 
Status closedResolutionfixed 
Product Version2.05 RC 
Fixed in Version2.05+ 
Summary08412: null value in column "entity_id" violates not-null constraint
Description

Creating a new user violates the DB schema.

Steps To Reproduce

Install a fresh system with PostgreSQL and try to create a new user. After pressing the submit button, you will see the error mentioned in additonal information.

Additional Information

Internal Server Error

CDbCommand failed to execute the SQL statement: SQLSTATE[23502]: Not null violation: 7 ERROR: null value in column "entity_id" violates not-null constraint

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)205rc7 131125
I will donate to the project if issue is resolvedNo
Browser
Database type & version(PostgreSQL) 9.1.10
Server OS (if known)Ubuntu 12.04.3 LTS
Webserver software & version (if known)Apache/2.2.22 (Ubuntu)
PHP VersionPHP/5.3.10-1ubuntu3.8

Users monitoring this issue

There are no users monitoring this issue.

Activities

ElmarKnipp

ElmarKnipp

2013-11-26 19:10

reporter   ~27413

With MySQL (mysql Ver 14.14 Distrib 5.5.34, for debian-linux-gnu (x86_64)) it works.

c_schmitz

c_schmitz

2013-11-27 12:05

administrator   ~27417

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

c_schmitz

c_schmitz

2013-12-09 15:23

administrator   ~27529

2.05 Build 131209 released.

Related Changesets

LimeSurvey: 2.05 ebae7b08

2013-11-27 11:05:54

c_schmitz

Details Diff
Fixed issue 08412: Creating a new user shows error on Postgres Affected Issues
08412
mod - application/controllers/admin/useraction.php Diff File

Issue History

Date Modified Username Field Change
2013-11-26 19:03 ElmarKnipp New Issue
2013-11-26 19:10 ElmarKnipp Note Added: 27413
2013-11-27 11:56 c_schmitz Assigned To => c_schmitz
2013-11-27 11:56 c_schmitz Status new => assigned
2013-11-27 12:05 c_schmitz Changeset attached => LimeSurvey 2.05 ebae7b08
2013-11-27 12:05 c_schmitz Note Added: 27417
2013-11-27 12:05 c_schmitz Resolution open => fixed
2013-11-27 12:05 c_schmitz Status assigned => resolved
2013-11-27 12:05 c_schmitz Fixed in Version => 2.05+
2013-12-09 15:23 c_schmitz Note Added: 27529
2013-12-09 15:23 c_schmitz Status resolved => closed