Skip Menu |

This queue is for tickets about the RT-Extension-Nagios CPAN distribution.

Report information
The Basics
Id: 89226
Status: new
Priority: 0/
Queue: RT-Extension-Nagios

People
Owner: Nobody in particular
Requestors: emiticci [...] gmail.com
Cc:
AdminCc:

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)



Subject: Merge does not occur when the subject contains a blackslash
Date: Thu, 3 Oct 2013 14:14:02 +0200
To: bug-RT-Extension-Nagios [...] rt.cpan.org
From: Emiliano Ticci <emiticci [...] gmail.com>
Steps to reproduce: Open two consecutive tickets with the following subject: ** PROBLEM Service Alert: SERVER/C:\ Operating System is WARNING ** When looking for previous active tickets, the MySQL query that RT executes is: SELECT main.* FROM Tickets main WHERE (main.Status != 'deleted') AND ( ( main.Subject LIKE '%Service Alert: SERVER/C: Operating System%' ) AND ( main.Status = 'open' OR main.Status = 'new' OR main.Status = 'stalled' ) AND ( main.Queue = '7' ) ) AND (main.Type = 'ticket') AND (main.EffectiveId = main.id) ORDER BY main.Created ASC Instead should be: SELECT main.* FROM Tickets main WHERE (main.Status != 'deleted') AND ( ( main.Subject LIKE '%Service Alert: SERVER/C:\\\\ Operating System%' ) AND ( main.Status = 'open' OR main.Status = 'new' OR main.Status = 'stalled' ) AND ( main.Queue = '7' ) ) AND (main.Type = 'ticket') AND (main.EffectiveId = main.id) ORDER BY main.Created ASC RT 4.0.0 Perl 5.10.0 Linux 2.6.21.7-2.fc8xen MySQL 5.0.51a