Search query triggering error in tsearch

Bug #174368 reported by Diogo Matsubara
4
Affects Status Importance Assigned to Milestone
Launchpad itself
Fix Released
Medium
Stuart Bishop

Bug Description

Steps to reproduce:
1. Open http://launchpad.dev/firefox/+bugs
2. Fill in the search field: )foo(
3. Click Search
4. OOPS-704E50 ProgrammingError ERROR: syntax error in tsearch query:

OOPS-808E659 shows another query that blows up tsearch: foo && ( bar

Changed in launchpad:
assignee: nobody → stub
status: New → Confirmed
description: updated
Revision history for this message
Francis J. Lacoste (flacoste) wrote :

That's mostly only affecting people trying to spam our search fields. But it's a valid OOPS and could affect some legitimate user, so let's try to clean that up at the end of this cycle if there is room.

Changed in launchpad-foundations:
importance: Undecided → Medium
milestone: none → 2.1.10
status: Confirmed → Triaged
assignee: stub → nobody
Changed in launchpad-foundations:
milestone: 2.1.10 → 2.1.11
Changed in launchpad-foundations:
assignee: nobody → stub
milestone: 2.1.11 → 2.1.12
Stuart Bishop (stub)
Changed in launchpad-foundations:
status: Triaged → Fix Committed
Changed in launchpad-foundations:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.