View Issue Details

Jump to NotesJump to History
This issue affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
10185Bug reportsInstallationpublic2015-12-25 22:242016-01-08 15:35
Reporteraesteban Assigned ToLouisGac 
PrioritynormalSeverityblock 
Status closedResolutionfixed 
Product Version2.50.x 
Summary10185: Crash when updating DB in Postgresql
Description

There is a SQL command in the code that use a non-existing keyword in Postgresql: AFTER

Steps To Reproduce

Try to update a existing limesurvey over Postgresql instance. This error raises:

Durante la actualización, ha ocurrido un error no recuperable. Detalles del error:

CDbCommand falló al ejecutar la sentencia SQL: SQLSTATE[42601]: Syntax error: 7 ERROR: error de sintaxis en o cerca de «AFTER» LINE 1: ...me_boxes" ADD COLUMN "ico" character varying (255) AFTER img ^. The SQL statement executed was: ALTER TABLE "lime_boxes" ADD COLUMN "ico" character varying (255) AFTER img

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)6449db051aa86ad988234e4fea05
I will donate to the project if issue is resolvedNo
BrowserN.A.
Database type & versionPostgresql 9.1
Server OS (if known)Debian Jessie
Webserver software & version (if known)N.A.
PHP Version5.6

Users monitoring this issue

There are no users monitoring this issue.

Activities

LouisGac

LouisGac

2015-12-28 11:46

developer   ~34118

This one has been corrected quiet a long time ago.
c_schmitz

c_schmitz

2016-01-08 15:35

administrator   ~34194

Version 2.5RC6 released

Issue History

Date Modified Username Field Change
2015-12-25 22:24 aesteban New Issue
2015-12-25 22:30 aesteban Operating System (Server) Debian Wheezy => Debian Jessie
2015-12-28 11:46 LouisGac Note Added: 34118
2015-12-28 11:46 LouisGac Status new => resolved
2015-12-28 11:46 LouisGac Resolution open => fixed
2015-12-28 11:46 LouisGac Assigned To => LouisGac
2016-01-08 15:35 c_schmitz Note Added: 34194
2016-01-08 15:35 c_schmitz Status resolved => closed