View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 2
IDProjectCategoryView StatusDate SubmittedLast Update
08481Bug reportsInstallationpublic2013-12-20 18:142014-01-09 23:31
Reporterdimbeni Assigned Toc_schmitz  
PrioritynormalSeveritycrash 
Status closedResolutionfixed 
Product Version2.05+ 
Fixed in Version2.05+ 
Summary08481: When updating the mysql db, I get FUNCTION limesurvey.COALESCE does not exist
Description

When updating the mysql db, I get FUNCTION limesurvey.COALESCE does not exist

Steps To Reproduce

Update mysql db

Additional Information

I think the problem is in line 1187 of limesurvey/application/helpers/update/updatedb_helper.php, that contains a space that (my version of) mysql doesn't like.
To fix, I chenged it from 

$sQuery = "SELECT attribute_id,attribute_name,COALESCE (lang)

to

$sQuery = "SELECT attribute_id,attribute_name,COALESCE(lang)
TagsNo tags attached.
Bug heat2
Complete LimeSurvey version number (& build)limesurvey205plus-build13121
I will donate to the project if issue is resolvedNo
Browser
Database type & versionmysql 5.0.95
Server OS (if known)Linux CentOS 5.9
Webserver software & version (if known)Apache
PHP Version5.3

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2014-01-09 23:31

administrator   ~27809

2.05+ build 140109 released

Related Changesets

LimeSurvey: master c830236d

2013-12-19 20:55:33

c_schmitz

Details Diff 		Merge pull request #160 from dani/master

Fix COALESCE		 Affected Issues
08481
mod - application/helpers/update/updatedb_helper.php Diff File

Issue History

Date Modified Username Field Change
2013-12-20 18:14 dimbeni New Issue
2013-12-20 18:43 DenisChenu Changeset attached => LimeSurvey master c830236d
2013-12-20 18:43 DenisChenu Assigned To => c_schmitz
2013-12-20 18:43 DenisChenu Status new => assigned
2013-12-21 10:22 c_schmitz Status assigned => resolved
2013-12-21 10:22 c_schmitz Fixed in Version => 2.05+
2013-12-21 10:22 c_schmitz Resolution open => fixed
2014-01-09 23:31 c_schmitz Note Added: 27809
2014-01-09 23:31 c_schmitz Status resolved => closed