Project

General

Profile

Actions

Bug #9790

closed

Error when accessing change request

Added by Nicolas CHARLES over 7 years ago. Updated over 7 years ago.

Status:
Released
Priority:
1
Category:
Web - Config management
Target version:
Severity:
UX impact:
User visibility:
Effort required:
Priority:
Name check:
Fix check:
Regression:

Description

On change request page, the following error happens:
Error when retrieving the last action

it's caused by invalid sql queries

2016-12-07 15:27:12 UTC [6165]: [3873-1] ERROR:  operator does not exist: text[] = character varying[] at character 210
2016-12-07 15:27:12 UTC [6165]: [3874-1] HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.
2016-12-07 15:27:12 UTC [6165]: [3875-1] STATEMENT:  
          select eventtype, id, modificationid, principal, creationdate, causeid, severity, reason, data
          from eventlog
          where cast (xpath('/entry/workflowStep/changeRequestId/text()', data) as text[]) = $1
           and eventType in ($2)  

sadly, no logs show that there is an error

Actions

Also available in: Atom PDF