View Issue Details

Related ChangesetsJump to NotesJump to History
This issue affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
09852Bug reportsSurvey editingpublic2015-08-29 02:052015-09-30 11:01
Reporteraesteban Assigned ToDenisChenu  
PrioritynormalSeverityblock 
Status closedResolutionfixed 
Product Version2.06+ 
Fixed in Version2.06+ 
Summary09852: DB error when trying to activate survey (only PostgresQL)
Description

When trying to activate survey, DB error prevents activation.

It happens only in Postgresql. I was not able to reproduce this bug with Mysql

Steps To Reproduce

1.- Create survey
2.- Try to activate

Error raises:

Activate survey (469657)
Survey table could not be created.
Database error!!

'surveytablecreation'
Main admin screen

Additional Information

I was not able to reproduce the bug with Mysql.

PostgresQL log shows this error:

ERROR: syntax error at or near "varying" at character 150
STATEMENT: CREATE TABLE "lime_survey_469657" (
"id" serial NOT NULL PRIMARY KEY,
"submitdate" timestamp,
"lastpage" integer,
"startlanguage" character (20) varying (255) NOT NULL,
"startdate" timestamp NOT NULL,
"datestamp" timestamp NOT NULL,
"ipaddr" character varying (255),
"refurl" character varying (255),
"469657X77X611" text
)

LINE 1: ...rial NOT NULL PRIMARY KEY, "token" character (36) varying (2...

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)f83805dc1d13dcf20558973752f1
I will donate to the project if issue is resolvedNo
BrowserFirefox
Database type & versionPostgresql 9.3
Server OS (if known)Ubuntu 14.04
Webserver software & version (if known)Nginx 1.4.6
PHP Version5.5.9

Relationships

Relationship GraphDependency Graph
parent of 09847 closedc_schmitz Non integer numerical input is saved as rounded integer to the database 

Users monitoring this issue

There are no users monitoring this issue.

Activities

DenisChenu

DenisChenu

2015-08-29 11:58

developer   ~33035

Last GIT version, right ? OK before but same issue than https://bugs.limesurvey.org/view.php?id=9847 , right ?
DenisChenu

DenisChenu

2015-08-29 14:59

developer   ~33037

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

DenisChenu

2015-08-29 15:00

developer   ~33038

Refix differently ... rework for 3.0 (witing mssql fix)
c_schmitz

c_schmitz

2015-09-30 11:01

administrator   ~33232

Version 2.06+ Build 150930 released

Related Changesets

LimeSurvey: master fab00d4a

2015-08-29 11:21

DenisChenu


Details Diff		 Dev: Show error exception when activate
Dev: We don't already have it ?????
Dev: Only with debug set : maybe always ?		 Affected Issues
09852
mod - application/helpers/admin/activate_helper.php Diff File

LimeSurvey: master 93f50c27

2015-08-29 14:59

DenisChenu


Details Diff		 Fixed issue 09852: DB error when trying to activate survey (only PostgresQL)
Dev: 334366c38c0bbc711bd8147e7b65264a1b7052cc child ( 09847 fix )
Dev: more test ... word can have space .. (here character varying (255))		 Affected Issues
09847, 09852
mod - application/core/db/MysqlSchema.php Diff File
mod - application/core/db/PgsqlSchema.php Diff File

Issue History

Date Modified Username Field Change
2015-08-29 02:05 aesteban New Issue
2015-08-29 11:23 DenisChenu Changeset attached => LimeSurvey master fab00d4a
2015-08-29 11:27 DenisChenu Assigned To => DenisChenu
2015-08-29 11:27 DenisChenu Status new => assigned
2015-08-29 11:57 DenisChenu Relationship added parent of 09847
2015-08-29 11:58 DenisChenu Note Added: 33035
2015-08-29 14:59 DenisChenu Changeset attached => LimeSurvey master 93f50c27
2015-08-29 14:59 DenisChenu Note Added: 33037
2015-08-29 14:59 DenisChenu Resolution open => fixed
2015-08-29 15:00 DenisChenu Note Added: 33038
2015-08-29 15:00 DenisChenu Status assigned => resolved
2015-08-29 15:00 DenisChenu Fixed in Version => 2.06+
2015-09-30 11:01 c_schmitz Note Added: 33232
2015-09-30 11:01 c_schmitz Status resolved => closed
2019-11-01 17:25 c_schmitz Category Survey design => Survey editing