View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 2
IDProjectCategoryView StatusDate SubmittedLast Update
10144Bug reportsOtherpublic2015-12-14 16:412016-01-22 08:54
Reporterwingman123 Assigned Toollehar  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Product Version2.06+ 
Fixed in Version2.50.x 
Summary10144: Lime2.5RC5 Error when deleting survey with Postgres as DB
Description

In Lime2.5RC5 using Postgres as the backend DB, when deleting a survey I receive the following error

Internal Server Error
CDbCommand failed to execute the SQL statement: SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: character varying = integer
LINE 1: ...gid_1' OR stg_name = 'last_question_1' OR stg_value = 369386
^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
An internal error occurred while the Web server was processing your request. Please contact the webmaster to report this problem.
Thank you.

The survey is deleted if you go back to the main admin screen, just a usability thing here

Steps To Reproduce
  • Install LimeSurvey 2.5RC5 then select Postgres as the database
  • Create a Survey in admin view
  • Delete survey from any view (error should appear)
  • Go back to admin interface
  • Survey should be gone
TagsNo tags attached.
Attached Files
Screen Shot 2015-12-14 at 10.28.30 AM.png (153,687 bytes)
Bug heat2
Complete LimeSurvey version number (& build)2.5RC5
I will donate to the project if issue is resolvedNo
BrowserChrome, Firefox
Database type & versionPostgres 9.4.4
Server OS (if known)Mac OSX 10.11
Webserver software & version (if known)Apache/2.4.16
PHP VersionPHP 5.5.29

Users monitoring this issue

There are no users monitoring this issue.

Activities

ollehar

ollehar

2015-12-17 16:50

administrator   ~34052

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

Related Changesets

LimeSurvey: 2.5 d9adc97f

2015-12-17 15:50:29

ollehar

Details Diff 		Fixed issue 10144: Don't compare int with char - PostgreSQL won't like it; also some error messages fixes Affected Issues
10144
mod - application/controllers/AdminController.php Diff File
mod - application/controllers/admin/index.php Diff File
mod - application/controllers/admin/surveyadmin.php Diff File
mod - application/core/Survey_Common_Action.php Diff File

Issue History

Date Modified Username Field Change
2015-12-14 16:41 wingman123 New Issue
2015-12-14 16:41 wingman123 File Added: Screen Shot 2015-12-14 at 10.28.30 AM.png
2015-12-15 09:36 c_schmitz Assigned To => LouisGac
2015-12-15 09:36 c_schmitz Status new => assigned
2015-12-17 16:05 ollehar Assigned To LouisGac => ollehar
2015-12-17 16:50 ollehar Changeset attached => LimeSurvey 2.5 d9adc97f
2015-12-17 16:50 ollehar Note Added: 34052
2015-12-17 16:50 ollehar Resolution open => fixed
2015-12-17 16:52 ollehar Status assigned => resolved
2015-12-17 16:52 ollehar Fixed in Version => 2.5
2016-01-22 08:54 c_schmitz Status resolved => closed