Unfriendly error message when entering "^" into the date picker in advanced search

VERIFIED FIXED in 1.7.6

Status

Socorro
General
VERIFIED FIXED
8 years ago
7 years ago

People

(Reporter: stephend, Assigned: ryansnyder)

Tracking

Firefox Tracking Flags

(Not tracked)

Details

(Whiteboard: [fuzzer], URL)

(Reporter)

Description

8 years ago
Very much edge-case, but if you:

1. Load http://crash-stats.stage.mozilla.com/query
2. Enter "^" into the date picker ("For the period of [x] weeks before ______")

You'll get:

An error was detected which prevented the loading of this page. If this problem persists, please contact the website administrator.

application/libraries/drivers/Database/Pgsql.php [74]:

pg_query() [function.pg-query]: Query failed: ERROR: invalid input syntax for type timestamp: "^"
(Reporter)

Comment 1

8 years ago
See also http://crash-stats.stage.mozilla.com/report/list?range_unit=weeks&query_search=signature&hang_type=any&query_type=exact&plugin_query=&do_query=&plugin_query_type=&date=<script>var+pf_687474703a2f2f63726173682d73746174732e73746167652e6d6f7a696c6c612e636f6d2f7265706f72742f6c697374_64617465=new+Boolean();</script>&query=&missing_sig=&build_id=&plugin_field=&process_type=any&version=Firefox%3A4.0b6&signature=js_fun_apply%28JSContext*%2C%20unsigned%20int%2C%20js%3A%3AValue*%29&page=2/&range_value=2
Whiteboard: [fuzzer]
Assignee: nobody → ryan
Status: NEW → ASSIGNED
Target Milestone: --- → 1.7.6
Committing for 1.7.6.

==

Sending        webapp-php/application/models/common.php
Transmitting file data .
Committed revision 2774.
Status: ASSIGNED → RESOLVED
Last Resolved: 8 years ago
Resolution: --- → FIXED
(Reporter)

Comment 3

8 years ago
Verified FIXED; thanks, Ryan!
Status: RESOLVED → VERIFIED
Component: Socorro → General
Product: Webtools → Socorro
You need to log in before you can comment on or make changes to this bug.